2-2_Selecting_data_and_analysis_part1

最新推荐文章于 2023-02-20 15:59:43 发布
最新推荐文章于 2023-02-20 15:59:43 发布
阅读量418 收藏
点赞数
分类专栏： 七月在线数据挖掘 文章标签： 数据预处理 可视化
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_35770067/article/details/98093404
版权

import包，加入一些初始设定

# The usual preamble
%matplotlib inline
import pandas as pd
import matplotlib.pyplot as plt
import warnings
warnings.filterwarnings('ignore')
# Make the graphs a bit prettier, and bigger


# This is necessary to show lots of columns in pandas 0.12. 
# Not necessary in pandas 0.13.
plt.style.use("bmh")
plt.rc('font', family='SimHei', size=13) #显示中文
pd.set_option('display.max_columns',1000)
pd.set_option('display.width', 1000)
pd.set_option('display.max_colwidth',1000)

上次的数据集有点小啦，咱们这里用一个大一点的数据集，比如NYC Open Data.

complaints = pd.read_csv('311-service-requests.csv')

其实warning暂时可以不用管，一般是python版本的问题

2.1 瞄一眼数据

dataframe这种格式还是很神奇的，比如说，你要是直接把dataframe丢出去输出一下，它会告诉你最基本的信息。

比如有多少行多少列，有多少非空的值等等。

