Overview

Dataset statistics

Number of variables41
Number of observations23899174
Missing cells326037736
Missing cells (%)33.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.3 GiB
Average record size in memory328.0 B

Variable types

CAT34
NUM6
UNSUPPORTED1

Warnings

Created Date has a high cardinality: 16127124 distinct values High cardinality
Closed Date has a high cardinality: 10389664 distinct values High cardinality
Agency Name has a high cardinality: 1934 distinct values High cardinality
Complaint Type has a high cardinality: 442 distinct values High cardinality
Descriptor has a high cardinality: 1685 distinct values High cardinality
Location Type has a high cardinality: 170 distinct values High cardinality
Incident Address has a high cardinality: 1426219 distinct values High cardinality
Street Name has a high cardinality: 41479 distinct values High cardinality
Cross Street 1 has a high cardinality: 28246 distinct values High cardinality
Cross Street 2 has a high cardinality: 28412 distinct values High cardinality
Intersection Street 1 has a high cardinality: 25016 distinct values High cardinality
Intersection Street 2 has a high cardinality: 24902 distinct values High cardinality
City has a high cardinality: 2545 distinct values High cardinality
Landmark has a high cardinality: 10112 distinct values High cardinality
Due Date has a high cardinality: 8155204 distinct values High cardinality
Resolution Description has a high cardinality: 1688 distinct values High cardinality
Resolution Action Updated Date has a high cardinality: 10447923 distinct values High cardinality
Community Board has a high cardinality: 77 distinct values High cardinality
Park Facility Name has a high cardinality: 4780 distinct values High cardinality
Taxi Pick Up Location has a high cardinality: 25934 distinct values High cardinality
Bridge Highway Name has a high cardinality: 88 distinct values High cardinality
Bridge Highway Direction has a high cardinality: 56 distinct values High cardinality
Bridge Highway Segment has a high cardinality: 5466 distinct values High cardinality
Location has a high cardinality: 1574650 distinct values High cardinality
Closed Date has 694323 (2.9%) missing values Missing
Descriptor has 332333 (1.4%) missing values Missing
Location Type has 5903335 (24.7%) missing values Missing
Incident Zip has 1339781 (5.6%) missing values Missing
Incident Address has 4274682 (17.9%) missing values Missing
Street Name has 4276148 (17.9%) missing values Missing
Cross Street 1 has 7683954 (32.2%) missing values Missing
Cross Street 2 has 7763961 (32.5%) missing values Missing
Intersection Street 1 has 18662406 (78.1%) missing values Missing
Intersection Street 2 has 18669897 (78.1%) missing values Missing
Address Type has 2646077 (11.1%) missing values Missing
City has 1487989 (6.2%) missing values Missing
Landmark has 22190811 (92.9%) missing values Missing
Facility Type has 18346033 (76.8%) missing values Missing
Due Date has 15231800 (63.7%) missing values Missing
Resolution Description has 502659 (2.1%) missing values Missing
Resolution Action Updated Date has 366236 (1.5%) missing values Missing
BBL has 5901765 (24.7%) missing values Missing
X Coordinate (State Plane) has 2077657 (8.7%) missing values Missing
Y Coordinate (State Plane) has 2077657 (8.7%) missing values Missing
Vehicle Type has 23890448 (> 99.9%) missing values Missing
Taxi Company Borough has 23879053 (99.9%) missing values Missing
Taxi Pick Up Location has 23711885 (99.2%) missing values Missing
Bridge Highway Name has 23847049 (99.8%) missing values Missing
Bridge Highway Direction has 23843535 (99.8%) missing values Missing
Road Ramp has 23843994 (99.8%) missing values Missing
Bridge Highway Segment has 23840263 (99.8%) missing values Missing
Latitude has 6249955 (26.2%) missing values Missing
Longitude has 6249955 (26.2%) missing values Missing
Location has 6249955 (26.2%) missing values Missing
Unique Key has unique values Unique
Incident Zip is an unsupported type, check if it needs cleaning or further analysis Unsupported

Reproduction

Analysis started2020-09-18 15:38:16.991826
Analysis finished2020-09-18 15:58:26.200851
Duration20 minutes and 9.21 seconds
Software versionpandas-profiling v2.9.0
Download configurationconfig.yaml

Variables

Unique Key
Real number (ℝ≥0)

UNIQUE

Distinct23899174
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean32200187.9
Minimum10564222
Maximum47560381
Zeros0
Zeros (%)0.0%
Memory size182.3 MiB
2020-09-18T11:58:43.118136image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Quantile statistics

Minimum10564222
5-th percentile18406366.65
Q125005856.25
median32389787.5
Q339526839.75
95-th percentile46047335.35
Maximum47560381
Range36996159
Interquartile range (IQR)14520983.5

Descriptive statistics

Standard deviation8727028.715
Coefficient of variation (CV)0.2710241549
Kurtosis-1.070770399
Mean32200187.9
Median Absolute Deviation (MAD)7258044
Skewness-0.07001375212
Sum7.695578935e+14
Variance7.61610302e+13
MonotocityNot monotonic
2020-09-18T11:58:43.448103image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
293621751< 0.1%
 
348712481< 0.1%
 
474521151< 0.1%
 
222985811< 0.1%
 
306830951< 0.1%
 
348876401< 0.1%
 
390839931< 0.1%
 
223149731< 0.1%
 
265031341< 0.1%
 
306994871< 0.1%
 
Other values (23899164)23899164> 99.9%
 
ValueCountFrequency (%) 
105642221< 0.1%
 
106934081< 0.1%
 
108367491< 0.1%
 
108369671< 0.1%
 
110511771< 0.1%
 
ValueCountFrequency (%) 
475603811< 0.1%
 
475603801< 0.1%
 
475603791< 0.1%
 
475603781< 0.1%
 
475603771< 0.1%
 

Created Date
Categorical

HIGH CARDINALITY

Distinct16127124
Distinct (%)67.5%
Missing0
Missing (%)0.0%
Memory size182.3 MiB
01/24/2013 12:00:00 AM
 
