Python S6-5 Pandas 人口密度统计项目
2022-08-10 本文已影响0人
薛东弗斯
![](https://img.haomeiwen.com/i3968643/a360d323b74167d2.png)
![](https://img.haomeiwen.com/i3968643/07a9ee1f25cded0c.png)
下面的merge,默认找字段相同的列。但由于字段不通,所以需要指定,left_on="state/region", right_on='abbreviation'; how='inner':只保留"state/region"与'abbreviation’同时存在的内容。有可能会丢失部分数据。一般用outer
inner:只保留交集
outer:并集
![](https://img.haomeiwen.com/i3968643/2921ffe223b8c7fa.png)
![](https://img.haomeiwen.com/i3968643/077e585037a7dbb4.png)
![](https://img.haomeiwen.com/i3968643/59cb90be91cd310c.png)
![](https://img.haomeiwen.com/i3968643/8ce0ec162bf762fa.png)
至少一个NaN的列
![](https://img.haomeiwen.com/i3968643/8ff88d53bdd7277e.png)
![](https://img.haomeiwen.com/i3968643/f230633f0555f3ce.png)
![](https://img.haomeiwen.com/i3968643/4b6d82e14c62aa41.png)
![](https://img.haomeiwen.com/i3968643/47ad82f6f8a5b8ee.png)
![](https://img.haomeiwen.com/i3968643/9f8360ab49af6c3e.png)
![](https://img.haomeiwen.com/i3968643/a288d7f5eecef15b.png)
![](https://img.haomeiwen.com/i3968643/87f22dbe76a5edd2.png)
![](https://img.haomeiwen.com/i3968643/a6db3f3220a95d23.png)
![](https://img.haomeiwen.com/i3968643/9228d08f5d006dda.png)
![](https://img.haomeiwen.com/i3968643/dcad73aeaddbe4ca.png)
![](https://img.haomeiwen.com/i3968643/b46ae40f75427c9e.png)
![](https://img.haomeiwen.com/i3968643/c8151cc02f8c07f5.png)
![](https://img.haomeiwen.com/i3968643/1abbc7ab1e1921c6.png)
下面的merge,默认找字段相同的列。但由于字段不通,所以需要指定,left_on="state/region", right_on='abbreviation'; how='inner':只保留"state/region"与'abbreviation’同时存在的内容。有可能会丢失部分数据。一般用outer
inner:只保留交集
outer:并集
至少一个NaN的列