complaints
Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution Action Updated DateCommunity BoardBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Park Facility NamePark BoroughSchool NameSchool NumberSchool RegionSchool CodeSchool Phone NumberSchool AddressSchool CitySchool StateSchool ZipSchool Not FoundSchool or Citywide ComplaintVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentGarage Lot NameFerry DirectionFerry Terminal NameLatitudeLongitudeLocation
02658965110/31/2013 02:08:41 AMNaNNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1143290-03 169 STREET169 STREET90 AVENUE91 AVENUENaNNaNADDRESSJAMAICANaNPrecinctAssigned10/31/2013 10:08:41 AM10/31/2013 02:35:17 AM12 QUEENSQUEENS1042027.0197389.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.708275-73.791604(40.70827532593202, -73.79160395779721)
12659369810/31/2013 02:01:04 AMNaNNYPDNew York City Police DepartmentIllegal ParkingCommercial Overnight ParkingStreet/Sidewalk1137858 AVENUE58 AVENUE58 PLACE59 STREETNaNNaNBLOCKFACEMASPETHNaNPrecinctOpen10/31/2013 10:01:04 AMNaN05 QUEENSQUEENS1009349.0201984.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.721041-73.909453(40.721040535628305, -73.90945306791765)
22659413910/31/2013 02:00:24 AM10/31/2013 02:40:32 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant100324060 BROADWAYBROADWAYWEST 171 STREETWEST 172 STREETNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/31/2013 10:00:24 AM10/31/2013 02:39:42 AM12 MANHATTANMANHATTAN1001088.0246531.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.843330-73.939144(40.84332975466513, -73.93914371913482)
32659572110/31/2013 01:56:23 AM10/31/2013 02:21:48 AMNYPDNew York City Police DepartmentNoise - VehicleCar/Truck HornStreet/Sidewalk10023WEST 72 STREETWEST 72 STREETCOLUMBUS AVENUEAMSTERDAM AVENUENaNNaNBLOCKFACENEW YORKNaNPrecinctClosed10/31/2013 09:56:23 AM10/31/2013 02:21:10 AM07 MANHATTANMANHATTAN989730.0222727.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.778009-73.980213(40.7780087446372, -73.98021349023975)
42659093010/31/2013 01:53:44 AMNaNDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting RodentsVacant Lot10027WEST 124 STREETWEST 124 STREETLENOX AVENUEADAM CLAYTON POWELL JR BOULEVARDNaNNaNBLOCKFACENEW YORKNaNNaNPending11/30/2013 01:53:44 AM10/31/2013 01:59:54 AM10 MANHATTANMANHATTAN998815.0233545.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.807691-73.947387(40.80769092704951, -73.94738703491433)
52659237010/31/2013 01:46:52 AMNaNNYPDNew York City Police DepartmentNoise - CommercialBanging/PoundingClub/Bar/Restaurant1137237 AVENUE37 AVENUE84 STREET85 STREETNaNNaNBLOCKFACEJACKSON HEIGHTSNaNPrecinctOpen10/31/2013 09:46:52 AMNaN03 QUEENSQUEENS1016948.0212540.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.749989-73.881988(40.7499893014072, -73.88198770727831)
62659568210/31/2013 01:46:40 AMNaNNYPDNew York City Police DepartmentBlocked DrivewayNo AccessStreet/Sidewalk11419107-50 109 STREET109 STREET107 AVENUE109 AVENUENaNNaNADDRESSSOUTH RICHMOND HILLNaNPrecinctAssigned10/31/2013 09:46:40 AM10/31/2013 01:59:51 AM10 QUEENSQUEENS1030919.0187622.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.681533-73.831737(40.68153278675525, -73.83173699701601)
72659519510/31/2013 01:44:19 AM10/31/2013 01:58:49 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant11417137-09 CROSSBAY BOULEVARDCROSSBAY BOULEVARDPITKIN AVENUEVAN WICKLEN ROADNaNNaNADDRESSOZONE PARKNaNPrecinctClosed10/31/2013 09:44:19 AM10/31/2013 01:58:49 AM10 QUEENSQUEENS1027776.0184076.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.671816-73.843092(40.67181584567338, -73.84309181950769)
82659054010/31/2013 01:44:14 AM10/31/2013 02:28:04 AMNYPDNew York City Police DepartmentNoise - CommercialLoud TalkingClub/Bar/Restaurant10011258 WEST 15 STREETWEST 15 STREET7 AVENUE8 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctClosed10/31/2013 09:44:14 AM10/31/2013 02:00:56 AM04 MANHATTANMANHATTAN984031.0208847.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.739913-74.000790(40.73991339303542, -74.00079028612932)
92659439210/31/2013 01:34:41 AM10/31/2013 02:23:51 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant11225835 NOSTRAND AVENUENOSTRAND AVENUEUNION STREETPRESIDENT STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/31/2013 09:34:41 AM10/31/2013 01:48:26 AM09 BROOKLYNBROOKLYN997941.0182725.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.668204-73.950648(40.66820406598287, -73.95064760056546)
102659517610/31/2013 01:25:12 AMNaNNYPDNew York City Police DepartmentNoise - House of WorshipLoud Music/PartyHouse of Worship112183775 18 AVENUE18 AVENUEEAST 9 STREETEAST 8 STREETNaNNaNADDRESSBROOKLYNNaNPrecinctOpen10/31/2013 09:25:12 AMNaN14 BROOKLYNBROOKLYN992726.0170399.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.634378-73.969462(40.63437840816299, -73.96946177104543)
112659198210/31/2013 01:24:14 AM10/31/2013 01:54:39 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant10003187 2 AVENUE2 AVENUEEAST 11 STREETEAST 12 STREETNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/31/2013 09:24:14 AM10/31/2013 01:54:39 AM03 MANHATTANMANHATTAN988110.0205533.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.730816-73.986073(40.73081644089586, -73.98607265739876)
122659416910/31/2013 01:20:57 AM10/31/2013 02:12:31 AMNYPDNew York City Police DepartmentIllegal ParkingDouble Parked Blocking VehicleStreet/Sidewalk1002965 EAST 99 STREETEAST 99 STREETMADISON AVENUEPARK AVENUENaNNaNADDRESSNEW YORKNaNPrecinctClosed10/31/2013 09:20:57 AM10/31/2013 01:42:05 AM11 MANHATTANMANHATTAN997470.0226725.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.788974-73.952259(40.78897400211689, -73.95225898702977)
132659439110/31/2013 01:20:13 AMNaNNYPDNew York City Police DepartmentNoise - VehicleEngine IdlingStreet/Sidewalk10466NaNNaNNaNNaNSTRANG AVENUEAMUNDSON AVENUEINTERSECTIONBRONXNaNPrecinctOpen10/31/2013 09:20:13 AMNaN12 BRONXBRONX1029467.0264124.0UnspecifiedBRONXUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.891517-73.836457(40.89151738488846, -73.83645714593568)
142659091710/31/2013 01:19:54 AMNaNDOHMHDepartment of Health and Mental HygieneRodentRat Sighting1-2 Family Mixed Use Building1121963 STREET63 STREET13 AVENUE14 AVENUENaNNaNBLOCKFACEBROOKLYNNaNNaNPending11/30/2013 01:19:54 AM10/31/2013 01:29:26 AM10 BROOKLYNBROOKLYN984467.0167519.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.626477-73.999218(40.6264774690411, -73.99921826202639)
152659145810/31/2013 01:14:02 AM10/31/2013 01:30:34 AMNYPDNew York City Police DepartmentNoise - House of WorshipLoud Music/PartyHouse of Worship10025NaNNaNNaNNaNWEST 99 STREETBROADWAYINTERSECTIONNEW YORKNaNPrecinctClosed10/31/2013 09:14:02 AM10/31/2013 01:30:34 AM07 MANHATTANMANHATTAN992454.0229500.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.796597-73.970370(40.7965967075252, -73.97036973473399)
162659408610/31/2013 12:54:03 AM10/31/2013 02:16:39 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud Music/PartyStreet/Sidewalk10310173 CAMPBELL AVENUECAMPBELL AVENUEHENDERSON AVENUEWINEGAR LANENaNNaNADDRESSSTATEN ISLANDNaNPrecinctClosed10/31/2013 08:54:03 AM10/31/2013 02:07:14 AM01 STATEN ISLANDSTATEN ISLAND952013.0171076.0UnspecifiedSTATEN ISLANDUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.636182-74.116150(40.63618202176914, -74.1161500428337)
172659511710/31/2013 12:52:46 AMNaNNYPDNew York City Police DepartmentIllegal ParkingPosted Parking Sign ViolationStreet/Sidewalk11236NaNNaNNaNNaNROCKAWAY PARKWAYSKIDMORE AVENUEINTERSECTIONBROOKLYNNaNPrecinctOpen10/31/2013 08:52:46 AMNaN18 BROOKLYNBROOKLYN1015289.0169710.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.632437-73.888173(40.63243692394328, -73.88817263437012)
182659038910/31/2013 12:51:00 AMNaNDOTDepartment of TransportationStreet Light ConditionStreet Light OutNaNNaN226 42 ST E42 ST ECHURCH AVESNYDER AVENaNNaNADDRESSNaNNaNNaNOpenNaNNaNUnspecified BROOKLYNBROOKLYNNaNNaNUnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
192659421010/31/2013 12:46:27 AMNaNNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant10033NaNNaNNaNNaNWEST 184 STREETBROADWAYINTERSECTIONNEW YORKNaNPrecinctAssigned10/31/2013 08:46:27 AM10/31/2013 01:32:41 AM12 MANHATTANMANHATTAN1002294.0249712.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.852058-73.934776(40.85205827756883, -73.93477640780834)
202659293210/31/2013 12:43:47 AM10/31/2013 12:56:20 AMNYPDNew York City Police DepartmentNoise - House of WorshipLoud Music/PartyHouse of Worship11216778 PARK PLACEPARK PLACEROGERS AVENUENOSTRAND AVENUENaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/31/2013 08:43:47 AM10/31/2013 12:56:20 AM08 BROOKLYNBROOKLYN997608.0184656.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.673505-73.951844(40.67350473678714, -73.95184414979961)
212659415210/31/2013 12:41:17 AM10/31/2013 01:04:37 AMNYPDNew York City Police DepartmentNoise - CommercialBanging/PoundingStore/Commercial10016155 E 34TH STE 34TH STNaNNaNNaNNaNLATLONGNEW YORKNaNPrecinctClosed10/31/2013 08:41:17 AM10/31/2013 01:04:38 AM06 MANHATTANMANHATTAN990133.0211136.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.746194-73.978769(40.74619417253121, -73.97876853124392)
222658967810/31/2013 12:39:55 AMNaNNYPDNew York City Police DepartmentNoise - VehicleCar/Truck MusicStreet/Sidewalk11419NaNNaNNaNNaN112 STREETATLANTIC AVENUEINTERSECTIONSOUTH RICHMOND HILLNaNPrecinctOpen10/31/2013 08:39:55 AMNaN09 QUEENSQUEENS1030314.0191578.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.692394-73.833891(40.69239424979043, -73.8338912453996)
232659230410/31/2013 12:38:00 AMNaNNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant11216371 TOMPKINS AVENUETOMPKINS AVENUEMADISON STREETPUTNAM AVENUENaNNaNADDRESSBROOKLYNNaNPrecinctAssigned10/31/2013 08:38:00 AM10/31/2013 01:16:53 AM03 BROOKLYNBROOKLYN999720.0188825.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.684944-73.944221(40.6849442562592, -73.94422078036632)
242659189210/31/2013 12:37:16 AMNaNNYPDNew York City Police DepartmentBlocked DrivewayPartial AccessStreet/Sidewalk103051496 BAY STREETBAY STREETLYMAN AVENUESCHOOL ROADNaNNaNADDRESSSTATEN ISLANDNaNPrecinctAssigned10/31/2013 08:37:16 AM10/31/2013 12:52:10 AM01 STATEN ISLANDSTATEN ISLAND967283.0160518.0UnspecifiedSTATEN ISLANDUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.607245-74.061106(40.60724493456944, -74.06110566015863)
252659157310/31/2013 12:35:18 AM10/31/2013 02:41:35 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1031224 PRINCETON LANEPRINCETON LANEHAMPTON GREENDEAD ENDNaNNaNADDRESSSTATEN ISLANDNaNPrecinctClosed10/31/2013 08:35:18 AM10/31/2013 01:45:17 AM03 STATEN ISLANDSTATEN ISLAND929577.0140964.0UnspecifiedSTATEN ISLANDUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.553421-74.196743(40.55342078716953, -74.19674315017886)
262659050910/31/2013 12:33:00 AMNaNDOTDepartment of TransportationStreet Light ConditionStreet Light OutNaNNaN38 ST E38 ST ECHURCH AVELINDEN BLVDNaNNaNBLOCKFACENaNNaNNaNOpenNaNNaNUnspecified BROOKLYNBROOKLYNNaNNaNUnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
272659137910/31/2013 12:32:44 AMNaNDOHMHDepartment of Health and Mental HygieneHarboring Bees/WaspsBees/Wasps - Not a beekeper3+ Family Mixed Use Building10025501 WEST 110 STREETWEST 110 STREETAMSTERDAM AVENUEBROADWAYNaNNaNADDRESSNEW YORKNaNNaNOpen11/30/2013 12:32:44 AMNaN09 MANHATTANMANHATTAN994143.0231888.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.803149-73.964266(40.80314938553783, -73.96426608076082)
282659408510/31/2013 12:32:08 AMNaNNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10026121 WEST 116 STREETWEST 116 STREETLENOX AVENUE7 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctAssigned10/31/2013 08:32:08 AM10/31/2013 02:00:57 AM10 MANHATTANMANHATTAN997947.0231613.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.802390-73.950526(40.80238950799943, -73.95052644123253)
292658920110/31/2013 12:32:00 AMNaNDOTDepartment of TransportationStreet Light ConditionStreet Light OutNaN10309295 BAYVIEW AVENUEBAYVIEW AVENUEVAIL AVENUEBAYVIEW LANENaNNaNADDRESSSTATEN ISLANDNaNNaNOpenNaNNaN03 STATEN ISLANDSTATEN ISLAND927687.0127837.0UnspecifiedSTATEN ISLANDUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.517378-74.203435(40.517377871705676, -74.20343466779575)
...............................................................................................................................................................
1110392642876410/04/2013 12:17:03 AM10/04/2013 12:38:37 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant10022249 EAST 53 STREETEAST 53 STREET3 AVENUE2 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:17:03 AM10/04/2013 12:38:37 AM06 MANHATTANMANHATTAN993036.0215164.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.757248-73.968286(40.757247604963055, -73.96828647941395)
1110402642616610/04/2013 12:16:22 AM10/04/2013 05:50:49 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyStore/Commercial10029252 EAST 110 STREETEAST 110 STREET3 AVENUE2 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:16:22 AM10/04/2013 05:50:49 AM11 MANHATTANMANHATTAN1000407.0228425.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.793635-73.941649(40.79363516179995, -73.94164859515777)
1110412643856510/04/2013 12:16:00 AMNaNDEPDepartment of Environmental ProtectionNoiseNoise: Construction Before/After Hours (NM1)NaN11231480 VAN BRUNT STREETVAN BRUNT STREETREED STREETDEAD ENDNaNNaNADDRESSBROOKLYNNaNNaNOpenNaNNaN06 BROOKLYNBROOKLYN979657.0184924.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.674249-74.016558(40.6742492231181, -74.01655803856313)
1110422642899010/04/2013 12:15:52 AM10/04/2013 12:44:52 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10014733 WASHINGTON STREETWASHINGTON STREETBANK STREETBETHUNE STREETNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:15:52 AM10/04/2013 12:44:52 AM02 MANHATTANMANHATTAN981950.0207532.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.736304-74.008299(40.736303747410034, -74.00829935904578)
1110432643265910/04/2013 12:15:46 AM10/04/2013 04:18:45 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant112181213 CORTELYOU ROADCORTELYOU ROADEAST 12 STREETEAST 13 STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:15:46 AM10/04/2013 04:18:45 AM14 BROOKLYNBROOKLYN993451.0172498.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.640139-73.966847(40.64013899178716, -73.96684680242933)
1110442642609610/04/2013 12:14:09 AM10/04/2013 01:03:46 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10032539 WEST 162 STREETWEST 162 STREETST NICHOLAS AVENUEBROADWAYNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:14:09 AM10/04/2013 01:03:46 AM12 MANHATTANMANHATTAN1000571.0244054.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.836532-73.941018(40.836532082987944, -73.9410182995914)
1110452643776410/04/2013 12:14:00 AM10/04/2013 12:14:00 AMDEPDepartment of Environmental ProtectionWater SystemDirty Water (WE)NaN10022251 EAST 51 STREETEAST 51 STREET3 AVENUE2 AVENUENaNNaNADDRESSNEW YORKNaNNaNClosedNaN10/04/2013 12:14:00 AM06 MANHATTANMANHATTAN992791.0214702.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.755980-73.969171(40.75597977288785, -73.96917140638074)
1110462643628610/04/2013 12:14:00 AMNaNDEPDepartment of Environmental ProtectionNoiseNoise: Construction Before/After Hours (NM1)NaN11231480 VAN BRUNT STREETVAN BRUNT STREETREED STREETDEAD ENDNaNNaNADDRESSBROOKLYNNaNNaNOpenNaNNaN06 BROOKLYNBROOKLYN979657.0184924.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.674249-74.016558(40.6742492231181, -74.01655803856313)
1110472642898910/04/2013 12:13:08 AM10/04/2013 02:12:47 AMNYPDNew York City Police DepartmentIllegal ParkingPosted Parking Sign ViolationStreet/Sidewalk11434NaNNaNNaNNaNGUY R BREWER BOULEVARDROCKAWAY BOULEVARDINTERSECTIONJAMAICANaNPrecinctClosed10/04/2013 08:13:08 AM10/04/2013 02:12:47 AM13 QUEENSQUEENS1048801.0178419.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.656160-73.767353(40.656160351546845, -73.76735262738222)
1110482643003010/04/2013 12:12:07 AM10/04/2013 02:45:24 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10027215 WEST 131ST STREETWEST 131ST STREETNaNNaNNaNNaNLATLONGNEW YORKNaNPrecinctClosed10/04/2013 08:12:07 AM10/04/2013 02:45:24 AM01 MANHATTANMANHATTAN999107.0235603.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.813339-73.946328(40.81333907832113, -73.94632769228208)
1110492642966310/04/2013 12:12:07 AM10/04/2013 01:03:44 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant112098915 5 AVENUE5 AVENUE89 STREET90 STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:12:07 AM10/04/2013 01:03:44 AM10 BROOKLYNBROOKLYN976525.0165015.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.619601-74.027826(40.619601147364584, -74.02782628492785)
1110502643776310/04/2013 12:11:00 AMNaNDEPDepartment of Environmental ProtectionNoiseNoise: Construction Before/After Hours (NM1)NaN10028NaNNaNNaNNaNEAST 84 STREETYORK AVENUEINTERSECTIONNEW YORKNaNNaNOpenNaNNaN08 MANHATTANMANHATTAN998629.0221493.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.774612-73.948085(40.77461174278734, -73.94808472177321)
1110512643295510/04/2013 12:08:15 AM10/04/2013 12:48:02 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant10009506 EAST 13 STREETEAST 13 STREETAVENUE AAVENUE BNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:08:15 AM10/04/2013 12:48:03 AM03 MANHATTANMANHATTAN989678.0205065.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.729531-73.980416(40.72953107218499, -73.98041550317102)
1110522643703510/04/2013 12:08:00 AM10/04/2013 12:13:00 AMDEPDepartment of Environmental ProtectionWater SystemDirty Water (WE)NaN10022325 EAST 54 STREETEAST 54 STREET2 AVENUE1 AVENUENaNNaNADDRESSNEW YORKNaNNaNClosedNaN10/04/2013 12:13:00 AM06 MANHATTANMANHATTAN993688.0215099.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.757069-73.965933(40.75706852462872, -73.96593314322774)
1110532643319710/04/2013 12:08:00 AM10/04/2013 12:00:00 PMDSNYBCC - Queens EastDerelict Vehicles14 Derelict VehiclesStreet11413220-11 145 AVENUE145 AVENUE221 STREET221 STREETNaNNaNADDRESSSpringfield GardensNaNDSNY GaragePendingNaN10/04/2013 12:08:00 AM13 QUEENSQUEENS1051511.0181411.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.664353-73.757556(40.6643525308449, -73.75755575708348)
1110542642606010/04/2013 12:06:39 AM10/04/2013 12:31:16 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk112244823 BEACH 48 STREETBEACH 48 STREETBODY OF WATERSURF AVENUENaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:06:39 AM10/04/2013 12:31:16 AM13 BROOKLYNBROOKLYN980859.0149681.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.577515-74.012207(40.57751513866536, -74.01220705163807)
1110552643062810/04/2013 12:06:28 AM10/04/2013 12:21:39 AMNYPDNew York City Police DepartmentNoise - CommercialLoud TalkingClub/Bar/Restaurant112097915 3 AVENUE3 AVENUE79 STREET80 STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:06:28 AM10/04/2013 12:21:39 AM10 BROOKLYNBROOKLYN976189.0168214.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.628381-74.029040(40.62838143294541, -74.02904041333245)
1110562643164810/04/2013 12:06:26 AM10/23/2013 08:14:52 AMDOTDepartment of TransportationStreet Sign - MissingBus StopStreet11378NaNNaNNaNNaN54 AVENUE43 STREETINTERSECTIONMASPETHNaNNaNClosed10/14/2013 09:38:47 AM10/23/2013 08:14:52 AM02 QUEENSQUEENS1005171.0206064.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.732250-73.924513(40.73225000573841, -73.92451289173367)
1110572643703410/04/2013 12:06:00 AMNaNDEPDepartment of Environmental ProtectionNoiseNoise: Jack Hammering (NC2)NaN10036NaNNaNNaNNaNWEST 48 STREETBROADWAYINTERSECTIONNEW YORKNaNNaNOpenNaNNaN05 MANHATTANMANHATTAN988451.0216208.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.760116-73.984836(40.76011648520396, -73.98483562074706)
1110582642609410/04/2013 12:05:12 AM10/04/2013 01:08:29 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant11237211 KNICKERBOCKER AVENUEKNICKERBOCKER AVENUEJEFFERSON STREETTROUTMAN STREETNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:05:12 AM10/04/2013 01:08:29 AM04 BROOKLYNBROOKLYN1004672.0195540.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.703365-73.926345(40.703365329011284, -73.92634531031759)
1110592642904010/04/2013 12:04:52 AM10/04/2013 03:01:04 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1000399 2 AVENUE2 AVENUEEAST 5 STREETEAST 6 STREETNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:04:52 AM10/04/2013 03:01:04 AM03 MANHATTANMANHATTAN987393.0204234.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.727251-73.988660(40.727251287038676, -73.98866028603422)
1110602643408410/04/2013 12:04:00 AMNaNDEPDepartment of Environmental ProtectionNoiseNoise: Construction Before/After Hours (NM1)NaN10036NaNNaNNaNNaN8 AVENUEWEST 47 STREETINTERSECTIONNEW YORKNaNNaNOpenNaNNaN04 MANHATTANMANHATTAN987720.0216313.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.760405-73.987474(40.76040500039782, -73.98747426235285)
1110612642616410/04/2013 12:03:00 AM10/04/2013 02:14:57 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant1110630-09 BROADWAYBROADWAY30 STREET31 STREETNaNNaNADDRESSASTORIANaNPrecinctClosed10/04/2013 08:03:00 AM10/04/2013 02:14:57 AM01 QUEENSQUEENS1004746.0217004.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.762279-73.926013(40.762278541098084, -73.92601303458156)
1110622643971010/04/2013 12:03:00 AM10/04/2013 12:03:00 AMDEPDepartment of Environmental ProtectionWater SystemDirty Water (WE)NaN10022325 EAST 54 STREETEAST 54 STREET2 AVENUE1 AVENUENaNNaNADDRESSNEW YORKNaNNaNClosedNaN10/04/2013 12:03:00 AM06 MANHATTANMANHATTAN993688.0215099.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.757069-73.965933(40.75706852462872, -73.96593314322774)
1110632643556910/04/2013 12:02:00 AM10/04/2013 01:10:00 AMDEPDepartment of Environmental ProtectionWater SystemDirty Water (WE)NaN10022311 EAST 50 STREETEAST 50 STREET2 AVENUE1 AVENUENaNNaNADDRESSNEW YORKNaNNaNClosedNaN10/04/2013 01:10:00 AM06 MANHATTANMANHATTAN993118.0214222.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.754662-73.967992(40.75466197318078, -73.96799173864807)
1110642642601310/04/2013 12:01:13 AM10/07/2013 04:07:16 PMDPRDepartment of Parks and RecreationMaintenance or FacilityStructure - OutdoorsPark11213NaNNaNNaNNaNNaNNaNNaNBROOKLYNNaNNaNClosed10/18/2013 12:01:13 AM10/07/2013 04:07:16 PM08 BROOKLYNBROOKLYNNaNNaNBrower ParkBROOKLYNBrower ParkB012NaNNaN7189658900Brooklyn, St. Marks, Kingston Avenues, Park PlaceBROOKLYNNY11213NNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
1110652642808310/04/2013 12:01:05 AM10/04/2013 02:13:50 AMNYPDNew York City Police DepartmentIllegal ParkingPosted Parking Sign ViolationStreet/Sidewalk11434NaNNaNNaNNaNGUY R BREWER BOULEVARDROCKAWAY BOULEVARDINTERSECTIONJAMAICANaNPrecinctClosed10/04/2013 08:01:05 AM10/04/2013 02:13:50 AM13 QUEENSQUEENS1048801.0178419.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.656160-73.767353(40.656160351546845, -73.76735262738222)
1110662642898710/04/2013 12:00:45 AM10/04/2013 01:25:01 AMNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk10016344 EAST 28 STREETEAST 28 STREETMOUNT CARMEL PLACE1 AVENUENaNNaNADDRESSNEW YORKNaNPrecinctClosed10/04/2013 08:00:45 AM10/04/2013 01:25:01 AM06 MANHATTANMANHATTAN990637.0208987.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.740295-73.976952(40.740295354643706, -73.97695165980414)
1110672642611510/04/2013 12:00:28 AM10/04/2013 04:17:32 AMNYPDNew York City Police DepartmentNoise - CommercialLoud TalkingClub/Bar/Restaurant112261233 FLATBUSH AVENUEFLATBUSH AVENUEAVENUE DNEWKIRK AVENUENaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:00:28 AM10/04/2013 04:17:32 AM14 BROOKLYNBROOKLYN996654.0172515.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.640182-73.955306(40.64018174662485, -73.95530566958138)
1110682642803310/04/2013 12:00:10 AM10/04/2013 01:20:52 AMNYPDNew York City Police DepartmentBlocked DrivewayPartial AccessStreet/Sidewalk112361259 EAST 94 STREETEAST 94 STREETAVENUE JAVENUE KNaNNaNADDRESSBROOKLYNNaNPrecinctClosed10/04/2013 08:00:10 AM10/04/2013 01:20:52 AM18 BROOKLYNBROOKLYN1011804.0172470.0UnspecifiedBROOKLYNUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.640024-73.900717(40.640024057399216, -73.90071711703163)

