{"id":478,"date":"2025-01-14T08:40:43","date_gmt":"2025-01-14T00:40:43","guid":{"rendered":"http:\/\/sqtcw.cn\/?p=478"},"modified":"2025-01-14T08:40:43","modified_gmt":"2025-01-14T00:40:43","slug":"python%e5%88%9b%e5%bb%ba%e6%95%b0%e6%8d%ae%e5%ad%97%e5%85%b8-data-%e5%ba%94%e8%af%a5%e4%bd%bf%e7%94%a8%e5%86%92%e5%8f%b7-%e6%9d%a5%e5%88%86%e9%9a%94%e9%94%ae%e5%92%8c%e5%80%bc","status":"publish","type":"post","link":"http:\/\/www.cnitw.com\/?p=478","title":{"rendered":"Python\u521b\u5efa\u6570\u636e\u5b57\u5178\u00a0data\u00a0\u5e94\u8be5\u4f7f\u7528\u5192\u53f7\u00a0:\u00a0\u6765\u5206\u9694\u952e\u548c\u503c\uff0c\u5e76\u4e14\u503c\u9700\u8981\u7528\u5217\u8868\u5f62\u5f0f"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>\u9519\u8bef\u4ee3\u7801\u793a\u8303\uff1a\nimport os\nimport pandas as pd\nfolder_path = 'D:\\\\Excel666'\nif not os.path.exists(folder_path) :\n    os.makedirs(folder_path)\n\n #\u521b\u5efa\u4e00\u4e2a\u793a\u4f8b\ndata = &#91;'Name':'boby', 'andy' ,'lucy'\n        'age': 30, 23, 35\n        '\u804c\u4e1a': '\u519c\u6c11' , '\u5de5\u4eba' ,'\u5de5\u7a0b\u5e08']\n\ndf =pd.DataFrame(data)\n\n#\u4fdd\u5b58new_file.xlsx\u5230Excel666\u4e2d\n\nexcel_file_path = os.path.join(folder_path, 'new_file.xlsx')\ndf.to_excel(excel_file_path)\n\n\n\u60a8\u7684\u4ee3\u7801\u5b58\u5728\u4e00\u4e9b\u9519\u8bef\uff0c\u4ee5\u4e0b\u662f\u4fee\u6b63\u540e\u7684\u4ee3\u7801\u53ca\u89e3\u91ca\uff1a\n\n```python\nimport os\nimport pandas as pd\n\nfolder_path = 'D:\\\\Excel666'\nif not os.path.exists(folder_path):\n    os.makedirs(folder_path)\n\n# \u521b\u5efa\u4e00\u4e2a\u793a\u4f8b\ndata = {'Name': &#91;'boby', 'andy', 'lucy'],\n        'Age': &#91;30, 23, 35],\n        '\u804c\u4e1a': &#91;'\u519c\u6c11', '\u5de5\u4eba', '\u5de5\u7a0b\u5e08']}  # \u8fd9\u91cc\u9700\u8981\u7528\u5192\u53f7\u5206\u9694\u952e\u548c\u503c\uff0c\u5e76\u4e14\u503c\u8981\u7528\u5217\u8868\u5f62\u5f0f\n\ndf = pd.DataFrame(data)\n\n# \u4fdd\u5b58 new_file.xlsx \u5230 Excel666 \u4e2d\nexcel_file_path = os.path.join(folder_path, 'new_file.xlsx')\ndf.to_excel(excel_file_path, index=False)  # \u5efa\u8bae\u6dfb\u52a0 index=False \u4e0d\u4fdd\u5b58\u7d22\u5f15\u5217\n```\n\n\u5728\u539f\u59cb\u4ee3\u7801\u4e2d\uff0c\u521b\u5efa\u6570\u636e\u5b57\u5178 `data` \u7684\u8bed\u6cd5\u6709\u8bef\uff0c\u5e94\u8be5\u4f7f\u7528\u5192\u53f7 `:` \u6765\u5206\u9694\u952e\u548c\u503c\uff0c\u5e76\u4e14\u503c\u9700\u8981\u7528\u5217\u8868\u6765\u8868\u793a\u3002\u4fee\u6539\u540e\uff0c\u5c31\u53ef\u4ee5\u6b63\u786e\u5730\u5c06\u6570\u636e\u8f6c\u6362\u4e3a `DataFrame` \u5e76\u4fdd\u5b58\u4e3a Excel \u6587\u4ef6\u3002\n\n<\/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":[8,14],"tags":[],"class_list":["post-478","post","type-post","status-publish","format-standard","hentry","category-python","category-14"],"_links":{"self":[{"href":"http:\/\/www.cnitw.com\/index.php?rest_route=\/wp\/v2\/posts\/478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.cnitw.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.cnitw.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.cnitw.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.cnitw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=478"}],"version-history":[{"count":0,"href":"http:\/\/www.cnitw.com\/index.php?rest_route=\/wp\/v2\/posts\/478\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.cnitw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cnitw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=478"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cnitw.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}