{"id":4156,"date":"2023-07-13T05:43:36","date_gmt":"2023-07-13T05:43:36","guid":{"rendered":"https:\/\/statorials.org\/cn\/pandas-%e9%80%90%e8%a1%8c%e6%af%94%e8%be%83%e4%b8%a4%e4%b8%aa%e6%95%b0%e6%8d%ae%e5%b8%a7\/"},"modified":"2023-07-13T05:43:36","modified_gmt":"2023-07-13T05:43:36","slug":"pandas-%e9%80%90%e8%a1%8c%e6%af%94%e8%be%83%e4%b8%a4%e4%b8%aa%e6%95%b0%e6%8d%ae%e5%b8%a7","status":"publish","type":"post","link":"https:\/\/statorials.org\/cn\/pandas-%e9%80%90%e8%a1%8c%e6%af%94%e8%be%83%e4%b8%a4%e4%b8%aa%e6%95%b0%e6%8d%ae%e5%b8%a7\/","title":{"rendered":"Pandas\uff1a\u5982\u4f55\u9010\u884c\u6bd4\u8f83\u4e24\u4e2a dataframe"},"content":{"rendered":"

<\/p>\n

\n

\u60a8\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u65b9\u6cd5\u9010\u884c\u6bd4\u8f83\u4e24\u4e2a pandas DataFrame\uff1a<\/span><\/p>\n

\u65b9\u6cd5 1\uff1a\u6bd4\u8f83 DataFrame \u5e76\u4ec5\u4fdd\u7559\u6709\u5dee\u5f02\u7684\u884c<\/strong><\/span><\/p>\n

 df_diff = df1. compare<\/span> (df2, keep_equal= True<\/span> , align_axis= 0<\/span> )\n<\/strong><\/pre>\n
\u65b9\u6cd5 2\uff1a\u6bd4\u8f83 DataFrame \u5e76\u4fdd\u7559\u6240\u6709\u884c<\/strong><\/span><\/p>\n
 df_diff = df1. compare<\/span> (df2, keep_equal= True<\/span> , keep_shape= True<\/span> , align_axis= 0<\/span> )<\/strong><\/pre>\n
\u4ee5\u4e0b\u793a\u4f8b\u5c55\u793a\u4e86\u5982\u4f55\u5c06\u6bcf\u79cd\u65b9\u6cd5\u4e0e\u4ee5\u4e0b pandas DataFrame \u4e00\u8d77\u4f7f\u7528\uff1a<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#create first DataFrame\n<\/span>df1 = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'B', 'C', 'D'],\n                    ' points<\/span> ': [18, 22, 19, 14],\n                    ' assists<\/span> ': [5, 7, 7, 9]})\n\nprint<\/span> (df1)\n\n  team points assists\n0 to 18 5\n1 B 22 7\n2 C 19 7\n3 D 14 9\n\n#create second DataFrame\n<\/span>df2 = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'B', 'C', 'E'],\n                    ' points<\/span> ': [18, 30, 19, 20],\n                    ' assists<\/span> ': [5, 7, 7, 9]})\n\nprint<\/span> (df2)\n\n  team points assists\n0 to 18 5\n1 B 30 7\n2 C 19 7\n3 E 20 9<\/strong><\/pre>\n
\u793a\u4f8b 1\uff1a\u6bd4\u8f83 DataFrame \u5e76\u4ec5\u4fdd\u7559\u6709\u5dee\u5f02\u7684\u884c<\/strong><\/span><\/h2>\n
\u4e0b\u9762\u7684\u4ee3\u7801\u5c55\u793a\u4e86\u5982\u4f55\u9010\u884c\u6bd4\u8f83\u4e24\u4e2a DataFrame \u5e76\u4ec5\u4fdd\u7559\u81f3\u5c11\u4e00\u5217\u4e2d\u5b58\u5728\u5dee\u5f02\u7684\u884c\uff1a<\/span><\/p>\n
 #compare DataFrames and only keep rows with differences\n<\/span>df_diff = df1. compare<\/span> (df2, keep_equal= True<\/span> , align_axis= 0<\/span> )\n\n#view results\n<\/span>print<\/span> (df_diff)\n\n        team points\n1 coil B 22\n  other B 30\n3 choke D 14\n  other E 20<\/span><\/span><\/strong><\/pre>\n
\u6211\u4eec\u53ef\u4ee5\u770b\u5230 DataFrame \u6709\u4e24\u4e2a\u4e0d\u540c\u7684\u884c\u3002<\/span><\/p>\n
\u7279\u522b\u662f\uff0c\u6211\u4eec\u53ef\u4ee5\u770b\u5230\u6bcf\u4e2aDataFrame\u7684\u7d22\u5f15\u4f4d\u7f6e1\u548c3\u5904\u7684\u884c\u81f3\u5c11\u6709\u4e00\u5217\u5177\u6709\u4e0d\u540c\u7684\u503c\u3002<\/span><\/p>\n
 self<\/strong>\u884c\u4e2d\u7684\u503c\u663e\u793a\u7b2c\u4e00\u4e2a DataFrame \u7684\u503c\uff0c\u800c\u53e6\u4e00<\/strong>\u884c\u4e2d\u7684\u503c\u663e\u793a\u7b2c\u4e8c\u4e2a DataFrame \u7684\u503c\u3002<\/span><\/p>\n
\u4f8b\u5982\uff0c\u6211\u4eec\u53ef\u4ee5\u770b\u5230\uff1a<\/span><\/p>\n