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 449 (4.5%) zerosZeros
카메라 통과 인원 (OUT) has 434 (4.3%) zerosZeros

Reproduction

Analysis started2024-03-13 18:37:22.167985
Analysis finished2024-03-13 18:37:23.267752
Duration1.1 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
4
2810 
3
2802 
1
2739 
2
1649 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
4 2810
28.1%
3 2802
28.0%
1 2739
27.4%
2 1649
16.5%

Length

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

Common Values (Plot)

2024-03-14T03:37:23.388809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
4 2810
28.1%
3 2802
28.0%
1 2739
27.4%
2 1649
16.5%

주소
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
북촌로5가길 38
2810 
북촌로11길 1
2802 
율곡로3길 50
2739 
계동길 69
1649 

Length

Max length9
Median length8
Mean length7.9512
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
북촌로5가길 38 2810
28.1%
북촌로11길 1 2802
28.0%
율곡로3길 50 2739
27.4%
계동길 69 1649
16.5%

Length

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

Common Values (Plot)

2024-03-14T03:37:23.550399image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
북촌로5가길 2810
14.1%
38 2810
14.1%
북촌로11길 2802
14.0%
1 2802
14.0%
율곡로3길 2739
13.7%
50 2739
13.7%
계동길 1649
8.2%
69 1649
8.2%

상세 설명
Categorical

HIGH CORRELATION 

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

Length

Max length9
Median length6
Mean length6.843
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
삼청파출소 사잇길 2810
28.1%
돈미약국 앞 2802
28.0%
덕성여고 앞 2739
27.4%
계동교회 앞 1649
16.5%

Length

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

Common Values (Plot)

2024-03-14T03:37:23.722742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
앞 7190
35.9%
삼청파출소 2810
 
14.1%
사잇길 2810
 
14.1%
돈미약국 2802
 
14.0%
덕성여고 2739
 
13.7%
계동교회 1649
 
8.2%

측정 시작 시간
Date

Distinct8361
Distinct (%)83.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2016-01-12 11:40:19
Maximum2016-09-17 09:30:37
2024-03-14T03:37:23.813600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:23.920238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

측정 종료 시간
Date

Distinct8380
Distinct (%)83.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2016-01-12 11:50:19
Maximum2016-09-17 09:40:37
2024-03-14T03:37:24.021888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:24.121684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

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

HIGH CORRELATION  ZEROS 

Distinct291
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean53.2505
Minimum0
Maximum979
Zeros449
Zeros (%)4.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T03:37:24.225346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q18
median36
Q381
95-th percentile162
Maximum979
Range979
Interquartile range (IQR)73

Descriptive statistics

Standard deviation56.487162
Coefficient of variation (CV)1.0607818
Kurtosis11.304603
Mean53.2505
Median Absolute Deviation (MAD)31
Skewness2.0044717
Sum532505
Variance3190.7994
MonotonicityNot monotonic
2024-03-14T03:37:24.331686image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 449
 
4.5%
2 387
 
3.9%
4 300
 
3.0%
3 291
 
2.9%
1 265
 
2.6%
5 264
 
2.6%
6 208
 
2.1%
8 180
 
1.8%
9 173
 
1.7%
7 168
 
1.7%
Other values (281) 7315
73.2%
ValueCountFrequency (%)
0 449
4.5%
1 265
2.6%
2 387
3.9%
3 291
2.9%
4 300
3.0%
5 264
2.6%
6 208
2.1%
7 168
 
1.7%
8 180
1.8%
9 173
 
1.7%
ValueCountFrequency (%)
979 1
< 0.1%
639 1
< 0.1%
517 1
< 0.1%
485 1
< 0.1%
428 1
< 0.1%
406 1
< 0.1%
398 1
< 0.1%
393 1
< 0.1%
383 1
< 0.1%
379 1
< 0.1%

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

HIGH CORRELATION  ZEROS 

Distinct332
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean56.4297
Minimum0
Maximum957
Zeros434
Zeros (%)4.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T03:37:24.519479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q18
median37
Q386
95-th percentile177
Maximum957
Range957
Interquartile range (IQR)78

Descriptive statistics

Standard deviation61.781845
Coefficient of variation (CV)1.0948462
Kurtosis9.0615852
Mean56.4297
Median Absolute Deviation (MAD)33
Skewness2.0225829
Sum564297
Variance3816.9964
MonotonicityNot monotonic
2024-03-14T03:37:24.646365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 434
 
4.3%
2 417
 
4.2%
4 315
 
3.1%
1 297
 
3.0%
3 277
 
2.8%
5 242
 
2.4%
6 211
 
2.1%
7 199
 
2.0%
8 176
 
1.8%
9 168
 
1.7%
Other values (322) 7264
72.6%
ValueCountFrequency (%)
0 434
4.3%
1 297
3.0%
2 417
4.2%
3 277
2.8%
4 315
3.1%
5 242
2.4%
6 211
2.1%
7 199
2.0%
8 176
1.8%
9 168
 