111069 rows × 52 columns

2.2 选行或者列

上一节提到了，直接用名字就可以取。

complaints.columns

Index(['Unique Key', 'Created Date', 'Closed Date', 'Agency', 'Agency Name', 'Complaint Type', 'Descriptor', 'Location Type', 'Incident Zip', 'Incident Address', 'Street Name', 'Cross Street 1', 'Cross Street 2', 'Intersection Street 1', 'Intersection Street 2', 'Address Type', 'City', 'Landmark', 'Facility Type', 'Status', 'Due Date', 'Resolution Action Updated Date', 'Community Board', 'Borough', 'X Coordinate (State Plane)', 'Y Coordinate (State Plane)', 'Park Facility Name', 'Park Borough', 'School Name', 'School Number', 'School Region', 'School Code', 'School Phone Number', 'School Address', 'School City', 'School State', 'School Zip', 'School Not Found', 'School or Citywide Complaint', 'Vehicle Type', 'Taxi Company Borough', 'Taxi Pick Up Location', 'Bridge Highway Name', 'Bridge Highway Direction', 'Road Ramp', 'Bridge Highway Segment', 'Garage Lot Name', 'Ferry Direction', 'Ferry Terminal Name', 'Latitude', 'Longitude', 'Location'], dtype='object')

complaints['Complaint Type']

