pandas 美国人口案例分析

import numpy as np
import pandas as pd
from pandas import Dataframe,Series

areas = pd.read_csv('./state-areas.csv')
areas

	state	area (sq. mi)
0	Alabama	52423
1	Alaska	656425
2	Arizona	114006
3	Arkansas	53182
4	California	163707
5	Colorado	104100
6	Connecticut	5544
7	Delaware	1954
8	Florida	65758
9	Georgia	59441
10	Hawaii	10932
11	Idaho	83574
12	Illinois	57918
13	Indiana	36420
14	Iowa	56276
15	Kansas	82282
16	Kentucky	40411
17	Louisiana	51843
18	Maine	35387
19	Maryland	12407
20	Massachusetts	10555
21	Michigan	96810
22	Minnesota	86943
23	Mississippi	48434
24	Missouri	69709
25	Montana	147046
26	Nebraska	77358
27	Nevada	110567
28	New Hampshire	9351
29	New Jersey	8722
30	New Mexico	121593
31	New York	54475
32	North Carolina	53821
33	North Dakota	70704
34	Ohio	44828
35	Oklahoma	69903
36	Oregon	98386
37	Pennsylvania	46058
38	Rhode Island	1545
39	South Carolina	32007
40	South Dakota	77121
41	Tennessee	42146
42	Texas	268601
43	Utah	84904
44	Vermont	9615
45	Virginia	42769
46	Washington	71303
47	West Virginia	24231
48	Wisconsin	65503
49	Wyoming	97818
50	District of Columbia	68
51	Puerto Rico	3515

ab = pd.read_csv('./state-abbrevs.csv')
ab

	state	abbreviation
0	Alabama	AL
1	Alaska	AK
2	Arizona	AZ
3	Arkansas	AR
4	California	CA
5	Colorado	CO
6	Connecticut	CT
7	Delaware	DE
8	District of Columbia	DC
9	Florida	FL
10	Georgia	GA
11	Hawaii	HI
12	Idaho	ID
13	Illinois	IL
14	Indiana	IN
15	Iowa	IA
16	Kansas	KS
17	Kentucky	KY
18	Louisiana	LA
19	Maine	ME
20	Montana	MT
21	Nebraska	NE
22	Nevada	NV
23	New Hampshire	NH
24	New Jersey	NJ
25	New Mexico	NM
26	New York	NY
27	North Carolina	NC
28	North Dakota	ND
29	Ohio	OH
30	Oklahoma	OK
31	Oregon	OR
32	Maryland	MD
33	Massachusetts	MA
34	Michigan	MI
35	Minnesota	MN
36	Mississippi	MS
37	Missouri	MO
38	Pennsylvania	PA
39	Rhode Island	RI
40	South Carolina	SC
41	South Dakota	SD
42	Tennessee	TN
43	Texas	TX
44	Utah	UT
45	Vermont	VT
46	Virginia	VA
47	Washington	WA
48	West Virginia	WV
49	Wisconsin	WI
50	Wyoming	WY

pop = pd.read_csv('./state-population.csv')
pop

	state/region	ages	year	population
0	AL	under18	2012	1117489.0
1	AL	total	2012	4817528.0
2	AL	under18	2010	1130966.0
3	AL	total	2010	4785570.0
4	AL	under18	2011	1125763.0
...	...	...	...	...
2539	USA	total	2010	309326295.0
2540	USA	under18	2011	73902222.0
2541	USA	total	2011	311582564.0
2542	USA	under18	2012	73708179.0
2543	USA	total	2012	313873685.0

2544 rows × 4 columns

pop.head()

	state/region	ages	year	population
0	AL	under18	2012	1117489.0
1	AL	total	2012	4817528.0
2	AL	under18	2010	1130966.0
3	AL	total	2010	4785570.0
4	AL	under18	2011	1125763.0

pop.shape

(2544, 4)

将地名全称与人口相对应

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

	state/region	ages	year	population	state	abbreviation
0	AL	under18	2012	1117489.0	Alabama	AL
1	AL	total	2012	4817528.0	Alabama	AL
2	AL	under18	2010	1130966.0	Alabama	AL
3	AL	total	2010	4785570.0	Alabama	AL
4	AL	under18	2011	1125763.0	Alabama	AL

n1.shape

(2544, 6)

n1.info()


Int64Index: 2544 entries, 0 to 2543
Data columns (total 6 columns):
 #   Column        Non-Null Count  Dtype  