7650
01/08/2015 12:00:00 AM
 
7242
01/07/2014 12:00:00 AM
 
7030
02/16/2015 12:00:00 AM
 
6430
01/08/2014 12:00:00 AM
 
6197
Other values (16127119)
23864625 
ValueCountFrequency (%) 
01/24/2013 12:00:00 AM7650< 0.1%
 
01/08/2015 12:00:00 AM7242< 0.1%
 
01/07/2014 12:00:00 AM7030< 0.1%
 
02/16/2015 12:00:00 AM6430< 0.1%
 
01/08/2014 12:00:00 AM6197< 0.1%
 
01/04/2012 12:00:00 AM5933< 0.1%
 
11/25/2013 12:00:00 AM5909< 0.1%
 
01/23/2014 12:00:00 AM5782< 0.1%
 
01/22/2014 12:00:00 AM5497< 0.1%
 
01/07/2015 12:00:00 AM5432< 0.1%
 
Other values (16127114)2383607299.7%
 
2020-09-18T12:00:26.022357image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique13978729 ?
Unique (%)58.5%

Closed Date
Categorical

HIGH CARDINALITY
MISSING

Distinct10389664
Distinct (%)44.8%
Missing694323
Missing (%)2.9%
Memory size182.3 MiB
11/15/2010 12:00:00 AM
 
9289
11/07/2012 12:00:00 AM
 
7477
12/09/2010 12:00:00 AM
 
6609
11/28/2011 12:00:00 AM
 
6508
11/08/2010 12:00:00 AM
 
6098
Other values (10389659)
23168870 
ValueCountFrequency (%) 
11/15/2010 12:00:00 AM9289< 0.1%
 
11/07/2012 12:00:00 AM7477< 0.1%
 
12/09/2010 12:00:00 AM6609< 0.1%
 
11/28/2011 12:00:00 AM6508< 0.1%
 
11/08/2010 12:00:00 AM6098< 0.1%
 
01/06/2014 12:00:00 AM6074< 0.1%
 
01/28/2013 12:00:00 AM5890< 0.1%
 
01/09/2014 12:00:00 AM5859< 0.1%
 
01/01/1900 12:00:00 AM5759< 0.1%
 
02/28/2011 12:00:00 AM5707< 0.1%
 
Other values (10389654)2313958196.8%
 
(Missing)6943232.9%
 
2020-09-18T12:01:30.921755image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique7597856 ?
Unique (%)32.7%

Agency
Categorical

Distinct33
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size182.3 MiB
HPD
6199704 
NYPD
6176466 
DOT
3205725 
DSNY
1983714 
DEP
1837485 
Other values (28)
4496080 
ValueCountFrequency (%) 
HPD619970425.9%
 
NYPD617646625.8%
 
DOT320572513.4%
 
DSNY19837148.3%
 
DEP18374857.7%
 
DOB12602975.3%
 
DPR10961354.6%
 
DOHMH6059502.5%
 
DOF5110332.1%
 
TLC2739701.1%
 
Other values (23)7486953.1%
 
2020-09-18T12:01:31.521461image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

Agency Name
Categorical

HIGH CARDINALITY

Distinct1934
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size182.3 MiB
Department of Housing Preservation and Development
6199370 
New York City Police Department
6174645 
Department of Transportation
3205627 
Department of Environmental Protection
1837485 
Department of Buildings
1231984 
Other values (1929)
5250063 
ValueCountFrequency (%) 
Department of Housing Preservation and Development619937025.9%
 
New York City Police Department617464525.8%
 
Department of Transportation320562713.4%
 
Department of Environmental Protection18374857.7%
 
Department of Buildings12319845.2%
 
Department of Parks and Recreation10961014.6%
 
Department of Health and Mental Hygiene6028532.5%
 
Department of Sanitation5624802.4%
 
Taxi and Limousine Commission2683811.1%
 
Department of Consumer Affairs2254690.9%
 
Other values (1924)249477910.4%
 
2020-09-18T12:01:32.766861image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique289 ?
Unique (%)< 0.1%

Complaint Type
Categorical

HIGH CARDINALITY

Distinct442
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size182.3 MiB
Noise - Residential
2091160 
HEAT/HOT WATER
 
1322032
Illegal Parking
 
1039120
Street Condition
 
1003788
Blocked Driveway
 
992538
Other values (437)
17450536 
ValueCountFrequency (%) 
Noise - Residential20911608.7%
 
HEAT/HOT WATER13220325.5%
 
Illegal Parking10391204.3%
 
Street Condition10037884.2%
 
Blocked Driveway9925384.2%
 
Street Light Condition9619804.0%
 
HEATING8878693.7%
 
PLUMBING7292613.1%
 
Water System6853292.9%
 
Noise - Street/Sidewalk6313912.6%
 
Other values (432)1355470656.7%
 
2020-09-18T12:01:33.922732image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique124 ?
Unique (%)< 0.1%

Descriptor
Categorical

HIGH CARDINALITY
MISSING

Distinct1685
Distinct (%)< 0.1%
Missing332333
Missing (%)1.4%
Memory size182.3 MiB
Loud Music/Party
2175996 
HEAT
 
871935
ENTIRE BUILDING
 
861625
No Access
 
737384
Street Light Out
 
713708
Other values (1680)
18206193 
ValueCountFrequency (%) 
Loud Music/Party21759969.1%
 
HEAT8719353.6%
 
ENTIRE BUILDING8616253.6%
 
No Access7373843.1%
 
Street Light Out7137083.0%
 
Pothole6084712.5%
 
Banging/Pounding5782752.4%
 
APARTMENT ONLY4604071.9%
 
CEILING3505471.5%
 
Loud Talking3411541.4%
 
Other values (1675)1586733966.4%
 
(Missing)3323331.4%
 
2020-09-18T12:01:34.618216image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique70 ?
Unique (%)< 0.1%

Location Type
Categorical

HIGH CARDINALITY
MISSING