1.7%
ValueCountFrequency (%)
957 1
< 0.1%
650 1
< 0.1%
501 1
< 0.1%
468 1
< 0.1%
466 1
< 0.1%
449 2
< 0.1%
441 1
< 0.1%
436 1
< 0.1%
428 1
< 0.1%
411 1
< 0.1%

데이터입력시간
Date

Distinct8380
Distinct (%)83.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2016-01-12 11:50:19
Maximum2016-09-17 09:40:37
2024-03-14T03:37:24.750504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:24.851264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-03-14T03:37:22.951367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:22.525384image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:23.020733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:22.597875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T03:37:24.941312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카메라 번호주소상세 설명카메라 통과 인원 (IN)카메라 통과 인원 (OUT)
카메라 번호1.0001.0001.0000.2740.197
주소1.0001.0001.0000.2740.197
상세 설명1.0001.0001.0000.2740.197
카메라 통과 인원 (IN)0.2740.2740.2741.0000.936
카메라 통과 인원 (OUT)0.1970.1970.1970.9361.000
2024-03-14T03:37:25.040353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
주소카메라 번호상세 설명
주소1.0001.0001.000
카메라 번호1.0001.0001.000
상세 설명1.0001.0001.000
2024-03-14T03:37:25.114440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카메라 통과 인원 (IN)카메라 통과 인원 (OUT)카메라 번호주소상세 설명
카메라 통과 인원 (IN)1.0000.8590.1260.1260.126
카메라 통과 인원 (OUT)0.8591.0000.0900.0900.090
카메라 번호0.1260.0901.0001.0001.000
주소0.1260.0901.0001.0001.000
상세 설명0.1260.0901.0001.0001.000

Missing values

2024-03-14T03:37:23.117194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T03:37:23.219775image/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)데이터입력시간
579054북촌로5가길 38삼청파출소 사잇길2016-07-04 06:30:272016-07-04 06:40:271112016-07-04 06:40:27
50964북촌로5가길 38삼청파출소 사잇길2016-01-25 09:10:292016-01-25 09:20:2913282016-01-25 09:20:29
29474북촌로5가길 38삼청파출소 사잇길2016-01-19 18:30:322016-01-19 18:40:3228242016-01-19 18:40:32
438383북촌로11길 1돈미약국 앞2016-06-08 21:40:332016-06-08 21:50:339212016-06-08 21:50:33
96443북촌로11길 1돈미약국 앞2016-02-06 04:10:362016-02-06 04:20:36042016-02-06 04:20:36
88631율곡로3길 50덕성여고 앞2016-02-04 06:10:332016-02-04 06:20:331112016-02-04 06:20:33
299612계동길 69계동교회 앞2016-05-14 21:30:362016-05-14 21:40:3627342016-05-14 21:40:36
46733북촌로11길 1돈미약국 앞2016-01-24 07:30:402016-01-24 07:40:40832016-01-24 07:40:40
317613북촌로11길 1돈미약국 앞2016-05-18 04:40:302016-05-18 04:50:30022016-05-18 04:50:30
374074북촌로5가길 38삼청파출소 사잇길2016-05-28 07:10:342016-05-28 07:20:34972016-05-28 07:20:34
카메라 번호주소상세 설명측정 시작 시간측정 종료 시간카메라 통과 인원 (IN)카메라 통과 인원 (OUT)데이터입력시간
498574북촌로5가길 38삼청파출소 사잇길2016-06-19 18:10:382016-06-19 18:20:381531842016-06-19 18:20:38
596681율곡로3길 50덕성여고 앞2016-07-07 11:20:322016-07-07 11:30:3288402016-07-07 11:30:32
455013북촌로11길 1돈미약국 앞2016-06-11 21:20:382016-06-11 21:30:3838442016-06-11 21:30:38
462643북촌로11길 1돈미약국 앞2016-06-13 07:00:282016-06-13 07:10:287132016-06-13 07:10:28
570621율곡로3길 50덕성여고 앞2016-07-02 17:50:382016-07-02 18:00:381662382016-07-02 18:00:38
676722계동길 69계동교회 앞2016-09-11 18:00:392016-09-11 18:10:3940412016-09-11 18:10:39
221433북촌로11길 1돈미약국 앞2016-03-08 06:50:282016-03-08 07:00:2820162016-03-08 07:00:28
182333북촌로11길 1돈미약국 앞2016-02-27 13:00:362016-02-27 13:10:36117742016-02-27 13:10:36
165861율곡로3길 50덕성여고 앞2016-02-23 11:30:302016-02-23 11:40:3081182016-02-23 11:40:30
317324북촌로5가길 38삼청파출소 사잇길2016-05-18 03:10:302016-05-18 03:20:30202016-05-18 03:20:30