---  ------        --------------  -----  
 0   state/region  2544 non-null   object 
 1   ages          2544 non-null   object 
 2   year          2544 non-null   int64  
 3   population    2524 non-null   float64
 4   state         2448 non-null   object 
 5   abbreviation  2448 non-null   object 
dtypes: float64(1), int64(1), object(4)
memory usage: 139.1+ KB

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

n1.head()

	state/region	ages	year	population	state
0	AL	under18	2012	1117489.0	Alabama
1	AL	total	2012	4817528.0	Alabama
2	AL	under18	2010	1130966.0	Alabama
3	AL	total	2010	4785570.0	Alabama
4	AL	under18	2011	1125763.0	Alabama

查找空数据并填充

n1.info()


Int64Index: 2544 entries, 0 to 2543
Data columns (total 5 columns):
 #   Column        Non-Null Count  Dtype  
---  ------        --------------  -----  
 0   state/region  2544 non-null   object 
 1   ages          2544 non-null   object 
 2   year          2544 non-null   int64  
 3   population    2524 non-null   float64
 4   state         2448 non-null   object 
dtypes: float64(1), int64(1), object(3)
memory usage: 183.8+ KB

cond = n1.state.isnull()

t1 = n1['state/region'][cond]

t1.unique()

array(['PR', 'USA'], dtype=object)

areas

	state	area (sq. mi)
0	Alabama	52423
1	Alaska	656425
2	Arizona	114006
3	Arkansas	53182
4	California	163707
5	Colorado	104100
6	Connecticut	5544
7	Delaware	1954
8	Florida	65758
9	Georgia	59441
10	Hawaii	10932
11	Idaho	83574
12	Illinois	57918
13	Indiana	36420
14	Iowa	56276
15	Kansas	82282
16	Kentucky	40411
17	Louisiana	51843
18	Maine	35387
19	Maryland	12407
20	Massachusetts	10555
21	Michigan	96810
22	Minnesota	86943
23	Mississippi	48434
24	Missouri	69709
25	Montana	147046
26	Nebraska	77358
27	Nevada	110567
28	New Hampshire	9351
29	New Jersey	8722
30	New Mexico	121593
31	New York	54475
32	North Carolina	53821
33	North Dakota	70704
34	Ohio	44828
35	Oklahoma	69903
36	Oregon	98386
37	Pennsylvania	46058
38	Rhode Island	1545
39	South Carolina	32007
40	South Dakota	77121
41	Tennessee	42146
42	Texas	268601
43	Utah	84904
44	Vermont	9615
45	Virginia	42769
46	Washington	71303
47	West Virginia	24231
48	Wisconsin	65503
49	Wyoming	97818
50	District of Columbia	68
51	Puerto Rico	3515

con1 = n1['state/region'] == 'PR'

n1['state'][con1] = 'Puerto Rico'

C:Users87513AppDataLocalTempipykernel_104201649942457.py:1: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a Dataframe

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  n1['state'][con1] = 'Puerto Rico'

con2 = n1['state/region'] == 'USA'

n1['state'][con2] = 'United States'

C:Users87513AppDataLocalTempipykernel_104202644435043.py:1: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a Dataframe

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  n1['state'][con2] = 'United States'

n1.info()


Int64Index: 2544 entries, 0 to 2543
Data columns (total 5 columns):
 #   Column        Non-Null Count  Dtype  
---  ------        --------------  -----  
 0   state/region  2544 non-null   object 
 1   ages          2544 non-null   object 
 2   year          2544 non-null   int64  
 3   population    2524 non-null   float64
 4   state         2544 non-null   object 
dtypes: float64(1), int64(1), object(3)
memory usage: 183.8+ KB

n1.isnull().any()

state/region    False
ages            False
year            False
population       True
state           False
dtype: bool

con4 = n1['population'].isnull()

n1[con4]

	state/region	ages	year	population	state
