Overview

Dataset statistics

Number of variables8
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory732.4 KiB
Average record size in memory75.0 B

Variable types

Categorical3
DateTime3
Numeric2

Dataset

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

Alerts

주소 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 카메라 번호 and 1 other fieldsHigh correlation
카메라 통과 인원 (IN) is highly overall correlated with 카메라 통과 인원 (OUT)High correlation
카메라 통과 인원 (OUT) is highly overall correlated with 카메라 통과 인원 (IN)High correlation
카메라 통과 인원 (IN) has 790 (7.9%) zerosZeros
카메라 통과 인원 (OUT) has 711 (7.1%) zerosZeros

Reproduction

Analysis started2024-03-13 18:37:18.053745
Analysis finished2024-03-13 18:37:19.215023
Duration1.16 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

카메라 번호
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2
2638 
1
2475 
3
2462 
4
2425 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3
2nd row3
3rd row4
4th row4
5th row4

Common Values

ValueCountFrequency (%)
2 2638
26.4%
1 2475
24.8%
3 2462
24.6%
4 2425
24.2%

Length

2024-03-14T03:37:19.260500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T03:37:19.334270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2 2638
26.4%
1 2475
24.8%
3 2462
24.6%
4 2425
24.2%

주소
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
계동길 69
2638 
율곡로3길 50
2475 
북촌로11길 1
2462 
북촌로5가길 38
2425 

Length

Max length9
Median length8
Mean length7.7149
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row북촌로11길 1
2nd row북촌로11길 1
3rd row북촌로5가길 38
4th row북촌로5가길 38
5th row북촌로5가길 38

Common Values

ValueCountFrequency (%)
계동길 69 2638
26.4%
율곡로3길 50 2475
24.8%
북촌로11길 1 2462
24.6%
북촌로5가길 38 2425
24.2%

Length

2024-03-14T03:37:19.430963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T03:37:19.524822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
계동길 2638
13.2%
69 2638
13.2%
율곡로3길 2475
12.4%
50 2475
12.4%
북촌로11길 2462
12.3%
1 2462
12.3%
북촌로5가길 2425
12.1%
38 2425
12.1%

상세 설명
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
계동교회 앞
2638 
덕성여고 앞
2475 
돈미약국 앞
2462 
삼청파출소 사잇길
2425 

Length

Max length9
Median length6
Mean length6.7275
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row돈미약국 앞
2nd row돈미약국 앞
3rd row삼청파출소 사잇길
4th row삼청파출소 사잇길
5th row삼청파출소 사잇길

Common Values

ValueCountFrequency (%)
계동교회 앞 2638
26.4%
덕성여고 앞 2475
24.8%
돈미약국 앞 2462
24.6%
삼청파출소 사잇길 2425
24.2%

Length

2024-03-14T03:37:19.614103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T03:37:19.693308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
앞 7575
37.9%
계동교회 2638
 
13.2%
덕성여고 2475
 
12.4%
돈미약국 2462
 
12.3%
삼청파출소 2425
 
12.1%
사잇길 2425
 
12.1%

측정 시작 시간
Date

Distinct5724
Distinct (%)57.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2017-01-24 05:50:29
Maximum2017-02-17 21:45:36
2024-03-14T03:37:19.782704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:19.878738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

측정 종료 시간
Date

Distinct5762
Distinct (%)57.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2017-01-24 05:55:30
Maximum2017-02-17 21:50:36
2024-03-14T03:37:19.973368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:20.082601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

카메라 통과 인원 (IN)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct153
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.0544
Minimum0
Maximum196
Zeros790
Zeros (%)7.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T03:37:20.202130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q14
median15
Q334
95-th percentile73
Maximum196
Range196
Interquartile range (IQR)30

Descriptive statistics

Standard deviation24.50927
Coefficient of variation (CV)1.063106
Kurtosis3.470424
Mean23.0544
Median Absolute Deviation (MAD)12
Skewness1.6726622
Sum230544
Variance600.70431
MonotonicityNot monotonic
2024-03-14T03:37:20.311120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 790
 
7.9%
2 625
 
6.2%
4 409
 
4.1%
1 377
 
3.8%
5 322
 
3.2%
3 310
 
3.1%
6 304
 
3.0%
8 256
 
2.6%
7 247
 
2.5%
11 231
 
2.3%
Other values (143) 6129
61.3%
ValueCountFrequency (%)
0 790
7.9%
1 377
3.8%
2 625
6.2%
3 310
 
3.1%
4 409
4.1%
5 322
3.2%
6 304
 
3.0%
7 247
 
2.5%
8 256
 
2.6%
9 221
 
2.2%
ValueCountFrequency (%)
196 1
< 0.1%
191 1
< 0.1%
177 1
< 0.1%
172 1
< 0.1%
168 1
< 0.1%
164 2
< 0.1%
155 1
< 0.1%
152 1
< 0.1%
150 1
< 0.1%
149 1
< 0.1%

카메라 통과 인원 (OUT)
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct150
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.7601
Minimum0
Maximum257
Zeros711
Zeros (%)7.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T03:37:20.420123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q15
median17
Q337
95-th percentile75
Maximum257
Range257
Interquartile range (IQR)32

Descriptive statistics

Standard deviation25.341096
Coefficient of variation (CV)1.023465
Kurtosis3.6829324
Mean24.7601
Median Absolute Deviation (MAD)14
Skewness1.6062611
Sum247601
Variance642.17117
MonotonicityNot monotonic
2024-03-14T03:37:20.543795image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 711
 
