{"id":332,"date":"2019-11-27T15:01:33","date_gmt":"2019-11-27T07:01:33","guid":{"rendered":"http:\/\/cnliutz.uicp.io\/wordpress\/?p=332"},"modified":"2021-06-15T16:09:34","modified_gmt":"2021-06-15T08:09:34","slug":"python%e4%bd%bf%e7%94%a89%e8%a1%8c%e4%bb%a3%e7%a0%81%e6%89%b9%e9%87%8f%e5%90%88%e5%b9%b6excel%e6%96%87%e4%bb%b6","status":"publish","type":"post","link":"http:\/\/nnqvlom6.ipyingshe.net:5347\/?p=332","title":{"rendered":"Python\u4f7f\u75289\u884c\u4ee3\u7801\u6279\u91cf\u5408\u5e76Excel\u6587\u4ef6"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>import os\nimport pandas as pd\nexcels=&#91;pd.read_excel(fname)\n        for fname in os.listdir(\".\/\")\n        #if \".xlsx\" in fname\n        if \".xls\" in fname\n]\ndf =pd.concat(excels)\ndf.to_excel(\"\u7ed3\u679c\u6587\u4ef6.xlsx\",index=False)<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,10],"tags":[],"class_list":["post-332","post","type-post","status-publish","format-standard","hentry","category-2","category-python"],"_links":{"self":[{"href":"http:\/\/nnqvlom6.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/332","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/nnqvlom6.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/nnqvlom6.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/nnqvlom6.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/nnqvlom6.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=332"}],"version-history":[{"count":8,"href":"http:\/\/nnqvlom6.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/332\/revisions"}],"predecessor-version":[{"id":1774,"href":"http:\/\/nnqvlom6.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/332\/revisions\/1774"}],"wp:attachment":[{"href":"http:\/\/nnqvlom6.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=332"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/nnqvlom6.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=332"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/nnqvlom6.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=332"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}