gimi9 Pandas Profiling

Dataset statistics

Number of variables	13
Number of observations	6966
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	18
Duplicate rows (%)	0.3%
Total size in memory	782.4 KiB
Average record size in memory	115.0 B

Variable types

DateTime	2
Numeric	9
Categorical	2

Dataset

Description	송파구 관내의 CCTV 위치별 조도 등 환경 데이터 입니다. DATE(관측 연월일), TIME(관측 시간), LATITUDE(위도), LONGTITUDE(경도), ILLUMINATION(조도), BRIGHTNESS(휘도), LUNAR_PHASE(달 위상), TEMPERATURE(기온), HUMIDITY(습도), WIND_DIR(풍향), WIND_SPD(풍속), PM10(미세먼지), PM25(초미세먼지) 데이터 입니다. 1차 전반 측정 : 2021. 8. 25. 21:00 기준 1차 후반 측정: 2021. 8. 25. 23:00 기준 2차 전반 측정: 2021. 11. 7. 21:00 기준 2차 후반 측정: 2021. 11. 7. 23:00 기준 3차 전반 측정: 2021. 11.22. 21:00 기준 3차 후반 측정: 2021. 11.22. 23:00 기준
Author	서울특별시 송파구
URL	https://www.data.go.kr/data/15097749/fileData.do

Alerts

