Overview

Dataset statistics

Number of variables8
Number of observations126
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.6 KiB
Average record size in memory70.0 B

Variable types

Categorical5
Numeric3

Dataset

Description파일 다운로드
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-15980/S/1/datasetView.do

Alerts

기관 명 has constant value ""Constant
모델명 has constant value ""Constant
시리얼 is highly overall correlated with 주차면수 and 2 other fieldsHigh correlation
총주차면수 is highly overall correlated with 주차면수 and 2 other fieldsHigh correlation
데이터요청일시 is highly overall correlated with 등록일자High correlation
주차면수 is highly overall correlated with 시리얼 and 1 other fieldsHigh correlation
빈주차면수 is highly overall correlated with 시리얼 and 1 other fieldsHigh correlation
등록일자 is highly overall correlated with 데이터요청일시High correlation

Reproduction

Analysis started2024-05-18 03:15:27.896223
Analysis finished2024-05-18 03:15:31.056055
Duration3.16 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기관 명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
마포구
126 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row마포구
2nd row마포구
3rd row마포구
4th row마포구
5th row마포구

Common Values

ValueCountFrequency (%)
마포구 126
100.0%

Length

2024-05-18T12:15:31.207547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T12:15:31.393292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
마포구 126
100.0%

모델명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
PARKING-SENSOR
126 

Length

Max length14
Median length14
Mean length14
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowPARKING-SENSOR
2nd rowPARKING-SENSOR
3rd rowPARKING-SENSOR
4th rowPARKING-SENSOR
5th rowPARKING-SENSOR

Common Values

ValueCountFrequency (%)
PARKING-SENSOR 126
100.0%

Length

2024-05-18T12:15:31.696190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T12:15:31.936477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
parking-sensor 126
100.0%

시리얼
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
111467200001
42 
111467200000
42 
111467200002
42 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row111467200001
2nd row111467200000
3rd row111467200002
4th row111467200002
5th row111467200001

Common Values

ValueCountFrequency (%)
111467200001 42
33.3%
111467200000 42
33.3%
111467200002 42
33.3%

Length

2024-05-18T12:15:32.247307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T12:15:32.559981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
111467200001 42
33.3%
111467200000 42
33.3%
111467200002 42
33.3%

데이터요청일시
Real number (ℝ)

HIGH CORRELATION 

Distinct42
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.0240206 × 109
Minimum2.0240205 × 109
Maximum2.0240207 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2024-05-18T12:15:32.912695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2.0240205 × 109
5-th percentile2.0240205 × 109
Q12.0240205 × 109
median2.0240206 × 109
Q32.0240207 × 109
95-th percentile2.0240207 × 109
Maximum2.0240207 × 109
Range213
Interquartile range (IQR)193

Descriptive statistics

Standard deviation82.075453
Coefficient of variation (CV)4.05507 × 10-8
Kurtosis-1.5045208
Mean2.0240206 × 109
Median Absolute Deviation (MAD)96.5
Skewness0
Sum2.550266 × 1011
Variance6736.38
MonotonicityIncreasing
2024-05-18T12:15:33.268829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
2024020509 3
 
2.4%
2024020713 3
 
2.4%
2024020619 3
 
2.4%
2024020620 3
 
2.4%
2024020621 3
 
2.4%
2024020622 3
 
2.4%
2024020709 3
 
2.4%
2024020710 3
 
2.4%
2024020711 3
 
2.4%
2024020712 3
 
2.4%
Other values (32) 96
76.2%
ValueCountFrequency (%)
2024020509 3
2.4%
2024020510 3
2.4%
2024020511 3
2.4%
2024020512 3
2.4%
2024020513 3
2.4%
2024020514 3
2.4%
2024020515 3
2.4%
2024020516 3
2.4%
2024020517 3
2.4%
2024020518 3
2.4%
ValueCountFrequency (%)
2024020722 3
2.4%
2024020721 3
2.4%
2024020720 3
2.4%
2024020719 3
2.4%
2024020718 3
2.4%
2024020717 3
2.4%
2024020716 3
2.4%
2024020715 3
2.4%
2024020714 3
2.4%
2024020713 3
2.4%

총주차면수
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
102
42 
38
42 
52
42 

Length

Max length3
Median length2
Mean length2.3333333
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row102
2nd row38
3rd row52
4th row52
5th row102

