import numpy as np
import pandas as pd
from pandas import DataFrame
abb = pd.read_csv(r'D:\天翼云盘下载\19367_数据分析项目-合集\state-abbrevs.csv')
area = pd.read_csv(r'D:/天翼云盘下载/19367_数据分析项目-合集/state-areas.csv')
pop = pd.read_csv(r'D:/天翼云盘下载/19367_数据分析项目-合集/state-population.csv')
abb_pop = pd.merge(abb,pop,left_on='abbreviation',right_on='state/region',how='outer')
abb_pop.head()
state | abbreviation | state/region | ages | year | population | |
---|---|---|---|---|---|---|
0 | Alabama | AL | AL | under18 | 2012 | 1117489.0 |
1 | Alabama | AL | AL | total | 2012 | 4817528.0 |
2 | Alabama | AL | AL | under18 | 2010 | 1130966.0 |
3 | Al |