人口分析案例

导入库和数据文件

合并州简称和人口数据

abb_pop=pd.merge(abb,pop,left_on='abbreviation',right_on='state/region',how='outer')
abb_pop.head()

删除合并表中重复的简称列

abb_pop.drop(labels='abbreviation',axis=1,inplace=True)
abb_pop.head()

查看存在缺失数据的列

abb_pop.isnull().any(axis=0)
abb_pop.info()

找到state的值为NaN的数据，并对其简称去重

abb_pop.head()
abb_pop.loc[abb_pop['state'].isnull()]['state/region'].unique()
abb_pop.info()

为找到的state/region的state项补上正确的项，去除state这列所有的NaN

abb_pop.loc[abb_pop['state'].isnull()]
index=abb_pop.loc[abb_pop['state/region'] == 'USA'].index
index

abb_pop.loc[index,'state'] = 'United States'
index=abb_pop.loc[abb_pop['state/region'] == 'PR'].index
abb_pop.loc[index,'state'] = 'PPPPPPRRRRRR'
abb_pop.loc[abb_pop['state'].isnull()]

合并各州面积

abb_pop_area = pd.merge(abb_pop,area,how='outer')
abb_pop_area.head(2)

找到area（sq.mi）中的缺失值并去除

indexs = abb_pop_area.loc[abb_pop_area['area (sq. mi)'].isnull()].index
indexs
abb_pop_area.drop(labels=indexs,axis=0,inplace=True)

2010年全名人口数据（条件查询）

abb_pop_area.query('ages =="total" & year ==2010')

计算各州的人口密度

abb_pop_area['midu']=abb_pop_area['population']/abb_pop_area['area (sq. mi)']
abb_pop_area

排序，找出人口密度最高的州

abb_pop_area.sort_values(by='midu',axis=0,ascending=False)
abb_pop_area.sort_values(by='midu',axis=0,ascending=False).iloc[:1]