Distinct170
Distinct (%)< 0.1%
Missing5903335
Missing (%)24.7%
Memory size182.3 MiB
RESIDENTIAL BUILDING
6139765 
Street/Sidewalk
3390949 
Street
2217932 
Residential Building/House
2174304 
Sidewalk
1536557 
Other values (165)
2536332 
ValueCountFrequency (%) 
RESIDENTIAL BUILDING613976525.7%
 
Street/Sidewalk339094914.2%
 
Street22179329.3%
 
Residential Building/House21743049.1%
 
Sidewalk15365576.4%
 
Store/Commercial2749491.2%
 
Property Address2117280.9%
 
Club/Bar/Restaurant1986390.8%
 
Senior Address1728820.7%
 
Park1687410.7%
 
Other values (160)15093936.3%
 
(Missing)590333524.7%
 
2020-09-18T12:01:36.379496image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

Incident Zip
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing1339781
Missing (%)5.6%
Memory size182.3 MiB

Incident Address
Categorical

HIGH CARDINALITY
MISSING

Distinct1426219
Distinct (%)7.3%
Missing4274682
Missing (%)17.9%
Memory size182.3 MiB
89-21 ELMHURST AVENUE
 
16223
655 EAST 230 STREET
 
14870
34 ARDEN STREET
 
14560
672 EAST 231 STREET
 
13572
78-15 PARSONS BOULEVARD
 
12970
Other values (1426214)
19552297 
ValueCountFrequency (%) 
89-21 ELMHURST AVENUE162230.1%
 
655 EAST 230 STREET148700.1%
 
34 ARDEN STREET145600.1%
 
672 EAST 231 STREET135720.1%
 
78-15 PARSONS BOULEVARD129700.1%
 
BROADWAY129570.1%
 
1025 BOYNTON AVENUE126850.1%
 
655 EAST 230 STREET9584< 0.1%
 
159-06 UNION TURNPIKE7745< 0.1%
 
82-16 164 STREET7715< 0.1%
 
Other values (1426209)1950161181.6%
 
(Missing)427468217.9%
 
2020-09-18T12:01:46.950531image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique456910 ?
Unique (%)2.3%

Street Name
Categorical

HIGH CARDINALITY
MISSING

Distinct41479
Distinct (%)0.2%
Missing4276148
Missing (%)17.9%
Memory size182.3 MiB
BROADWAY
 
230318
GRAND CONCOURSE
 
140604
OCEAN AVENUE
 
92265
5 AVENUE
 
85802
3 AVENUE
 
82144
Other values (41474)
18991893 
ValueCountFrequency (%) 
BROADWAY2303181.0%
 
GRAND CONCOURSE1406040.6%
 
OCEAN AVENUE922650.4%
 
5 AVENUE858020.4%
 
3 AVENUE821440.3%
 
AMSTERDAM AVENUE800350.3%
 
ST NICHOLAS AVENUE661490.3%
 
MORRIS AVENUE635300.3%
 
2 AVENUE626460.3%
 
BEDFORD AVENUE608050.3%
 
Other values (41469)1865872878.1%
 
(Missing)427614817.9%
 
2020-09-18T12:01:47.651396image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique17391 ?
Unique (%)0.1%

Cross Street 1
Categorical

HIGH CARDINALITY
MISSING

Distinct28246
Distinct (%)0.2%
Missing7683954
Missing (%)32.2%
Memory size182.3 MiB
BEND
 
303338
BROADWAY
 
201898
5 AVENUE
 
147220
3 AVENUE
 
143312
AMSTERDAM AVENUE
 
128683
Other values (28241)
15290769 
ValueCountFrequency (%) 
BEND3033381.3%
 
BROADWAY2018980.8%
 
5 AVENUE1472200.6%
 
3 AVENUE1433120.6%
 
AMSTERDAM AVENUE1286830.5%
 
DEAD END1109020.5%
 
7 AVENUE1093490.5%
 
2 AVENUE1011450.4%
 
8 AVENUE934760.4%
 
BEDFORD AVENUE737810.3%
 
Other values (28236)1480211661.9%
 
(Missing)768395432.2%
 
2020-09-18T12:01:48.429647image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique5537 ?
Unique (%)< 0.1%

Cross Street 2
Categorical

HIGH CARDINALITY
MISSING

Distinct28412
Distinct (%)0.2%
Missing7763961
Missing (%)32.5%
Memory size182.3 MiB
BEND
 
298177
BROADWAY
 
210463
DEAD END
 
134606
7 AVENUE
 
104481
8 AVENUE
 
102589
Other values (28407)
15284897 
ValueCountFrequency (%) 
BEND2981771.2%
 
BROADWAY2104630.9%
 
DEAD END1346060.6%
 
7 AVENUE1044810.4%
 
8 AVENUE1025890.4%
 
3 AVENUE897640.4%
 
2 AVENUE886190.4%
 
1 AVENUE883080.4%
 
NOSTRAND AVENUE819720.3%
 
BEDFORD AVENUE676050.3%
 
Other values (28402)1486862962.2%
 
(Missing)776396132.5%
 
2020-09-18T12:01:48.884706image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique5573 ?
Unique (%)< 0.1%

Intersection Street 1
Categorical

HIGH CARDINALITY
MISSING

Distinct25016
Distinct (%)0.5%
Missing18662406
Missing (%)78.1%
Memory size182.3 MiB
BROADWAY
 
84854
CARPENTER AVENUE
 
49645
3 AVENUE
 
43308
BEND
 
42691
5 AVENUE
 
38708
Other values (25011)
4977562 
ValueCountFrequency (%) 
BROADWAY848540.4%
 
CARPENTER AVENUE496450.2%
 
3 AVENUE433080.2%
 
BEND426910.2%
 
5 AVENUE387080.2%
 
AMSTERDAM AVENUE281040.1%
 
2 AVENUE277650.1%
 
8 AVENUE219550.1%
 
7 AVENUE211850.1%
 
1 AVENUE203120.1%
 
Other values (25006)485824120.3%
 
(Missing)1866240678.1%
 