Common Values

ValueCountFrequency (%)
102 42
33.3%
38 42
33.3%
52 42
33.3%

Length

2024-05-18T12:15:33.599759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-18T12:15:33.881464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
102 42
33.3%
38 42
33.3%
52 42
33.3%

주차면수
Real number (ℝ)

HIGH CORRELATION 

Distinct41
Distinct (%)32.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26.047619
Minimum9
Maximum62
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2024-05-18T12:15:34.169721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9
5-th percentile14
Q114
median20.5
Q335.75
95-th percentile50.75
Maximum62
Range53
Interquartile range (IQR)21.75

Descriptive statistics

Standard deviation13.120279
Coefficient of variation (CV)0.50370357
Kurtosis-0.75044693
Mean26.047619
Median Absolute Deviation (MAD)6.5
Skewness0.67763442
Sum3282
Variance172.14171
MonotonicityNot monotonic
2024-05-18T12:15:34.578637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)
ValueCountFrequency (%)
14 44
34.9%
33 6
 
4.8%
20 5
 
4.0%
19 5
 
4.0%
31 4
 
3.2%
35 4
 
3.2%
25 3
 
2.4%
42 3
 
2.4%
28 3
 
2.4%
15 3
 
2.4%
Other values (31) 46
36.5%
ValueCountFrequency (%)
9 1
 
0.8%
10 1
 
0.8%
12 1
 
0.8%
14 44
34.9%
15 3
 
2.4%
16 3
 
2.4%
19 5
 
4.0%
20 5
 
4.0%
21 2
 
1.6%
22 1
 
0.8%
ValueCountFrequency (%)
62 1
0.8%
54 1
0.8%
53 2
1.6%
52 1
0.8%
51 2
1.6%
50 1
0.8%
49 1
0.8%
48 1
0.8%
47 2
1.6%
46 2
1.6%

빈주차면수
Real number (ℝ)

HIGH CORRELATION 

Distinct52
Distinct (%)41.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.952381
Minimum6
Maximum86
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.2 KiB
2024-05-18T12:15:34.970989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum6
5-th percentile12.25
Q124
median24
Q354.75
95-th percentile80.25
Maximum86
Range80
Interquartile range (IQR)30.75

Descriptive statistics

Standard deviation21.584757
Coefficient of variation (CV)0.56873261
Kurtosis-0.72907136
Mean37.952381
Median Absolute Deviation (MAD)9.5
Skewness0.75544613
Sum4782
Variance465.90171
MonotonicityNot monotonic
2024-05-18T12:15:35.409115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
24 44
34.9%
19 4
 
3.2%
33 3
 
2.4%
82 3
 
2.4%
37 3
 
2.4%
17 2
 
1.6%
6 2
 
1.6%
49 2
 
1.6%
13 2
 
1.6%
73 2
 
1.6%
Other values (42) 59
46.8%
ValueCountFrequency (%)
6 2
1.6%
9 1
 
0.8%
10 1
 
0.8%
11 1
 
0.8%
12 2
1.6%
13 2
1.6%
14 2
1.6%
17 2
1.6%
18 1
 
0.8%
19 4
3.2%
ValueCountFrequency (%)
86 1
 
0.8%
83 2
1.6%
82 3
2.4%
81 1
 
0.8%
78 1
 
0.8%
77 1
 
0.8%
75 1
 
0.8%
74 1
 
0.8%
73 2
1.6%
72 1
 
0.8%

등록일자
Categorical

HIGH CORRELATION 

Distinct50
Distinct (%)39.7%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2024-02-05 08:58:26
 
3
2024-02-05 13:58:26
 
3
2024-02-06 12:58:30
 
3
2024-02-06 14:58:30
 
3
2024-02-05 16:58:32
 
3
Other values (45)
111 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique8 ?
Unique (%)6.3%

Sample

1st row2024-02-05 08:58:26
2nd row2024-02-05 08:58:26
3rd row2024-02-05 08:58:26
4th row2024-02-05 09:58:33
5th row2024-02-05 09:58:33

Common Values

ValueCountFrequency (%)
2024-02-05 08:58:26 3
 
2.4%
2024-02-05 13:58:26 3
 
2.4%
2024-02-06 12:58:30 3
 
2.4%
2024-02-06 14:58:30 3
 