Dataset has 18 (0.3%) duplicate rows	Duplicates
`초미세먼지(PM25)` is highly overall correlated with `기온(TEMPERATURE)` and 5 other fields	High correlation
`달위상(LUNAR_PHASE)` is highly overall correlated with `기온(TEMPERATURE)` and 5 other fields	High correlation
`위도(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
`기온(TEMPERATURE)` is highly overall correlated with `습도(HUMIDITY)` and 5 other fields	High correlation
`습도(HUMIDITY)` is highly overall correlated with `기온(TEMPERATURE)` and 3 other fields	High correlation
`풍향(WIND_DIR)` is highly overall correlated with `기온(TEMPERATURE)` and 4 other fields	High correlation
`풍속(WIND_SPD)` is highly overall correlated with `기온(TEMPERATURE)` and 4 other fields	High correlation
`미세먼지(PM10)` is highly overall correlated with `기온(TEMPERATURE)` and 5 other fields	High correlation

Reproduction

Analysis started	2023-12-12 05:42:34.432297
Analysis finished	2023-12-12 05:42:46.083874
Duration	11.65 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

관측연월일(DATE)
Date

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.6 KiB

Minimum	2021-08-25 00:00:00
Maximum	2021-11-22 00:00:00

Histogram

Histogram with fixed size bins (bins=3)

관측시간(TIME)
Date

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.6 KiB

Minimum	2023-12-12 21:00:00
Maximum	2023-12-12 23:00:00

Histogram

Histogram with fixed size bins (bins=2)

위도(LATITUDE)
Real number (ℝ)

HIGH CORRELATION

Distinct	1148
Distinct (%)	16.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.50347

Minimum	37.4693
Maximum	37.539936
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.4 KiB

Quantile statistics

Minimum	37.4693
5-th percentile	37.481808
Q1	37.494429
median	37.502281
Q3	37.509318
95-th percentile	37.533775
Maximum	37.539936
Range	0.07063579
Interquartile range (IQR)	0.01488943

Descriptive statistics

Standard deviation	0.013461521
Coefficient of variation (CV)	0.00035894067
Kurtosis	0.56685355
Mean	37.50347
Median Absolute Deviation (MAD)	0.00730514
Skewness	0.64103704
Sum	261249.17
Variance	0.00018121254
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37.50633621	18	0.3%
37.50331497	12	0.2%
37.49263	12	0.2%
37.50440979	12	0.2%
37.49958038	12	0.2%
37.50095522	12	0.2%
37.52802277	12	0.2%
37.49923325	12	0.2%
37.50170135	12	0.2%
37.49938369	12	0.2%
Other values (1138)	6840	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
37.46930028	6	0.1%
37.4699123	6	0.1%
37.47334726	6	0.1%
37.47431183	6	0.1%
37.47451401	6	0.1%
37.47543	6	0.1%
37.4755	6	0.1%
37.47558212	6	0.1%
37.47609711	6	0.1%
37.47715378	6	0.1%

Value	Count	Frequency (%)
37.53993607	6	0.1%
37.53941464	6	0.1%
37.53881073	6	0.1%
37.53842923	6	0.1%
37.53842649	6	0.1%
37.53836268	6	0.1%
37.53835678	6	0.1%
37.538307	6	0.1%
37.53825378	6	0.1%
37.53818582	6	0.1%

경도(LONGITUDE)
Real number (ℝ)

HIGH CORRELATION

Distinct	1148
Distinct (%)	16.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	127.11984

Minimum	127.07109
Maximum	127.16097
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.4 KiB

Quantile statistics

Minimum	127.07109
5-th percentile	127.08388
Q1	127.10647
median	127.11909
Q3	127.1349
95-th percentile	127.15227
Maximum	127.16097
Range	0.0898743
Interquartile range (IQR)	0.0284358

Descriptive statistics

Standard deviation	0.020394632
Coefficient of variation (CV)	0.00016043626
Kurtosis	-0.65307001
Mean	127.11984
Median Absolute Deviation (MAD)	0.0142212
Skewness	-0.11760378
Sum	885516.79
Variance	0.000415941
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
127.1095789	12	0.2%
127.1224747	12	0.2%
127.1199036	12	0.2%
127.0965424	12	0.2%
127.1303406	12	0.2%
127.1353989	12	0.2%
127.1045898	12	0.2%
127.110527	12	0.2%
127.1157303	12	0.2%
127.1251984	12	0.2%
Other values (1138)	6846	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
127.0710907	6	0.1%
127.0713272	6	0.1%
127.0716095	6	0.1%
127.0735525	6	0.1%
127.0737839	6	0.1%
127.073928	6	0.1%
127.0740738	6	0.1%
127.0741864	6	0.1%
127.0749735	6	0.1%
127.0750885	6	0.1%

Value	Count	Frequency (%)
127.160965	6	0.1%
127.1607628	6	0.1%
127.1597978	6	0.1%
127.1594805	6	0.1%
127.1593037	6	0.1%
127.1591266	6	0.1%
127.159073	6	0.1%
127.1588955	6	0.1%
127.1587226	6	0.1%
127.1583557	6	0.1%

조도(ILLUMINATION)
Real number (ℝ)

HIGH CORRELATION

Distinct	2437
Distinct (%)	35.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.693196

Minimum	3.11
Maximum	69.69
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.4 KiB

Quantile statistics

Minimum	3.11
5-th percentile	7.9
Q1	11.9725
median	16
Q3	21.5475
95-th percentile	33.12
Maximum	69.69
Range	66.58
Interquartile range (IQR)	9.575

Descriptive statistics

Standard deviation	8.0712099
Coefficient of variation (CV)	0.45617593
Kurtosis	2.8868123
Mean	17.693196
Median Absolute Deviation (MAD)	4.55
Skewness	1.3771716
Sum	123250.8
Variance	65.144429
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.92	18	0.3%
16.38	17	0.2%
18.42	16	0.2%
12.75	16	0.2%
18.38	16	0.2%
11.43	14	0.2%
14.85	14	0.2%
16.09	13	0.2%
17.27	13	0.2%
14.63	13	0.2%
Other values (2427)	6816	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.11	1	< 0.1%
3.24	1	< 0.1%
3.49	1	< 0.1%
3.92	2	< 0.1%
4.18	1	< 0.1%
4.31	1	< 0.1%
4.36	1	< 0.1%
4.52	1	< 0.1%
4.68	1	< 0.1%
4.72	1	< 0.1%

Value	Count	Frequency (%)
69.69	1	< 0.1%
67.19	1	< 0.1%
65.54	1	< 0.1%
64.91	1	< 0.1%
60.66	1	< 0.1%
59.9	1	< 0.1%
58.0	1	< 0.1%
57.63	1	< 0.1%
57.29	1	< 0.1%
57.04	1	< 0.1%

휘도(BRIGHTNESS)
Real number (ℝ)

HIGH CORRELATION

Distinct	258
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.91709015

Minimum	0.19
Maximum	5.74
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.4 KiB

Quantile statistics

Minimum	0.19
5-th percentile	0.44
Q1	0.63
median	0.82
Q3	1.09
95-th percentile	1.7
Maximum	5.74
Range	5.55
Interquartile range (IQR)	0.46

Descriptive statistics

Standard deviation	0.43015634
Coefficient of variation (CV)	0.46904477
Kurtosis	11.28828
Mean	0.91709015
Median Absolute Deviation (MAD)	0.22
Skewness	2.278783
Sum	6388.45
Variance	0.18503447
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.62	120	1.7%
0.6	115	1.7%
0.72	107	1.5%
0.69	105	1.5%
0.65	101	1.4%
0.71	99	1.4%
0.8	97	1.4%
0.68	97	1.4%
0.64	95	1.4%
0.74	95	1.4%
Other values (248)	5935	85.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.19	2	< 0.1%
0.2	1	< 0.1%
0.24	6	0.1%
0.25	2	< 0.1%
0.26	1	< 0.1%
0.27	3	< 0.1%
0.28	4	0.1%
0.29	7	0.1%
0.3	3	< 0.1%
0.31	10	0.1%

Value	Count	Frequency (%)
5.74	1	< 0.1%
5.72	1	< 0.1%
4.85	1	< 0.1%
4.63	1	< 0.1%
4.02	1	< 0.1%
3.8	2	< 0.1%
3.65	4	0.1%
3.64	1	< 0.1%
3.63	1	< 0.1%
3.58	1	< 0.1%

달위상(LUNAR_PHASE)
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.6 KiB

90.8	2322
1.2	2322
92.2	2322

Length

Max length	4
Median length	4
Mean length	3.6666667
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	90.8
2nd row	90.8
3rd row	90.8
4th row	90.8
5th row	90.8

Common Values

Value	Count	Frequency (%)
90.8	2322	33.3%
1.2	2322	33.3%
92.2	2322	33.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
90.8	2322	33.3%
1.2	2322	33.3%
92.2	2322	33.3%

기온(TEMPERATURE)
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.216667

Minimum	0.7
Maximum	24.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.4 KiB

Quantile statistics

Minimum	0.7
5-th percentile	0.7
Q1	1.6
median	20
Q3	24.2
95-th percentile	24.8
Maximum	24.8
Range	24.1
Interquartile range (IQR)	22.6

Descriptive statistics

Standard deviation	10.121895
Coefficient of variation (CV)	0.66518479
Kurtosis	-1.4944335
Mean	15.216667
Median Absolute Deviation (MAD)	4.5
Skewness	-0.60412418
Sum	105999.3
Variance	102.45276
Monotonicity	Decreasing

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
24.8	1161	16.7%
24.2	1161	16.7%
20.3	1161	16.7%
19.7	1161	16.7%
1.6	1161	16.7%
0.7	1161	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.7	1161	16.7%
1.6	1161	16.7%
19.7	1161	16.7%
20.3	1161	16.7%
24.2	1161	16.7%
24.8	1161	16.7%

Value	Count	Frequency (%)
24.8	1161	16.7%
24.2	1161	16.7%
20.3	1161	16.7%
19.7	1161	16.7%
1.6	1161	16.7%
0.7	1161	16.7%

습도(HUMIDITY)
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	75

Minimum	43
Maximum	96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.4 KiB

Quantile statistics

Minimum	43
5-th percentile	43
Q1	51
median	85
Q3	90
95-th percentile	96
Maximum	96
Range	53
Interquartile range (IQR)	39

Descriptive statistics

Standard deviation	20.28281
Coefficient of variation (CV)	0.27043747
Kurtosis	-1.3780754
Mean	75
Median Absolute Deviation (MAD)	8
Skewness	-0.63736417
Sum	522450
Variance	411.39239
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
96	1161	16.7%
86	1161	16.7%
90	1161	16.7%
84	1161	16.7%
51	1161	16.7%
43	1161	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
43	1161	16.7%
51	1161	16.7%
84	1161	16.7%
86	1161	16.7%
90	1161	16.7%
96	1161	16.7%

Value	Count	Frequency (%)
96	1161	16.7%
90	1161	16.7%
86	1161	16.7%
84	1161	16.7%
51	1161	16.7%
43	1161	16.7%

풍향(WIND_DIR)
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	225.03333

Minimum	164.6
Maximum	314.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.4 KiB

Quantile statistics

Minimum	164.6
5-th percentile	164.6
Q1	170.5
median	203.5
Q3	293.2
95-th percentile	314.9
Maximum	314.9
Range	150.3
Interquartile range (IQR)	122.7

Descriptive statistics

Standard deviation	60.728425
Coefficient of variation (CV)	0.26986413
Kurtosis	-1.5749964
Mean	225.03333
Median Absolute Deviation (MAD)	35.95
Skewness	0.38732464
Sum	1567582.2
Variance	3687.9416
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
173.1	1161	16.7%
164.6	1161	16.7%
233.9	1161	16.7%
170.5	1161	16.7%
314.9	1161	16.7%
293.2	1161	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
164.6	1161	16.7%
170.5	1161	16.7%
173.1	1161	16.7%
233.9	1161	16.7%
293.2	1161	16.7%
314.9	1161	16.7%

Value	Count	Frequency (%)
314.9	1161	16.7%
293.2	1161	16.7%
233.9	1161	16.7%
173.1	1161	16.7%
170.5	1161	16.7%
164.6	1161	16.7%

풍속(WIND_SPD)
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.05

Minimum	0.9
Maximum	3.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.4 KiB

Quantile statistics

Minimum	0.9
5-th percentile	0.9
Q1	1.2
median	1.75
Q3	3.1
95-th percentile	3.6
Maximum	3.6
Range	2.7
Interquartile range (IQR)	1.9

Descriptive statistics

Standard deviation	0.98791368
Coefficient of variation (CV)	0.48190911
Kurtosis	-1.363637
Mean	2.05
Median Absolute Deviation (MAD)	0.7
Skewness	0.4461681
Sum	14280.3
Variance	0.97597344
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2.0	1161	16.7%
0.9	1161	16.7%
1.5	1161	16.7%
1.2	1161	16.7%
3.1	1161	16.7%
3.6	1161	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.9	1161	16.7%
1.2	1161	16.7%
1.5	1161	16.7%
2.0	1161	16.7%
3.1	1161	16.7%
3.6	1161	16.7%

Value	Count	Frequency (%)
3.6	1161	16.7%
3.1	1161	16.7%
2.0	1161	16.7%
1.5	1161	16.7%
1.2	1161	16.7%
0.9	1161	16.7%

미세먼지(PM10)
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.666667

Minimum	14
Maximum	44
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	61.4 KiB

Quantile statistics

Minimum	14
5-th percentile	14
Q1	17
median	20.5
Q3	38
95-th percentile	44
Maximum	44
Range	30
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	11.205962
Coefficient of variation (CV)	0.43659592
Kurtosis	-1.2896296
Mean	25.666667
Median Absolute Deviation (MAD)	5
Skewness	0.65354823
Sum	178794
Variance	125.57358
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
14	1161	16.7%
17	1161	16.7%
21	1161	16.7%
20	1161	16.7%
44	1161	16.7%
38	1161	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
14	1161	16.7%
17	1161	16.7%
20	1161	16.7%
21	1161	16.7%
38	1161	16.7%
44	1161	16.7%

Value	Count	Frequency (%)
44	1161	16.7%
38	1161	16.7%
21	1161	16.7%
20	1161	16.7%
17	1161	16.7%
14	1161	16.7%

초미세먼지(PM25)
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	54.6 KiB

9	2322
4	1161
5	1161
21	1161
19	1161

Length

Max length	2
Median length	1
Mean length	1.3333333
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
9	2322	33.3%
4	1161	16.7%
5	1161	16.7%
21	1161	16.7%
19	1161	16.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
9	2322	33.3%
4	1161	16.7%
5	1161	16.7%
21	1161	16.7%
19	1161	16.7%

Heatmap
Table

	관측연월일(DATE)	관측시간(TIME)	위도(LATITUDE)	경도(LONGITUDE)	조도(ILLUMINATION)	휘도(BRIGHTNESS)	달위상(LUNAR_PHASE)	기온(TEMPERATURE)	습도(HUMIDITY)	풍향(WIND_DIR)	풍속(WIND_SPD)	미세먼지(PM10)	초미세먼지(PM25)
관측연월일(DATE)	1.000	0.000	0.000	0.000	0.271	0.328	1.000	1.000	0.833	0.743	1.000	1.000	1.000
관측시간(TIME)	0.000	1.000	0.000	0.000	0.246	0.144	0.000	0.785	0.683	0.932	1.000	0.683	0.683
위도(LATITUDE)	0.000	0.000	1.000	0.747	0.260	0.230	0.000	0.000	0.000	0.000	0.000	0.000	0.000
경도(LONGITUDE)	0.000	0.000	0.747	1.000	0.354	0.259	0.000	0.000	0.000	0.000	0.000	0.000	0.000
조도(ILLUMINATION)	0.271	0.246	0.260	0.354	1.000	0.574	0.271	0.248	0.313	0.255	0.262	0.341	0.341
휘도(BRIGHTNESS)	0.328	0.144	0.230	0.259	0.574	1.000	0.328	0.219	0.163	0.192	0.232	0.202	0.202
달위상(LUNAR_PHASE)	1.000	0.000	0.000	0.000	0.271	0.328	1.000	1.000	0.833	0.743	1.000	1.000	1.000
기온(TEMPERATURE)	1.000	0.785	0.000	0.000	0.248	0.219	1.000	1.000	0.876	0.982	1.000	0.841	0.841
습도(HUMIDITY)	0.833	0.683	0.000	0.000	0.313	0.163	0.833	0.876	1.000	1.000	1.000	0.995	0.995
풍향(WIND_DIR)	0.743	0.932	0.000	0.000	0.255	0.192	0.743	0.982	1.000	1.000	1.000	0.990	0.990
풍속(WIND_SPD)	1.000	1.000	0.000	0.000	0.262	0.232	1.000	1.000	1.000	1.000	1.000	1.000	1.000
미세먼지(PM10)	1.000	0.683	0.000	0.000	0.341	0.202	1.000	0.841	0.995	0.990	1.000	1.000	1.000
초미세먼지(PM25)	1.000	0.683	0.000	0.000	0.341	0.202	1.000	0.841	0.995	0.990	1.000	1.000	1.000

Heatmap
Table

	초미세먼지(PM25)	달위상(LUNAR_PHASE)
초미세먼지(PM25)	1.000	1.000
달위상(LUNAR_PHASE)	1.000	1.000

Heatmap
Table

	위도(LATITUDE)	경도(LONGITUDE)	조도(ILLUMINATION)	휘도(BRIGHTNESS)	기온(TEMPERATURE)	습도(HUMIDITY)	풍향(WIND_DIR)	풍속(WIND_SPD)	미세먼지(PM10)	달위상(LUNAR_PHASE)	초미세먼지(PM25)
위도(LATITUDE)	1.000	-0.530	0.061	-0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.000
경도(LONGITUDE)	-0.530	1.000	-0.141	-0.191	0.000	0.000	0.000	0.000	0.000	0.000	0.000
조도(ILLUMINATION)	0.061	-0.141	1.000	0.684	-0.168	-0.111	0.300	0.236	0.249	0.168	0.148
휘도(BRIGHTNESS)	-0.008	-0.191	0.684	1.000	-0.175	-0.107	0.277	0.215	0.241	0.153	0.117
기온(TEMPERATURE)	0.000	0.000	-0.168	-0.175	1.000	0.943	-0.657	-0.600	-0.886	1.000	0.816
습도(HUMIDITY)	0.000	0.000	-0.111	-0.107	0.943	1.000	-0.486	-0.486	-0.771	0.866	0.901
풍향(WIND_DIR)	0.000	0.000	0.300	0.277	-0.657	-0.486	1.000	0.886	0.829	0.816	0.882
풍속(WIND_SPD)	0.000	0.000	0.236	0.215	-0.600	-0.486	0.886	1.000	0.600	1.000	1.000
미세먼지(PM10)	0.000	0.000	0.249	0.241	-0.886	-0.771	0.829	0.600	1.000	1.000	0.866
달위상(LUNAR_PHASE)	0.000	0.000	0.168	0.153	1.000	0.866	0.816	1.000	1.000	1.000	1.000
초미세먼지(PM25)	0.000	0.000	0.148	0.117	0.816	0.901	0.882	1.000	0.866	1.000	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	관측연월일(DATE)	관측시간(TIME)	위도(LATITUDE)	경도(LONGITUDE)	조도(ILLUMINATION)	휘도(BRIGHTNESS)	달위상(LUNAR_PHASE)	기온(TEMPERATURE)	습도(HUMIDITY)	풍향(WIND_DIR)	풍속(WIND_SPD)	미세먼지(PM10)	초미세먼지(PM25)
0	2021-08-25	21:00	37.478458	127.139145	15.95	0.89	90.8	24.8	96	173.1	2.0	14	4
1	2021-08-25	21:00	37.47847	127.142044	15.55	1.56	90.8	24.8	96	173.1	2.0	14	4
2	2021-08-25	21:00	37.47999	127.14168	12.64	1.23	90.8	24.8	96	173.1	2.0	14	4
3	2021-08-25	21:00	37.480915	127.126656	12.35	0.65	90.8	24.8	96	173.1	2.0	14	4
4	2021-08-25	21:00	37.48148	127.131393	8.17	0.38	90.8	24.8	96	173.1	2.0	14	4
5	2021-08-25	21:00	37.481808	127.130951	11.5	0.58	90.8	24.8	96	173.1	2.0	14	4
6	2021-08-25	21:00	37.482105	127.127022	9.48	0.54	90.8	24.8	96	173.1	2.0	14	4
7	2021-08-25	21:00	37.482693	127.131035	7.22	0.38	90.8	24.8	96	173.1	2.0	14	4
8	2021-08-25	21:00	37.4828	127.129547	9.66	0.53	90.8	24.8	96	173.1	2.0	14	4
9	2021-08-25	21:00	37.483255	127.12463	11.93	0.7	90.8	24.8	96	173.1	2.0	14	4

	관측연월일(DATE)	관측시간(TIME)	위도(LATITUDE)	경도(LONGITUDE)	조도(ILLUMINATION)	휘도(BRIGHTNESS)	달위상(LUNAR_PHASE)	기온(TEMPERATURE)	습도(HUMIDITY)	풍향(WIND_DIR)	풍속(WIND_SPD)	미세먼지(PM10)	초미세먼지(PM25)
6956	2021-11-22	23:00	37.52394	127.1066	26.29	1.03	92.2	0.7	43	293.2	3.6	38	19
6957	2021-11-22	23:00	37.524788	127.102905	19.28	1.01	92.2	0.7	43	293.2	3.6	38	19
6958	2021-11-22	23:00	37.510052	127.120926	20.38	1.39	92.2	0.7	43	293.2	3.6	38	19
6959	2021-11-22	23:00	37.525181	127.106468	18.61	0.95	92.2	0.7	43	293.2	3.6	38	19
6960	2021-11-22	23:00	37.533772	127.118652	16.69	1.36	92.2	0.7	43	293.2	3.6	38	19
6961	2021-11-22	23:00	37.495457	127.101379	12.08	0.68	92.2	0.7	43	293.2	3.6	38	19
6962	2021-11-22	23:00	37.511162	127.12503	10.46	0.72	92.2	0.7	43	293.2	3.6	38	19
6963	2021-11-22	23:00	37.481197	127.134666	13.01	0.95	92.2	0.7	43	293.2	3.6	38	19
6964	2021-11-22	23:00	37.478291	127.144074	15.88	1.66	92.2	0.7	43	293.2	3.6	38	19
6965	2021-11-22	23:00	37.477352	127.139122	13.19	0.98	92.2	0.7	43	293.2	3.6	38	19

Most frequently occurring

	관측연월일(DATE)	관측시간(TIME)	위도(LATITUDE)	경도(LONGITUDE)	조도(ILLUMINATION)	휘도(BRIGHTNESS)	달위상(LUNAR_PHASE)	기온(TEMPERATURE)	습도(HUMIDITY)	풍향(WIND_DIR)	풍속(WIND_SPD)	미세먼지(PM10)	초미세먼지(PM25)	# duplicates
0	2021-08-25	21:00	37.499233	127.119904	12.48	0.58	90.8	24.8	96	173.1	2.0	14	4	2
1	2021-08-25	21:00	37.499384	127.10459	17.03	0.99	90.8	24.8	96	173.1	2.0	14	4	2
2	2021-08-25	21:00	37.500955	127.109579	15.04	0.85	90.8	24.8	96	173.1	2.0	14	4	2
3	2021-08-25	23:00	37.499233	127.119904	21.35	0.94	90.8	24.2	86	164.6	0.9	17	5	2
4	2021-08-25	23:00	37.499384	127.10459	17.92	1.15	90.8	24.2	86	164.6	0.9	17	5	2
5	2021-08-25	23:00	37.500955	127.109579	11.85	0.77	90.8	24.2	86	164.6	0.9	17	5	2
6	2021-10-07	21:00	37.499233	127.119904	16.82	0.71	1.2	20.3	90	233.9	1.5	21	9	2
7	2021-10-07	21:00	37.499384	127.10459	30.32	1.65	1.2	20.3	90	233.9	1.5	21	9	2
8	2021-10-07	21:00	37.500955	127.109579	20.9	1.1	1.2	20.3	90	233.9	1.5	21	9	2
9	2021-10-07	23:00	37.499233	127.119904	16.19	0.61	1.2	19.7	84	170.5	1.2	20	9	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring