pandas4

最新推荐文章于 2024-08-27 16:38:10 发布

qq_54911309

最新推荐文章于 2024-08-27 16:38:10 发布

阅读量27

点赞数

文章标签： python pandas 数据分析

本文链接：https://blog.csdn.net/qq_54911309/article/details/134676502

版权

十套练习使用pandas数据分析.4

import pandas as pd
import numpy as np
crime =  pd.read_csv("D:/东华研/数据分析/pandas_exercise/exercise_data/US_Crime_Rates_1960_2014.csv")
crime.head()

	Year	Population	Total	Violent	Property	Murder	Forcible_Rape	Robbery	Aggravated_assault	Burglary	Larceny_Theft	Vehicle_Theft
0	1960	179323175	3384200	288460	3095700	9110	17190	107840	154320	912100	1855400	328200
1	1961	182992000	3488000	289390	3198600	8740	17220	106670	156760	949600	1913000	336000
2	1962	185771000	3752200	301510	3450700	8530	17550	110860	164570	994300	2089600	366800
3	1963	188483000	4109500	316970	3792500	8640	17650	116470	174210	1086400	2297800	408300
4	1964	191141000	4564600	364220	4200400	9360	21420	130390	203050	1213200	2514400	472800

crime.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 55 entries, 0 to 54
Data columns (total 12 columns):
 #   Column              Non-Null Count  Dtype
---  ------              --------------  -----
 0   Year                55 non-null     int64
 1   Population          55 non-null     int64
 2   Total               55 non-null     int64
 3   Violent             55 non-null     int64
 4   Property            55 non-null     int64
 5   Murder              55 non-null     int64
 6   Forcible_Rape       55 non-null     int64
 7   Robbery             55 non-null     int64
 8   Aggravated_assault  55 non-null     int64
 9   Burglary            55 non-null     int64
 10  Larceny_Theft       55 non-null     int64
 11  Vehicle_Theft       55 non-null     int64
dtypes: int64(12)
memory usage: 5.3 KB

crime.columns

Index(['Year', 'Population', 'Total', 'Violent', 'Property', 'Murder',
       'Forcible_Rape', 'Robbery', 'Aggravated_assault', 'Burglary',
       'Larceny_Theft', 'Vehicle_Theft'],
      dtype='object')

crime.Year = pd.to_datetime(crime.Year,format="%Y")
crime.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 55 entries, 0 to 54
Data columns (total 12 columns):
 #   Column              Non-Null Count  Dtype         
---  ------              --------------  -----         
 0   Year                55 non-null     datetime64[ns]
 1   Population          55 non-null     int64         
 2   Total               55 non-null     int64         
 3   Violent             55 non-null     int64         
 4   Property            55 non-null     int64         
 5   Murder              55 non-null     int64         
 6   Forcible_Rape       55 non-null     int64         
 7   Robbery             55 non-null     int64         
 8   Aggravated_assault  55 non-null     int64         
 9   Burglary            55 non-null     int64         
 10  Larceny_Theft       55 non-null     int64         
 11  Vehicle_Theft       55 non-null     int64         
dtypes: datetime64[ns](1), int64(11)
memory usage: 5.3 KB

crime = crime.set_index("Year",drop=True)

crime.head()

	Population	Total	Violent	Property	Murder	Forcible_Rape	Robbery	Aggravated_assault	Burglary	Larceny_Theft	Vehicle_Theft
Year
1960-01-01	179323175	3384200	288460	3095700	9110	17190	107840	154320	912100	1855400	328200
1961-01-01	182992000	3488000	289390	3198600	8740	17220	106670	156760	949600	1913000	336000
1962-01-01	185771000	3752200	301510	3450700	8530	17550	110860	164570	994300	2089600	366800
1963-01-01	188483000	4109500	316970	3792500	8640	17650	116470	174210	1086400	2297800	408300
1964-01-01	191141000	4564600	364220	4200400	9360	21420	130390	203050	1213200	2514400	472800

crime.columns

Index(['Population', 'Violent', 'Property', 'Murder', 'Forcible_Rape',
       'Robbery', 'Aggravated_assault', 'Burglary', 'Larceny_Theft',
       'Vehicle_Theft'],
      dtype='object')