2020-09-18T12:01:49.227206image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique8297 ?
Unique (%)0.2%

Intersection Street 2
Categorical

HIGH CARDINALITY
MISSING

Distinct24902
Distinct (%)0.5%
Missing18669897
Missing (%)78.1%
Memory size182.3 MiB
BROADWAY
 
78125
BEND
 
40950
3 AVENUE
 
37344
2 AVENUE
 
36783
1 AVENUE
 
29495
Other values (24897)
5006580 
ValueCountFrequency (%) 
BROADWAY781250.3%
 
BEND409500.2%
 
3 AVENUE373440.2%
 
2 AVENUE367830.2%
 
1 AVENUE294950.1%
 
5 AVENUE293890.1%
 
WHITE PLAINS ROAD292750.1%
 
7 AVENUE245960.1%
 
8 AVENUE243760.1%
 
6 AVENUE243280.1%
 
Other values (24892)487461620.4%
 
(Missing)1866989778.1%
 
2020-09-18T12:01:49.704738image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique7534 ?
Unique (%)0.1%

Address Type
Categorical

MISSING

Distinct5
Distinct (%)< 0.1%
Missing2646077
Missing (%)11.1%
Memory size182.3 MiB
ADDRESS
17254571 
INTERSECTION
3256294 
BLOCKFACE
 
550311
LATLONG
 
182117
PLACENAME
 
9804
ValueCountFrequency (%) 
ADDRESS1725457172.2%
 
INTERSECTION325629413.6%
 
BLOCKFACE5503112.3%
 
LATLONG1821170.8%
 
PLACENAME9804< 0.1%
 
(Missing)264607711.1%
 
2020-09-18T12:01:49.982485image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

City
Categorical

HIGH CARDINALITY
MISSING

Distinct2545
Distinct (%)< 0.1%
Missing1487989
Missing (%)6.2%
Memory size182.3 MiB
BROOKLYN
7100864 
NEW YORK
4515292 
BRONX
4291273 
STATEN ISLAND
1175641 
JAMAICA
 
328713
Other values (2540)
4999402 
ValueCountFrequency (%) 
BROOKLYN710086429.7%
 
NEW YORK451529218.9%
 
BRONX429127318.0%
 
STATEN ISLAND11756414.9%
 
JAMAICA3287131.4%
 
FLUSHING2523141.1%
 
Jamaica2434191.0%
 
ASTORIA2296131.0%
 
RIDGEWOOD1779440.7%
 
Flushing1706780.7%
 
Other values (2535)392543416.4%
 
(Missing)14879896.2%
 
2020-09-18T12:01:50.756732image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique1594 ?
Unique (%)< 0.1%

Landmark
Categorical

HIGH CARDINALITY
MISSING

Distinct10112
Distinct (%)0.6%
Missing22190811
Missing (%)92.9%
Memory size182.3 MiB
BROADWAY
 
22095
EAST 231 STREET
 
19927
EAST 230 STREET
 
14512
5 AVENUE
 
10764
EAST 230 STREET
 
9609
Other values (10107)
1631456 
ValueCountFrequency (%) 
BROADWAY220950.1%
 
EAST 231 STREET199270.1%
 
EAST 230 STREET145120.1%
 
5 AVENUE10764< 0.1%
 
EAST 230 STREET9609< 0.1%
 
GRAND CONCOURSE9097< 0.1%
 
3 AVENUE8831< 0.1%
 
2 AVENUE7304< 0.1%
 
PARSONS BOULEVARD7294< 0.1%
 
AMSTERDAM AVENUE7013< 0.1%
 
Other values (10102)15919176.7%
 
(Missing)2219081192.9%
 
2020-09-18T12:01:51.728470image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique1295 ?
Unique (%)0.1%

Facility Type
Categorical

MISSING

Distinct4
Distinct (%)< 0.1%
Missing18346033
Missing (%)76.8%
Memory size182.3 MiB
Precinct
4757734 
DSNY Garage
777916 
School
 
15849
School District
 
1642
ValueCountFrequency (%) 
Precinct475773419.9%
 
DSNY Garage7779163.3%
 
School158490.1%
 
School District1642< 0.1%
 
(Missing)1834603376.8%
 
2020-09-18T12:01:51.887296image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

Status
Categorical

Distinct12
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size182.3 MiB
Closed
22743842 
Pending
 
490007
Open
 
296647
In Progress
 
191467
Assigned
 
164245
Other values (7)
 
12966
ValueCountFrequency (%) 
Closed2274384295.2%
 
Pending4900072.1%
 
Open2966471.2%
 
In Progress1914670.8%
 
Assigned1642450.7%
 
Started8991< 0.1%
 
Email Sent3835< 0.1%
 
Unassigned45< 0.1%
 
Closed - Testing38< 0.1%
 
Unspecified38< 0.1%
 
Other values (2)19< 0.1%
 
2020-09-18T12:01:51.981105image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

Due Date
Categorical

HIGH CARDINALITY
MISSING

Distinct8155204
Distinct (%)94.1%
Missing15231800
Missing (%)63.7%
Memory size182.3 MiB
04/08/2015 10:00:58 AM
 
4552
05/02/2014 03:32:17 PM
 
4326
03/30/2018 10:10:39 AM
 
4234
07/09/2016 11:21:17 AM
 
3871
06/27/2015 10:29:08 AM
 
3674
Other values (8155199)
8646717 
ValueCountFrequency (%) 
04/08/2015 10:00:58 AM4552< 0.1%
 
05/02/2014 03:32:17 PM4326< 0.1%
 
03/30/2018 10:10:39 AM4234< 0.1%
 
07/09/2016 11:21:17 AM3871< 0.1%
 
06/27/2015 10:29:08 AM3674< 0.1%
 
04/03/2016 03:32:41 PM3328< 0.1%
 
09/12/2014 02:25:36 PM3308< 0.1%
 
01/17/2020 11:55:23 AM3054< 0.1%
 
06/22/2018 03:13:02 PM2986< 0.1%
 