0          Noise - Street/Sidewalk
1                  Illegal Parking
2               Noise - Commercial
3                  Noise - Vehicle
4                           Rodent
5               Noise - Commercial
6                 Blocked Driveway
7               Noise - Commercial
8               Noise - Commercial
9               Noise - Commercial
10        Noise - House of Worship
11              Noise - Commercial
12                 Illegal Parking
13                 Noise - Vehicle
14                          Rodent
15        Noise - House of Worship
16         Noise - Street/Sidewalk
17                 Illegal Parking
18          Street Light Condition
19              Noise - Commercial
20        Noise - House of Worship
21              Noise - Commercial
22                 Noise - Vehicle
23              Noise - Commercial
24                Blocked Driveway
25         Noise - Street/Sidewalk
26          Street Light Condition
27            Harboring Bees/Wasps
28         Noise - Street/Sidewalk
29          Street Light Condition
                    ...           
111039          Noise - Commercial
111040          Noise - Commercial
111041                       Noise
111042     Noise - Street/Sidewalk
111043          Noise - Commercial
111044     Noise - Street/Sidewalk
111045                Water System
111046                       Noise
111047             Illegal Parking
111048     Noise - Street/Sidewalk
111049          Noise - Commercial
111050                       Noise
111051          Noise - Commercial
111052                Water System
111053           Derelict Vehicles
111054     Noise - Street/Sidewalk
111055          Noise - Commercial
111056       Street Sign - Missing
111057                       Noise
111058          Noise - Commercial
111059     Noise - Street/Sidewalk
111060                       Noise
111061          Noise - Commercial
111062                Water System
111063                Water System
111064     Maintenance or Facility
111065             Illegal Parking
111066     Noise - Street/Sidewalk
111067          Noise - Commercial
111068            Blocked Driveway
Name: Complaint Type, Length: 111069, dtype: object