2448	PR	under18	1990	NaN	Puerto Rico
2449	PR	total	1990	NaN	Puerto Rico
2450	PR	total	1991	NaN	Puerto Rico
2451	PR	under18	1991	NaN	Puerto Rico
2452	PR	total	1993	NaN	Puerto Rico
2453	PR	under18	1993	NaN	Puerto Rico
2454	PR	under18	1992	NaN	Puerto Rico
2455	PR	total	1992	NaN	Puerto Rico
2456	PR	under18	1994	NaN	Puerto Rico
2457	PR	total	1994	NaN	Puerto Rico
2458	PR	total	1995	NaN	Puerto Rico
2459	PR	under18	1995	NaN	Puerto Rico
2460	PR	under18	1996	NaN	Puerto Rico
2461	PR	total	1996	NaN	Puerto Rico
2462	PR	under18	1998	NaN	Puerto Rico
2463	PR	total	1998	NaN	Puerto Rico
2464	PR	total	1997	NaN	Puerto Rico
2465	PR	under18	1997	NaN	Puerto Rico
2466	PR	total	1999	NaN	Puerto Rico
2467	PR	under18	1999	NaN	Puerto Rico

n1.dropna(inplace = True)

n1.info()


Int64Index: 2524 entries, 0 to 2543
Data columns (total 5 columns):
 #   Column        Non-Null Count  Dtype  
---  ------        --------------  -----  
 0   state/region  2524 non-null   object 
 1   ages          2524 non-null   object 
 2   year          2524 non-null   int64  
 3   population    2524 non-null   float64
 4   state         2524 non-null   object 
dtypes: float64(1), int64(1), object(3)
memory usage: 118.3+ KB

合并面积

n2 = pd.merge(n1,areas,how = 'outer')
display(n2.head(),n2.shape)

	state/region	ages	year	population	state	area (sq. mi)
0	AL	under18	2012	1117489.0	Alabama	52423.0
1	AL	total	2012	4817528.0	Alabama	52423.0
2	AL	under18	2010	1130966.0	Alabama	52423.0
3	AL	total	2010	4785570.0	Alabama	52423.0
4	AL	under18	2011	1125763.0	Alabama	52423.0

(2524, 6)

n2.isnull().any()

state/region     False
ages             False
year             False
population       False
state            False
area (sq. mi)     True
dtype: bool

cond5 = n2['area (sq. mi)'].isnull()

n2[cond5]

	state/region	ages	year	population	state	area (sq. mi)
2476	USA	under18	1990	64218512.0	United States	NaN
2477	USA	total	1990	249622814.0	United States	NaN
2478	USA	total	1991	252980942.0	United States	NaN
2479	USA	under18	1991	65313018.0	United States	NaN
2480	USA	under18	1992	66509177.0	United States	NaN
2481	USA	total	1992	256514231.0	United States	NaN
2482	USA	total	1993	259918595.0	United States	NaN
2483	USA	under18	1993	67594938.0	United States	NaN
2484	USA	under18	1994	68640936.0	United States	NaN
2485	USA	total	1994	263125826.0	United States	NaN
2486	USA	under18	1995	69473140.0	United States	NaN
2487	USA	under18	1996	70233512.0	United States	NaN
2488	USA	total	1995	266278403.0	United States	NaN
2489	USA	total	1996	269394291.0	United States	NaN
2490	USA	total	1997	272646932.0	United States	NaN
2491	USA	under18	1997	70920738.0	United States	NaN
2492	USA	under18	1998	71431406.0	United States	NaN
2493	USA	total	1998	275854116.0	United States	NaN
2494	USA	under18	1999	71946051.0	United States	NaN
2495	USA	total	2000	282162411.0	United States	NaN
2496	USA	under18	2000	72376189.0	United States	NaN
2497	USA	total	1999	279040181.0	United States	NaN
2498	USA	total	2001	284968955.0	United States	NaN
2499	USA	under18	2001	72671175.0	United States	NaN
2500	USA	total	2002	287625193.0	United States	NaN
2501	USA	under18	2002	72936457.0	United States	NaN
2502	USA	total	2003	290107933.0	United States	NaN
2503	USA	under18	2003	73100758.0	United States	NaN
2504	USA	total	2004	292805298.0	United States	NaN
2505	USA	under18	2004	73297735.0	United States	NaN
2506	USA	total	2005	295516599.0	United States	NaN
2507	USA	under18	2005	73523669.0	United States	NaN
2508	USA	total	2006	298379912.0	United States	NaN
2509	USA	under18	2006	73757714.0	United States	NaN
2510	USA	total	2007	301231207.0	United States	NaN
2511	USA	under18	2007	74019405.0	United States	NaN
2512	USA	total	2008	304093966.0	United States	NaN
2513	USA	under18	2008	74104602.0	United States	NaN
2514	USA	under18	2013	73585872.0	United States	NaN
2515	USA	total	2013	316128839.0	United States	NaN
2516	USA	total	2009	306771529.0	United States	NaN
2517	USA	under18	2009	74134167.0	United States	NaN
2518	USA	under18	2010	74119556.0	United States	NaN
2519	USA	total	2010	309326295.0	United States	NaN
2520	USA	under18	2011	73902222.0	United States	NaN
2521	USA	total	2011	311582564.0	United States	NaN
2522	USA	under18	2012	73708179.0	United States	NaN
2523	USA	total	2012	313873685.0	United States	NaN

