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
데이터입력시간 has unique valuesUnique

Reproduction

Analysis started2024-03-13 18:37:14.411814
Analysis finished2024-03-13 18:37:15.280160
Duration0.87 seconds
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
1
2977 
3
2953 
4
2918 
2
1152 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 2977
29.8%
3 2953
29.5%
4 2918
29.2%
2 1152
 
11.5%

Length

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

Common Values (Plot)

2024-03-14T03:37:15.399149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 2977
29.8%
3 2953
29.5%
4 2918
29.2%
2 1152
 
11.5%

주소
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
율곡로3길 50
2977 
북촌로11길 1
2953 
북촌로5가길 38
2918 
계동길 69
1152 

Length

Max length9
Median length8
Mean length8.0614
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row율곡로3길 50
2nd row계동길 69
3rd row계동길 69
4th row북촌로5가길 38
5th row북촌로11길 1

Common Values

ValueCountFrequency (%)
율곡로3길 50 2977
29.8%
북촌로11길 1 2953
29.5%
북촌로5가길 38 2918
29.2%
계동길 69 1152
 
11.5%

Length

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

Common Values (Plot)

2024-03-14T03:37:15.560161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
율곡로3길 2977
14.9%
50 2977
14.9%
북촌로11길 2953
14.8%
1 2953
14.8%
북촌로5가길 2918
14.6%
38 2918
14.6%
계동길 1152
 
5.8%
69 1152
 
5.8%

상세 설명
Categorical

HIGH CORRELATION 

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

Length

Max length9
Median length6
Mean length6.8754
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row덕성여고 앞
2nd row계동교회 앞
3rd row계동교회 앞
4th row삼청파출소 사잇길
5th row돈미약국 앞

Common Values

ValueCountFrequency (%)
덕성여고 앞 2977
29.8%
돈미약국 앞 2953
29.5%
삼청파출소 사잇길 2918
29.2%
계동교회 앞 1152
 
11.5%

Length

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

Common Values (Plot)

2024-03-14T03:37:15.744743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
앞 7082
35.4%
덕성여고 2977
14.9%
돈미약국 2953
14.8%
삼청파출소 2918
14.6%
사잇길 2918
14.6%
계동교회 1152
 
5.8%

측정 시작 시간
Date

Distinct7715
Distinct (%)77.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2018-03-23 10:11:21
Maximum2018-06-29 09:20:37
2024-03-14T03:37:15.861946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:15.965993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

측정 종료 시간
Date

Distinct7736
Distinct (%)77.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2018-03-23 10:21:21
Maximum2018-06-29 09:30:37
2024-03-14T03:37:16.063048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:16.187376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

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

HIGH CORRELATION 

Distinct8590
Distinct (%)85.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22045.761
Minimum0
Maximum68621
Zeros5
Zeros (%)< 0.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T03:37:16.297893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile900
Q19022.75
median19373
Q332291
95-th percentile52569.3
Maximum68621
Range68621
Interquartile range (IQR)23268.25

Descriptive statistics

Standard deviation15764.921
Coefficient of variation (CV)0.71509987
Kurtosis-0.33797548
Mean22045.761
Median Absolute Deviation (MAD)11387.5
Skewness0.63817679
Sum2.2045761 × 108
Variance2.4853272 × 108
MonotonicityNot monotonic
2024-03-14T03:37:16.401905image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
900 177
 
1.8%
11486 109
 
1.1%
32 7
 
0.1%
23 7
 
0.1%
12 6
 
0.1%
14 6
 
0.1%
49 6
 
0.1%
4 6
 
0.1%
19 5
 
0.1%
0 5
 
0.1%
Other values (8580) 9666
96.7%
ValueCountFrequency (%)
0 5
0.1%
1 3
< 0.1%
2 1
 
< 0.1%
3 5
0.1%
4 6
0.1%
5 3
< 0.1%
6 5
0.1%
7 5
0.1%
8 4
< 0.1%
9 3
< 0.1%
ValueCountFrequency (%)
68621 1
< 0.1%
68616 2
< 0.1%
68561 1
< 0.1%
68523 1
< 0.1%
68480 1
< 0.1%
68011 1
< 0.1%
67809 1
< 0.1%
66695 1
< 0.1%
66688 1
< 0.1%
66679 1
< 0.1%

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

HIGH CORRELATION 

Distinct8473
Distinct (%)84.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21657.836
Minimum0
Maximum67907
Zeros10
Zeros (%)0.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-14T03:37:16.504176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile789
Q19306.5
median19514
Q332264.5
95-th percentile48101.55
Maximum67907
Range67907
Interquartile range (IQR)22958

Descriptive statistics

Standard deviation14955.046
Coefficient of variation (CV)0.69051431
Kurtosis-0.56506796
Mean21657.836
Median Absolute Deviation (MAD)11165.5
Skewness0.50104996
Sum2.1657836 × 108
Variance2.236534 × 108
MonotonicityNot monotonic
2024-03-14T03:37:16.609127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
789 177
 
1.8%
14180 109
 
1.1%
0 10
 
0.1%
1 8
 
0.1%
2 6
 
0.1%
48 5
 
0.1%
7 5
 
0.1%
12 5
 
0.1%
38742 5
 
0.1%
8 5
 