06/20/2019 04:33:38 PM2598< 0.1%
 
Other values (8155194)863144336.1%
 
(Missing)1523180063.7%
 
2020-09-18T12:02:38.846922image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique7940080 ?
Unique (%)91.6%

Resolution Description
Categorical

HIGH CARDINALITY
MISSING

Distinct1688
Distinct (%)< 0.1%
Missing502659
Missing (%)2.1%
Memory size182.3 MiB
The Police Department responded to the complaint and with the information available observed no evidence of the violation at that time.
2134375 
The Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed.
1756866 
The Police Department responded to the complaint and took action to fix the condition.
 
1478721
Service Request status for this request is available on the Department of Transportation?s website. Please click the ?Learn More? link below.
 
1286269
The Department of Housing Preservation and Development inspected the following conditions. Violations were issued. Information about specific violations is available at www.nyc.gov/hpd.
 
1052923
Other values (1683)
15687361 
ValueCountFrequency (%) 
The Police Department responded to the complaint and with the information available observed no evidence of the violation at that time.21343758.9%
 
The Department of Housing Preservation and Development inspected the following conditions. No violations were issued. The complaint has been closed.17568667.4%
 
The Police Department responded to the complaint and took action to fix the condition.14787216.2%
 
Service Request status for this request is available on the Department of Transportation?s website. Please click the ?Learn More? link below.12862695.4%
 
The Department of Housing Preservation and Development inspected the following conditions. Violations were issued. Information about specific violations is available at www.nyc.gov/hpd.10529234.4%
 
The Department of Housing Preservation and Development was not able to gain access to inspect the following conditions. The complaint has been closed. If the condition still exists, please file a new complaint.8436633.5%
 
The Police Department responded to the complaint and determined that police action was not necessary.8195363.4%
 
The Police Department responded and upon arrival those responsible for the condition were gone.7619263.2%
 
The complaint you filed is a duplicate of a condition already reported by another tenant for a building-wide condition. The original complaint is still open. HPD may attempt to contact you to verify the correction of the condition or may conduct an inspection of your unit if the original complainant is not available for verification.4974442.1%
 
The Department of Transportation inspected this complaint and repaired the problem.4940302.1%
 
Other values (1678)1227076251.3%
 
(Missing)5026592.1%
 
2020-09-18T12:02:39.131278image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique154 ?
Unique (%)< 0.1%

Resolution Action Updated Date
Categorical

HIGH CARDINALITY
MISSING

Distinct10447923
Distinct (%)44.4%
Missing366236
Missing (%)1.5%
Memory size182.3 MiB
11/15/2010 12:00:00 AM
 
9227
11/07/2012 12:00:00 AM
 
7590
12/09/2010 12:00:00 AM
 
6674
11/08/2010 12:00:00 AM
 
6594
11/28/2011 12:00:00 AM
 
6472
Other values (10447918)
23496381 
ValueCountFrequency (%) 
11/15/2010 12:00:00 AM9227< 0.1%
 
11/07/2012 12:00:00 AM7590< 0.1%
 
12/09/2010 12:00:00 AM6674< 0.1%
 
11/08/2010 12:00:00 AM6594< 0.1%
 
11/28/2011 12:00:00 AM6472< 0.1%
 
02/28/2011 12:00:00 AM6203< 0.1%
 
01/06/2014 12:00:00 AM6179< 0.1%
 
01/09/2014 12:00:00 AM5977< 0.1%
 
01/28/2013 12:00:00 AM5945< 0.1%
 
11/03/2011 12:00:00 AM5528< 0.1%
 
Other values (10447913)2346654998.2%
 
(Missing)3662361.5%
 
2020-09-18T12:03:44.299247image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique7817329 ?
Unique (%)33.2%

Community Board
Categorical

HIGH CARDINALITY

Distinct77
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size182.3 MiB
0 Unspecified
 
1222047
12 MANHATTAN
 
710039
12 QUEENS
 
560573
01 BROOKLYN
 
515712
03 BROOKLYN
 
512527
Other values (72)
20378276 
ValueCountFrequency (%) 
0 Unspecified12220475.1%
 
12 MANHATTAN7100393.0%
 
12 QUEENS5605732.3%
 
01 BROOKLYN5157122.2%
 
03 BROOKLYN5125272.1%
 
04 BRONX4924442.1%
 
07 QUEENS4903812.1%
 
05 BROOKLYN4839572.0%
 
12 BRONX4760552.0%
 
05 QUEENS4754042.0%
 
Other values (67)1796003575.1%
 
2020-09-18T12:03:44.434625image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

BBL
Real number (ℝ≥0)

MISSING

Distinct784651
Distinct (%)4.4%
Missing5901765
Missing (%)24.7%
Infinite0
Infinite (%)0.0%
Mean2753593843
Minimum0
Maximum6066007501
Zeros2319
Zeros (%)< 0.1%
Memory size182.3 MiB
2020-09-18T12:03:44.951413image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1008460017
Q12028310020
median3019690093
Q34008030138
95-th percentile4161520082
Maximum6066007501
Range6066007501
Interquartile range (IQR)1979720118

Descriptive statistics

Standard deviation1167667311
Coefficient of variation (CV)0.4240521214
Kurtosis-0.9517437793
Mean2753593843
Median Absolute Deviation (MAD)991030048
Skewness-0.03296748224
Sum4.955755462e+16
Variance1.363446949e+18
MonotocityNot monotonic
2020-09-18T12:03:45.065415image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
2048330028244540.1%
 
4015110001164000.1%
 
2048330080157350.1%
 
1021740175149150.1%
 
4068290001130110.1%
 
2037140054126670.1%
 
203944750110278< 0.1%
 
20288202298882< 0.1%
 
20251100688536< 0.1%
 
30130200017834< 0.1%
 
Other values (784641)1786469774.8%
 
(Missing)590176524.7%
 
ValueCountFrequency (%) 
02319< 0.1%
 
75021< 0.1%
 
30757622< 0.1%
 
660075011< 0.1%
 
