Overview

Dataset statistics

Number of variables5
Number of observations2738
Missing cells0
Missing cells (%)0.0%
Duplicate rows628
Duplicate rows (%)22.9%
Total size in memory117.8 KiB
Average record size in memory44.0 B

Variable types

Categorical2
Numeric3

Dataset

Description서울특별시 서대문구 CCTV 위치별 조도, 휘도 데이터를 제공합니다. 날짜, 시간, 위도, 경도, 조도 데이터를 제공하고 있습니다.
Author서울특별시 서대문구
URLhttps://www.data.go.kr/data/15109208/fileData.do

Alerts

날짜 has constant value ""Constant
시간 has constant value ""Constant
Dataset has 628 (22.9%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 09:32:51.371756
Analysis finished2023-12-12 09:32:52.960474
Duration1.59 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

날짜
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size21.5 KiB
20220926
2738 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row20220926
2nd row20220926
3rd row20220926
4th row20220926
5th row20220926

Common Values

ValueCountFrequency (%)
20220926 2738
100.0%

Length

2023-12-12T18:32:53.049730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:32:53.166650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20220926 2738
100.0%

시간
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size21.5 KiB
20:17
2738 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row20:17
2nd row20:17
3rd row20:17
4th row20:17
5th row20:17

Common Values

ValueCountFrequency (%)
20:17 2738
100.0%

Length

2023-12-12T18:32:53.290167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:32:53.406881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20:17 2738
100.0%

위도
Real number (ℝ)

Distinct804
Distinct (%)29.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.577165
Minimum37.555796
Maximum37.6058
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size24.2 KiB
2023-12-12T18:32:53.545115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.555796
5-th percentile37.557857
Q137.567329
median37.578182
Q337.58532
95-th percentile37.598233
Maximum37.6058
Range0.05000432
Interquartile range (IQR)0.01799137

Descriptive statistics

Standard deviation0.012287576
Coefficient of variation (CV)0.00032699582
Kurtosis-0.83048595
Mean37.577165
Median Absolute Deviation (MAD)0.00875089
Skewness0.067341773
Sum102886.28
Variance0.00015098452
MonotonicityNot monotonic
2023-12-12T18:32:53.743878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.57890074 28
 
1.0%
37.56185447 20
 
0.7%
37.55723615 16
 
0.6%
37.58537284 14
 
0.5%
37.574108 12
 
0.4%
37.58438976 12
 
0.4%
37.5581842 11
 
0.4%
37.59477112 10
 
0.4%
37.56788241 10
 
0.4%
37.580063 10
 
0.4%
Other values (794) 2595
94.8%
ValueCountFrequency (%)
37.55579603 1
 
< 0.1%
37.55598695 4
0.1%
37.556147 1
 
< 0.1%
37.55630715 4
0.1%
37.5566748 1
 
< 0.1%
37.55687376 2
 
0.1%
37.55693278 8
0.3%
37.5569452 5
0.2%
37.55695796 4
0.1%
37.55704283 6
0.2%
ValueCountFrequency (%)
37.60580035 2
 
0.1%
37.605378 3
0.1%
37.60523087 4
0.1%
37.60381265 4
0.1%
37.60346911 1
 
< 0.1%
37.60334171 3
0.1%
37.60307318 1
 
< 0.1%
37.603019 4
0.1%
37.60262693 3
0.1%
37.60238579 5
0.2%

경도
Real number (ℝ)

Distinct801
Distinct (%)29.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.93562
Minimum126.90346
Maximum126.96691
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size24.2 KiB
2023-12-12T18:32:53.959112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum126.90346
5-th percentile126.91083
Q1126.92425
median126.93514
Q3126.94728
95-th percentile126.96014
Maximum126.96691
Range0.0634455
Interquartile range (IQR)0.023028

Descriptive statistics

Standard deviation0.014905667
Coefficient of variation (CV)0.00011742698
Kurtosis-0.83568052
Mean126.93562
Median Absolute Deviation (MAD)0.0115754
Skewness-0.069119564
Sum347549.73
Variance0.0002221789
MonotonicityNot monotonic
2023-12-12T18:32:54.136322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
126.9177559 28
 
1.0%
126.954875 20
 
0.7%
126.9328742 16
 
0.6%
126.9389115 14
 
0.5%
126.9439175 12
 
0.4%
126.918545 12
 
0.4%
126.952262 11
 
0.4%
126.919415 10
 
0.4%
126.9429481 10
 
0.4%
126.9468728 10
 
0.4%
Other values (791) 2595
94.8%
ValueCountFrequency (%)
126.90346 1
 
< 0.1%
126.9038642 4
0.1%
126.9047879 2
 
0.1%
126.9049853 2
 
0.1%
126.905255 4
0.1%
126.905281 5
0.2%
126.9054524 4
0.1%
126.905502 3
0.1%
126.9059805 4
0.1%
126.90628 4
0.1%
ValueCountFrequency (%)
126.9669055 3
0.1%
126.9667707 4
0.1%
126.9661652 2
 
0.1%
126.9659613 3
0.1%
126.965737 5
0.2%
126.965155 7
0.3%
126.965138 3
0.1%
126.9644372 5
0.2%
126.9643946 3
0.1%
126.9643682 4
0.1%

조도
Real number (ℝ)

Distinct339
Distinct (%)12.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34.774543
Minimum0.1
Maximum132.9
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size24.2 KiB
2023-12-12T18:32:54.295337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.1
5-th percentile12.3
Q123.2
median31.2
Q343.5
95-th percentile68.5
Maximum132.9
Range132.8
Interquartile range (IQR)20.3

Descriptive statistics

Standard deviation17.683843
Coefficient of variation (CV)0.5085284
Kurtosis2.4516979
Mean34.774543
Median Absolute Deviation (MAD)10
Skewness1.1437458
Sum95212.7
Variance312.7183
MonotonicityNot monotonic
2023-12-12T18:32:54.479763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20.9 41
 
1.5%
16.4 34
 
1.2%
31.1 32
 
1.2%
13.5 31
 
1.1%
32.2 29
 
1.1%
32.6 28
 
1.0%
30.0 27
 
1.0%
25.8 26
 
0.9%
28.7 26
 
0.9%
21.2 25
 
0.9%
Other values (329) 2439
89.1%
ValueCountFrequency (%)
0.1 4
 
0.1%
1.4 3
 
0.1%
2.8 22
0.8%
3.9 3
 
0.1%
4.2 6
 
0.2%
4.4 4
 
0.1%
4.8 4
 
0.1%
5.3 3
 
0.1%
5.7 2
 
0.1%
5.8 4
 
0.1%
ValueCountFrequency (%)
132.9 4
 
0.1%
127.4 3
 
0.1%
96.3 8
0.3%
94.0 4
 
0.1%
93.0 3
 
0.1%
90.0 14
0.5%
83.8 3
 
0.1%
81.6 5
 
0.2%
81.3 8
0.3%
80.7 4
 
0.1%

Interactions

2023-12-12T18:32:52.338509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:32:51.567973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:32:51.922251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:32:52.485041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:32:51.685360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:32:52.066394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:32:52.612940image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:32:51.812501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:32:52.195016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:32:54.595258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도조도
위도1.0000.7970.420
경도0.7971.0000.407
조도0.4200.4071.000
2023-12-12T18:32:54.692485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도조도
위도1.000-0.0450.003
경도-0.0451.0000.211
조도0.0030.2111.000

Missing values

2023-12-12T18:32:52.774411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:32:52.909147image/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

날짜시간위도경도조도
02022092620:1737.580063126.91941513.5
12022092620:1737.580063126.91941513.5
22022092620:1737.580063126.91941513.5
32022092620:1737.580063126.91941513.5
42022092620:1737.580063126.91941513.5
52022092620:1737.580063126.91941513.5
62022092620:1737.580063126.91941513.5
72022092620:1737.580063126.91941513.5
82022092620:1737.580063126.91941513.5
92022092620:1737.580063126.91941513.5
날짜시간위도경도조도
27282022092620:1737.597585126.95620350.9
27292022092620:1737.597585126.95620350.9
27302022092620:1737.597585126.95620350.9
27312022092620:1737.597585126.95620350.9
27322022092620:1737.597203126.95608150.9
27332022092620:1737.57815126.92391835.4
27342022092620:1737.57815126.92391835.4
27352022092620:1737.57815126.92391835.4
27362022092620:1737.57815126.92391835.4
27372022092620:1737.57815126.92391835.4

Duplicate rows

Most frequently occurring

날짜시간위도경도조도# duplicates
3232022092620:1737.578901126.91775616.428
932022092620:1737.561854126.95487521.220
72022092620:1737.557236126.93287419.616
4662022092620:1737.585373126.9389122.814
2372022092620:1737.574108126.91854521.612
4462022092620:1737.58439126.94391720.912
362022092620:1737.558184126.95226229.311
1602022092620:1737.567882126.94687325.810
3512022092620:1737.580063126.91941513.510
5652022092620:1737.594771126.94294820.910