del crime["Total"]
crime.head()

	Population	Violent	Property	Murder	Forcible_Rape	Robbery	Aggravated_assault	Burglary	Larceny_Theft	Vehicle_Theft
Year
1960-01-01	179323175	288460	3095700	9110	17190	107840	154320	912100	1855400	328200
1961-01-01	182992000	289390	3198600	8740	17220	106670	156760	949600	1913000	336000
1962-01-01	185771000	301510	3450700	8530	17550	110860	164570	994300	2089600	366800
1963-01-01	188483000	316970	3792500	8640	17650	116470	174210	1086400	2297800	408300
1964-01-01	191141000	364220	4200400	9360	21420	130390	203050	1213200	2514400	472800

crime.resample('10AS').sum()

	Population	Violent	Property	Murder	Forcible_Rape	Robbery	Aggravated_assault	Burglary	Larceny_Theft	Vehicle_Theft
Year
1960-01-01	1915053175	4134930	45160900	106180	236720	1633510	2158520	13321100	26547700	5292100
1970-01-01	2121193298	9607930	91383800	192230	554570	4159020	4702120	28486000	53157800	9739900
1980-01-01	2371370069	14074328	117048900	206439	865639	5383109	7619130	33073494	72040253	11935411
1990-01-01	2612825258	17527048	119053499	211664	998827	5748930	10568963	26750015	77679366	14624418
2000-01-01	2947969117	13968056	100944369	163068	922499	4230366	8652124	21565176	67970291	11412834
2010-01-01	1570146307	6072017	44095950	72867	421059	1749809	3764142	10125170	30401698	3569080

crimes = crime.groupby("Year").sum()

population = crime['Population'].resample('10AS').max()
crimes['Population'] = population
crimes

	Population	Violent	Property	Murder	Forcible_Rape	Robbery	Aggravated_assault	Burglary	Larceny_Theft	Vehicle_Theft