1406940203< 0.1%
 
ValueCountFrequency (%) 
60660075012< 0.1%
 
52700099951< 0.1%
 
52700005151< 0.1%
 
52700005144< 0.1%
 
527000050112< 0.1%
 

Borough
Categorical

Distinct6
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size182.3 MiB
BROOKLYN
7087307 
QUEENS
5475285 
MANHATTAN
4663546 
BRONX
4262250 
Unspecified
1222047 
ValueCountFrequency (%) 
BROOKLYN708730729.7%
 
QUEENS547528522.9%
 
MANHATTAN466354619.5%
 
BRONX426225017.8%
 
Unspecified12220475.1%
 
STATEN ISLAND11887395.0%
 
2020-09-18T12:03:45.174242image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

X Coordinate (State Plane)
Real number (ℝ)

MISSING

Distinct138691
Distinct (%)0.6%
Missing2077657
Missing (%)8.7%
Infinite0
Infinite (%)0.0%
Mean1005328.189
Minimum-195555
Maximum1067302
Zeros0
Zeros (%)0.0%
Memory size182.3 MiB
2020-09-18T12:03:45.370140image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Quantile statistics

Minimum-195555
5-th percentile964203
Q1993538
median1004516
Q31018201
95-th percentile1044090
Maximum1067302
Range1262857
Interquartile range (IQR)24663

Descriptive statistics

Standard deviation22545.06889
Coefficient of variation (CV)0.02242558115
Kurtosis2.616542072
Mean1005328.189
Median Absolute Deviation (MAD)12290
Skewness-0.4187585724
Sum2.193778617e+13
Variance508280131.2
MonotocityNot monotonic
2020-09-18T12:03:45.505904image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
1022911245590.1%
 
1018372163750.1%
 
1023174161000.1%
 
1004402145510.1%
 
1037000131340.1%
 
1018209124200.1%
 
10386297975< 0.1%
 
10125867924< 0.1%
 
10375387871< 0.1%
 
10039367467< 0.1%
 
Other values (138681)2169314190.8%
 
(Missing)20776578.7%
 
ValueCountFrequency (%) 
-1955553< 0.1%
 
9132813< 0.1%
 
9133532< 0.1%
 
91335727< 0.1%
 
9133681< 0.1%
 
ValueCountFrequency (%) 
10673021< 0.1%
 
10672831< 0.1%
 
106727912< 0.1%
 
106722044< 0.1%
 
10671931< 0.1%
 

Y Coordinate (State Plane)
Real number (ℝ)

MISSING

Distinct143303
Distinct (%)0.7%
Missing2077657
Missing (%)8.7%
Infinite0
Infinite (%)0.0%
Mean205514.0751
Minimum-195555
Maximum272089
Zeros0
Zeros (%)0.0%
Memory size182.3 MiB
2020-09-18T12:03:45.678877image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Quantile statistics

Minimum-195555
5-th percentile156604
Q1182278
median202379
Q3234831
95-th percentile255914
Maximum272089
Range467644
Interquartile range (IQR)52553

Descriptive statistics

Standard deviation31694.43075
Coefficient of variation (CV)0.1542202437
Kurtosis-0.9141656012
Mean205514.0751
Median Absolute Deviation (MAD)24131
Skewness0.06471759239
Sum4.484628884e+12
Variance1004536941
MonotocityNot monotonic
2020-09-18T12:03:45.780706image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
264242244640.1%
 
211606162820.1%
 
264429157360.1%
 
253313148750.1%
 
202363132170.1%
 
239723124380.1%
 
2011858228< 0.1%
 
2017708110< 0.1%
 
2614827495< 0.1%
 
2422337199< 0.1%
 
Other values (143293)2169347390.8%
 
(Missing)20776578.7%
 
ValueCountFrequency (%) 
-1955553< 0.1%
 
1208261< 0.1%
 
12103210< 0.1%
 
12107213< 0.1%
 
1210801< 0.1%
 
ValueCountFrequency (%) 
2720891< 0.1%
 
2719011< 0.1%
 
271876136< 0.1%
 
27186158< 0.1%
 
2718203< 0.1%
 
Distinct5
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size182.3 MiB
PHONE
12003672 
UNKNOWN
5625950 
ONLINE
4098043 
MOBILE
1804670 
OTHER
 
366839
ValueCountFrequency (%) 
PHONE1200367250.2%
 
UNKNOWN562595023.5%
 
ONLINE409804317.1%
 
MOBILE18046707.6%
 
OTHER3668391.5%
 
2020-09-18T12:03:45.883243image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

Park Facility Name
Categorical

HIGH CARDINALITY

Distinct4780
Distinct (%)< 0.1%
Missing2140
Missing (%)< 0.1%
Memory size182.3 MiB
Unspecified
23736082 
Central Park
 
6062
Riverside Park
 
2757
Prospect Park
 
2688
Flushing Meadows Corona Park
 
1860
Other values (4775)
 
147585
ValueCountFrequency (%) 
Unspecified2373608299.3%
 
Central Park6062< 0.1%
 
Riverside Park2757< 0.1%
 
Prospect Park2688< 0.1%
 
Flushing Meadows Corona Park1860< 0.1%
 
Forest Park1473< 0.1%
 
Rockaway Beach Boardwalk1376< 0.1%
 
Hudson River Park1147< 0.1%
 
Franz Sigel Park1104< 0.1%
 
Morningside Park1076< 0.1%
 
Other values (4770)1414090.6%
 
(Missing)2140< 0.1%
 
2020-09-18T12:03:46.149859image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique723 ?
Unique (%)< 0.1%

Park Borough
Categorical

Distinct6
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size182.3 MiB
BROOKLYN
7087307 
QUEENS
5475285 
MANHATTAN
4663546 
BRONX
4262250 
Unspecified
1222047 
ValueCountFrequency (%) 
BROOKLYN708730729.7%
 
QUEENS547528522.9%
 
MANHATTAN466354619.5%
 
BRONX426225017.8%
 
Unspecified12220475.1%
 