areas.sum()

state            AlabamaAlaskaArizonaArkansasCaliforniaColorado...
area (sq. mi)                                              3790399
dtype: object

n2.fillna(3790399,inplace=True)

n2.notnull().all()

state/region     True
ages             True
year             True
population       True
state            True
area (sq. mi)    True
dtype: bool

求2010年人口密度

n2.head()

	state/region	ages	year	population	state	area (sq. mi)
0	AL	under18	2012	1117489.0	Alabama	52423.0
1	AL	total	2012	4817528.0	Alabama	52423.0
2	AL	under18	2010	1130966.0	Alabama	52423.0
3	AL	total	2010	4785570.0	Alabama	52423.0
4	AL	under18	2011	1125763.0	Alabama	52423.0

n2010 = n2.query("year == 2010 and ages == 'total'")
n2010

	state/region	ages	year	population	state	area (sq. mi)
3	AL	total	2010	4785570.0	Alabama	52423.0
91	AK	total	2010	713868.0	Alaska	656425.0
101	AZ	total	2010	6408790.0	Arizona	114006.0
189	AR	total	2010	2922280.0	Arkansas	53182.0
197	CA	total	2010	37333601.0	California	163707.0
283	CO	total	2010	5048196.0	Colorado	104100.0
293	CT	total	2010	3579210.0	Connecticut	5544.0
379	DE	total	2010	899711.0	Delaware	1954.0
389	DC	total	2010	605125.0	District of Columbia	68.0
475	FL	total	2010	18846054.0	Florida	65758.0
485	GA	total	2010	9713248.0	Georgia	59441.0
570	HI	total	2010	1363731.0	Hawaii	10932.0
581	ID	total	2010	1570718.0	Idaho	83574.0
666	IL	total	2010	12839695.0	Illinois	57918.0
677	IN	total	2010	6489965.0	Indiana	36420.0
762	IA	total	2010	3050314.0	Iowa	56276.0
773	KS	total	2010	2858910.0	Kansas	82282.0
858	KY	total	2010	4347698.0	Kentucky	40411.0
869	LA	total	2010	4545392.0	Louisiana	51843.0
954	ME	total	2010	1327366.0	Maine	35387.0
965	MD	total	2010	5787193.0	Maryland	12407.0
1050	MA	total	2010	6563263.0	Massachusetts	10555.0
1061	MI	total	2010	9876149.0	Michigan	96810.0
1146	MN	total	2010	5310337.0	Minnesota	86943.0
1157	MS	total	2010	2970047.0	Mississippi	48434.0
1242	MO	total	2010	5996063.0	Missouri	69709.0
1253	MT	total	2010	990527.0	Montana	147046.0
1338	NE	total	2010	1829838.0	Nebraska	77358.0
1349	NV	total	2010	2703230.0	Nevada	110567.0
1434	NH	total	2010	1316614.0	New Hampshire	9351.0
1445	NJ	total	2010	8802707.0	New Jersey	8722.0
1530	NM	total	2010	2064982.0	New Mexico	121593.0
1541	NY	total	2010	19398228.0	New York	54475.0
1626	NC	total	2010	9559533.0	North Carolina	53821.0
1637	ND	total	2010	674344.0	North Dakota	70704.0
1722	OH	total	2010	11545435.0	Ohio	44828.0
1733	OK	total	2010	3759263.0	Oklahoma	69903.0
1818	OR	total	2010	3837208.0	Oregon	98386.0
1829	PA	total	2010	12710472.0	Pennsylvania	46058.0
1914	RI	total	2010	1052669.0	Rhode Island	1545.0
1925	SC	total	2010	4636361.0	South Carolina	32007.0
2010	SD	total	2010	816211.0	South Dakota	77121.0
2021	TN	total	2010	6356683.0	Tennessee	42146.0
2106	TX	total	2010	25245178.0	Texas	268601.0
2117	UT	total	2010	2774424.0	Utah	84904.0
2202	VT	total	2010	625793.0	Vermont	9615.0
2213	VA	total	2010	8024417.0	Virginia	42769.0
2298	WA	total	2010	6742256.0	Washington	71303.0
2309	WV	total	2010	1854146.0	West Virginia	24231.0
2394	WI	total	2010	5689060.0	Wisconsin	65503.0
2405	WY	total	2010	564222.0	Wyoming	97818.0
2470	PR	total	2010	3721208.0	Puerto Rico	3515.0
2519	USA	total	2010	309326295.0	United States	3790399.0