相信大家对python中list的切片操作非常熟悉，这里也一样，比如你要取前5条数据，直接用df[:5]即可。

拿前几条数据出来的原因是，我们可以先熟悉熟悉数据，为后期做分析热热身。

complaints[:5]
Unique KeyCreated DateClosed DateAgencyAgency NameComplaint TypeDescriptorLocation TypeIncident ZipIncident AddressStreet NameCross Street 1Cross Street 2Intersection Street 1Intersection Street 2Address TypeCityLandmarkFacility TypeStatusDue DateResolution Action Updated DateCommunity BoardBoroughX Coordinate (State Plane)Y Coordinate (State Plane)Park Facility NamePark BoroughSchool NameSchool NumberSchool RegionSchool CodeSchool Phone NumberSchool AddressSchool CitySchool StateSchool ZipSchool Not FoundSchool or Citywide ComplaintVehicle TypeTaxi Company BoroughTaxi Pick Up LocationBridge Highway NameBridge Highway DirectionRoad RampBridge Highway SegmentGarage Lot NameFerry DirectionFerry Terminal NameLatitudeLongitudeLocation
02658965110/31/2013 02:08:41 AMNaNNYPDNew York City Police DepartmentNoise - Street/SidewalkLoud TalkingStreet/Sidewalk1143290-03 169 STREET169 STREET90 AVENUE91 AVENUENaNNaNADDRESSJAMAICANaNPrecinctAssigned10/31/2013 10:08:41 AM10/31/2013 02:35:17 AM12 QUEENSQUEENS1042027.0197389.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.708275-73.791604(40.70827532593202, -73.79160395779721)
12659369810/31/2013 02:01:04 AMNaNNYPDNew York City Police DepartmentIllegal ParkingCommercial Overnight ParkingStreet/Sidewalk1137858 AVENUE58 AVENUE58 PLACE59 STREETNaNNaNBLOCKFACEMASPETHNaNPrecinctOpen10/31/2013 10:01:04 AMNaN05 QUEENSQUEENS1009349.0201984.0UnspecifiedQUEENSUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.721041-73.909453(40.721040535628305, -73.90945306791765)
22659413910/31/2013 02:00:24 AM10/31/2013 02:40:32 AMNYPDNew York City Police DepartmentNoise - CommercialLoud Music/PartyClub/Bar/Restaurant100324060 BROADWAYBROADWAYWEST 171 STREETWEST 172 STREETNaNNaNADDRESSNEW YORKNaNPrecinctClosed10/31/2013 10:00:24 AM10/31/2013 02:39:42 AM12 MANHATTANMANHATTAN1001088.0246531.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.843330-73.939144(40.84332975466513, -73.93914371913482)
32659572110/31/2013 01:56:23 AM10/31/2013 02:21:48 AMNYPDNew York City Police DepartmentNoise - VehicleCar/Truck HornStreet/Sidewalk10023WEST 72 STREETWEST 72 STREETCOLUMBUS AVENUEAMSTERDAM AVENUENaNNaNBLOCKFACENEW YORKNaNPrecinctClosed10/31/2013 09:56:23 AM10/31/2013 02:21:10 AM07 MANHATTANMANHATTAN989730.0222727.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.778009-73.980213(40.7780087446372, -73.98021349023975)
42659093010/31/2013 01:53:44 AMNaNDOHMHDepartment of Health and Mental HygieneRodentCondition Attracting RodentsVacant Lot10027WEST 124 STREETWEST 124 STREETLENOX AVENUEADAM CLAYTON POWELL JR BOULEVARDNaNNaNBLOCKFACENEW YORKNaNNaNPending11/30/2013 01:53:44 AM10/31/2013 01:59:54 AM10 MANHATTANMANHATTAN998815.0233545.0UnspecifiedMANHATTANUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedUnspecifiedNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN40.807691-73.947387(40.80769092704951, -73.94738703491433)