STATEN ISLAND11887395.0%
 
2020-09-18T12:03:46.242815image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

Vehicle Type
Categorical

MISSING

Distinct4
Distinct (%)< 0.1%
Missing23890448
Missing (%)> 99.9%
Memory size182.3 MiB
Car Service
7796 
Ambulette / Paratransit
 
573
Commuter Van
 
320
Green Taxi
 
37
ValueCountFrequency (%) 
Car Service7796< 0.1%
 
Ambulette / Paratransit573< 0.1%
 
Commuter Van320< 0.1%
 
Green Taxi37< 0.1%
 
(Missing)23890448> 99.9%
 
2020-09-18T12:03:46.329575image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

Taxi Company Borough
Categorical

MISSING

Distinct11
Distinct (%)0.1%
Missing23879053
Missing (%)99.9%
Memory size182.3 MiB
BROOKLYN
5253 
QUEENS
4365 
MANHATTAN
4283 
BRONX
3319 
STATEN ISLAND
769 
Other values (6)
2132 
ValueCountFrequency (%) 
BROOKLYN5253< 0.1%
 
QUEENS4365< 0.1%
 
MANHATTAN4283< 0.1%
 
BRONX3319< 0.1%
 
STATEN ISLAND769< 0.1%
 
Brooklyn663< 0.1%
 
Manhattan589< 0.1%
 
Queens451< 0.1%
 
Bronx380< 0.1%
 
Staten Island45< 0.1%
 
(Missing)2387905399.9%
 
2020-09-18T12:03:46.417302image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

Taxi Pick Up Location
Categorical

HIGH CARDINALITY
MISSING

Distinct25934
Distinct (%)13.8%
Missing23711885
Missing (%)99.2%
Memory size182.3 MiB
Other
100959 
JFK Airport
13437 
Intersection
12317 
La Guardia Airport
 
8362
JFK AIRPORT, QUEENS (JAMAICA) ,NY, 11430
 
2245
Other values (25929)
49969 
ValueCountFrequency (%) 
Other1009590.4%
 
JFK Airport134370.1%
 
Intersection123170.1%
 
La Guardia Airport8362< 0.1%
 
JFK AIRPORT, QUEENS (JAMAICA) ,NY, 114302245< 0.1%
 
New York-Penn Station2169< 0.1%
 
Grand Central Station1469< 0.1%
 
Port Authority Bus Terminal1358< 0.1%
 
LA GUARDIA AIRPORT, QUEENS (EAST ELMHURST) ,NY, 11369752< 0.1%
 
PENNSYLVANIA STATION, MANHATTAN (NEW YORK) ,NY, 10121234< 0.1%
 
Other values (25924)439870.2%
 
(Missing)2371188599.2%
 
2020-09-18T12:03:46.695693image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique19043 ?
Unique (%)10.2%

Bridge Highway Name
Categorical

HIGH CARDINALITY
MISSING

Distinct88
Distinct (%)0.2%
Missing23847049
Missing (%)99.8%
Memory size182.3 MiB
Belt Pkwy
5917 
BQE/Gowanus Expwy
5616 
Grand Central Pkwy
4280 
Long Island Expwy
3606 
FDR Dr
3527 
Other values (83)
29179 
ValueCountFrequency (%) 
Belt Pkwy5917< 0.1%
 
BQE/Gowanus Expwy5616< 0.1%
 
Grand Central Pkwy4280< 0.1%
 
Long Island Expwy3606< 0.1%
 
FDR Dr3527< 0.1%
 
Van Wyck Expwy2998< 0.1%
 
Staten Island Expwy2326< 0.1%
 
Major Deegan Expwy2235< 0.1%
 
Cross Island Pkwy2035< 0.1%
 
Henry Hudson Pkwy/Rt 9A1892< 0.1%
 
Other values (78)176930.1%
 
(Missing)2384704999.8%
 
2020-09-18T12:03:46.807758image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique2 ?
Unique (%)< 0.1%

Bridge Highway Direction
Categorical

HIGH CARDINALITY
MISSING

Distinct56
Distinct (%)0.1%
Missing23843535
Missing (%)99.8%
Memory size182.3 MiB
East/Long Island Bound
5140 
North/Bronx Bound
5028 
East/Queens Bound
4531 
West/Staten Island Bound
3962 
Manhattan Bound
 
2414
Other values (51)
34564 
ValueCountFrequency (%) 
East/Long Island Bound5140< 0.1%
 
North/Bronx Bound5028< 0.1%
 
East/Queens Bound4531< 0.1%
 
West/Staten Island Bound3962< 0.1%
 
Manhattan Bound2414< 0.1%
 
West/Brooklyn Bound2366< 0.1%
 
West/Toward Triborough Br2011< 0.1%
 
West/Manhattan Bound1976< 0.1%
 
Northbound/Uptown1883< 0.1%
 
Southbound/Downtown1875< 0.1%
 
Other values (46)244530.1%
 
(Missing)2384353599.8%
 
2020-09-18T12:03:46.925548image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique1 ?
Unique (%)< 0.1%

Road Ramp
Categorical

MISSING

Distinct2
Distinct (%)< 0.1%
Missing23843994
Missing (%)99.8%
Memory size182.3 MiB
Roadway
41539 
Ramp
13641 
ValueCountFrequency (%) 
Roadway415390.2%
 
Ramp136410.1%
 
(Missing)2384399499.8%
 
2020-09-18T12:03:47.014260image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique0 ?
Unique (%)0.0%

Bridge Highway Segment
Categorical

HIGH CARDINALITY
MISSING

Distinct5466
Distinct (%)9.3%
Missing23840263
Missing (%)99.8%
Memory size182.3 MiB
Ramp
 
2042
Roadway
 
1889
Clove Rd/Richmond Rd (Exit 13) - Lily Pond Ave/Bay St (Exit 15 S-N)
 
548
Outer Roadway
 
503
Bikepath
 
443
Other values (5461)
53486 
ValueCountFrequency (%) 
Ramp2042< 0.1%
 