n2010.set_index('state/region',inplace = True)

n2010

	ages	year	population	state	area (sq. mi)
state/region
AL	total	2010	4785570.0	Alabama	52423.0
AK	total	2010	713868.0	Alaska	656425.0
AZ	total	2010	6408790.0	Arizona	114006.0
AR	total	2010	2922280.0	Arkansas	53182.0
CA	total	2010	37333601.0	California	163707.0
CO	total	2010	5048196.0	Colorado	104100.0
CT	total	2010	3579210.0	Connecticut	5544.0
DE	total	2010	899711.0	Delaware	1954.0
DC	total	2010	605125.0	District of Columbia	68.0
FL	total	2010	18846054.0	Florida	65758.0
GA	total	2010	9713248.0	Georgia	59441.0
HI	total	2010	1363731.0	Hawaii	10932.0
ID	total	2010	1570718.0	Idaho	83574.0
IL	total	2010	12839695.0	Illinois	57918.0
IN	total	2010	6489965.0	Indiana	36420.0
IA	total	2010	3050314.0	Iowa	56276.0
KS	total	2010	2858910.0	Kansas	82282.0
KY	total	2010	4347698.0	Kentucky	40411.0
LA	total	2010	4545392.0	Louisiana	51843.0
ME	total	2010	1327366.0	Maine	35387.0
MD	total	2010	5787193.0	Maryland	12407.0
MA	total	2010	6563263.0	Massachusetts	10555.0
MI	total	2010	9876149.0	Michigan	96810.0
MN	total	2010	5310337.0	Minnesota	86943.0
MS	total	2010	2970047.0	Mississippi	48434.0
MO	total	2010	5996063.0	Missouri	69709.0
MT	total	2010	990527.0	Montana	147046.0
NE	total	2010	1829838.0	Nebraska	77358.0
NV	total	2010	2703230.0	Nevada	110567.0
NH	total	2010	1316614.0	New Hampshire	9351.0
NJ	total	2010	8802707.0	New Jersey	8722.0
NM	total	2010	2064982.0	New Mexico	121593.0
NY	total	2010	19398228.0	New York	54475.0
NC	total	2010	9559533.0	North Carolina	53821.0
ND	total	2010	674344.0	North Dakota	70704.0
OH	total	2010	11545435.0	Ohio	44828.0
OK	total	2010	3759263.0	Oklahoma	69903.0
OR	total	2010	3837208.0	Oregon	98386.0
PA	total	2010	12710472.0	Pennsylvania	46058.0
RI	total	2010	1052669.0	Rhode Island	1545.0
SC	total	2010	4636361.0	South Carolina	32007.0
SD	total	2010	816211.0	South Dakota	77121.0
TN	total	2010	6356683.0	Tennessee	42146.0
TX	total	2010	25245178.0	Texas	268601.0
UT	total	2010	2774424.0	Utah	84904.0
VT	total	2010	625793.0	Vermont	9615.0
VA	total	2010	8024417.0	Virginia	42769.0
WA	total	2010	6742256.0	Washington	71303.0
WV	total	2010	1854146.0	West Virginia	24231.0
WI	total	2010	5689060.0	Wisconsin	65503.0
WY	total	2010	564222.0	Wyoming	97818.0
PR	total	2010	3721208.0	Puerto Rico	3515.0
USA	total	2010	309326295.0	United States	3790399.0

density_2010 = n2010['population'] / n2010['area (sq. mi)']
density_2010