Year
1960-01-01	201385000.0	288460	3095700	9110	17190	107840	154320	912100	1855400	328200
1961-01-01	NaN	289390	3198600	8740	17220	106670	156760	949600	1913000	336000
1962-01-01	NaN	301510	3450700	8530	17550	110860	164570	994300	2089600	366800
1963-01-01	NaN	316970	3792500	8640	17650	116470	174210	1086400	2297800	408300
1964-01-01	NaN	364220	4200400	9360	21420	130390	203050	1213200	2514400	472800
1965-01-01	NaN	387390	4352000	9960	23410	138690	215330	1282500	2572600	496900
1966-01-01	NaN	430180	4793300	11040	25820	157990	235330	1410100	2822000	561200
1967-01-01	NaN	499930	5403500	12240	27620	202910	257160	1632100	3111600	659800
1968-01-01	NaN	595010	6125200	13800	31670	262840	286700	1858900	3482700	783600
1969-01-01	NaN	661870	6749000	14760	37170	298850	311090	1981900	3888600	878500
1970-01-01	220099000.0	738820	7359200	16000	37990	349860	334970	2205000	4225800	928400
1971-01-01	NaN	816500	7771700	17780	42260	387700	368760	2399300	4424200	948200
1972-01-01	NaN	834900	7413900	18670	46850	376290	393090	2375500	4151200	887200
1973-01-01	NaN	875910	7842200	19640	51400	384220	420650	2565500	4347900	928800
1974-01-01	NaN	974720	9278700	20710	55400	442400	456210	3039200	5262500	977100
1975-01-01	NaN	1039710	10252700	20510	56090	470500	492620	3265300	5977700	1009600
1976-01-01	NaN	1004210	10345500	18780	57080	427810	500530	3108700	6270800	966000
1977-01-01	NaN	1029580	9955000	19120	63500	412610	534350	3071500	5905700	977700
1978-01-01	NaN	1085550	10123400	19560	67610	426930	571460	3128300	5991000	1004100
1979-01-01	NaN	1208030	11041500	21460	76390	480700	629480	3327700	6601000	1112800
1980-01-01	248239000.0	1344520	12063700	23040	82990	565840	672650	3795200	7136900	1131700
1981-01-01	NaN	1361820	12061900	22520	82500	592910	663900	3779700	7194400	1087800
1982-01-01	NaN	1322390	11652000	21010	78770	553130	669480	3447100	7142500	1062400
1983-01-01	NaN	1258090	10850500	19310	78920	506570	653290	3129900	6712800	1007900
1984-01-01	NaN	1273280	10608500	18690	84230	485010	685350	2984400	6591900	1032200
1985-01-01	NaN	1328800	11102600	18980	88670	497870	723250	3073300	6926400	1102900
1986-01-01	NaN	1489169	11722700	20613	91459	542775	834322	3241410	7257153	1224137
1987-01-01	NaN	1483999	12024700	20096	91110	517704	855088	3236184	7499900	1288674
1988-01-01	NaN	1566220	12356900	20680	92490	542970	910090	3218100	7705900	1432900
1989-01-01	NaN	1646040	12605400	21500	94500	578330	951710	3168200	7872400	1564800
1990-01-01	272690813.0	1820130	12655500	23440	102560	639270	1054860	3073900	7945700	1635900
1991-01-01	NaN	1911770	12961100	24700	106590	687730	1092740	3157200	8142200	1661700
1992-01-01	NaN	1932270	12505900	23760	109060	672480	1126970	2979900	7915200	1610800
1993-01-01	NaN	1926020	12218800	24530	106010	659870	1135610	2834800	7820900	1563100
1994-01-01	NaN	1857670	12131900	23330	102220	618950	1113180	2712800	7879800	1539300
1995-01-01	NaN	1798790	12063900	21610	97470	580510	1099210	2593800	7997700	1472400
1996-01-01	NaN	1688540	11805300	19650	96250	535590	1037050	2506400	7904700	1394200
1997-01-01	NaN	1634770	11558175	18208	96153	498534	1023201	2460526	7743760	1354189
1998-01-01	NaN	1531044	10944590	16914	93103	446625	974402	2329950	7373886	1240754
1999-01-01	NaN	1426044	10208334	15522	89411	409371	911740	2100739	6955520	1152075
2000-01-01	307006550.0	1425486	10182586	15586	90178	408016	911706	2050992	6971590	1160002
2001-01-01	NaN	1439480	10437480	16037	90863	423557	909023	2116531	7092267	1228391
2002-01-01	NaN	1423677	10455277	16229	95235	420806	891407	2151252	7057370	1246646
2003-01-01	NaN	1383676	10442862	16528	93883	414235	859030	2154834	7026802	1261226
2004-01-01	NaN	1360088	10319386	16148	95089	401470	847381	2144446	6937089	1237851
2005-01-01	NaN	1390745	10174754	16740	94347	417438	862220	2155448	6783447	1235859
2006-01-01	NaN	1418043	9983568	17030	92757	447403	860853	2183746	6607013	1192809
2007-01-01	NaN	1408337	9843481	16929	90427	445125	855856	2176140	6568572	1095769
2008-01-01	NaN	1392628	9767915	16442	90479	443574	842134	2228474	6588046	958629
2009-01-01	NaN	1325896	9337060	15399	89241	408742	812514	2203313	6338095	795652
2010-01-01	318857056.0	1251248	9112625	14772	85593	369089	781844	2168457	6204601	739565
2011-01-01	NaN	1206031	9052743	14661	84175	354772	752423	2185140	6151095	716508
2012-01-01	NaN	1217067	9001992	14866	85141	355051	762009	2109932	6168874	723186
2013-01-01	NaN	1199684	8650761	14319	82109	345095	726575	1931835	6018632	700294
2014-01-01	NaN	1197987	8277829	14249	84041	325802	741291	1729806	5858496	689527

crime.idxmax(0)

Population           2014-01-01
Violent              1992-01-01
Property             1991-01-01
Murder               1991-01-01
Forcible_Rape        1992-01-01
Robbery              1991-01-01
Aggravated_assault   1993-01-01
Burglary             1980-01-01
Larceny_Theft        1991-01-01
Vehicle_Theft        1991-01-01
dtype: datetime64[ns]