Roadway1889< 0.1%
 
Clove Rd/Richmond Rd (Exit 13) - Lily Pond Ave/Bay St (Exit 15 S-N)548< 0.1%
 
Outer Roadway503< 0.1%
 
Bikepath443< 0.1%
 
Lower Level422< 0.1%
 
Flatbush Ave (Exit 11N) - Flatbush Ave (Exit 11S)363< 0.1%
 
East 61st St / East 63rd St (Exit 12) - East 96th St (Exit 14)350< 0.1%
 
East 96th St (Exit 14) - Triborough Br (Exit 17)320< 0.1%
 
Rockaway Pkwy (Exit 13) - Flatbush Ave (Exit 11N)299< 0.1%
 
Other values (5456)517320.2%
 
(Missing)2384026399.8%
 
2020-09-18T12:03:47.148966image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique4002 ?
Unique (%)6.8%

Latitude
Real number (ℝ≥0)

MISSING

Distinct1226586
Distinct (%)6.9%
Missing6249955
Missing (%)26.2%
Infinite0
Infinite (%)0.0%
Mean40.72771094
Minimum39.5525551
Maximum40.9134565
Zeros0
Zeros (%)0.0%
Memory size182.3 MiB
2020-09-18T12:03:47.953820image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Quantile statistics

Minimum39.5525551
5-th percentile40.59471949
Q140.6671106
median40.7218536
Q340.80162
95-th percentile40.8679758
Maximum40.9134565
Range1.3609014
Interquartile range (IQR)0.1345094

Descriptive statistics

Standard deviation0.09140984318
Coefficient of variation (CV)0.002244413965
Kurtosis4.081355959
Mean40.72771094
Median Absolute Deviation (MAD)0.0630296
Skewness-0.70060043
Sum718812289.8
Variance0.00835575943
MonotocityNot monotonic
2020-09-18T12:03:48.061505image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
40.1123853463840.2%
 
40.8918724148370.1%
 
40.7474203142990.1%
 
40.8923845135580.1%
 
40.7219591121500.1%
 
40.824594510836< 0.1%
 
40.891872429584< 0.1%
 
40.72032827562< 0.1%
 
40.71871597359< 0.1%
 
40.83036236083< 0.1%
 
Other values (1226576)1750656773.3%
 
(Missing)624995526.2%
 
ValueCountFrequency (%) 
39.55255513< 0.1%
 
40.1123853463840.2%
 
40.49804421< 0.1%
 
40.49862777< 0.1%
 
40.498737412< 0.1%
 
ValueCountFrequency (%) 
40.91345651< 0.1%
 
40.91294051< 0.1%
 
40.9128688122< 0.1%
 
40.91286884< 0.1%
 
40.912827651< 0.1%
 

Longitude
Real number (ℝ)

MISSING

Distinct1248556
Distinct (%)7.1%
Missing6249955
Missing (%)26.2%
Infinite0
Infinite (%)0.0%
Mean-73.9339463
Minimum-78.1845081
Maximum-73.700292
Zeros0
Zeros (%)0.0%
Memory size182.3 MiB
2020-09-18T12:03:48.752893image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/

Quantile statistics

Minimum-78.1845081
5-th percentile-74.080833
Q1-73.9709085
median-73.9282326
Q3-73.8764838
95-th percentile-73.7833306
Maximum-73.700292
Range4.4842161
Interquartile range (IQR)0.0944247

Descriptive statistics

Standard deviation0.2016812147
Coefficient of variation (CV)-0.002727856754
Kurtosis259.7242837
Mean-73.9339463
Median Absolute Deviation (MAD)0.0468761
Skewness-14.77254863
Sum-1304876410
Variance0.04067531238
MonotocityNot monotonic
2020-09-18T12:03:48.854686image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%) 
-77.5195844463840.2%
 
-73.8601685148310.1%
 
-73.876853142990.1%
 
-73.8592161135620.1%
 
-73.8096968121500.1%
 
-73.877299110836< 0.1%
 
-73.860168459584< 0.1%
 
-73.80776067562< 0.1%
 
-73.80382957358< 0.1%
 
-73.86602156083< 0.1%
 
Other values (1248546)1750657073.3%
 
(Missing)624995526.2%
 
ValueCountFrequency (%) 
-78.18450813< 0.1%
 
-77.5195844463840.2%
 
-74.25521083< 0.1%
 
-74.25495172< 0.1%
 
-74.254937220< 0.1%
 
ValueCountFrequency (%) 
-73.7002921< 0.1%
 
-73.70038358< 0.1%
 
-73.700596823< 0.1%
 
-73.70068361< 0.1%
 
-73.7007153< 0.1%
 

Location
Categorical

HIGH CARDINALITY
MISSING

Distinct1574650
Distinct (%)8.9%
Missing6249955
Missing (%)26.2%
Memory size182.3 MiB
(40.1123853, -77.5195844)
 
46384
(40.8918724, -73.8601685)
 
14826
(40.7474203, -73.876853)
 
14299
(40.8923845, -73.8592161)
 
13557
(40.7219591, -73.8096968)
 
12150
Other values (1574645)
17548003 
ValueCountFrequency (%) 
(40.1123853, -77.5195844)463840.2%
 
(40.8918724, -73.8601685)148260.1%
 
(40.7474203, -73.876853)142990.1%
 
(40.8923845, -73.8592161)135570.1%
 
(40.7219591, -73.8096968)121500.1%
 
(40.8245945, -73.8772991)10836< 0.1%
 
(40.89187241649303, -73.86016845296459)9584< 0.1%
 
(40.7203282, -73.8077606)7562< 0.1%
 
(40.7187159, -73.8038295)7358< 0.1%
 
(40.8303623, -73.8660215)6083< 0.1%
 
Other values (1574640)1750658073.3%
 
(Missing)624995526.2%
 
2020-09-18T12:04:00.849178image/svg+xmlMatplotlib v3.3.2, https://matplotlib.org/
Frequencies of value counts

Unique

Unique519947 ?
Unique (%)2.9%