2.4%
2024-02-05 16:58:32 3
 
2.4%
2024-02-05 20:58:32 3
 
2.4%
2024-02-05 10:58:26 3
 
2.4%
2024-02-07 09:58:22 3
 
2.4%
2024-02-05 14:58:33 3
 
2.4%
2024-02-07 19:58:21 3
 
2.4%
Other values (40) 96
76.2%

Length

2024-05-18T12:15:35.906308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2024-02-05 42
 
16.7%
2024-02-06 42
 
16.7%
2024-02-07 42
 
16.7%
20:58:23 3
 
1.2%
21:58:23 3
 
1.2%
17:58:21 3
 
1.2%
09:58:33 3
 
1.2%
15:58:30 3
 
1.2%
08:58:26 3
 
1.2%
17:58:23 3
 
1.2%
Other values (43) 105
41.7%

Interactions

2024-05-18T12:15:29.580212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:15:28.305880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:15:28.851966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:15:29.825717image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:15:28.520025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:15:29.085682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:15:30.079497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:15:28.676666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-18T12:15:29.319391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-18T12:15:36.136595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼데이터요청일시총주차면수주차면수빈주차면수등록일자
시리얼1.0000.0001.0000.7990.9430.000
데이터요청일시0.0001.0000.0000.0000.1971.000
총주차면수1.0000.0001.0000.7990.9430.000
주차면수0.7990.0000.7991.0000.9550.639
빈주차면수0.9430.1970.9430.9551.0000.000
등록일자0.0001.0000.0000.6390.0001.000
2024-05-18T12:15:36.404889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시리얼등록일자총주차면수
시리얼1.0000.0001.000
등록일자0.0001.0000.000
총주차면수1.0000.0001.000
2024-05-18T12:15:36.656313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
데이터요청일시주차면수빈주차면수시리얼총주차면수등록일자
데이터요청일시1.0000.033-0.0430.0000.0000.789
주차면수0.0331.0000.1920.6700.6700.202
빈주차면수-0.0430.1921.0000.8930.8930.000
시리얼0.0000.6700.8931.0001.0000.000
총주차면수0.0000.6700.8931.0001.0000.000
등록일자0.7890.2020.0000.0000.0001.000

Missing values

2024-05-18T12:15:30.487538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-18T12:15:30.902235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

기관 명모델명시리얼데이터요청일시총주차면수주차면수빈주차면수등록일자
0마포구PARKING-SENSOR111467200001202402050910231712024-02-05 08:58:26
1마포구PARKING-SENSOR11146720000020240205093814242024-02-05 08:58:26
2마포구PARKING-SENSOR11146720000220240205095216362024-02-05 08:58:26
3마포구PARKING-SENSOR11146720000220240205105220322024-02-05 09:58:33
4마포구PARKING-SENSOR111467200001202402051010228742024-02-05 09:58:33
5마포구PARKING-SENSOR11146720000020240205103814242024-02-05 09:58:33
6마포구PARKING-SENSOR11146720000020240205113814242024-02-05 10:58:26
7마포구PARKING-SENSOR111467200001202402051110231712024-02-05 10:58:26
8마포구PARKING-SENSOR11146720000220240205115225272024-02-05 10:58:26
9마포구PARKING-SENSOR11146720000020240205123814242024-02-05 11:58:26
기관 명모델명시리얼데이터요청일시총주차면수주차면수빈주차면수등록일자
116마포구PARKING-SENSOR11146720000220240207195221312024-02-07 18:58:21
117마포구PARKING-SENSOR11146720000020240207203814242024-02-07 19:58:21
118마포구PARKING-SENSOR111467200001202402072010224782024-02-07 19:58:21
119마포구PARKING-SENSOR11146720000220240207205215372024-02-07 19:58:21
120마포구PARKING-SENSOR11146720000020240207213814242024-02-07 20:58:21
121마포구PARKING-SENSOR111467200001202402072110219832024-02-07 20:58:21
122마포구PARKING-SENSOR11146720000220240207215216362024-02-07 20:58:21
123마포구PARKING-SENSOR111467200001202402072210216862024-02-07 21:58:27
124마포구PARKING-SENSOR11146720000020240207223814242024-02-07 21:58:27
125마포구PARKING-SENSOR11146720000220240207225212402024-02-07 21:58:27