{"id":485,"date":"2025-01-14T15:46:08","date_gmt":"2025-01-14T07:46:08","guid":{"rendered":"http:\/\/sqtcw.cn\/?p=485"},"modified":"2025-01-14T15:46:08","modified_gmt":"2025-01-14T07:46:08","slug":"%e5%b0%86%e6%96%87%e4%bb%b6%e4%bf%9d%e5%ad%98%e5%88%b0%e6%a1%8c%e9%9d%a2%e7%9a%84python%e4%bb%a3%e7%a0%81","status":"publish","type":"post","link":"http:\/\/www.cnitw.com\/?p=485","title":{"rendered":"\u5c06\u6587\u4ef6\u4fdd\u5b58\u5230\u684c\u9762\u7684Python\u4ee3\u7801"},"content":{"rendered":"\n<p>\u4ee5\u4e0b\u662f\u5c06\u6587\u4ef6\u4fdd\u5b58\u5230\u684c\u9762\u7684\u4ee3\u7801\u793a\u4f8b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import os\nimport pandas as pd\n\n# \u83b7\u53d6\u684c\u9762\u8def\u5f84\ndesktop_path = os.path.join(os.path.expanduser(\"~\"), 'Desktop')\n\ndata = {'A': &#91;1, 2, 3], 'B': &#91;'a', 'b', 'c']}\ndf = pd.DataFrame(data)\n\nexcel_file_path = os.path.join(desktop_path, 'output.xlsx')\ndf.to_excel(excel_file_path, index=False)<\/code><\/pre>\n\n\n\n<p>\u5728\u4e0a\u8ff0\u4ee3\u7801\u4e2d\uff0c\u9996\u5148\u4f7f\u7528 <code>os.path.join(os.path.expanduser(\"~\"), 'Desktop')<\/code> \u83b7\u53d6\u684c\u9762\u7684\u8def\u5f84\uff0c\u7136\u540e\u5c06\u751f\u6210\u7684 Excel \u6587\u4ef6\u8def\u5f84\u8bbe\u7f6e\u4e3a\u684c\u9762\u8def\u5f84\u52a0\u4e0a\u6587\u4ef6\u540d\uff0c\u6700\u540e\u4f7f\u7528 <code>to_excel<\/code> \u65b9\u6cd5\u4fdd\u5b58\u6587\u4ef6\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><code>os.path.expanduser(\"~\")<\/code> \u662f Python \u4e2d <code>os.path<\/code> \u6a21\u5757\u7684\u4e00\u4e2a\u51fd\u6570\u8c03\u7528\u3002<\/p>\n\n\n\n<p>\u5b83\u7684\u4f5c\u7528\u662f\u5c06 <code>~<\/code> \u5b57\u7b26\u6269\u5c55\u4e3a\u5f53\u524d\u7528\u6237\u7684\u4e3b\u76ee\u5f55\u8def\u5f84\u3002<\/p>\n\n\n\n<p>\u5728\u4e0d\u540c\u7684\u64cd\u4f5c\u7cfb\u7edf\u4e2d\uff0c\u7528\u6237\u7684\u4e3b\u76ee\u5f55\u8def\u5f84\u8868\u793a\u65b9\u5f0f\u53ef\u80fd\u4e0d\u540c\u3002\u4f8b\u5982\uff0c\u5728 Windows \u7cfb\u7edf\u4e2d\uff0c\u53ef\u80fd\u7c7b\u4f3c\u4e8e <code>C:\\Users\\\u7528\u6237\u540d<\/code> \uff1b\u5728\u7c7b Unix \u7cfb\u7edf\uff08\u5982 Linux\u3001Mac OS\uff09\u4e2d\uff0c\u53ef\u80fd\u7c7b\u4f3c\u4e8e <code>\/home\/\u7528\u6237\u540d<\/code> \u3002<\/p>\n\n\n\n<p>\u4f7f\u7528 <code>os.path.expanduser(\"~\")<\/code> \u53ef\u4ee5\u4f7f\u4ee3\u7801\u5728\u4e0d\u540c\u7684\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u90fd\u80fd\u6b63\u786e\u83b7\u53d6\u5230\u7528\u6237\u7684\u4e3b\u76ee\u5f55\u8def\u5f84\uff0c\u589e\u52a0\u4e86\u4ee3\u7801\u7684\u53ef\u79fb\u690d\u6027\u3002<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u4e0b\u662f\u5c06\u6587\u4ef6\u4fdd\u5b58\u5230\u684c\u9762\u7684\u4ee3\u7801\u793a\u4f8b\uff1a \u5728\u4e0a\u8ff0\u4ee3\u7801\u4e2d\uff0c\u9996\u5148\u4f7f\u7528 os.path.join(os.path.expanduser(&#8220;~&#8221;), &#8216;Desktop&#8217;) \u83b7\u53d6\u684c\u9762\u7684\u8def\u5f84\uff0c\u7136\u540e\u5c06\u751f\u6210\u7684 Excel \u6587\u4ef6\u8def\u5f84\u8bbe\u7f6e\u4e3a\u684c\u9762\u8def\u5f84\u52a0\u4e0a\u6587\u4ef6\u540d\uff0c\u6700\u540e\u4f7f\u7528 to_excel \u65b9\u6cd5\u4fdd\u5b58\u6587\u4ef6\u3002 os.path.expanduser(&#8220;~&#8221;) \u662f Python \u4e2d os.path \u6a21\u5757\u7684\u4e00\u4e2a\u51fd\u6570\u8c03\u7528\u3002 \u5b83\u7684\u4f5c\u7528\u662f\u5c06 ~ \u5b57\u7b26\u6269\u5c55\u4e3a\u5f53\u524d\u7528\u6237\u7684\u4e3b\u76ee\u5f55\u8def\u5f84\u3002 \u5728\u4e0d\u540c\u7684\u64cd\u4f5c\u7cfb\u7edf\u4e2d\uff0c\u7528\u6237\u7684\u4e3b\u76ee\u5f55\u8def\u5f84\u8868\u793a\u65b9\u5f0f\u53ef\u80fd\u4e0d\u540c\u3002\u4f8b\u5982\uff0c\u5728 Windows \u7cfb\u7edf\u4e2d\uff0c\u53ef\u80fd\u7c7b\u4f3c\u4e8e C:\\Users\\\u7528\u6237\u540d \uff1b\u5728\u7c7b Unix \u7cfb\u7edf\uff08\u5982 Linux\u3001Mac OS\uff09\u4e2d\uff0c\u53ef\u80fd\u7c7b\u4f3c\u4e8e \/home\/\u7528\u6237\u540d \u3002 \u4f7f\u7528&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-485","post","type-post","status-publish","format-standard","hentry","category-python"],"_links":{"self":[{"href":"http:\/\/www.cnitw.com\/index.php?rest_route=\/wp\/v2\/posts\/485","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=485"}],"version-history":[{"count":0,"href":"http:\/\/www.cnitw.com\/index.php?rest_route=\/wp\/v2\/posts\/485\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.cnitw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cnitw.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=485"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cnitw.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}