合并一下，取出某一列的前5行:

complaints['Complaint Type'][:5]

0    Noise - Street/Sidewalk
1            Illegal Parking
2         Noise - Commercial
3            Noise - Vehicle
4                     Rodent
Name: Complaint Type, dtype: object

另外你先取列再切片 和 先切片再取列，其实是一样一样的。

complaints[:5]['Complaint Type']

0    Noise - Street/Sidewalk
1            Illegal Parking
2         Noise - Commercial
3            Noise - Vehicle
4                     Rodent
Name: Complaint Type, dtype: object

2.3 选多行

选一行是把这一行的名字告诉它，那选多行呢？恩，传一个名称list给他咯。

complaints[['Complaint Type', 'Borough']]
Complaint TypeBorough
0Noise - Street/SidewalkQUEENS
1Illegal ParkingQUEENS
2Noise - CommercialMANHATTAN
3Noise - VehicleMANHATTAN
4RodentMANHATTAN
5Noise - CommercialQUEENS
6Blocked DrivewayQUEENS
7Noise - CommercialQUEENS
8Noise - CommercialMANHATTAN
9Noise - CommercialBROOKLYN
10Noise - House of WorshipBROOKLYN
11Noise - CommercialMANHATTAN
12Illegal ParkingMANHATTAN
13Noise - VehicleBRONX
14RodentBROOKLYN
15Noise - House of WorshipMANHATTAN
16Noise - Street/SidewalkSTATEN ISLAND
17Illegal ParkingBROOKLYN
18Street Light ConditionBROOKLYN
19Noise - CommercialMANHATTAN
20Noise - House of WorshipBROOKLYN
21Noise - CommercialMANHATTAN
22Noise - VehicleQUEENS
23Noise - CommercialBROOKLYN
24Blocked DrivewaySTATEN ISLAND
25Noise - Street/SidewalkSTATEN ISLAND
26Street Light ConditionBROOKLYN
27Harboring Bees/WaspsMANHATTAN
28Noise - Street/SidewalkMANHATTAN
29Street Light ConditionSTATEN ISLAND
.........
111039Noise - CommercialMANHATTAN
111040Noise - CommercialMANHATTAN
111041NoiseBROOKLYN
111042Noise - Street/SidewalkMANHATTAN
111043Noise - CommercialBROOKLYN
111044Noise - Street/SidewalkMANHATTAN
111045Water SystemMANHATTAN
111046NoiseBROOKLYN
111047Illegal ParkingQUEENS
111048Noise - Street/SidewalkMANHATTAN
111049Noise - CommercialBROOKLYN
111050NoiseMANHATTAN
111051Noise - CommercialMANHATTAN
111052Water SystemMANHATTAN
111053Derelict VehiclesQUEENS
111054Noise - Street/SidewalkBROOKLYN
111055Noise - CommercialBROOKLYN
111056Street Sign - MissingQUEENS
111057NoiseMANHATTAN
111058Noise - CommercialBROOKLYN
111059Noise - Street/SidewalkMANHATTAN
111060NoiseMANHATTAN
111061Noise - CommercialQUEENS
111062Water SystemMANHATTAN
111063Water SystemMANHATTAN
111064Maintenance or FacilityBROOKLYN
111065Illegal ParkingQUEENS
111066Noise - Street/SidewalkMANHATTAN
111067Noise - CommercialBROOKLYN
111068Blocked DrivewayBROOKLYN

