{"id":273,"date":"2022-06-24T17:20:00","date_gmt":"2022-06-24T09:20:00","guid":{"rendered":""},"modified":"2023-01-17T16:52:02","modified_gmt":"2023-01-17T08:52:02","slug":"python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98-%e7%b3%bb%e6%89%80%e7%b0%a1%e7%a8%b1%e6%aa%a2%e6%a0%b8%e5%88%a4%e6%96%b7%e7%b3%bb%e6%89%80%e6%ad%a3%e7%a2%ba%e5%90%8d%e7%a8%b1","status":"publish","type":"post","link":"https:\/\/kuo.us.to\/wordpress\/python%e5%ad%b8%e7%bf%92%e7%ad%86%e8%a8%98\/273\/","title":{"rendered":"Python\u5b78\u7fd2\u7b46\u8a18: \u7cfb\u6240\u7c21\u7a31\u6aa2\u6838\u5224\u65b7\u7cfb\u6240\u6b63\u78ba\u540d\u7a31"},"content":{"rendered":"

\u5b78\u751f\u5728\u586b\u5beb\u8cc7\u6599\u6642\uff0c\u5e38\u5e38\u4ee5\u7cfb\u6240\u7c21\u7a31\u4f86\u586b\u5beb\u3002\u672c\u6bb5\u7a0b\u5f0f\u4e3b\u8981\u4ee5\u7cfb\u6240\u7c21\u7a31\u6bd4\u5c0d\u7cfb\u6240\u6b63\u78ba\u540d\u7a31\uff0c\u4ee3\u5165\u7cfb\u6240\u6b63\u78ba\u540d\u7a31<\/h2>\n

\u672c\u6848\u4ee5\u4e2d\u539f\u5927\u5b78\u7cfb\u6240\u70ba\u7bc4\u4f8b<\/strong><\/p>\n

In [1]:<\/p>\n

import pandas as pd\n\n# \u8b80\u53d6\u7cfb\u6240\u7c21\u7a31\u8cc7\u6599\ndf1 = pd.read_excel('110624_\u7cfb\u6240\u7c21\u7a31_\u5224\u65b7\u7cfb\u6240\u6b63\u78ba\u540d\u7a31.xlsx', sheet_name='\u7cfb\u6240\u7c21\u7a31')\nprint(len(df1))\nprint(df1.columns)\nprint(df1.info())\ndf1<\/code><\/pre>\n
\n
33 Index(['\u7cfb\u6240\u7c21\u7a31'], dtype='object') <class 'pandas.core.frame.DataFrame'> RangeIndex: 33 entries, 0 to 32 Data columns (total 1 columns):  #   Column  Non-Null Count  Dtype  ---  ------  --------------  -----   0   \u7cfb\u6240\u7c21\u7a31    33 non-null     object dtypes: object(1) memory usage: 392.0+ bytes None<\/code><\/p>\n
Out[1]:<\/p>\n
\n
<\/h4>\n\n\n\n
<\/path><\/svg><\/span>Property<\/th>\n<\/path><\/svg><\/span>\u7cfb\u6240\u7c21\u7a31<\/th>\n<\/tr>\n<\/thead>\n\n
\n0<\/td>\n\u5e2b\u57f9\u4e2d\u5fc3<\/a><\/td>\n<\/tr>\n
\n1<\/td>\n\u901a\u8b58\u4e2d\u5fc3<\/a><\/td>\n<\/tr>\n
\n2<\/td>\n\u6a5f\u68b0\u7cfb<\/a><\/td>\n<\/tr>\n
\n3<\/td>\n\u5de5\u5de5\u7cfb<\/a><\/td>\n<\/tr>\n
\n4<\/td>\n\u5fc3\u7406\u7cfb<\/a><\/td>\n<\/tr>\n
\n5<\/td>\n\u74b0\u5de5\u7cfb<\/a><\/td>\n<\/tr>\n
\n6<\/td>\n\u570b\u969b\u5b78\u7a0b<\/a><\/td>\n<\/tr>\n
\n7<\/td>\n\u4f01\u7ba1\u7cfb<\/a><\/td>\n<\/tr>\n
\n8<\/td>\n\u8ca1\u91d1\u7cfb<\/a><\/td>\n<\/tr>\n
\n9<\/td>\n\u5929\u666e\u5b78\u7a0b<\/a><\/td>\n<\/tr>\n
\n10<\/td>\n\u5916\u6587\u7cfb<\/a><\/td>\n<\/tr>\n
\n11<\/td>\n\u96fb\u6a5f\u7cfb<\/a><\/td>\n<\/tr>\n
\n12<\/td>\n\u8ca1\u6cd5\u7cfb<\/a><\/td>\n<\/tr>\n
\n13<\/td>\n\u7279\u6559\u7cfb<\/a><\/td>\n<\/tr>\n
\n14<\/td>\n\u751f\u91ab\u7cfb<\/a><\/td>\n<\/tr>\n
\n15<\/td>\n\u96fb\u5b50\u7cfb<\/a><\/td>\n<\/tr>\n
\n16<\/td>\n\u8cc7\u5de5\u7cfb<\/a><\/td>\n<\/tr>\n
\n17<\/td>\n\u570b\u8cbf\u7cfb<\/a><\/td>\n<\/tr>\n
\n18<\/td>\n\u6703\u8a08\u7cfb<\/a><\/td>\n<\/tr>\n
\n19<\/td>\n\u8cc7\u7ba1\u7cfb<\/a><\/td>\n<\/tr>\n
\n20<\/td>\n\u5ba4\u5167\u8a2d\u8a08\u7cfb<\/a><\/td>\n<\/tr>\n
\n21<\/td>\n\u5546\u8a2d\u7cfb<\/a><\/td>\n<\/tr>\n
\n22<\/td>\n\u8a2d\u8a08\u539f\u6c11\u73ed<\/a><\/td>\n<\/tr>\n
\n23<\/td>\n\u83ef\u8a9e\u7cfb<\/a><\/td>\n<\/tr>\n
\n24<\/td>\n\u61c9\u6578\u7cfb<\/a><\/td>\n<\/tr>\n
\n25<\/td>\n\u5316\u5de5\u7cfb<\/a><\/td>\n<\/tr>\n
\n26<\/td>\n\u571f\u6728\u7cfb<\/a><\/td>\n<\/tr>\n
\n27<\/td>\n\u5bc6\u723e\u74e6\u57fa\u5b78\u7a0b<\/a><\/td>\n<\/tr>\n
\n28<\/td>\n\u7269\u7406\u7cfb<\/a><\/td>\n<\/tr>\n
\n29<\/td>\n\u751f\u6280\u7cfb<\/a><\/td>\n<\/tr>\n
\n30<\/td>\n\u4e0d\u5206\u7cfb<\/a><\/td>\n<\/tr>\n
\n31<\/td>\n\u4eba\u6587\u8207\u6559\u80b2\u5b78\u7a0b<\/a><\/td>\n<\/tr>\n
\n32<\/td>\n\u96fb\u8cc7\u5b78\u58eb\u73ed<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
In [2]:<\/p>\n
\n
# \u8b80\u53d6\u7cfb\u6240\u6b63\u78ba\u540d\u7a31\u8cc7\u6599\ndf2 = pd.read_excel('110624_\u7cfb\u6240\u7c21\u7a31_\u5224\u65b7\u7cfb\u6240\u6b63\u78ba\u540d\u7a31.xlsx', sheet_name='\u7cfb\u6240\u540d\u7a31')\nprint(len(df2))\nprint(df2.columns)\nprint(df2.info())\ndf2<\/code><\/pre>\n
37 Index(['\u7cfb\u6240\u540d\u7a31'], dtype='object') <class 'pandas.core.frame.DataFrame'> RangeIndex: 37 entries, 0 to 36 Data columns (total 1 columns):  #   Column  Non-Null Count  Dtype  ---  ------  --------------  -----   0   \u7cfb\u6240\u540d\u7a31    37 non-null     object dtypes: object(1) memory usage: 424.0+ bytes None<\/code><\/p>\n
Out[2]:<\/p>\n
\n
<\/h4>\n\n\n\n
<\/path><\/svg><\/span>Property<\/th>\n<\/path><\/svg><\/span>\u7cfb\u6240\u540d\u7a31<\/th>\n<\/tr>\n<\/thead>\n\n
\n0<\/td>\n\u5e2b\u8cc7\u57f9\u80b2\u4e2d\u5fc3<\/a><\/td>\n<\/tr>\n
\n1<\/td>\n\u901a\u8b58\u6559\u80b2\u4e2d\u5fc3<\/a><\/td>\n<\/tr>\n
\n2<\/td>\n\u6a5f\u68b0\u5de5\u7a0b\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n3<\/td>\n\u5de5\u696d\u8207\u7cfb\u7d71\u5de5\u7a0b\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n4<\/td>\n\u5316\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n5<\/td>\n\u5fc3\u7406\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n6<\/td>\n\u74b0\u5883\u5de5\u7a0b\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n7<\/td>\n\u570b\u969b\u5546\u5b78\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/a><\/td>\n<\/tr>\n
\n8<\/td>\n\u4f01\u696d\u7ba1\u7406\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n9<\/td>\n\u8ca1\u52d9\u91d1\u878d\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n10<\/td>\n\u4e2d\u539f\u5927\u5b78\u8207\u7f8e\u570b\u5929\u666e\u5927\u5b78\u5546\u5b78\u7ba1\u7406\u96d9\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/a><\/td>\n<\/tr>\n
\n11<\/td>\n\u61c9\u7528\u5916\u570b\u8a9e\u6587\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n12<\/td>\n\u96fb\u6a5f\u5de5\u7a0b\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n13<\/td>\n\u8ca1\u7d93\u6cd5\u5f8b\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n14<\/td>\n\u7279\u6b8a\u6559\u80b2\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n15<\/td>\n\u751f\u7269\u91ab\u5b78\u5de5\u7a0b\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n16<\/td>\n\u96fb\u5b50\u5de5\u7a0b\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n17<\/td>\n\u8cc7\u8a0a\u5de5\u7a0b\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n18<\/td>\n\u570b\u969b\u7d93\u71df\u8207\u8cbf\u6613\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n19<\/td>\n\u6703\u8a08\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n20<\/td>\n\u8cc7\u8a0a\u7ba1\u7406\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n21<\/td>\n\u5efa\u7bc9\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n22<\/td>\n\u5ba4\u5167\u8a2d\u8a08\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n23<\/td>\n\u5546\u696d\u8a2d\u8a08\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n24<\/td>\n\u8a2d\u8a08\u5b78\u58eb\u539f\u4f4f\u6c11\u5c08\u73ed<\/a><\/td>\n<\/tr>\n
\n25<\/td>\n\u5730\u666f\u5efa\u7bc9\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n26<\/td>\n\u61c9\u7528\u83ef\u8a9e\u6587\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n27<\/td>\n\u61c9\u7528\u6578\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n28<\/td>\n\u5316\u5b78\u5de5\u7a0b\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n29<\/td>\n\u571f\u6728\u5de5\u7a0b\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n30<\/td>\n\u96fb\u6a5f\u8cc7\u8a0a\u5b78\u9662\u4eba\u5de5\u667a\u6167\u61c9\u7528\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/a><\/td>\n<\/tr>\n
\n31<\/td>\n\u4e2d\u539f\u5927\u5b78\u7f8e\u570b\u5a01\u5927\u5bc6\u723e\u74e6\u57fa\u5206\u6821\u96fb\u6a5f\u8207\u8cc7\u8a0a\u5de5\u7a0b\u96d9\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/a><\/td>\n<\/tr>\n
\n32<\/td>\n\u7269\u7406\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n33<\/td>\n\u751f\u7269\u79d1\u6280\u5b78\u7cfb<\/a><\/td>\n<\/tr>\n
\n34<\/td>\n\u5168\u6821\u5916\u7c4d\u751f\u5927\u4e00\u4e0d\u5206\u7cfb\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/a><\/td>\n<\/tr>\n
\n35<\/td>\n\u4eba\u6587\u8207\u6559\u80b2\u5b78\u9662\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/a><\/td>\n<\/tr>\n
\n36<\/td>\n\u96fb\u6a5f\u8cc7\u8a0a\u5b78\u9662\u5b78\u58eb\u73ed<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
In [3]:<\/p>\n
final = [] # \u5132\u5b58\u6700\u5f8c\u6aa2\u6838\u7d50\u679cfor i in df1['\u7cfb\u6240\u7c21\u7a31']:\n    target_count = 0\n    target = []\n    for j in df2['\u7cfb\u6240\u540d\u7a31']:\n        match = set(list(i)) & set(list(j)) # \u6bd4\u5c0d\u7cfb\u6240\u7c21\u7a31\u548c\u7cfb\u6240\u540d\u7a31\u5f8c\uff0c\u627e\u51fa\u76f8\u540c\u7684\u5b57\u5143\n        temp_target = j\n        temp_count = len(match)\n        if temp_count == 0 : # \u5982\u679c\u6bd4\u5c0d\u5f8c\uff0c\u5b8c\u5168\u4e0d\u76f8\u540c\uff0c\u5c31\u627e\u4e00\u500b\u7cfb\u6240\u540d\u7a31\u7e7c\u7e8c\u505a\n            continue\n        elif temp_count > target_count: # \u5982\u679c\u6bd4\u5c0d\u5f8c\uff0c\u76f8\u540c\u7684\u5b57\u5143\u6578\u5927\u65bc\u539f\u5148target\u4e2d\u7684\u5b57\u5143\u6578\uff0c\u5247target\u5167\u5bb9\u88ab\u53d6\u4ee3\n            target = [temp_target]\n            target_count = temp_count\n        elif temp_count == target_count: # \u5982\u679c\u6bd4\u5c0d\u5f8c\uff0c\u76f8\u540c\u7684\u5b57\u5143\u6578\u8207\u539f\u5148target\u4e2d\u7684\u5b57\u5143\u6578\u4e00\u6a23\uff0c\u5247target\u5167\u5bb9\u518d\u589e\u52a0temp_target\u7684\u5167\u5bb9\n            target.append(temp_target)\n            final.append(target) # \u628atarget\u7684\u5167\u5bb9\u65b0\u589e\u5230final\u4e2dprint(final)<\/code><\/pre>\n
Out[3]:<\/p>\n
[['\u5e2b\u8cc7\u57f9\u80b2\u4e2d\u5fc3'], ['\u901a\u8b58\u6559\u80b2\u4e2d\u5fc3'], ['\u6a5f\u68b0\u5de5\u7a0b\u5b78\u7cfb'], ['\u6a5f\u68b0\u5de5\u7a0b\u5b78\u7cfb', '\u5de5\u696d\u8207\u7cfb\u7d71\u5de5\u7a0b\u5b78\u7cfb', '\u74b0\u5883\u5de5\u7a0b\u5b78\u7cfb', '\u96fb\u6a5f\u5de5\u7a0b\u5b78\u7cfb', '\u751f\u7269\u91ab\u5b78\u5de5\u7a0b\u5b78\u7cfb', '\u96fb\u5b50\u5de5\u7a0b\u5b78\u7cfb', '\u8cc7\u8a0a\u5de5\u7a0b\u5b78\u7cfb', '\u5316\u5b78\u5de5\u7a0b\u5b78\u7cfb', '\u571f\u6728\u5de5\u7a0b\u5b78\u7cfb'], ['\u5fc3\u7406\u5b78\u7cfb'], ['\u74b0\u5883\u5de5\u7a0b\u5b78\u7cfb'], ['\u570b\u969b\u5546\u5b78\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b'], ['\u4f01\u696d\u7ba1\u7406\u5b78\u7cfb'], ['\u8ca1\u52d9\u91d1\u878d\u5b78\u7cfb'], ['\u4e2d\u539f\u5927\u5b78\u8207\u7f8e\u570b\u5929\u666e\u5927\u5b78\u5546\u5b78\u7ba1\u7406\u96d9\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b'], ['\u61c9\u7528\u5916\u570b\u8a9e\u6587\u5b78\u7cfb'], ['\u96fb\u6a5f\u5de5\u7a0b\u5b78\u7cfb'], ['\u8ca1\u7d93\u6cd5\u5f8b\u5b78\u7cfb'], ['\u7279\u6b8a\u6559\u80b2\u5b78\u7cfb'], ['\u751f\u7269\u91ab\u5b78\u5de5\u7a0b\u5b78\u7cfb'], ['\u96fb\u5b50\u5de5\u7a0b\u5b78\u7cfb'], ['\u8cc7\u8a0a\u5de5\u7a0b\u5b78\u7cfb'], ['\u570b\u969b\u7d93\u71df\u8207\u8cbf\u6613\u5b78\u7cfb'], ['\u6703\u8a08\u5b78\u7cfb'], ['\u8cc7\u8a0a\u7ba1\u7406\u5b78\u7cfb'], ['\u5ba4\u5167\u8a2d\u8a08\u5b78\u7cfb'], ['\u5546\u696d\u8a2d\u8a08\u5b78\u7cfb'], ['\u8a2d\u8a08\u5b78\u58eb\u539f\u4f4f\u6c11\u5c08\u73ed'], ['\u61c9\u7528\u83ef\u8a9e\u6587\u5b78\u7cfb'], ['\u61c9\u7528\u6578\u5b78\u7cfb'], ['\u5316\u5b78\u5de5\u7a0b\u5b78\u7cfb'], ['\u571f\u6728\u5de5\u7a0b\u5b78\u7cfb'], ['\u4e2d\u539f\u5927\u5b78\u7f8e\u570b\u5a01\u5927\u5bc6\u723e\u74e6\u57fa\u5206\u6821\u96fb\u6a5f\u8207\u8cc7\u8a0a\u5de5\u7a0b\u96d9\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b'], ['\u7269\u7406\u5b78\u7cfb'], ['\u751f\u7269\u79d1\u6280\u5b78\u7cfb'], ['\u5168\u6821\u5916\u7c4d\u751f\u5927\u4e00\u4e0d\u5206\u7cfb\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b'], ['\u4eba\u6587\u8207\u6559\u80b2\u5b78\u9662\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b'], ['\u96fb\u6a5f\u8cc7\u8a0a\u5b78\u9662\u5b78\u58eb\u73ed']]<\/code><\/p>\n
In [4]:<\/p>\n
df1['\u6aa2\u6838\u5224\u65b7'] = [','.join(map(str, l)) for l in final] # \u5c07final\u7684list\u8f49\u63db\u6210df1['\u6aa2\u6838\u5224\u65b7']\n\ndf1<\/code><\/pre>\n
Out[4]:<\/p>\n
\n
<\/h4>\n\n\n\n
<\/path><\/svg><\/span>Property<\/th>\n<\/path><\/svg><\/span>\u7cfb\u6240\u7c21\u7a31<\/th>\n<\/path><\/svg><\/span>\u6aa2\u6838\u5224\u65b7<\/th>\n<\/tr>\n<\/thead>\n\n
\n0<\/td>\n\u5e2b\u57f9\u4e2d\u5fc3<\/a><\/td>\n\u5e2b\u8cc7\u57f9\u80b2\u4e2d\u5fc3<\/td>\n<\/tr>\n
\n1<\/td>\n\u901a\u8b58\u4e2d\u5fc3<\/a><\/td>\n\u901a\u8b58\u6559\u80b2\u4e2d\u5fc3<\/td>\n<\/tr>\n
\n2<\/td>\n\u6a5f\u68b0\u7cfb<\/a><\/td>\n\u6a5f\u68b0\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n3<\/td>\n\u5de5\u5de5\u7cfb<\/a><\/td>\n\u6a5f\u68b0\u5de5\u7a0b\u5b78\u7cfb,\u5de5\u696d\u8207\u7cfb\u7d71\u5de5\u7a0b\u5b78\u7cfb,\u74b0\u5883\u5de5\u7a0b\u5b78\u7cfb,\u96fb\u6a5f\u5de5\u7a0b\u5b78\u7cfb,\u751f\u7269\u91ab\u5b78\u5de5\u7a0b\u5b78\u7cfb,\u96fb\u5b50\u5de5\u7a0b\u5b78\u7cfb…<\/td>\n<\/tr>\n
\n4<\/td>\n\u5fc3\u7406\u7cfb<\/a><\/td>\n\u5fc3\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
\n5<\/td>\n\u74b0\u5de5\u7cfb<\/a><\/td>\n\u74b0\u5883\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n6<\/td>\n\u570b\u969b\u5b78\u7a0b<\/a><\/td>\n\u570b\u969b\u5546\u5b78\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/td>\n<\/tr>\n
\n7<\/td>\n\u4f01\u7ba1\u7cfb<\/a><\/td>\n\u4f01\u696d\u7ba1\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
\n8<\/td>\n\u8ca1\u91d1\u7cfb<\/a><\/td>\n\u8ca1\u52d9\u91d1\u878d\u5b78\u7cfb<\/td>\n<\/tr>\n
\n9<\/td>\n\u5929\u666e\u5b78\u7a0b<\/a><\/td>\n\u4e2d\u539f\u5927\u5b78\u8207\u7f8e\u570b\u5929\u666e\u5927\u5b78\u5546\u5b78\u7ba1\u7406\u96d9\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/td>\n<\/tr>\n
\n10<\/td>\n\u5916\u6587\u7cfb<\/a><\/td>\n\u61c9\u7528\u5916\u570b\u8a9e\u6587\u5b78\u7cfb<\/td>\n<\/tr>\n
\n11<\/td>\n\u96fb\u6a5f\u7cfb<\/a><\/td>\n\u96fb\u6a5f\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n12<\/td>\n\u8ca1\u6cd5\u7cfb<\/a><\/td>\n\u8ca1\u7d93\u6cd5\u5f8b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n13<\/td>\n\u7279\u6559\u7cfb<\/a><\/td>\n\u7279\u6b8a\u6559\u80b2\u5b78\u7cfb<\/td>\n<\/tr>\n
\n14<\/td>\n\u751f\u91ab\u7cfb<\/a><\/td>\n\u751f\u7269\u91ab\u5b78\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n15<\/td>\n\u96fb\u5b50\u7cfb<\/a><\/td>\n\u96fb\u5b50\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n16<\/td>\n\u8cc7\u5de5\u7cfb<\/a><\/td>\n\u8cc7\u8a0a\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n17<\/td>\n\u570b\u8cbf\u7cfb<\/a><\/td>\n\u570b\u969b\u7d93\u71df\u8207\u8cbf\u6613\u5b78\u7cfb<\/td>\n<\/tr>\n
\n18<\/td>\n\u6703\u8a08\u7cfb<\/a><\/td>\n\u6703\u8a08\u5b78\u7cfb<\/td>\n<\/tr>\n
\n19<\/td>\n\u8cc7\u7ba1\u7cfb<\/a><\/td>\n\u8cc7\u8a0a\u7ba1\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
\n20<\/td>\n\u5ba4\u5167\u8a2d\u8a08\u7cfb<\/a><\/td>\n\u5ba4\u5167\u8a2d\u8a08\u5b78\u7cfb<\/td>\n<\/tr>\n
\n21<\/td>\n\u5546\u8a2d\u7cfb<\/a><\/td>\n\u5546\u696d\u8a2d\u8a08\u5b78\u7cfb<\/td>\n<\/tr>\n
\n22<\/td>\n\u8a2d\u8a08\u539f\u6c11\u73ed<\/a><\/td>\n\u8a2d\u8a08\u5b78\u58eb\u539f\u4f4f\u6c11\u5c08\u73ed<\/td>\n<\/tr>\n
\n23<\/td>\n\u83ef\u8a9e\u7cfb<\/a><\/td>\n\u61c9\u7528\u83ef\u8a9e\u6587\u5b78\u7cfb<\/td>\n<\/tr>\n
\n24<\/td>\n\u61c9\u6578\u7cfb<\/a><\/td>\n\u61c9\u7528\u6578\u5b78\u7cfb<\/td>\n<\/tr>\n
\n25<\/td>\n\u5316\u5de5\u7cfb<\/a><\/td>\n\u5316\u5b78\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n26<\/td>\n\u571f\u6728\u7cfb<\/a><\/td>\n\u571f\u6728\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n27<\/td>\n\u5bc6\u723e\u74e6\u57fa\u5b78\u7a0b<\/a><\/td>\n\u4e2d\u539f\u5927\u5b78\u7f8e\u570b\u5a01\u5927\u5bc6\u723e\u74e6\u57fa\u5206\u6821\u96fb\u6a5f\u8207\u8cc7\u8a0a\u5de5\u7a0b\u96d9\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/td>\n<\/tr>\n
\n28<\/td>\n\u7269\u7406\u7cfb<\/a><\/td>\n\u7269\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
\n29<\/td>\n\u751f\u6280\u7cfb<\/a><\/td>\n\u751f\u7269\u79d1\u6280\u5b78\u7cfb<\/td>\n<\/tr>\n
\n30<\/td>\n\u4e0d\u5206\u7cfb<\/a><\/td>\n\u5168\u6821\u5916\u7c4d\u751f\u5927\u4e00\u4e0d\u5206\u7cfb\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/td>\n<\/tr>\n
\n31<\/td>\n\u4eba\u6587\u8207\u6559\u80b2\u5b78\u7a0b<\/a><\/td>\n\u4eba\u6587\u8207\u6559\u80b2\u5b78\u9662\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/td>\n<\/tr>\n
\n32<\/td>\n\u96fb\u8cc7\u5b78\u58eb\u73ed<\/a><\/td>\n\u96fb\u6a5f\u8cc7\u8a0a\u5b78\u9662\u5b78\u58eb\u73ed<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
In [5]:<\/p>\n
df1.loc[df1['\u6aa2\u6838\u5224\u65b7'].str.split(',').apply(len)>3, '\u6aa2\u6838\u5224\u65b7'] = \"\" # \u5982\u679cdf1['\u6aa2\u6838\u5224\u65b7']\u4e2d\u8d85\u904e3\u500b\u904f\u865f\uff0c\u8868\u793a\u592a\u591a\u4e00\u6a23\uff0c\u5c07\u5167\u5bb9\u53d6\u4ee3\u70baNaN\uff0c\u672a\u4f86\u63a1\u4eba\u5de5\u5224\u65b7\n\ndf1<\/code><\/pre>\n
Out[5]:<\/p>\n
\n
<\/h4>\n\n\n\n
<\/path><\/svg><\/span>Property<\/th>\n<\/path><\/svg><\/span>\u7cfb\u6240\u7c21\u7a31<\/th>\n<\/path><\/svg><\/span>\u6aa2\u6838\u5224\u65b7<\/th>\n<\/tr>\n<\/thead>\n\n
\n0<\/td>\n\u5e2b\u57f9\u4e2d\u5fc3<\/a><\/td>\n\u5e2b\u8cc7\u57f9\u80b2\u4e2d\u5fc3<\/td>\n<\/tr>\n
\n1<\/td>\n\u901a\u8b58\u4e2d\u5fc3<\/a><\/td>\n\u901a\u8b58\u6559\u80b2\u4e2d\u5fc3<\/td>\n<\/tr>\n
\n2<\/td>\n\u6a5f\u68b0\u7cfb<\/a><\/td>\n\u6a5f\u68b0\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n3<\/td>\n\u5de5\u5de5\u7cfb<\/a><\/td>\n<\/td>\n<\/tr>\n
\n4<\/td>\n\u5fc3\u7406\u7cfb<\/a><\/td>\n\u5fc3\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
\n5<\/td>\n\u74b0\u5de5\u7cfb<\/a><\/td>\n\u74b0\u5883\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n6<\/td>\n\u570b\u969b\u5b78\u7a0b<\/a><\/td>\n\u570b\u969b\u5546\u5b78\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/td>\n<\/tr>\n
\n7<\/td>\n\u4f01\u7ba1\u7cfb<\/a><\/td>\n\u4f01\u696d\u7ba1\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
\n8<\/td>\n\u8ca1\u91d1\u7cfb<\/a><\/td>\n\u8ca1\u52d9\u91d1\u878d\u5b78\u7cfb<\/td>\n<\/tr>\n
\n9<\/td>\n\u5929\u666e\u5b78\u7a0b<\/a><\/td>\n\u4e2d\u539f\u5927\u5b78\u8207\u7f8e\u570b\u5929\u666e\u5927\u5b78\u5546\u5b78\u7ba1\u7406\u96d9\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/td>\n<\/tr>\n
\n10<\/td>\n\u5916\u6587\u7cfb<\/a><\/td>\n\u61c9\u7528\u5916\u570b\u8a9e\u6587\u5b78\u7cfb<\/td>\n<\/tr>\n
\n11<\/td>\n\u96fb\u6a5f\u7cfb<\/a><\/td>\n\u96fb\u6a5f\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n12<\/td>\n\u8ca1\u6cd5\u7cfb<\/a><\/td>\n\u8ca1\u7d93\u6cd5\u5f8b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n13<\/td>\n\u7279\u6559\u7cfb<\/a><\/td>\n\u7279\u6b8a\u6559\u80b2\u5b78\u7cfb<\/td>\n<\/tr>\n
\n14<\/td>\n\u751f\u91ab\u7cfb<\/a><\/td>\n\u751f\u7269\u91ab\u5b78\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n15<\/td>\n\u96fb\u5b50\u7cfb<\/a><\/td>\n\u96fb\u5b50\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n16<\/td>\n\u8cc7\u5de5\u7cfb<\/a><\/td>\n\u8cc7\u8a0a\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n17<\/td>\n\u570b\u8cbf\u7cfb<\/a><\/td>\n\u570b\u969b\u7d93\u71df\u8207\u8cbf\u6613\u5b78\u7cfb<\/td>\n<\/tr>\n
\n18<\/td>\n\u6703\u8a08\u7cfb<\/a><\/td>\n\u6703\u8a08\u5b78\u7cfb<\/td>\n<\/tr>\n
\n19<\/td>\n\u8cc7\u7ba1\u7cfb<\/a><\/td>\n\u8cc7\u8a0a\u7ba1\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
\n20<\/td>\n\u5ba4\u5167\u8a2d\u8a08\u7cfb<\/a><\/td>\n\u5ba4\u5167\u8a2d\u8a08\u5b78\u7cfb<\/td>\n<\/tr>\n
\n21<\/td>\n\u5546\u8a2d\u7cfb<\/a><\/td>\n\u5546\u696d\u8a2d\u8a08\u5b78\u7cfb<\/td>\n<\/tr>\n
\n22<\/td>\n\u8a2d\u8a08\u539f\u6c11\u73ed<\/a><\/td>\n\u8a2d\u8a08\u5b78\u58eb\u539f\u4f4f\u6c11\u5c08\u73ed<\/td>\n<\/tr>\n
\n23<\/td>\n\u83ef\u8a9e\u7cfb<\/a><\/td>\n\u61c9\u7528\u83ef\u8a9e\u6587\u5b78\u7cfb<\/td>\n<\/tr>\n
\n24<\/td>\n\u61c9\u6578\u7cfb<\/a><\/td>\n\u61c9\u7528\u6578\u5b78\u7cfb<\/td>\n<\/tr>\n
\n25<\/td>\n\u5316\u5de5\u7cfb<\/a><\/td>\n\u5316\u5b78\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n26<\/td>\n\u571f\u6728\u7cfb<\/a><\/td>\n\u571f\u6728\u5de5\u7a0b\u5b78\u7cfb<\/td>\n<\/tr>\n
\n27<\/td>\n\u5bc6\u723e\u74e6\u57fa\u5b78\u7a0b<\/a><\/td>\n\u4e2d\u539f\u5927\u5b78\u7f8e\u570b\u5a01\u5927\u5bc6\u723e\u74e6\u57fa\u5206\u6821\u96fb\u6a5f\u8207\u8cc7\u8a0a\u5de5\u7a0b\u96d9\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/td>\n<\/tr>\n
\n28<\/td>\n\u7269\u7406\u7cfb<\/a><\/td>\n\u7269\u7406\u5b78\u7cfb<\/td>\n<\/tr>\n
\n29<\/td>\n\u751f\u6280\u7cfb<\/a><\/td>\n\u751f\u7269\u79d1\u6280\u5b78\u7cfb<\/td>\n<\/tr>\n
\n30<\/td>\n\u4e0d\u5206\u7cfb<\/a><\/td>\n\u5168\u6821\u5916\u7c4d\u751f\u5927\u4e00\u4e0d\u5206\u7cfb\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/td>\n<\/tr>\n
\n31<\/td>\n\u4eba\u6587\u8207\u6559\u80b2\u5b78\u7a0b<\/a><\/td>\n\u4eba\u6587\u8207\u6559\u80b2\u5b78\u9662\u5b78\u58eb\u5b78\u4f4d\u5b78\u7a0b<\/td>\n<\/tr>\n
\n32<\/td>\n\u96fb\u8cc7\u5b78\u58eb\u73ed<\/a><\/td>\n\u96fb\u6a5f\u8cc7\u8a0a\u5b78\u9662\u5b78\u58eb\u73ed<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
In [ ]:<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5b78\u751f\u5728\u586b\u5beb\u8cc7\u6599\u6642\uff0c\u5e38\u5e38\u4ee5\u7cfb\u6240\u7c21\u7a31\u4f86\u586b\u5beb\u3002\u672c\u6bb5\u7a0b\u5f0f\u4e3b\u8981\u4ee5\u7cfb\u6240\u7c21\u7a31\u6bd4\u5c0d\u7cfb\u6240\u6b63\u78ba\u540d\u7a31\uff0c\u4ee3\u5165\u7cfb\u6240\u6b63\u78ba\u540d\u7a31 \u672c\u6848\u4ee5\u4e2d\u539f\u5927 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[7,8,9,231,232],"author_meta":{"display_name":"mackuo","author_link":"https:\/\/kuo.us.to\/wordpress\/author\/mackuo\/"},"featured_img":null,"coauthors":[],"tax_additional":{"categories":{"linked":["Python\u5b78\u7fd2\u7b46\u8a18<\/a>"],"unlinked":["Python\u5b78\u7fd2\u7b46\u8a18<\/span>"]},"tags":{"linked":["List<\/a>","Pandas<\/a>","Python<\/a>","\u5b57\u4e32<\/a>","\u6bd4\u5c0d<\/a>"],"unlinked":["List<\/span>","Pandas<\/span>","Python<\/span>","\u5b57\u4e32<\/span>","\u6bd4\u5c0d<\/span>"]}},"comment_count":"0","relative_dates":{"created":"Posted 4 \u5e74 ago","modified":"Updated 3 \u5e74 ago"},"absolute_dates":{"created":"Posted on 2022 \u5e74 6 \u6708 24 \u65e5","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5"},"absolute_dates_time":{"created":"Posted on 2022 \u5e74 6 \u6708 24 \u65e5 \u4e0b\u5348 5:20","modified":"Updated on 2023 \u5e74 1 \u6708 17 \u65e5 \u4e0b\u5348 4:52"},"featured_img_caption":"","series_order":"","_links":{"self":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/273"}],"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=273"}],"version-history":[{"count":2,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/273\/revisions"}],"predecessor-version":[{"id":633,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/posts\/273\/revisions\/633"}],"wp:attachment":[{"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/media?parent=273"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/categories?post=273"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kuo.us.to\/wordpress\/wp-json\/wp\/v2\/tags?post=273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}