state/region
AL      91.29
AK       1.09
AZ      56.21
AR      54.95
CA     228.05
CO      48.49
CT     645.60
DE     460.45
DC    8898.90
FL     286.60
GA     163.41
HI     124.75
ID      18.79
IL     221.69
IN     178.20
IA      54.20
KS      34.75
KY     107.59
LA      87.68
ME      37.51
MD     466.45
MA     621.82
MI     102.02
MN      61.08
MS      61.32
MO      86.02
MT       6.74
NE      23.65
NV      24.45
NH     140.80
NJ    1009.25
NM      16.98
NY     356.09
NC     177.62
ND       9.54
OH     257.55
OK      53.78
OR      39.00
PA     275.97
RI     681.34
SC     144.85
SD      10.58
TN     150.83
TX      93.99
UT      32.68
VT      65.09
VA     187.62
WA      94.56
WV      76.52
WI      86.85
WY       5.77
PR    1058.67
USA     81.61
dtype: float64

pd.set_option('display.float.format',lambda x:'%0.2f'%(x))

pop_2010 = Dataframe(density_2010,columns = ['mean2010'])

pop_2010.head()

	mean2010
state/region
AL	91.29
AK	1.09
AZ	56.21
AR	54.95
CA	228.05

result = pd.merge(n2010,pop_2010,left_index=True,right_index=True)
result

	ages	year	population	state	area (sq. mi)	mean2010
state/region
AL	total	2010	4785570.00	Alabama	52423.00	91.29
AK	total	2010	713868.00	Alaska	656425.00	1.09
AZ	total	2010	6408790.00	Arizona	114006.00	56.21
AR	total	2010	2922280.00	Arkansas	53182.00	54.95
CA	total	2010	37333601.00	California	163707.00	228.05
CO	total	2010	5048196.00	Colorado	104100.00	48.49
CT	total	2010	3579210.00	Connecticut	5544.00	645.60
DE	total	2010	899711.00	Delaware	1954.00	460.45
DC	total	2010	605125.00	District of Columbia	68.00	8898.90
FL	total	2010	18846054.00	Florida	65758.00	286.60
GA	total	2010	9713248.00	Georgia	59441.00	163.41
HI	total	2010	1363731.00	Hawaii	10932.00	124.75
ID	total	2010	1570718.00	Idaho	83574.00	18.79
IL	total	2010	12839695.00	Illinois	57918.00	221.69
IN	total	2010	6489965.00	Indiana	36420.00	178.20
IA	total	2010	3050314.00	Iowa	56276.00	54.20
KS	total	2010	2858910.00	Kansas	82282.00	34.75
KY	total	2010	4347698.00	Kentucky	40411.00	107.59
LA	total	2010	4545392.00	Louisiana	51843.00	87.68
ME	total	2010	1327366.00	Maine	35387.00	37.51
MD	total	2010	5787193.00	Maryland	12407.00	466.45
MA	total	2010	6563263.00	Massachusetts	10555.00	621.82
MI	total	2010	9876149.00	Michigan	96810.00	102.02
MN	total	2010	5310337.00	Minnesota	86943.00	61.08
MS	total	2010	2970047.00	Mississippi	48434.00	61.32
MO	total	2010	5996063.00	Missouri	69709.00	86.02
MT	total	2010	990527.00	Montana	147046.00	6.74
NE	total	2010	1829838.00	Nebraska	77358.00	23.65
NV	total	2010	2703230.00	Nevada	110567.00	24.45
NH	total	2010	1316614.00	New Hampshire	9351.00	140.80
NJ	total	2010	8802707.00	New Jersey	8722.00	1009.25
NM	total	2010	2064982.00	New Mexico	121593.00	16.98
NY	total	2010	19398228.00	New York	54475.00	356.09
NC	total	2010	9559533.00	North Carolina	53821.00	177.62
ND	total	2010	674344.00	North Dakota	70704.00	9.54
OH	total	2010	11545435.00	Ohio	44828.00	257.55
OK	total	2010	3759263.00	Oklahoma	69903.00	53.78
OR	total	2010	3837208.00	Oregon	98386.00	39.00
PA	total	2010	12710472.00	Pennsylvania	46058.00	275.97
RI	total	2010	1052669.00	Rhode Island	1545.00	681.34
SC	total	2010	4636361.00	South Carolina	32007.00	144.85
SD	total	2010	816211.00	South Dakota	77121.00	10.58
TN	total	2010	6356683.00	Tennessee	42146.00	150.83
TX	total	2010	25245178.00	Texas	268601.00	93.99
UT	total	2010	2774424.00	Utah	84904.00	32.68
VT	total	2010	625793.00	Vermont	9615.00	65.09
VA	total	2010	8024417.00	Virginia	42769.00	187.62
WA	total	2010	6742256.00	Washington	71303.00	94.56
WV	total	2010	1854146.00	West Virginia	24231.00	76.52
WI	total	2010	5689060.00	Wisconsin	65503.00	86.85
WY	total	2010	564222.00	Wyoming	97818.00	5.77
PR	total	2010	3721208.00	Puerto Rico	3515.00	1058.67
USA	total	2010	309326295.00	United States	3790399.00	81.61