7.1%
2 626
 
6.3%
4 410
 
4.1%
1 375
 
3.8%
3 314
 
3.1%
6 290
 
2.9%
5 273
 
2.7%
8 233
 
2.3%
9 233
 
2.3%
7 218
 
2.2%
Other values (140) 6317
63.2%
ValueCountFrequency (%)
0 711
7.1%
1 375
3.8%
2 626
6.3%
3 314
3.1%
4 410
4.1%
5 273
 
2.7%
6 290
2.9%
7 218
 
2.2%
8 233
 
2.3%
9 233
 
2.3%
ValueCountFrequency (%)
257 1
 
< 0.1%
220 1
 
< 0.1%
202 1
 
< 0.1%
174 1
 
< 0.1%
171 1
 
< 0.1%
161 1
 
< 0.1%
152 1
 
< 0.1%
149 2
< 0.1%
148 2
< 0.1%
147 3
< 0.1%

데이터입력시간
Date

Distinct5762
Distinct (%)57.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2017-01-24 05:55:30
Maximum2017-02-17 21:50:36
2024-03-14T03:37:20.668110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:20.762046image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-03-14T03:37:18.888186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:18.709600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:18.975776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:18.805502image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T03:37:20.824400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카메라 번호주소상세 설명카메라 통과 인원 (IN)카메라 통과 인원 (OUT)
카메라 번호1.0001.0001.0000.3470.211
주소1.0001.0001.0000.3470.211
상세 설명1.0001.0001.0000.3470.211
카메라 통과 인원 (IN)0.3470.3470.3471.0000.770
카메라 통과 인원 (OUT)0.2110.2110.2110.7701.000
2024-03-14T03:37:20.907311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
주소카메라 번호상세 설명
주소1.0001.0001.000
카메라 번호1.0001.0001.000
상세 설명1.0001.0001.000
2024-03-14T03:37:20.992435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카메라 통과 인원 (IN)카메라 통과 인원 (OUT)카메라 번호주소상세 설명
카메라 통과 인원 (IN)1.0000.7610.2140.2140.214
카메라 통과 인원 (OUT)0.7611.0000.1270.1270.127
카메라 번호0.2140.1271.0001.0001.000
주소0.2140.1271.0001.0001.000
상세 설명0.2140.1271.0001.0001.000

Missing values

2024-03-14T03:37:19.068935image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T03:37:19.168116image/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

카메라 번호주소상세 설명측정 시작 시간측정 종료 시간카메라 통과 인원 (IN)카메라 통과 인원 (OUT)데이터입력시간
146293북촌로11길 1돈미약국 앞2017-02-07 20:50:302017-02-07 20:55:3012102017-02-07 20:55:30
43383북촌로11길 1돈미약국 앞2017-01-28 13:25:362017-01-28 13:30:3644502017-01-28 13:30:36
110634북촌로5가길 38삼청파출소 사잇길2017-02-04 08:35:382017-02-04 08:40:383122017-02-04 08:40:38
136444북촌로5가길 38삼청파출소 사잇길2017-02-06 21:35:292017-02-06 21:40:29522017-02-06 21:40:29
112884북촌로5가길 38삼청파출소 사잇길2017-02-04 13:20:382017-02-04 13:25:3839692017-02-04 13:25:38
186743북촌로11길 1돈미약국 앞2017-02-11 20:55:372017-02-11 21:00:3715112017-02-11 21:00:37
81014북촌로5가길 38삼청파출소 사잇길2017-02-01 10:30:332017-02-01 10:35:33862017-02-01 10:35:33
244333북촌로11길 1돈미약국 앞2017-02-17 14:25:362017-02-17 14:30:3661352017-02-17 14:30:36
174162계동길 69계동교회 앞2017-02-10 15:35:352017-02-10 15:40:3527632017-02-10 15:40:35
75774북촌로5가길 38삼청파출소 사잇길2017-01-31 20:20:322017-01-31 20:25:321042017-01-31 20:25:32
카메라 번호주소상세 설명측정 시작 시간측정 종료 시간카메라 통과 인원 (IN)카메라 통과 인원 (OUT)데이터입력시간
125523북촌로11길 1돈미약국 앞2017-02-05 19:45:402017-02-05 19:50:4011112017-02-05 19:50:40
57604북촌로5가길 38삼청파출소 사잇길2017-01-29 23:30:382017-01-29 23:35:394112017-01-29 23:35:39
213041율곡로3길 50덕성여고 앞2017-02-14 13:40:312017-02-14 13:45:3150252017-02-14 13:45:31
159882계동길 69계동교회 앞2017-02-09 06:55:322017-02-09 07:00:33622017-02-09 07:00:33
151672계동길 69계동교회 앞2017-02-08 10:50:312017-02-08 10:55:3134872017-02-08 10:55:31
5873북촌로11길 1돈미약국 앞2017-01-24 18:20:302017-01-24 18:25:3012222017-01-24 18:25:30
110344북촌로5가길 38삼청파출소 사잇길2017-02-04 08:00:382017-02-04 08:05:38102017-02-04 08:05:38
150002계동길 69계동교회 앞2017-02-08 07:20:312017-02-08 07:25:315192017-02-08 07:25:31
205253북촌로11길 1돈미약국 앞2017-02-13 19:00:302017-02-13 19:05:3023262017-02-13 19:05:30
38152계동길 69계동교회 앞2017-01-27 21:45:352017-01-27 21:50:350142017-01-27 21:50:35