111069 rows × 2 columns

好吧，再拼一下：多列的前n行。

complaints[['Complaint Type', 'Borough']][:10]
Complaint TypeBorough
0Noise - Street/SidewalkQUEENS
1Illegal ParkingQUEENS
2Noise - CommercialMANHATTAN
3Noise - VehicleMANHATTAN
4RodentMANHATTAN
5Noise - CommercialQUEENS
6Blocked DrivewayQUEENS
7Noise - CommercialQUEENS
8Noise - CommercialMANHATTAN
9Noise - CommercialBROOKLYN

2.4 想统计找出Top类型的数据？

dataframe真的很智能，比如你告诉它，我要统计一下数量了！（用.value_counts()函数），那它就帮你统计数量了：

complaints['Complaint Type'].value_counts()

HEATING                                 14200
GENERAL CONSTRUCTION                     7471
Street Light Condition                   7117
DOF Literature Request                   5797
PLUMBING                                 5373
PAINT - PLASTER                          5149
Blocked Driveway                         4590
NONCONST                                 3998
Street Condition                         3473
Illegal Parking                          3343
Noise                                    3321
Traffic Signal Condition                 3145
Dirty Conditions                         2653
Water System                             2636
Noise - Commercial                       2578
ELECTRIC                                 2350
Broken Muni Meter                        2070
Noise - Street/Sidewalk                  1928
Sanitation Condition                     1824
Rodent                                   1632
Sewer                                    1627
Taxi Complaint                           1227
Consumer Complaint                       1227
Damaged Tree                             1180
Overgrown Tree/Branches                  1083
Graffiti                                  973
Missed Collection (All Materials)         973
Building/Use                              942
Root/Sewer/Sidewalk Condition             836
Derelict Vehicle                          803
                                        ...  
Fire Alarm - Modification                   5
Internal Code                               5
Poison Ivy                                  5
Posting Advertisement                       5
Miscellaneous Categories                    5
Special Natural Area District (SNAD)        4
Ferry Complaint                             4
Illegal Animal Sold                         4
Transportation Provider Complaint           4
Fire Alarm - Replacement                    3
Illegal Fireworks                           3
Adopt-A-Basket                              3
Invitation                                  3
DFTA Literature Request                     2
Public Assembly                             2
Window Guard                                2
Opinion for the Mayor                       2
Legal Services Provider Complaint           2
Misc. Comments                              2
X-Ray Machine/Equipment                     1
Snow                                        1
DHS Income Savings Requirement              1
DWD                                         1
Trans Fat                                   1
Highway Sign - Damaged                      1
Ferry Permit                                1
Stalled Sites                               1
Municipal Parking Facility                  1
Open Flame Permit                           1
Tunnel Condition                            1
Name: Complaint Type, Length: 165, dtype: int64

注意哈，咱们拿到的结果是排过序的，也就是说如果我只要top 10的话，其实截断一下就可以了：

complaint_counts = complaints['Complaint Type'].value_counts()
complaint_counts[:10]

HEATING                   14200
GENERAL CONSTRUCTION       7471
Street Light Condition     7117
DOF Literature Request     5797
PLUMBING                   5373
PAINT - PLASTER            5149
Blocked Driveway           4590
NONCONST                   3998
Street Condition           3473
Illegal Parking            3343
Name: Complaint Type, dtype: int64

哈哈，聪明的你一定想到上一节说的绘图，是的，咱们可以把top10画出来。

complaint_counts[:10].plot(figsize=(20,6))#默认是折线图

<matplotlib.axes._subplots.AxesSubplot at 0xf1cd160>

在这里插入图片描述

