Overview

Dataset statistics

Number of variables7
Number of observations3310
Missing cells0
Missing cells (%)0.0%
Duplicate rows136
Duplicate rows (%)4.1%
Total size in memory197.3 KiB
Average record size in memory61.0 B

Variable types

DateTime2
Numeric4
Categorical1

Dataset

Description경기도 성남시 CCTV 위치별 조도, 휘도 데이터를 제공합니다. 날짜, 시간, 위도, 경도, 조도, 휘도 데이터를 제공하고 있습니다.
Author경기도 성남시
URLhttps://www.data.go.kr/data/15110584/fileData.do

Alerts

날짜(DATE) has constant value ""Constant
시간(TIME) has constant value ""Constant
달 위상(LUNAR_PHASE) has constant value ""Constant
Dataset has 136 (4.1%) duplicate rowsDuplicates
위도(LATITUDE) is highly overall correlated with 경도(LONGITUDE)High correlation
경도(LONGITUDE) is highly overall correlated with 위도(LATITUDE)High correlation
조도(ILLUMINATION) is highly overall correlated with 휘도(BRIGHTNESS)High correlation
휘도(BRIGHTNESS) is highly overall correlated with 조도(ILLUMINATION)High correlation

Reproduction

Analysis started2023-12-12 20:38:55.219017
Analysis finished2023-12-12 20:38:57.630632
Duration2.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

날짜(DATE)
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size26.0 KiB
Minimum2022-09-19 00:00:00
Maximum2022-09-19 00:00:00
2023-12-13T05:38:57.689063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:57.808083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

시간(TIME)
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size26.0 KiB
Minimum2023-12-13 20:50:00
Maximum2023-12-13 20:50:00
2023-12-13T05:38:57.925103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:58.046914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

위도(LATITUDE)
Real number (ℝ)

HIGH CORRELATION 

Distinct3053
Distinct (%)92.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.417736
Minimum37.33406
Maximum37.473342
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size29.2 KiB
2023-12-13T05:38:58.227057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.33406
5-th percentile37.359156
Q137.39108
median37.43065
Q337.444984
95-th percentile37.458494
Maximum37.473342
Range0.1392819
Interquartile range (IQR)0.053903625

Descriptive statistics

Standard deviation0.03306843
Coefficient of variation (CV)0.00088376353
Kurtosis-0.9094428
Mean37.417736
Median Absolute Deviation (MAD)0.0228245
Skewness-0.51659803
Sum123852.71
Variance0.0010935211
MonotonicityNot monotonic
2023-12-13T05:38:58.466930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
37.4062829 13
 
0.4%
37.4022329 11
 
0.3%
37.3704978 5
 
0.2%
37.4281 4
 
0.1%
37.3921196 4
 
0.1%
37.3897387 4
 
0.1%
37.3917731 4
 
0.1%
37.41872 4
 
0.1%
37.3995763 4
 
0.1%
37.4443519 3
 
0.1%
Other values (3043) 3254
98.3%
ValueCountFrequency (%)
37.33406 1
< 0.1%
37.33415 1
< 0.1%
37.3346918 2
0.1%
37.33524 1
< 0.1%
37.33606 1
< 0.1%
37.3373 1
< 0.1%
37.3375722 1
< 0.1%
37.337576 1
< 0.1%
37.3378233 1
< 0.1%
37.337944 1
< 0.1%
ValueCountFrequency (%)
37.4733419 1
< 0.1%
37.4729854 1
< 0.1%
37.4724 1
< 0.1%
37.4723 1
< 0.1%
37.4719 2
0.1%
37.4717 1
< 0.1%
37.47165 1
< 0.1%
37.4713 1
< 0.1%
37.4712498 1
< 0.1%
37.4712 1
< 0.1%

경도(LONGITUDE)
Real number (ℝ)

HIGH CORRELATION 

Distinct3055
Distinct (%)92.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.13026
Minimum127.05796
Maximum127.1814
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size29.2 KiB
2023-12-13T05:38:58.998782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.05796
5-th percentile127.08244
Q1127.1133
median127.13223
Q3127.14773
95-th percentile127.16623
Maximum127.1814
Range0.1234457
Interquartile range (IQR)0.0344335

Descriptive statistics

Standard deviation0.024711469
Coefficient of variation (CV)0.00019437913
Kurtosis-0.27572165
Mean127.13026
Median Absolute Deviation (MAD)0.0172737
Skewness-0.46434356
Sum420801.14
Variance0.0006106567
MonotonicityNot monotonic
2023-12-13T05:38:59.166809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
127.1164218 13
 
0.4%
127.0949281 11
 
0.3%
127.1167369 5
 
