{"id":427,"date":"2022-08-06T14:35:38","date_gmt":"2022-08-06T06:35:38","guid":{"rendered":"https:\/\/kuo.us.to\/wordpress\/?p=427"},"modified":"2023-01-17T16:47:03","modified_gmt":"2023-01-17T08:47:03","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%96excel%e6%aa%94%e6%a1%88%e4%b8%8b%e6%89%80%e6%9c%89%e7%9a%84%e5%b7%a5%e4%bd%9c%e8%a1%a8%ef%bc%88%e5%90%8c%e4%b8%80","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/427\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: \u6279\u6b21\u8b80\u53d6excel\u6a94\u6848\u4e0b\u6240\u6709\u7684\u5de5\u4f5c\u8868\uff08\u540c\u4e00\u76ee\u9304\u4e0b\uff09\uff0c\u5f59\u6574\u6210\u4e00\u500bdataframe"},"content":{"rendered":"\n

\u672c\u6587\u70ba\u7db2\u53cb\u65bcithelp\u767c\u554f\u4e4b\u89e3\u7b54\uff1a<\/p>\n\n\n\n

\u7db2\u53cb\u6709n\u500bexcel\u6a94\u6848\uff0c\u6bcf\u500b\u6a94\u6848\u4e2d\u90fd\u6709time\u3001X\u3001Y\u3001Z\u5de5\u4f5c\u8868\u3002
\u7db2\u53cb\u60f3\u8981\u628a\u6bcf\u500bexcel\u6a94\u6848\u4e2d\u300c\u76f8\u540c\u540d\u7a31\u300d\u7684\u5de5\u4f5c\u8868\u8b80\u51fa\u4f86\uff0c\u4e26\u6574\u5408\u6210\u540c\u4e00\u500bdataframe\uff0c
\u7136\u5f8c\u518d\u4f86\u505a\u5f8c\u7e8c\u7684\u8655\u7406\u3002<\/p>\n\n\n\n

https:\/\/ithelp.ithome.com.tw\/questions\/10209617<\/a><\/p>\n\n\n\n

import<\/strong> pandas as<\/strong> pd\nimport<\/strong> os\n\npath =<\/strong> os.<\/strong>getcwd()\n# List files:<\/em>\nfiles =<\/strong> os.<\/strong>listdir(path)\nprint(files)\nfiles_xlsx =<\/strong> [f for<\/strong> f in<\/strong> files if<\/strong> f[-<\/strong>4:] ==<\/strong> \"xlsx\"]\nfiles_xls =<\/strong> [f for<\/strong> f in<\/strong> files if<\/strong> f[-<\/strong>3:] ==<\/strong> \"xls\"]\nfiles_xls.<\/strong>extend(files_xlsx)\nfor<\/strong> i, element in<\/strong> enumerate(files_xls):\n    print(i, element)\nprint(len(files_xls))\n\nprint(files_xls)<\/code><\/pre>\n\n\n\n
['.ipynb_checkpoints', '1.xlsx', '2.xlsx', '3.xlsx', 'Untitled.ipynb']\n0 1.xlsx\n1 2.xlsx\n2 3.xlsx\n3\n['1.xlsx', '2.xlsx', '3.xlsx']\n<\/pre>\n\n\n\n
import<\/strong> warnings\nsh_list =<\/strong> ['time', 'X', 'Y', 'Z']\n\nfor<\/strong> s in<\/strong> sh_list:\n    df =<\/strong> pd.<\/strong>DataFrame()\n    print(f'\u5de5\u4f5c\u8868\u8b8a\u6578\uff1a{s}')\n    for<\/strong> f in<\/strong> files_xls:\n        data =<\/strong> pd.<\/strong>read_excel(f, sheet_name=<\/strong>s)        \n        warnings.<\/strong>simplefilter(\"ignore\") #\u4e0d\u986f\u793a\u8b80\u6a94\u9a57\u8b49\u8b66\u544a<\/em>\n        print(f'\u6a94\u6848\u540d\u7a31\uff1a{f}\uff0c\u5de5\u4f5c\u8868{s}\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a{len(data)}')\n\n        df =<\/strong> df.<\/strong>append(data, ignore_index=True<\/strong>) # \u5c07\u6240\u6709\u6a94\u6848\u4e2d\u76f8\u540c\u540d\u7a31\u7684\u5de5\u4f5c\u8868dataframe\u5408\u4f75<\/em>\n    print(f'dataframe_{s}\u7684\u7e3d\u8cc7\u6599\u7b46\u6578\uff1a{len(df)}')\n    \n    \n    exec('{} = df.copy()'.<\/strong>format('df_'+<\/strong>s)) # \u5c07\u5408\u4f75\u597d\u7684\u5de5\u4f5c\u8868dataframe\u5b58\u5230\u4e00\u500b\u65b0\u7684\u540d\u7a31\u5982df_time<\/em><\/strong><\/code><\/pre>\n\n\n\n
\u5de5\u4f5c\u8868\u8b8a\u6578\uff1atime\n\u6a94\u6848\u540d\u7a31\uff1a1.xlsx\uff0c\u5de5\u4f5c\u8868time\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a224\n\u6a94\u6848\u540d\u7a31\uff1a2.xlsx\uff0c\u5de5\u4f5c\u8868time\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a475\n\u6a94\u6848\u540d\u7a31\uff1a3.xlsx\uff0c\u5de5\u4f5c\u8868time\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a469\ndataframe_time\u7684\u7e3d\u8cc7\u6599\u7b46\u6578\uff1a1168\n\u5de5\u4f5c\u8868\u8b8a\u6578\uff1aX\n\u6a94\u6848\u540d\u7a31\uff1a1.xlsx\uff0c\u5de5\u4f5c\u8868X\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a224\n\u6a94\u6848\u540d\u7a31\uff1a2.xlsx\uff0c\u5de5\u4f5c\u8868X\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a475\n\u6a94\u6848\u540d\u7a31\uff1a3.xlsx\uff0c\u5de5\u4f5c\u8868X\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a469\ndataframe_X\u7684\u7e3d\u8cc7\u6599\u7b46\u6578\uff1a1168\n\u5de5\u4f5c\u8868\u8b8a\u6578\uff1aY\n\u6a94\u6848\u540d\u7a31\uff1a1.xlsx\uff0c\u5de5\u4f5c\u8868Y\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a224\n\u6a94\u6848\u540d\u7a31\uff1a2.xlsx\uff0c\u5de5\u4f5c\u8868Y\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a475\n\u6a94\u6848\u540d\u7a31\uff1a3.xlsx\uff0c\u5de5\u4f5c\u8868Y\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a469\ndataframe_Y\u7684\u7e3d\u8cc7\u6599\u7b46\u6578\uff1a1168\n\u5de5\u4f5c\u8868\u8b8a\u6578\uff1aZ\n\u6a94\u6848\u540d\u7a31\uff1a1.xlsx\uff0c\u5de5\u4f5c\u8868Z\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a224\n\u6a94\u6848\u540d\u7a31\uff1a2.xlsx\uff0c\u5de5\u4f5c\u8868Z\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a475\n\u6a94\u6848\u540d\u7a31\uff1a3.xlsx\uff0c\u5de5\u4f5c\u8868Z\u7684\u539f\u59cb\u8cc7\u6599\u7b46\u6578\uff1a469\ndataframe_Z\u7684\u7e3d\u8cc7\u6599\u7b46\u6578\uff1a1168\n<\/pre>\n\n\n\n
print(len(df_time))\ndf_time.<\/strong>head()<\/strong><\/strong><\/code><\/pre>\n\n\n\n
1168<\/pre>\n\n\n\n
<\/th>0<\/th>1<\/th><\/tr><\/thead>
0<\/th>0.0<\/td>NaN<\/td><\/tr>
1<\/th>0.0<\/td>NaN<\/td><\/tr>
2<\/th>0.0<\/td>NaN<\/td><\/tr>
3<\/th>0.0<\/td>NaN<\/td><\/tr>
4<\/th>0.0<\/td>NaN<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
print(len(df_X))\ndf_X.<\/strong>head()<\/strong><\/strong><\/code><\/pre>\n\n\n\n
1168<\/pre>\n\n\n\n
<\/th>0.04102<\/th>-0.10547<\/th>-0.1748<\/th>-0.13477<\/th>0.01904<\/th>0.05664<\/th>0.02539<\/th>-0.09033<\/th>-0.17432<\/th>-0.1167<\/th>…<\/th>-0.03516.2<\/th>-0.02832.2<\/th>-0.11523.1<\/th>-0.17627.4<\/th>0.22949<\/th>0.41064<\/th>0.27441.2<\/th>0.1167.3<\/th>0.06006.4<\/th>0.06641.5<\/th><\/tr><\/thead>
0<\/th>-0.41943<\/td>-0.10059<\/td>0.20605<\/td>0.27051<\/td>0.28760<\/td>0.17188<\/td>-0.10596<\/td>-0.21484<\/td>-0.09229<\/td>0.29248<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
1<\/th>0.05176<\/td>0.00586<\/td>-0.03516<\/td>-0.05371<\/td>-0.01807<\/td>0.12744<\/td>0.16602<\/td>0.08838<\/td>-0.03564<\/td>-0.08008<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
2<\/th>-0.70557<\/td>-0.48193<\/td>-0.12988<\/td>0.29785<\/td>0.16455<\/td>-0.24951<\/td>0.12354<\/td>0.35303<\/td>0.16650<\/td>0.15918<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
3<\/th>0.05127<\/td>-0.27930<\/td>-0.35889<\/td>-0.21143<\/td>-0.00977<\/td>0.08154<\/td>0.14697<\/td>0.28418<\/td>0.37305<\/td>0.26221<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
4<\/th>0.03027<\/td>-0.59082<\/td>-0.97949<\/td>-0.63574<\/td>0.06885<\/td>0.47705<\/td>0.35059<\/td>-0.04639<\/td>-0.15820<\/td>0.07666<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
5 rows \u00d7 5559 columnsIn [5]:<\/p>\n\n\n\n
print(len(df_Y))\ndf_Y.<\/strong>head()<\/strong><\/strong><\/code><\/pre>\n\n\n\n
1168<\/pre>\n\n\n\n
<\/th>-0.15186<\/th>-0.25<\/th>-0.26367<\/th>-0.2749<\/th>-0.30957<\/th>-0.38379<\/th>-0.38428<\/th>-0.37598<\/th>-0.29883<\/th>-0.146<\/th>…<\/th>-0.00244.7<\/th>0.20654.2<\/th>-0.01807.9<\/th>0.23584.2<\/th>0.3833.1<\/th>-0.07617.3<\/th>-0.37988<\/th>-0.40771.1<\/th>0.12256.3<\/th>-0.01562.5<\/th><\/tr><\/thead>
0<\/th>-0.23535<\/td>0.28613<\/td>0.49023<\/td>0.21631<\/td>-0.24805<\/td>-0.30127<\/td>0.09033<\/td>0.37061<\/td>0.40283<\/td>0.26025<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
1<\/th>-0.24512<\/td>-0.16797<\/td>-0.06836<\/td>0.06152<\/td>0.03613<\/td>0.00537<\/td>0.00000<\/td>0.04541<\/td>0.05420<\/td>0.04346<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
2<\/th>0.16846<\/td>0.25098<\/td>0.11035<\/td>-0.08691<\/td>-0.28906<\/td>-0.31592<\/td>-0.35693<\/td>-0.27637<\/td>-0.03125<\/td>-0.00049<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
3<\/th>0.24561<\/td>0.35889<\/td>0.19336<\/td>-0.07178<\/td>-0.05029<\/td>0.22754<\/td>0.41113<\/td>0.26074<\/td>-0.11621<\/td>-0.23633<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
4<\/th>-0.16406<\/td>-0.15771<\/td>-0.09717<\/td>-0.04883<\/td>-0.03516<\/td>-0.15869<\/td>-0.18115<\/td>-0.20459<\/td>-0.15283<\/td>0.18359<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
5 rows \u00d7 5601 columnsIn [6]:<\/p>\n\n\n\n
print(len(df_Z))\ndf_Z.<\/strong>head()<\/strong><\/strong><\/code><\/pre>\n\n\n\n
1168<\/pre>\n\n\n\n
<\/th>-0.021<\/th>0.05566<\/th>0.05078<\/th>-0.01025<\/th>-0.05762<\/th>-0.06982<\/th>-0.11768<\/th>-0.06201<\/th>-0.04785<\/th>-0.10254<\/th>…<\/th>0.33887<\/th>0.05273.5<\/th>-0.26855.2<\/th>0.16406.2<\/th>0.14258.2<\/th>0.17725.1<\/th>0.1416.4<\/th>0.19727.3<\/th>0.03223.9<\/th>-0.38916.1<\/th><\/tr><\/thead>
0<\/th>0.31445<\/td>0.10303<\/td>-0.21191<\/td>-0.16260<\/td>0.09375<\/td>0.10205<\/td>-0.12402<\/td>-0.23584<\/td>-0.25879<\/td>0.00537<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
1<\/th>0.10693<\/td>-0.03516<\/td>0.02100<\/td>-0.05566<\/td>-0.04980<\/td>0.01221<\/td>-0.00195<\/td>0.02100<\/td>-0.02783<\/td>-0.00635<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
2<\/th>-0.06006<\/td>-0.10205<\/td>-0.06689<\/td>0.39844<\/td>0.35645<\/td>-0.05957<\/td>0.09863<\/td>-0.01172<\/td>-0.31250<\/td>-0.13965<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
3<\/th>-0.14209<\/td>-0.29150<\/td>-0.09131<\/td>0.34473<\/td>0.56250<\/td>0.33936<\/td>0.04980<\/td>-0.00830<\/td>0.10889<\/td>0.04736<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr>
4<\/th>-0.23535<\/td>-0.20410<\/td>-0.08936<\/td>-0.10107<\/td>-0.27344<\/td>-0.30713<\/td>-0.17334<\/td>-0.04834<\/td>-0.10400<\/td>-0.18945<\/td>…<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td>NaN<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
5 rows \u00d7 5298 columns<\/p>\n","protected":false},"excerpt":{"rendered":"
\u672c\u6587\u70ba\u7db2\u53cb\u65bcithelp\u767c\u554f\u4e4b\u89e3\u7b54\uff1a \u7db2\u53cb\u6709n\u500bexcel\u6a94\u6848\uff0c\u6bcf\u500b\u6a94\u6848\u4e2d\u90fd\u6709time\u3001X\u3001Y\u3001Z\u5de5\u4f5c\u8868\u3002\u7db2\u53cb […]<\/p>\n","protected":false},"author":1,"featured_media":433,"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":[177,8,9,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\/08\/lftttcsx5vk-300x200.jpg","coauthors":[],"tax_additional":{"categories":{"linked":["Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["excel<\/a>","Pandas<\/a>","Python<\/a>","\u6279\u6b21<\/a>"],"unlinked":["excel<\/span>","Pandas<\/span>","Python<\/span>","\u6279\u6b21<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 4 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2022 \u5e74 8 \u6708 6 \u65e5","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 8 \u6708 6 \u65e5 \u4e0b\u5348 2:35","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5 \u4e0b\u5348 4:47"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/427"}],"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=427"}],"version-history":[{"count":6,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/427\/revisions"}],"predecessor-version":[{"id":437,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/427\/revisions\/437"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media\/433"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}