result.sort_values(by = 'mean2010')

	ages	year	population	state	area (sq. mi)	mean2010
state/region
AK	total	2010	713868.00	Alaska	656425.00	1.09
WY	total	2010	564222.00	Wyoming	97818.00	5.77
MT	total	2010	990527.00	Montana	147046.00	6.74
ND	total	2010	674344.00	North Dakota	70704.00	9.54
SD	total	2010	816211.00	South Dakota	77121.00	10.58
NM	total	2010	2064982.00	New Mexico	121593.00	16.98
ID	total	2010	1570718.00	Idaho	83574.00	18.79
NE	total	2010	1829838.00	Nebraska	77358.00	23.65
NV	total	2010	2703230.00	Nevada	110567.00	24.45
UT	total	2010	2774424.00	Utah	84904.00	32.68
KS	total	2010	2858910.00	Kansas	82282.00	34.75
ME	total	2010	1327366.00	Maine	35387.00	37.51
OR	total	2010	3837208.00	Oregon	98386.00	39.00
CO	total	2010	5048196.00	Colorado	104100.00	48.49
OK	total	2010	3759263.00	Oklahoma	69903.00	53.78
IA	total	2010	3050314.00	Iowa	56276.00	54.20
AR	total	2010	2922280.00	Arkansas	53182.00	54.95
AZ	total	2010	6408790.00	Arizona	114006.00	56.21
MN	total	2010	5310337.00	Minnesota	86943.00	61.08
MS	total	2010	2970047.00	Mississippi	48434.00	61.32
VT	total	2010	625793.00	Vermont	9615.00	65.09
WV	total	2010	1854146.00	West Virginia	24231.00	76.52
USA	total	2010	309326295.00	United States	3790399.00	81.61
MO	total	2010	5996063.00	Missouri	69709.00	86.02
WI	total	2010	5689060.00	Wisconsin	65503.00	86.85
LA	total	2010	4545392.00	Louisiana	51843.00	87.68
AL	total	2010	4785570.00	Alabama	52423.00	91.29
TX	total	2010	25245178.00	Texas	268601.00	93.99
WA	total	2010	6742256.00	Washington	71303.00	94.56
MI	total	2010	9876149.00	Michigan	96810.00	102.02
KY	total	2010	4347698.00	Kentucky	40411.00	107.59
HI	total	2010	1363731.00	Hawaii	10932.00	124.75
NH	total	2010	1316614.00	New Hampshire	9351.00	140.80
SC	total	2010	4636361.00	South Carolina	32007.00	144.85
TN	total	2010	6356683.00	Tennessee	42146.00	150.83
GA	total	2010	9713248.00	Georgia	59441.00	163.41
NC	total	2010	9559533.00	North Carolina	53821.00	177.62
IN	total	2010	6489965.00	Indiana	36420.00	178.20
VA	total	2010	8024417.00	Virginia	42769.00	187.62
IL	total	2010	12839695.00	Illinois	57918.00	221.69
CA	total	2010	37333601.00	California	163707.00	228.05
OH	total	2010	11545435.00	Ohio	44828.00	257.55
PA	total	2010	12710472.00	Pennsylvania	46058.00	275.97
FL	total	2010	18846054.00	Florida	65758.00	286.60
NY	total	2010	19398228.00	New York	54475.00	356.09
DE	total	2010	899711.00	Delaware	1954.00	460.45
MD	total	2010	5787193.00	Maryland	12407.00	466.45
MA	total	2010	6563263.00	Massachusetts	10555.00	621.82
CT	total	2010	3579210.00	Connecticut	5544.00	645.60
RI	total	2010	1052669.00	Rhode Island	1545.00	681.34
NJ	total	2010	8802707.00	New Jersey	8722.00	1009.25
PR	total	2010	3721208.00	Puerto Rico	3515.00	1058.67
DC	total	2010	605125.00	District of Columbia	68.00	8898.90

result.to_csv('./pop_2010.csv')

result.to_excel('./pop_total.xlsx')

pandas 美国人口案例分析

Python相关栏目本月热门文章