0.2%
127.1017312 4
 
0.1%
127.1183055 4
 
0.1%
127.0667121 4
 
0.1%
127.1272 4
 
0.1%
127.0752031 4
 
0.1%
127.118613 3
 
0.1%
127.105877 3
 
0.1%
Other values (3045) 3255
98.3%
ValueCountFrequency (%)
127.057956 1
< 0.1%
127.058537 1
< 0.1%
127.0617751 1
< 0.1%
127.0621399 1
< 0.1%
127.0624901 1
< 0.1%
127.0625973 1
< 0.1%
127.0632668 1
< 0.1%
127.0633526 1
< 0.1%
127.0634879 1
< 0.1%
127.063617 1
< 0.1%
ValueCountFrequency (%)
127.1814017 1
< 0.1%
127.180953 1
< 0.1%
127.18091 1
< 0.1%
127.1809082 1
< 0.1%
127.180471 1
< 0.1%
127.180371 1
< 0.1%
127.18037 1
< 0.1%
127.1801152 1
< 0.1%
127.1800133 1
< 0.1%
127.1794657 1
< 0.1%

조도(ILLUMINATION)
Real number (ℝ)

HIGH CORRELATION 

Distinct1750
Distinct (%)52.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.772011
Minimum0.3
Maximum200
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size29.2 KiB
2023-12-13T05:38:59.318434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.3
5-th percentile3.725
Q19.37
median17.458869
Q330.246875
95-th percentile57.008214
Maximum200
Range199.7
Interquartile range (IQR)20.876875

Descriptive statistics

Standard deviation19.866605
Coefficient of variation (CV)0.87241327
Kurtosis15.396616
Mean22.772011
Median Absolute Deviation (MAD)9.458869
Skewness2.8350829
Sum75375.356
Variance394.68197
MonotonicityNot monotonic
2023-12-13T05:38:59.519466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
7.8 18
 
0.5%
33.983333 13
 
0.4%
0.5 9
 
0.3%
40.2 9
 
0.3%
12.8 8
 
0.2%
11.4 8
 
0.2%
19.155556 7
 
0.2%
15.9 7
 
0.2%
6.8 7
 
0.2%
8.866667 7
 
0.2%
Other values (1740) 3217
97.2%
ValueCountFrequency (%)
0.3 1
 
< 0.1%
0.4 4
0.1%
0.44 1
 
< 0.1%
0.45 1
 
< 0.1%
0.5 9
0.3%
0.6 2
 
0.1%
0.65 1
 
< 0.1%
0.68 2
 
0.1%
0.7 1
 
< 0.1%
0.744444 1
 
< 0.1%
ValueCountFrequency (%)
200.0 1
 
< 0.1%
189.5 6
0.2%
186.7 1
 
< 0.1%
177.0 1
 
< 0.1%
150.542857 1
 
< 0.1%
136.033333 1
 
< 0.1%
122.8 2
 
0.1%
121.3 2
 
0.1%
120.6 1
 
< 0.1%
112.825 1
 
< 0.1%

휘도(BRIGHTNESS)
Real number (ℝ)

HIGH CORRELATION 

Distinct1542
Distinct (%)46.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.9796674
Minimum0.01
Maximum9.99
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size29.2 KiB
2023-12-13T05:38:59.710328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.01
5-th percentile0.14
Q10.35270825
median0.640667
Q31.259
95-th percentile2.9616923
Maximum9.99
Range9.98
Interquartile range (IQR)0.90629175

Descriptive statistics

Standard deviation1.0135182
Coefficient of variation (CV)1.0345534
Kurtosis10.548584
Mean0.9796674
Median Absolute Deviation (MAD)0.365667
Skewness2.714467
Sum3242.6991
Variance1.0272192
MonotonicityNot monotonic
2023-12-13T05:38:59.898828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.225 23
 
0.7%
0.73 22
 
0.7%
0.52 14
 
0.4%
0.59 14
 
0.4%
0.14 11
 
0.3%
0.415 11
 
0.3%
0.62 10
 
0.3%
0.6 10
 
0.3%
0.23 9
 
0.3%
0.38 9
 
0.3%
Other values (1532) 3177
96.0%
ValueCountFrequency (%)
0.01 1
 
< 0.1%
0.015 1
 
< 0.1%
0.02 2
 
0.1%
0.026 2
 
0.1%
0.03 6
0.2%
0.038 2
 
0.1%
0.04 8
0.2%
0.043333 1
 
< 0.1%
0.045 2
 
0.1%
0.0475 1
 
< 0.1%
ValueCountFrequency (%)
9.99 1
 
< 0.1%
8.93 1
 
