{"id":780,"date":"2023-03-29T22:50:08","date_gmt":"2023-03-29T14:50:08","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=780"},"modified":"2023-03-29T22:50:10","modified_gmt":"2023-03-29T14:50:10","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-pandas-%e6%89%b9%e6%ac%a1%e8%ae%80%e5%8f%96txt%e6%aa%94%e6%a1%88%ef%bc%8c%e6%8c%87%e5%ae%9a%e7%89%b9%e5%ae%9a%e8%b3%87%e6%96%99%ef%bc%8c%e6%89%b9%e6%ac%a1","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/780\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: Pandas \u6279\u6b21\u8b80\u53d6txt\u6a94\u6848\uff0c\u6307\u5b9a\u7279\u5b9a\u8cc7\u6599\uff0c\u6279\u6b21\u532f\u51faExcel\u6a94\u6848"},"content":{"rendered":"\n<p>\u672c\u6587\u4f86\u81ea\u65bcithelp\u7db2\u53cb\u4e4b\u767c\u554f\uff0c\u7db2\u5740\u5982\u4e0b\uff1a<br><a rel=\"noreferrer noopener\" href=\"https:\/\/ithelp.ithome.com.tw\/questions\/10212370\" data-type=\"URL\" data-id=\"https:\/\/ithelp.ithome.com.tw\/questions\/10212370\" target=\"_blank\">https:\/\/ithelp.ithome.com.tw\/questions\/10212370<\/a><\/p>\n\n\n\n<p>\u56e0\u4e0a\u9762\u554f\u7b54\u8cc7\u6599\u6709\u9ede\u591a\uff0c\u7db2\u53cb\u53c8\u6709\u5f8c\u7e8c\u63d0\u554f\uff0c\u5beb\u6210\u6587\u7ae0\u6bd4\u8f03\u5bb9\u6613\u7de8\u8f2f\u3002<\/p>\n\n\n\n<h2>\u539f\u5148\u554f\u984c\u53ca\u63d0\u554f\u5206\u985e\u62102\u984c\uff1a<\/h2>\n\n\n\n<h2>\u7b2c1\u984c<\/h2>\n\n\n\n<p>test.txt\u8cc7\u6599\u6a94\u5167\u5bb9\u5982\u4e0b\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n3 i\n2 10-\n2 ,,\n1 \/ 1 cia\n0 \\ 0 0 By Pte\n\u4eba 4 6 8 \u201cPost\n-1 \/ \u201cI 5-\n2\n2 \/ TO\n-3\n4g \/ \u4eba ]\nVolume shift &#x5B;ml] 15-\n\n####Flow-Volume-Curve####\n\nPred Pre %... Post %... Chg...\nsr eff 0.96 1.13 118 0.15 89 -25\nR tot 0.30 0.48 161 1.44 146 -10\nR eff 0.30 0.42 139 0.38 127 -9\nFrcpl 2.51 1.16 74 1.79 71 -4\nVT 0.59 1.71 290 0.90 154 -47\nIc 1.91 2.44 128 2.38 125 -3\nERV 1.05 0.36 35 0.53 50 45\nRV 1.46 1.50 102 1.26 16 -16\nTLC 4.44 4.31 97 4.16 94 -3\nRV%TLC 32.90 34.78 106 30.30 92 -13\nVC IN 2.96 1.02 68 1.38 47 -32\nFVC 2.91 2.81 96 2.90 100 3\nFEV 1 2.10 2.29 92 2.38 95 4\nFEV1%F 81.65 82.08 1\nPEF 6.18 6.64 107 5.43 88 -18\nMEF 75 5.57 5.79 104 4.98 89 -14\nMEF 50 3.93 2.68 68 3.10 79 16\nMEF 25 1.71 0.88 52 1.03 60 17\nMMEF 3.46 2.24 65 2.50 72 11\nFIF 50 4.18 3.94 -6\nSubstance ventolin\n<\/pre><\/div>\n\n\n<p>\u76ee\u6a19\uff1a\u8b80\u53d6\u300cPred Pre %\u2026 Post %\u2026 Chg\u2026\u300d\u8207\u300cSubstance ventolin\u300d\u4e4b\u9593\u7684\u5167\u5bb9\uff0c\u6574\u7406\u6210\u4ee5\u4e0b\u683c\u5f0f\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"433\" height=\"666\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-28-114328.jpg\" alt=\"\" class=\"wp-image-773\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-28-114328.jpg 433w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-28-114328-195x300.jpg 195w\" sizes=\"(max-width: 433px) 100vw, 433px\" \/><\/figure>\n\n\n\n<p>code1\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u5148\u627e\u51fa\u8b80\u53d6\u6a94\u6848\u7684\u8d77\u59cb\u548c\u7d50\u675f\u884c\nimport pandas as pd\nimport re\n\nfile = 'test.txt'\n\n# \u8a2d\u5b9a\u7a7a\u7684\u7d22\u5f15\nindexes = &#x5B;]\nwith open(file) as f:        \n    lines = f.readlines()\n    for i, line in enumerate(lines):\n        # \u641c\u5c0b\u6a94\u6848\u8981\u8b80\u53d6\u7684\u8d77\u59cb\u4f4d\u7f6e\n        if line.startswith('Pred Pre %... Post %... Chg...'):\n            # \u627e\u5230\u8d77\u59cb\u4f4d\u7f6e\u5f8c\uff0c\u4e0b\u4e00\u884c\u624d\u958b\u59cb\u8b80\u53d6\n            s = i+1\n        # \u641c\u5c0b\u6a94\u6848\u8981\u8b80\u53d6\u7684\u7d50\u675f\u4f4d\u7f6e\n        elif line.startswith('Substance ventolin'):\n            e = i\n            indexes.append((s, e))  \n        else:\n            pass\n# \u8a2d\u5b9a\u7a7a\u7684list\u5132\u5b58\u8981\u6574\u7406\u7684\u82f1\u6587\u540d\u5b57\nresult_name = &#x5B;]\n# \u8a2d\u5b9a\u7a7a\u7684list\u5132\u5b58\u8981\u6574\u7406\u7684\u6578\u64da\nresult_data = &#x5B;]\n\n# \u8b80\u53d6\u8d77\u59cb\u548c\u7d50\u675f\u4f4d\u7f6e\u4e2d\u9593\u7684\u8cc7\u6599\nfor line in lines&#x5B;s:e]:\n    \n    # \u9019\u908a\u662f\u7528ccutmis\u524d\u8f29\u7684Regex\u4f86\u5c0b\u627e\u8207\u5207\u5272\u8cc7\u6599\uff1a\n    temp = re.findall('(^&#x5B;A-Za-z%]+.*&#x5B;A-Za-z%].)(.*)$', line)\n    \n    # \u539f\u59cb\u8cc7\u6599\u4e2d\u7684\u82f1\u6587\u540d\u5b58\u5230result_name\n    result_name.append(temp&#x5B;0]&#x5B;0])\n    \n    # \u539f\u59cb\u8cc7\u6599\u4e2d\u7684\u6578\u64da\u5b58\u5230result_name\n    result_data.append(temp&#x5B;0]&#x5B;1].split(' '))\n\n\ndf_name = pd.DataFrame(result_name)\ndf_data = pd.DataFrame(result_data)\n\n# \u5c07\u4ee5\u4e0a\u76842\u500bdataframe \u4e32\u63a5\ndf = pd.concat(&#x5B;df_name, df_data], axis=1)\n\n# \u5c07\u6b04\u540d\u4fee\u6b63\u70ba\u300ccol_1......, col_x\u300d\ndf.columns=&#x5B;'col_' + str(x) for x in range(1, len(df.columns)+1)]\n\ndf\n<\/pre><\/div>\n\n\n<p>\u7d50\u679c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"433\" height=\"666\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-28-114328.jpg\" alt=\"\" class=\"wp-image-773\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-28-114328.jpg 433w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/Screenshot-2023-03-28-114328-195x300.jpg 195w\" sizes=\"(max-width: 433px) 100vw, 433px\" \/><\/figure>\n\n\n\n<h2>\u7b2c2\u984c<\/h2>\n\n\n\n<p>\u5047\u8a2d\u67093\u500btext\u6a94\u6848\uff0c\u8cc7\u6599\u5206\u5225\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>test1.txt\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n3 i\n2 10-\n2 ,,\n1 \/ 1 cia\n0 \\ 0 0 By Pte\n\u4eba 4 6 8 \u201cPost\n-1 \/ \u201cI 5-\n2\n2 \/ TO\n-3\n4g \/ \u4eba ]\nVolume shift &#x5B;ml] 15-\n\n####Flow-Volume-Curve####\n\nPred Pre %... Post %... Chg...\nsr eff 0.96 1.13 118 0.15 89 -25\nR tot 0.30 0.48 161 1.44 146 -10\nR eff 0.30 0.42 139 0.38 127 -9\nFrcpl 2.51 1.16 74 1.79 71 -4\nVT 0.59 1.71 290 0.90 154 -47\nSubstance ventolin\n<\/pre><\/div>\n\n\n<p>test2.txt\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n3 i\n2 10-\n2 ,,\n1 \/ 1 cia\n0 \\ 0 0 By Pte\n\u4eba 4 6 8 \u201cPost\n-1 \/ \u201cI 5-\n2\n2 \/ TO\n-3\n4g \/ \u4eba ]\nVolume shift &#x5B;ml] 15-\n\n####Flow-Volume-Curve####\n\nPred Pre %... Post %... Chg...\nIc 1.91 2.44 128 2.38 125 -3\nERV 1.05 0.36 35 0.53 50 45\nRV 1.46 1.50 102 1.26 16 -16\nTLC 4.44 4.31 97 4.16 94 -3\nRV%TLC 32.90 34.78 106 30.30 92 -13\nVC IN 2.96 1.02 68 1.38 47 -32\nFVC 2.91 2.81 96 2.90 100 3\nSubstance ventolin\n<\/pre><\/div>\n\n\n<p>test3.txt\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n3 i\n2 10-\n2 ,,\n1 \/ 1 cia\n0 \\ 0 0 By Pte\n\u4eba 4 6 8 \u201cPost\n-1 \/ \u201cI 5-\n2\n2 \/ TO\n-3\n4g \/ \u4eba ]\nVolume shift &#x5B;ml] 15-\n\n####Flow-Volume-Curve####\n\nPred Pre %... Post %... Chg...\nFEV 1 2.10 2.29 92 2.38 95 4\nFEV1%F 81.65 82.08 1\nPEF 6.18 6.64 107 5.43 88 -18\nMEF 75 5.57 5.79 104 4.98 89 -14\nMEF 50 3.93 2.68 68 3.10 79 16\nMEF 25 1.71 0.88 52 1.03 60 17\nMMEF 3.46 2.24 65 2.50 72 11\nFIF 50 4.18 3.94 -6\nSubstance ventolin\n<\/pre><\/div>\n\n\n<p>\u76ee\u6a192-1\uff1a\u6279\u6b21\u8b80\u53d6text\u6a94\u6848\uff0c\u8655\u7406\u5b8c\u5f8c\uff0c\u8f38\u51fa\u6210\u4e00\u500btest.xlsx\u6a94\u6848\uff0c\u5206\u6210\u300ctest1, test2, test3\u300d\u4e09\u500b\u5de5\u4f5c\u8868\u3002<br>\u76ee\u6a192-2\uff1a\u6279\u6b21\u8b80\u53d6text\u6a94\u6848\uff0c\u8655\u7406\u5b8c\u5f8c\u7d50\u5408\u6240\u6709\u8cc7\u6599\uff0c\u8f38\u51fa\u6210\u4e00\u500btest.xlsx\u6a94\u6848\u3002<\/p>\n\n\n\n<p>code 2-0\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\nimport glob\nimport re\nimport pandas as pd\n\n# \u5047\u8a2d\u6240\u6709\u7684text\u6a94\u6848\u653e\u572820230329_test\u7684\u76ee\u9304\u4e0b\nfiles = glob.glob('.\/20230329_test\/*.txt')\n\n# \u5148\u5370\u51fa\u6240\u6709\u7684\u6a94\u6848\nfiles\n<\/pre><\/div>\n\n\n<p>\u7d50\u679c\u5982\u4e0b\uff1a<br>[&#8216;.\/20230329_test\\test1.txt&#8217;,<br>&#8216;.\/20230329_test\\test2.txt&#8217;,<br>&#8216;.\/20230329_test\\test3.txt&#8217;]<\/p>\n\n\n\n<p>code 2-1\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u8a2d\u5b9a\u7a7a\u7684list\u5132\u5b58\u8ff4\u5708\u7684\u6240\u6709dataframe\ndf_list = &#x5B;]\n\n# \u8a2d\u5b9a\u7a7a\u7684list\u5132\u5b58dataframe\u7684\u5de5\u4f5c\u8868\u540d\u7a31\nsheet_list = &#x5B;]\n\n# \u8ff4\u5708\u8b80\u53d6\u6240\u6709\u8981\u8655\u7406\u7684\u6a94\u6848\nfor file in files:\n    \n    # \u5c07txt\u7684\u6a94\u6848\u540d\u7a31\u4e0d\u542b\u526f\u6a94\u540d\u5b58\u5165sheet_name\n    sheet_list.append(file&#x5B;-9:-4])\n    \n    # \u5148\u627e\u51fa\u8b80\u53d6\u6a94\u6848\u7684\u8d77\u59cb\u548c\u7d50\u675f\u884c\n    with open(file) as f:  \n        s, e = None, None\n        lines = f.readlines()\n        for i, line in enumerate(lines):\n    \n            # \u641c\u5c0b\u6a94\u6848\u8981\u8b80\u53d6\u7684\u8d77\u59cb\u4f4d\u7f6e\n            if line.startswith('Pred Pre %... Post %... Chg...'):\n            \n                # \u627e\u5230\u8d77\u59cb\u4f4d\u7f6e\u5f8c\uff0c\u4e0b\u4e00\u884c\u624d\u958b\u59cb\u8b80\u53d6\n                s = i+1\n            \n            # \u641c\u5c0b\u6a94\u6848\u8981\u8b80\u53d6\u7684\u7d50\u675f\u4f4d\u7f6e\n            elif line.startswith('Substance ventolin'):\n                e = i\n                  \n            else:\n                pass\n    \n    # \u8a2d\u5b9a\u7a7a\u7684list\u5132\u5b58\u8981\u6574\u7406\u7684\u82f1\u6587\u540d\u5b57\n    result_name = &#x5B;]\n    \n    # \u8a2d\u5b9a\u7a7a\u7684list\u5132\u5b58\u8981\u6574\u7406\u7684\u6578\u64da\n    result_data = &#x5B;]\n    \n    # \u8b80\u53d6\u8d77\u59cb\u548c\u7d50\u675f\u4f4d\u7f6e\u4e2d\u9593\u7684\u8cc7\u6599\n    for line in lines&#x5B;s:e]:\n        \n        # \u9019\u908a\u662f\u7528ccutmis\u524d\u8f29\u7684Regex\u4f86\u5c0b\u627e\u8207\u5207\u5272\u8cc7\u6599\uff1a\n        temp = re.findall('(^&#x5B;A-Za-z%]+.*&#x5B;A-Za-z%].)(.*)$', line)\n        \n        # \u539f\u59cb\u8cc7\u6599\u4e2d\u7684\u82f1\u6587\u540d\u5b58\u5230result_name\n        result_name.append(temp&#x5B;0]&#x5B;0])\n        \n        # \u539f\u59cb\u8cc7\u6599\u4e2d\u7684\u6578\u64da\u5b58\u5230result_name\n        result_data.append(temp&#x5B;0]&#x5B;1].split(' '))\n    \n    \n    df_name = pd.DataFrame(result_name)\n    df_data = pd.DataFrame(result_data)\n    \n    # \u5c07\u4ee5\u4e0a\u76842\u500bdataframe \u4e32\u63a5\n    df = pd.concat(&#x5B;df_name, df_data], axis=1)\n    \n    # \u5c07\u6b04\u540d\u4fee\u6b63\u70ba\u300ccol_1......, col_x\u300d\n    df.columns=&#x5B;'col_' + str(x) for x in range(1, len(df.columns)+1)]\n    \n    # \u5c07dataframe\u5b58\u5165df_list\n    df_list.append(df)\n\n# \u5c07\u4e0a\u9762\u8655\u7406\u5b8c\u7684\u8cc7\u6599\u5206\u62103\u500b\u5de5\u4f5c\u8868\uff0c\u5b58\u5165\u539f\u5148\u8cc7\u6599\u5b58\u4e2d\u7684test.xlsx\nw = pd.ExcelWriter('.\/20230329_test\/test.xlsx')\nfor a, b in zip(sheet_list, df_list):\n    b.to_excel(w, sheet_name=f'{a}', index=False)\nw.close()\n<\/pre><\/div>\n\n\n<p>\u7d50\u679c\u5982\u4e0b\uff1a<br>test1\u5de5\u4f5c\u8868<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"545\" height=\"512\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/20122335ho0HSMS2xU.jpg\" alt=\"\" class=\"wp-image-782\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/20122335ho0HSMS2xU.jpg 545w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/20122335ho0HSMS2xU-300x282.jpg 300w\" sizes=\"(max-width: 545px) 100vw, 545px\" \/><\/figure>\n\n\n\n<p>\u6ce8\u610ftest3\u5de5\u4f5c\u8868\u662fcol_1-col_8<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"601\" height=\"486\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/20122335hgo0VrH76g.jpg\" alt=\"\" class=\"wp-image-783\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/20122335hgo0VrH76g.jpg 601w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/20122335hgo0VrH76g-300x243.jpg 300w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/figure>\n\n\n\n<p>code 2-2\uff1a<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: python; title: ; notranslate\" title=\"\">\n# \u8a2d\u5b9a\u7a7a\u7684list\u5132\u5b58\u8ff4\u5708\u7684\u6240\u6709dataframe\ndf_list = &#x5B;]\n\n# \u8a2d\u5b9a\u7a7a\u7684list\u5132\u5b58dataframe\u7684\u5de5\u4f5c\u8868\u540d\u7a31\uff0c\u9019\u500b\u7528\u4e0d\u5230\u4e86!!\n#sheet_list = &#x5B;]\n\n# \u8ff4\u5708\u8b80\u53d6\u6240\u6709\u8981\u8655\u7406\u7684\u6a94\u6848\nfor file in files:\n    \n    # \u5c07txt\u7684\u6a94\u6848\u540d\u7a31\u4e0d\u542b\u526f\u6a94\u540d\u5b58\u5165sheet_name\uff0c\u9019\u500b\u7528\u4e0d\u5230\u4e86!!\n    #sheet_list.append(file&#x5B;-9:-4])\n    \n    # \u5148\u627e\u51fa\u8b80\u53d6\u6a94\u6848\u7684\u8d77\u59cb\u548c\u7d50\u675f\u884c\n    with open(file) as f:  \n        s, e = None, None\n        lines = f.readlines()\n        for i, line in enumerate(lines):\n    \n            # \u641c\u5c0b\u6a94\u6848\u8981\u8b80\u53d6\u7684\u8d77\u59cb\u4f4d\u7f6e\n            if line.startswith('Pred Pre %... Post %... Chg...'):\n            \n                # \u627e\u5230\u8d77\u59cb\u4f4d\u7f6e\u5f8c\uff0c\u4e0b\u4e00\u884c\u624d\u958b\u59cb\u8b80\u53d6\n                s = i+1\n            \n            # \u641c\u5c0b\u6a94\u6848\u8981\u8b80\u53d6\u7684\u7d50\u675f\u4f4d\u7f6e\n            elif line.startswith('Substance ventolin'):\n                e = i\n                  \n            else:\n                pass\n    \n    # \u8a2d\u5b9a\u7a7a\u7684list\u5132\u5b58\u8981\u6574\u7406\u7684\u82f1\u6587\u540d\u5b57\n    result_name = &#x5B;]\n    \n    # \u8a2d\u5b9a\u7a7a\u7684list\u5132\u5b58\u8981\u6574\u7406\u7684\u6578\u64da\n    result_data = &#x5B;]\n    \n    # \u8b80\u53d6\u8d77\u59cb\u548c\u7d50\u675f\u4f4d\u7f6e\u4e2d\u9593\u7684\u8cc7\u6599\n    for line in lines&#x5B;s:e]:\n        \n        # \u9019\u908a\u662f\u7528ccutmis\u524d\u8f29\u7684Regex\u4f86\u5c0b\u627e\u8207\u5207\u5272\u8cc7\u6599\uff1a\n        temp = re.findall('(^&#x5B;A-Za-z%]+.*&#x5B;A-Za-z%].)(.*)$', line)\n        \n        # \u539f\u59cb\u8cc7\u6599\u4e2d\u7684\u82f1\u6587\u540d\u5b58\u5230result_name\n        result_name.append(temp&#x5B;0]&#x5B;0])\n        \n        # \u539f\u59cb\u8cc7\u6599\u4e2d\u7684\u6578\u64da\u5b58\u5230result_name\n        result_data.append(temp&#x5B;0]&#x5B;1].split(' '))\n    \n    \n    df_name = pd.DataFrame(result_name)\n    df_data = pd.DataFrame(result_data)\n    \n    # \u5c07\u4ee5\u4e0a\u76842\u500bdataframe \u4e32\u63a5\n    df = pd.concat(&#x5B;df_name, df_data], axis=1)\n    \n    # \u5c07\u6b04\u540d\u4fee\u6b63\u70ba\u300ccol_1......, col_x\u300d\n    df.columns=&#x5B;'col_' + str(x) for x in range(1, len(df.columns)+1)]\n    \n    # \u5c07dataframe\u5b58\u5165df_list\n    df_list.append(df)\n\n# \u5c073\u500b\u6a94\u6848\u4e32\u63a5\ndf_all = pd.concat(df_list, axis=0).reset_index(drop=True)\n\n# \u4e32\u63a5\u5f8c\u7684\u6a94\u6848\u5b58\u5165\u539f\u5148\u8cc7\u6599\u5b58\u4e2d\u7684test.xlsx\ndf_all.to_excel('.\/20230329_test\/test.xlsx', index=False)\n\n<\/pre><\/div>\n\n\n<p>\u7d50\u679c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"622\" height=\"781\" src=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/20122335eXGJGEHbUf.jpg\" alt=\"\" class=\"wp-image-784\" srcset=\"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/20122335eXGJGEHbUf.jpg 622w, https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/20122335eXGJGEHbUf-239x300.jpg 239w\" sizes=\"(max-width: 622px) 100vw, 622px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u4f86\u81ea\u65bcithelp\u7db2\u53cb\u4e4b\u767c\u554f\uff0c\u7db2\u5740\u5982\u4e0b\uff1ahttps:\/\/ithelp.ithome.com.tw\/ques [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":786,"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":"default","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":"default","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":[8,9,394,171,396,178,173],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":"https:\/\/kuo.us.to\/wordpress\/wp-content\/uploads\/2023\/03\/zsl306fdck-300x200.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\">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\">Python<\/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\">re<\/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\">Regular Expression<\/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\">\u4e0d\u898f\u5247\u6587\u5b57\u6a94<\/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>","<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\">\u6b63\u898f\u8868\u9054\u5f0f<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">Pandas<\/span>","<span class=\"advgb-post-tax-term\">Python<\/span>","<span class=\"advgb-post-tax-term\">re<\/span>","<span class=\"advgb-post-tax-term\">Regular Expression<\/span>","<span class=\"advgb-post-tax-term\">\u4e0d\u898f\u5247\u6587\u5b57\u6a94<\/span>","<span class=\"advgb-post-tax-term\">\u6279\u6b21<\/span>","<span class=\"advgb-post-tax-term\">\u6b63\u898f\u8868\u9054\u5f0f<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 3 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2023 \u5e74 3 \u6708 29 \u65e5","modified":"Updated on 2023 \u5e74 3 \u6708 29 \u65e5"},"absolute_dates_time":{"created":"Posted on 2023 \u5e74 3 \u6708 29 \u65e5 \u4e0b\u5348 10:50","modified":"Updated on 2023 \u5e74 3 \u6708 29 \u65e5 \u4e0b\u5348 10:50"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/780"}],"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=780"}],"version-history":[{"count":2,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/780\/revisions"}],"predecessor-version":[{"id":785,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/780\/revisions\/785"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/786"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=780"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}