{"id":512,"date":"2022-11-16T11:01:22","date_gmt":"2022-11-16T03:01:22","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=512"},"modified":"2022-11-16T11:03:24","modified_gmt":"2022-11-16T03:03:24","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-%e6%89%b9%e6%ac%a1%e8%ae%80%e5%8f%96csv%e6%aa%94%e6%a1%88%ef%bc%8c%e5%bd%99%e6%95%b4%e6%88%90%e4%b8%80%e5%80%8bcsv%e6%aa%94%e6%a1%88","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/512\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: \u6279\u6b21\u8b80\u53d6csv\u6a94\u6848\uff0c\u5f59\u6574\u6210\u4e00\u500bcsv\u6a94\u6848"},"content":{"rendered":"<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nimport glob\nimport pandas as pd\nimport numpy as np\n\n# \u4e82\u6578\u88fd\u4f5c5\u500b2\u52178\u6b04\u4e4bcsv\u6a94\u6848\nfor i in range(1, 6):\n    df_temp = pd.DataFrame(np.random.rand(2, 8), columns=list('abcdefgh'))\n    df_temp.to_csv(('df_' + str(i) + '.csv'), index=False)\n<\/pre><\/div>\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u67e5\u8a62\u76ee\u9304\u4e0b\u6240\u6709\u7684csv\u6a94\u6848\nfiles = glob.glob('*.csv')\nprint(len(files))\nfiles\n<\/pre><\/div>\n\n\n<p>5<br>[&#8216;df_1.csv&#8217;, &#8216;df_2.csv&#8217;, &#8216;df_3.csv&#8217;, &#8216;df_4.csv&#8217;, &#8216;df_5.csv&#8217;]<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u7b2c\u4e00\u7a2e\u65b9\u6cd5\ndf = pd.concat(\n    map(pd.read_csv, files), ignore_index=True)\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"632\" height=\"395\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-10-163814.jpg\" alt=\"\" class=\"wp-image-515\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-10-163814.jpg 632w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-10-163814-300x188.jpg 300w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/figure>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u7b2c\u4e8c\u7a2e\u65b9\u6cd5\ndf_from_each_file = (pd.read_csv(f) for f in files)\ndf = pd.concat(df_from_each_file, ignore_index=True)\ndf\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"632\" height=\"395\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-10-163814.jpg\" alt=\"\" class=\"wp-image-515\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-10-163814.jpg 632w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/Screenshot-2022-11-10-163814-300x188.jpg 300w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>5[&#8216;df_1.csv&#8217;, &#8216;df_2.csv&#8217;, &#038;#821 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":516,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}}},"categories":[4],"tags":[201,8,178],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2022\/11\/uvmpvircf5w-300x169.jpg","coauthors":[],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">csv<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">Pandas<\/a>","<a href=\"https:\/\/kuo.us.to\/wordpress\/category\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/\" class=\"advgb-post-tax-term\">\u6279\u6b21<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">csv<\/span>","<span class=\"advgb-post-tax-term\">Pandas<\/span>","<span class=\"advgb-post-tax-term\">\u6279\u6b21<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 3 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2022 \u5e74 11 \u6708 16 \u65e5","modified":"Updated on 2022 \u5e74 11 \u6708 16 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 11 \u6708 16 \u65e5 \u4e0a\u5348 11:01","modified":"Updated on 2022 \u5e74 11 \u6708 16 \u65e5 \u4e0a\u5348 11:03"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/512"}],"collection":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/comments?post=512"}],"version-history":[{"count":3,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/512\/revisions"}],"predecessor-version":[{"id":517,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/512\/revisions\/517"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/516"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}