0.1%
Other values (8463) 9665
96.7%
ValueCountFrequency (%)
0 10
0.1%
1 8
0.1%
2 6
0.1%
3 4
 
< 0.1%
4 4
 
< 0.1%
5 5
0.1%
6 3
 
< 0.1%
7 5
0.1%
8 5
0.1%
9 3
 
< 0.1%
ValueCountFrequency (%)
67907 3
< 0.1%
67896 1
 
< 0.1%
67875 1
 
< 0.1%
67789 1
 
< 0.1%
66347 1
 
< 0.1%
65983 1
 
< 0.1%
63764 1
 
< 0.1%
62889 2
< 0.1%
62883 1
 
< 0.1%
62871 1
 
< 0.1%

데이터입력시간
Date

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2018-03-23 10:21:21.597708
Maximum2018-06-29 09:30:37.397690
2024-03-14T03:37:16.713938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:16.812483image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-03-14T03:37:14.942380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:14.776523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:15.023432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T03:37:14.857636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T03:37:16.875867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카메라 번호주소상세 설명카메라 통과 인원 (IN)카메라 통과 인원 (OUT)
카메라 번호1.0001.0001.0000.4280.326
주소1.0001.0001.0000.4280.326
상세 설명1.0001.0001.0000.4280.326
카메라 통과 인원 (IN)0.4280.4280.4281.0000.951
카메라 통과 인원 (OUT)0.3260.3260.3260.9511.000
2024-03-14T03:37:16.950440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
주소카메라 번호상세 설명
주소1.0001.0001.000
카메라 번호1.0001.0001.000
상세 설명1.0001.0001.000
2024-03-14T03:37:17.031162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
카메라 통과 인원 (IN)카메라 통과 인원 (OUT)카메라 번호주소상세 설명
카메라 통과 인원 (IN)1.0000.9670.2690.2690.269
카메라 통과 인원 (OUT)0.9671.0000.2000.2000.200
카메라 번호0.2690.2001.0001.0001.000
주소0.2690.2001.0001.0001.000
상세 설명0.2690.2001.0001.0001.000

Missing values

2024-03-14T03:37:15.132029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T03:37:15.231825image/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)데이터입력시간
292431율곡로3길 50덕성여고 앞2018-05-17 18:50:362018-05-17 19:00:3629794237792018-05-17 19:00:36.491558
203422계동길 69계동교회 앞2018-04-27 21:10:372018-04-27 21:20:379007892018-04-27 21:20:37.967517
179422계동길 69계동교회 앞2018-04-23 16:10:312018-04-23 16:20:319007892018-04-23 16:20:31.274404
285724북촌로5가길 38삼청파출소 사잇길2018-05-16 05:40:342018-05-16 05:50:348635107892018-05-16 05:50:34.013494
172473북촌로11길 1돈미약국 앞2018-04-22 11:00:402018-04-22 11:10:4043493387432018-04-22 11:10:40.708468
143764북촌로5가길 38삼청파출소 사잇길2018-04-17 11:20:322018-04-17 11:30:32561772482018-04-17 11:30:32.743662
420733북촌로11길 1돈미약국 앞2018-06-17 08:20:392018-06-17 08:30:3941784349252018-06-17 08:30:39.336551
152502계동길 69계동교회 앞2018-04-18 23:50:352018-04-19 00:00:3517172210792018-04-19 00:00:35.15945
171844북촌로5가길 38삼청파출소 사잇길2018-04-22 08:20:402018-04-22 08:30:4034500418252018-04-22 08:30:40.627375
59904북촌로5가길 38삼청파출소 사잇길2018-04-02 21:10:302018-04-02 21:20:30480661312018-04-02 21:20:30.543752
카메라 번호주소상세 설명측정 시작 시간측정 종료 시간카메라 통과 인원 (IN)카메라 통과 인원 (OUT)데이터입력시간
332313북촌로11길 1돈미약국 앞2018-05-27 20:30:402018-05-27 20:40:4048621425182018-05-27 20:40:40.370213
445933북촌로11길 1돈미약국 앞2018-06-23 04:40:382018-06-23 04:50:3830881271062018-06-23 04:50:38.514664
426001율곡로3길 50덕성여고 앞2018-06-18 13:50:312018-06-18 14:00:31375315882018-06-18 14:00:31.168749
284953북촌로11길 1돈미약국 앞2018-05-16 01:20:332018-05-16 01:30:3312293104572018-05-16 01:30:33.733209
101344북촌로5가길 38삼청파출소 사잇길2018-04-10 02:20:322018-04-10 02:30:32452155022018-04-10 02:30:32.493253
107402계동길 69계동교회 앞2018-04-11 03:30:342018-04-11 03:40:3410122136882018-04-11 03:40:34.168372
363214북촌로5가길 38삼청파출소 사잇길2018-06-04 00:20:392018-06-04 00:30:3936229445862018-06-04 00:30:39.825768
152724북촌로5가길 38삼청파출소 사잇길2018-04-19 00:40:352018-04-19 00:50:3514937182202018-04-19 00:50:35.235045
316974북촌로5가길 38삼청파출소 사잇길2018-05-24 07:10:342018-05-24 07:20:34294733362018-05-24 07:20:34.717055
381791율곡로3길 50덕성여고 앞2018-06-08 07:50:342018-06-08 08:00:3436287306752018-06-08 08:00:34.766427