安替-AnTi
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
KendoUI使用指南
u012333307的专栏
05-13 3113
导出excel引入jszip.min.jstoolbar设置excel命令设置excelExport函数，可以对导出的列进行自定义处理在弹出的编辑界面打印引入jQuery.print.js，支持jquery打印监听onEdit方法，增加打印按钮 onEdit: function () { return function onEdit(e) {
vue.js源码
csdn_12345678910的博客
07-01 1995
/*! * Vue.js v2.5.16 * (c) 2014-2018 Evan You * Released under the MIT License. */ !function(e,t){"object"==typeof exports&amp;&amp;"undefined"!=typeof module?module.exports=t():"function"==typeof...
了解一下COLLADA
弗里茨杰拉德
02-27 2571
COLLADA, Skeletal Animation, C++, OpenGL 文章目录COLLADA, Skeletal Animation, C++, OpenGL Step by Step Skeletal Animation in C++ and OpenGL, Using COLLADA Part 1 Level: Beginner to Intermediate Introducti...
2.2数据选择与分析及折线图柱状图Selecting_data_and_analysis_part1
youif的博客
02-09 548
# * coding:utf-8_*_ # 作者 :XiangLin # 创建时间 :09/02/2020 12:01 # 文件 :2-2_Selecting_data_and_analysis_part1.py # IDE :PyCharm import pandas as pd import matplotlib.pyplot as plt import warnin...
wgrib2安装_用wgrib2-读取grib2文件说明
weixin_40003512的博客
01-11 946
Introductionto GRIB2 using the GFS forecasts2/2013Wesley EbisuzakiGRIB2 (grib edition 2) is a standard formatsponsored by the WMO (UN's World Meteorological Organization) for thetransmission of gridde...
scikit-learn_Scikit Learn-快速指南
cunzai1985的博客
09-23 1480
Scikit Learn-快速指南 (Scikit Learn - Quick Guide) Advertisements 广告 Previous Page 上一页 Next Page 下一页 Scikit Learn-简介 (Scikit Learn - Introduction) In this chapter, we will understand wh...
tb4_Starting an Adventure w Calculations_row-level_aggregate-level_Vacation Rentals_parameter_Ad hoc
Linli522362242的专栏
03-03 667
We have already seen what amazing discovery, analysis, and data storytelling is possible in Tableau by simply connecting to data and dragging and dropping fields. Now, we'll set off on an adventure with calculations. Calculations significantly e...
项目管理检查清单-项目监控_数据科学项目的最终清单
weixin_26642481的博客
09-23 279
项目管理检查清单-项目监控Working on Data is always interesting as you get to know the things that you might have never thought of. But it can also get very confusing and hefty if you are not organized. So to avoi...
Http1.1_1
gulanga5的博客
02-20 606
http1.1
t4_Trading Strategies(dual SMA_Naive_Turtle_pair_Pearson_z-scores_ARIMA_autoregressive_Dickey–Fuller
Linli522362242的专栏
12-12 2223
During the previous chaptershttps://blog.csdn.net/Linli522362242/article/details/121551663, we used statistical methods to predict market price movement from historical data. You may think that you know how to manipulate data, but how can these stati...
lasso特征选择python_转：结合Scikit-learn介绍几种常用的特征选择方法-2
weixin_39572764的博客
02-26 1154
4.2 平均精确率减少 Mean decrease accuracy另一种常用的特征选择方法就是直接度量每个特征对模型精确率的影响。主要思路是打乱每个特征的特征值顺序，并且度量顺序变动对模型的精确率的影响。很明显，对于不重要的变量来说，打乱顺序对模型的精确率影响不会太大，但是对于重要的变量来说，打乱顺序就会降低模型的精确率。这个方法sklearn中没有直接提供，但是很容易实现，下面继续在波士顿房价...
【C++11高性能服务器】Thread Safety Analysis，概念，用法详解
weixin_42157432的博客
04-21 1225
静态检查工具：Clang thread safety annotations 参考连接：Thread Safety Analysis¶ 总览 线程安全分析的工作原理非常类似于多线程程序的类型系统。除了声明数据类型(例如int、float等)之外，程序员还可以(选择性地)声明如何在多线程环境中控制对数据的访问。例如，如果foo是由互斥锁mu保护的，那么当一段代码在没有首先锁定mu的情况下对foo进行读写时，分析就会发出警告。类似地，如果有一些特定的例程应该只由GUI线程调用，那么分析将在其他线程调用这些例.
t2_Deciphering the Market_ticklabels_sma_ewma_apo_macd_Bollinger_Momentum_statsmodels_adfuller_ARIMA
Linli522362242的专栏
11-25 3445
Deciphering解读 the Markets with Technical Analysis In this chapter, we will go through some popular methods of technical analysis and show how to apply them while analyzing market data. We will perform basic algorithmic trading using market trends, suppo..
实时计算：Apache Flink：Flink与Kafka集成实现事件驱动架构.docx
09-02
实时计算：Apache Flink：Flink与Kafka集成实现事件驱动架构.docx
移动软件开发实验五：高校新闻
09-02
移动软件开发实验五：高校新闻
分布式存储系统：Google Cloud Storage：GoogleCloudStorage架构解析.docx
09-02
分布式存储系统：Google Cloud Storage：GoogleCloudStorage架构解析.docx
基于现有explorer文件资源管理，实现跨平台告诉多标签页文件资源管理器，类似360文件管理器等，还处于起步阶段
09-02
基于现有explorer文件资源管理，实现跨平台告诉多标签页文件资源管理器，类似360文件管理器等，还处于起步阶段
关于进程之间的通信IPC，管道，信号的学习
最新发布
09-02
进程间通信（IPC）是操作系统中用于让不同进程之间相互通信的机制。管道是一种半双工的通信方式，数据只能单向流动，而且只能在具有亲缘关系的进程间使用。信号是在软件层次上对中断机制的一种模拟，是一种异步通信方式。该文章讲述了进程的通信通过管道与信号，以及扩展信号等实现进程间数据的交互。它们涵盖基础知识、代码示例和应用场景，适合初学者学习和参考。这些资源能够帮助你理解相关概念，并在实际开发中运用它们进行有效的进程间通信。
select sid from choices where cid=’1-428’ _______________ select sid from choices where cid=’2-669’
04-02
Without more context, it is difficult to determine what is being asked. These are two separate SQL queries selecting the sid column from the choices table where the cid column matches a certain value. Is there a specific question or task associated with these queries?
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

安替-AnTi

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值