< 0.1%
7.85 4
0.1%
6.314286 2
0.1%
6.273333 1
 
< 0.1%
6.17 2
0.1%
6.082 1
 
< 0.1%
6.044615 4
0.1%
6.0375 1
 
< 0.1%
5.874286 1
 
< 0.1%

달 위상(LUNAR_PHASE)
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size26.0 KiB
45.33333333
3310 

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row45.33333333
2nd row45.33333333
3rd row45.33333333
4th row45.33333333
5th row45.33333333

Common Values

ValueCountFrequency (%)
45.33333333 3310
100.0%

Length

2023-12-13T05:39:00.081461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T05:39:00.184568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
45.33333333 3310
100.0%

Interactions

2023-12-13T05:38:56.927289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:55.537638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:55.999159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:56.481032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:57.040908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:55.638611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:56.115539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:56.595912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:57.149839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:55.750799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:56.232836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:56.708316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:57.271317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:55.874155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:56.365924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T05:38:56.819142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T05:39:00.255612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도(LATITUDE)경도(LONGITUDE)조도(ILLUMINATION)휘도(BRIGHTNESS)
위도(LATITUDE)1.0000.7530.2270.209
경도(LONGITUDE)0.7531.0000.2350.198
조도(ILLUMINATION)0.2270.2351.0000.816
휘도(BRIGHTNESS)0.2090.1980.8161.000
2023-12-13T05:39:00.371204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도(LATITUDE)경도(LONGITUDE)조도(ILLUMINATION)휘도(BRIGHTNESS)
위도(LATITUDE)1.0000.618-0.004-0.011
경도(LONGITUDE)0.6181.0000.048-0.032
조도(ILLUMINATION)-0.0040.0481.0000.808
휘도(BRIGHTNESS)-0.011-0.0320.8081.000

Missing values

2023-12-13T05:38:57.435880image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T05:38:57.570142image/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

날짜(DATE)시간(TIME)위도(LATITUDE)경도(LONGITUDE)조도(ILLUMINATION)휘도(BRIGHTNESS)달 위상(LUNAR_PHASE)
02022-09-1920:5037.4713127.1354136.0333336.27333345.333333
12022-09-1920:5037.471127.137248.52.74545.333333
22022-09-1920:5037.4712127.140542.050.8545.333333
32022-09-1920:5037.4707127.1458122.84.69545.333333
42022-09-1920:5037.4696127.14076.80.1945.333333
52022-09-1920:5037.4699127.150950.052.40545.333333
62022-09-1920:5037.46735127.138631.7142861.67571445.333333
72022-09-1920:5037.47118127.1385717.00.7845.333333
82022-09-1920:5037.4685127.13816.061.045.333333
92022-09-1920:5037.4676127.138631.7142861.67571445.333333
날짜(DATE)시간(TIME)위도(LATITUDE)경도(LONGITUDE)조도(ILLUMINATION)휘도(BRIGHTNESS)달 위상(LUNAR_PHASE)
33002022-09-1920:5037.452607127.15338452.921.73645.333333
33012022-09-1920:5037.455369127.151177.6333331.44545.333333
33022022-09-1920:5037.452942127.15054829.7333330.67666745.333333
33032022-09-1920:5037.457571127.1528815.6666670.04833345.333333
33042022-09-1920:5037.459555127.16139426.450.6345.333333
33052022-09-1920:5037.462584127.16704116.6833330.66166745.333333
33062022-09-1920:5037.46031127.1628385.5250.397545.333333
33072022-09-1920:5037.457481127.16011115.080.54845.333333
33082022-09-1920:5037.44939127.16353422.710.66945.333333
33092022-09-1920:5037.448404127.1627979.3142860.26857145.333333

Duplicate rows

Most frequently occurring

날짜(DATE)시간(TIME)위도(LATITUDE)경도(LONGITUDE)조도(ILLUMINATION)휘도(BRIGHTNESS)달 위상(LUNAR_PHASE)# duplicates
842022-09-1920:5037.406283127.11642233.9833330.7345.33333313
802022-09-1920:5037.402233127.0949287.80.22545.33333311
242022-09-1920:5037.370498127.1167376.4666670.5245.3333335
432022-09-1920:5037.389739127.101731189.55.38545.3333334
572022-09-1920:5037.391773127.07520355.3666672.03666745.3333334
582022-09-1920:5037.39212127.0667122.70.09545.3333334
762022-09-1920:5037.399576127.1183069.60.7545.3333334
872022-09-1920:5037.41872127.12724.750.172545.3333334
132022-09-1920:5037.358961127.1244922.9333330.12777845.3333333
542022-09-1920:5037.391191127.08479155.821.86645.3333333