{"id":1414,"date":"2020-10-26T02:28:33","date_gmt":"2020-10-26T02:28:33","guid":{"rendered":"https:\/\/www.ipcpu.com\/?p=1414"},"modified":"2021-04-26T02:29:02","modified_gmt":"2021-04-26T02:29:02","slug":"pandas%e4%b8%a4%e4%b8%aadataframe%e6%8c%89%e7%85%a7%e6%8c%87%e5%ae%9a%e5%88%97%e7%9b%b8%e5%8a%a0%e6%b1%82%e5%92%8c","status":"publish","type":"post","link":"https:\/\/c.ipcpu.com\/2020\/10\/pandas%e4%b8%a4%e4%b8%aadataframe%e6%8c%89%e7%85%a7%e6%8c%87%e5%ae%9a%e5%88%97%e7%9b%b8%e5%8a%a0%e6%b1%82%e5%92%8c\/","title":{"rendered":"pandas\u4e24\u4e2adataframe\u6309\u7167\u6307\u5b9a\u5217\u76f8\u52a0\u6c42\u548c"},"content":{"rendered":"

pandas\u4e24\u4e2adataframe\u6309\u7167\u6307\u5b9a\u5217\u76f8\u52a0\u6c42\u548c.md<\/p>\n

\u9700\u6c42<\/h2>\n

\u5982\u4e0b\u56fe\u4e24\u4e2adataframe\uff0c\u6309\u7167name\u540d\u79f0\u5bf9value\u8fdb\u884c\u76f8\u52a0\u6c42\u548c\u3002
\n\u6ce8\u610f\uff0cname\u987a\u5e8f\u662f\u6253\u4e71\u7684\u3002
\n<\/p>\n

\u5c1d\u8bd5<\/h2>\n

\u6211\u4eec\u76f4\u63a5\u76f8\u52a0\uff0c\u4f46\u662f\u5f97\u5230\u4e86\u5982\u4e0b\u7ed3\u679c<\/p>\n

\n
df = df1 + df2\ndf = df1.add(df2)\n======newdf=======\n               name  value\n0     baishanaliyun   1130\n1     aliyunbaishan   1447\n2  kingsoftkingsoft    151\n3        totaltotal   6409\n4        otherother   3681<\/code><\/pre>\n<\/div>\n
\u663e\u7136\u4e0d\u5408\u8981\u6c42<\/p>\n
\u6b63\u89e3<\/h2>\n
\u7f51\u4e0a\u67e5\u4e86\u4e0b\uff0c\u7ec8\u4e8e\u627e\u5230\u4e86\u6b63\u786e\u7684\u65b9\u6cd5\uff0c\u5982\u4e0b<\/p>\n
\n
df = df1.set_index('name').add(df2.set_index('name'), fill_value=0).reset_index()\n\u6216\u8005\n\ndf = pd.concat([df1, df2]).groupby('name')['value'].sum().reset_index()<\/code><\/pre>\n<\/div>\n
\u7ed3\u679c\u5982\u4e0b<\/p>\n
\n
======newdf=======\n       name  value\n0    aliyun   2264\n1   baishan    313\n2  kingsoft    151\n3     other   3681\n4     total   6409<\/code><\/pre>\n<\/div>\n
\u53c2\u8003\u8d44\u6599<\/h2>\n
https:\/\/stackoverflow.com\/questions\/49111859\/how-to-merge-two-dataframes-and-sum-the-values-of-columns<\/a><\/p>\n
\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1aIPCPU-\u7f51\u7edc\u4e4b\u8def<\/a> » pandas\u4e24\u4e2adataframe\u6309\u7167\u6307\u5b9a\u5217\u76f8\u52a0\u6c42\u548c<\/a><\/p>","protected":false},"excerpt":{"rendered":"
pandas\u4e24\u4e2adataframe\u6309\u7167\u6307\u5b9a\u5217\u76f8\u52a0\u6c42\u548c.md \u9700\u6c42 \u5982\u4e0b\u56fe\u4e24\u4e2adataframe\uff0c\u6309\u7167name\u540d\u79f0\u5bf9value\u8fdb\u884c\u76f8\u52a0\u6c42\u548c\u3002 \u6ce8\u610f\uff0cname\u987a\u5e8f\u662f\u6253\u4e71\u7684\u3002 \u5c1d\u8bd5 \u6211\u4eec\u76f4\u63a5\u76f8\u52a0\uff0c\u4f46\u662f\u5f97\u5230\u4e86\u5982\u4e0b\u7ed3\u679c df = df1 + df2 df = df1.add(df2) ======newdf======= name value 0 baishanaliyun 1130 1 aliyunbaishan 1447 2 kingsoftkingsoft 151 3 totaltotal 6409 4 otherother 3681 \u663e\u7136\u4e0d\u5408\u8981\u6c42 \u6b63\u89e3 \u7f51\u4e0a\u67e5\u4e86\u4e0b\uff0c\u7ec8\u4e8e\u627e\u5230\u4e86\u6b63\u786e\u7684\u65b9\u6cd5\uff0c\u5982\u4e0b df = df1.set_index(‘name’).add(df2.set_index(‘name’), fill_value=0).reset_index() \u6216\u8005 df = pd.concat([df1, df2]).groupby(‘name’)[‘value’].sum().reset_index() \u7ed3\u679c\u5982\u4e0b ======newdf======= name value 0 aliyun 2264 1 baishan 313 2 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[59],"_links":{"self":[{"href":"https:\/\/c.ipcpu.com\/wp-json\/wp\/v2\/posts\/1414"}],"collection":[{"href":"https:\/\/c.ipcpu.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c.ipcpu.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c.ipcpu.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/c.ipcpu.com\/wp-json\/wp\/v2\/comments?post=1414"}],"version-history":[{"count":1,"href":"https:\/\/c.ipcpu.com\/wp-json\/wp\/v2\/posts\/1414\/revisions"}],"predecessor-version":[{"id":1415,"href":"https:\/\/c.ipcpu.com\/wp-json\/wp\/v2\/posts\/1414\/revisions\/1415"}],"wp:attachment":[{"href":"https:\/\/c.ipcpu.com\/wp-json\/wp\/v2\/media?parent=1414"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c.ipcpu.com\/wp-json\/wp\/v2\/categories?post=1414"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c.ipcpu.com\/wp-json\/wp\/v2\/tags?post=1414"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}