gimi9 Pandas Profiling

Dataset statistics

Number of variables	9
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	5
Duplicate rows (%)	0.1%
Total size in memory	859.4 KiB
Average record size in memory	88.0 B

Variable types

Numeric	8
DateTime	1

Dataset

Description	서울특별시 서대문구 계절별(가을) 도로 주도, 휘도 데이터입니다. 날짜, 시간, 위도, 경도, 조도, 휘도, 달 위상, 기온 등 데이터를 제공합니다.
Author	서울특별시 서대문구
URL	https://www.data.go.kr/data/15109199/fileData.do

Alerts

Dataset has 5 (0.1%) duplicate rows	Duplicates
`날짜` is highly overall correlated with `위도`	High correlation
`위도` is highly overall correlated with `날짜`	High correlation
`조도` is highly overall correlated with `휘도`	High correlation
`휘도` is highly overall correlated with `조도`	High correlation

Reproduction

Analysis started	2023-12-12 21:01:08.157373
Analysis finished	2023-12-12 21:01:18.536212
Duration	10.38 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

날짜
Real number (ℝ)

HIGH CORRELATION

Distinct	15
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20221109

Minimum	20221031
Maximum	20221118
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	20221031
5-th percentile	20221102
Q1	20221104
median	20221109
Q3	20221114
95-th percentile	20221117
Maximum	20221118
Range	87
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	10.572662
Coefficient of variation (CV)	5.2285273 × 10^-7
Kurtosis	39.055233
Mean	20221109
Median Absolute Deviation (MAD)	5
Skewness	-5.6463581
Sum	2.0221109 × 10¹¹
Variance	111.78118
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
20221109	1198	12.0%
20221111	1128	11.3%
20221108	926	9.3%
20221104	849	8.5%
20221103	839	8.4%
20221114	801	8.0%
20221116	801	8.0%
20221110	743	7.4%
20221117	670	6.7%
20221115	528	5.3%
Other values (5)	1517	15.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20221031	144	1.4%
20221101	232	2.3%
20221102	463	4.6%
20221103	839	8.4%
20221104	849	8.5%
20221107	370	3.7%
20221108	926	9.3%
20221109	1198	12.0%
20221110	743	7.4%
20221111	1128	11.3%

Value	Count	Frequency (%)
20221118	308	3.1%
20221117	670	6.7%
20221116	801	8.0%
20221115	528	5.3%
20221114	801	8.0%
20221111	1128	11.3%
20221110	743	7.4%
20221109	1198	12.0%
20221108	926	9.3%
20221107	370	3.7%

시간
Date

Distinct	241
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

Minimum	2023-12-13 17:49:00
Maximum	2023-12-13 21:50:00

Histogram

Histogram with fixed size bins (bins=50)

위도
Real number (ℝ)

HIGH CORRELATION

Distinct	9564
Distinct (%)	95.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.577014

Minimum	37.555532
Maximum	37.604909
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	37.555532
5-th percentile	37.559027
Q1	37.568953
median	37.577304
Q3	37.58408
95-th percentile	37.596435
Maximum	37.604909
Range	0.04937698
Interquartile range (IQR)	0.015127838

Descriptive statistics

Standard deviation	0.01091427
Coefficient of variation (CV)	0.00029045068
Kurtosis	-0.59878459
Mean	37.577014
Median Absolute Deviation (MAD)	0.00767912
Skewness	0.14655453
Sum	375770.14
Variance	0.00011912128
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
37.588729	5	0.1%
37.58589122	5	0.1%
37.584261	4	< 0.1%
37.58194311	4	< 0.1%
37.59974374	4	< 0.1%
37.591754	4	< 0.1%
37.58234012	3	< 0.1%
37.600242	3	< 0.1%
37.58194669	3	< 0.1%
37.58284801	3	< 0.1%
Other values (9554)	9962	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
37.55553186	1	< 0.1%
37.555593	1	< 0.1%
37.555684	1	< 0.1%
37.555725	1	< 0.1%
37.55579491	1	< 0.1%
37.55587738	1	< 0.1%
37.55592793	1	< 0.1%
37.55593982	1	< 0.1%
37.55594136	1	< 0.1%
37.5559499	1	< 0.1%

Value	Count	Frequency (%)
37.60490884	1	< 0.1%
37.60487231	1	< 0.1%
37.60485461	1	< 0.1%
37.60484594	1	< 0.1%
37.60467676	1	< 0.1%
37.60443461	1	< 0.1%
37.60433744	1	< 0.1%
37.603977	2	< 0.1%
37.60389258	1	< 0.1%
37.603641	1	< 0.1%

경도
Real number (ℝ)

Distinct	9572
Distinct (%)	95.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	126.93428

Minimum	126.90383
Maximum	126.96858
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	126.90383
5-th percentile	126.91229
Q1	126.92449
median	126.93302
Q3	126.94529
95-th percentile	126.95969
Maximum	126.96858
Range	0.0647493
Interquartile range (IQR)	0.0208009

Descriptive statistics

Standard deviation	0.014075283
Coefficient of variation (CV)	0.00011088638
Kurtosis	-0.61690728
Mean	126.93428
Median Absolute Deviation (MAD)	0.00999305
Skewness	0.23003705
Sum	1269342.8
Variance	0.0001981136
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
126.93565	5	0.1%
126.93491	4	< 0.1%
126.945087	4	< 0.1%
126.9142844	4	< 0.1%
126.933878	3	< 0.1%
126.9496	3	< 0.1%
126.959718	3	< 0.1%
126.94388	3	< 0.1%
126.950491	3	< 0.1%
126.923335	3	< 0.1%
Other values (9562)	9965	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
126.9038287	1	< 0.1%
126.9039355	1	< 0.1%
126.9040036	1	< 0.1%
126.9040559	1	< 0.1%
126.9041314	1	< 0.1%
126.9042853	1	< 0.1%
126.9043642	1	< 0.1%
126.904388	1	< 0.1%
126.9043971	1	< 0.1%
126.9045147	1	< 0.1%

Value	Count	Frequency (%)
126.968578	1	< 0.1%
126.9682183	1	< 0.1%
126.9680209	1	< 0.1%
126.968012	1	< 0.1%
126.9679935	1	< 0.1%
126.9678554	1	< 0.1%
126.9678362	1	< 0.1%
126.9677555	1	< 0.1%
126.9677173	1	< 0.1%
126.9677077	1	< 0.1%

조도
Real number (ℝ)

HIGH CORRELATION

Distinct	1391
Distinct (%)	13.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.307998

Minimum	0.05
Maximum	200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0.05
5-th percentile	0.6
Q1	9.9
median	28.2
Q3	52.2
95-th percentile	107.01
Maximum	200
Range	199.95
Interquartile range (IQR)	42.3

Descriptive statistics

Standard deviation	37.080402
Coefficient of variation (CV)	0.99389954
Kurtosis	4.0753475
Mean	37.307998
Median Absolute Deviation (MAD)	20.5
Skewness	1.7858723
Sum	373079.98
Variance	1374.9562
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.4	116	1.2%
0.5	99	1.0%
0.3	92	0.9%
0.6	88	0.9%
0.2	84	0.8%
0.7	80	0.8%
200.0	75	0.8%
1.2	68	0.7%
0.8	55	0.5%
1.5	51	0.5%
Other values (1381)	9192	91.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.05	1	< 0.1%
0.07	1	< 0.1%
0.1	17	0.2%
0.2	84	0.8%
0.23	1	< 0.1%
0.27	1	< 0.1%
0.28	1	< 0.1%
0.3	92	0.9%
0.36	1	< 0.1%
0.4	116	1.2%

Value	Count	Frequency (%)
200.0	75	0.8%
199.9	1	< 0.1%
199.8	1	< 0.1%
198.9	1	< 0.1%
198.7	1	< 0.1%
198.3	1	< 0.1%
198.2	1	< 0.1%
197.8	2	< 0.1%
196.0	1	< 0.1%
193.7	1	< 0.1%

휘도
Real number (ℝ)

HIGH CORRELATION

Distinct	637
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.204392

Minimum	0.01
Maximum	31.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.05
Q1	0.29
median	0.75
Q3	1.52
95-th percentile	3.99
Maximum	31.6
Range	31.59
Interquartile range (IQR)	1.23

Descriptive statistics

Standard deviation	1.5042676
Coefficient of variation (CV)	1.248985
Kurtosis	27.472703
Mean	1.204392
Median Absolute Deviation (MAD)	0.54
Skewness	3.6378547
Sum	12043.92
Variance	2.262821
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.04	145	1.5%
0.05	135	1.4%
0.06	125	1.2%
0.12	123	1.2%
0.03	111	1.1%
0.14	108	1.1%
0.02	106	1.1%
0.07	101	1.0%
0.17	95	0.9%
0.08	92	0.9%
Other values (627)	8859	88.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	70	0.7%
0.02	106	1.1%
0.03	111	1.1%
0.04	145	1.5%
0.05	135	1.4%
0.06	125	1.2%
0.07	101	1.0%
0.08	92	0.9%
0.09	75	0.8%
0.1	85	0.9%

Value	Count	Frequency (%)
31.6	1	< 0.1%
10.0	71	0.7%
9.95	1	< 0.1%
9.84	1	< 0.1%
9.8	1	< 0.1%
9.71	1	< 0.1%
9.62	2	< 0.1%
9.61	1	< 0.1%
9.55	1	< 0.1%
9.5	1	< 0.1%

달 위상
Real number (ℝ)

Distinct	8
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.72500667

Minimum	0.4
Maximum	1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0.4
5-th percentile	0.46666667
Q1	0.53333333
median	0.66666667
Q3	0.93333333
95-th percentile	1
Maximum	1
Range	0.6
Interquartile range (IQR)	0.4

Descriptive statistics

Standard deviation	0.19351649
Coefficient of variation (CV)	0.26691685
Kurtosis	-1.4512106
Mean	0.72500667
Median Absolute Deviation (MAD)	0.2
Skewness	0.017853362
Sum	7250.0667
Variance	0.037448634
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
0.933333333	1669	16.7%
0.666666667	1650	16.5%
0.866666667	1498	15.0%
0.6	1367	13.7%
0.533333333	1264	12.6%
1.0	1198	12.0%
0.466666667	902	9.0%
0.4	452	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.4	452	4.5%
0.466666667	902	9.0%
0.533333333	1264	12.6%
0.6	1367	13.7%
0.666666667	1650	16.5%
0.866666667	1498	15.0%
0.933333333	1669	16.7%
1.0	1198	12.0%

Value	Count	Frequency (%)
1.0	1198	12.0%
0.933333333	1669	16.7%
0.866666667	1498	15.0%
0.666666667	1650	16.5%
0.6	1367	13.7%
0.533333333	1264	12.6%
0.466666667	902	9.0%
0.4	452	4.5%

기온
Real number (ℝ)

Distinct	1811
Distinct (%)	18.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.496683

Minimum	4.6
Maximum	18.28
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	4.6
5-th percentile	5.9295
Q1	9.1166667
median	11.596667
Q3	13.22
95-th percentile	17.161667
Maximum	18.28
Range	13.68
Interquartile range (IQR)	4.1033333

Descriptive statistics

Standard deviation	3.0975511
Coefficient of variation (CV)	0.26942998
Kurtosis	-0.46505534
Mean	11.496683
Median Absolute Deviation (MAD)	2.2366667
Skewness	0.092225876
Sum	114966.83
Variance	9.5948229
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.42	26	0.3%
9.0	25	0.2%
12.18	24	0.2%
9.48	24	0.2%
9.45	24	0.2%
8.84	24	0.2%
12.84	23	0.2%
9.49	23	0.2%
12.06	22	0.2%
8.6	21	0.2%
Other values (1801)	9764	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.6	3	< 0.1%
4.61	5	0.1%
4.62	1	< 0.1%
4.63	4	< 0.1%
4.64	1	< 0.1%
4.65	3	< 0.1%
4.66	2	< 0.1%
4.67	3	< 0.1%
4.68	4	< 0.1%
4.69	1	< 0.1%

Value	Count	Frequency (%)
18.28	1	< 0.1%
18.26166667	6	0.1%
18.24333333	7	0.1%
18.225	9	0.1%
18.20666667	10	0.1%
18.18833333	11	0.1%
18.17	8	0.1%
18.15166667	7	0.1%
18.13333333	3	< 0.1%
18.115	4	< 0.1%

습도
Real number (ℝ)

Distinct	1331
Distinct (%)	13.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	62.591597

Minimum	29
Maximum	96.49881
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	29
5-th percentile	37.331667
Q1	56.4
median	63.583333
Q3	70.266667
95-th percentile	77.883333
Maximum	96.49881
Range	67.49881
Interquartile range (IQR)	13.866667

Descriptive statistics

Standard deviation	11.725272
Coefficient of variation (CV)	0.18732982
Kurtosis	0.88466149
Mean	62.591597
Median Absolute Deviation (MAD)	6.9833333
Skewness	-0.45895612
Sum	625915.97
Variance	137.48201
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
64.0	32	0.3%
58.8	31	0.3%
60.0	30	0.3%
49.13333333	29	0.3%
66.5	28	0.3%
69.0	28	0.3%
55.5	27	0.3%
59.8	26	0.3%
62.75	26	0.3%
64.5	26	0.3%
Other values (1321)	9717	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
29.0	2	< 0.1%
29.08333333	4	< 0.1%
29.16666667	3	< 0.1%
29.25	2	< 0.1%
29.33333333	2	< 0.1%
29.41666667	1	< 0.1%
29.5	3	< 0.1%
29.58333333	6	0.1%
29.66666667	2	< 0.1%
29.75	2	< 0.1%

Value	Count	Frequency (%)
96.49880952	1	< 0.1%
96.49761905	2	< 0.1%
96.49642857	1	< 0.1%
96.4952381	1	< 0.1%
96.49404762	2	< 0.1%
96.49285714	1	< 0.1%
96.49166667	1	< 0.1%
96.49047619	1	< 0.1%
96.48809524	2	< 0.1%
96.48690476	1	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	날짜	위도	경도	조도	휘도	달 위상	기온	습도
날짜	1.000	0.593	0.752	0.141	0.048	0.634	0.870	0.431
위도	0.593	1.000	0.755	0.261	0.093	0.655	0.737	0.670
경도	0.752	0.755	1.000	0.194	0.095	0.707	0.816	0.692
조도	0.141	0.261	0.194	1.000	0.561	0.098	0.146	0.125
휘도	0.048	0.093	0.095	0.561	1.000	0.081	0.124	0.095
달 위상	0.634	0.655	0.707	0.098	0.081	1.000	0.813	0.779
기온	0.870	0.737	0.816	0.146	0.124	0.813	1.000	0.933
습도	0.431	0.670	0.692	0.125	0.095	0.779	0.933	1.000

Heatmap
Table

	날짜	위도	경도	조도	휘도	달 위상	기온	습도
날짜	1.000	0.544	-0.224	-0.025	0.019	-0.204	0.055	0.109
위도	0.544	1.000	-0.029	-0.050	-0.065	-0.098	-0.139	0.036
경도	-0.224	-0.029	1.000	0.098	-0.044	-0.108	0.100	-0.091
조도	-0.025	-0.050	0.098	1.000	0.672	0.013	-0.024	-0.034
휘도	0.019	-0.065	-0.044	0.672	1.000	-0.034	-0.033	-0.001
달 위상	-0.204	-0.098	-0.108	0.013	-0.034	1.000	0.417	0.346
기온	0.055	-0.139	0.100	-0.024	-0.033	0.417	1.000	0.219
습도	0.109	0.036	-0.091	-0.034	-0.001	0.346	0.219	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

	날짜	시간	위도	경도	조도	휘도	달 위상	기온	습도
11199	20221117	18:54	37.576064	126.905098	10.8	0.68	0.466667	11.82	62.2
11850	20221117	20:11	37.602715	126.947873	29.2	0.25	0.466667	10.753333	69.366667
8689	20221114	19:25	37.577415	126.92275	8.3	0.51	0.666667	8.733333	65.083333
7987	20221111	20:23	37.578083	126.928039	7.6	0.2	0.866667	15.955	60.916667
2148	20221104	18:22	37.566882	126.951877	5.4	0.13	0.666667	6.87	30.833333
9081	20221114	20:57	37.571382	126.915413	51.8	3.41	0.666667	8.31	69.9
7246	20221111	18:42	37.571108	126.921567	31.2	1.37	0.866667	17.73	53.7
9616	20221115	19:08	37.583181	126.92353	22.0	1.39	0.6	9.42	74.933333
8156	20221111	21:04	37.577445	126.926175	2.3	0.15	0.866667	15.36	64.066667
1	20221031	18:38	37.562084	126.96225	64.1	0.26	0.4	10.420714	96.028571

	날짜	시간	위도	경도	조도	휘도	달 위상	기온	습도
44	20221031	19:10	37.560805	126.964446	23.9	0.33	0.4	10.439286	96.488095
4726	20221109	18:15	37.570924	126.931477	18.0	0.07	1.0	13.225	70.5
5606	20221109	21:11	37.576789	126.933078	34.5	1.14	1.0	11.608333	78.366667
10097	20221115	18:58	37.591374	126.94792	41.2	0.85	0.6	9.533333	73.9
6050	20221109	20:53	37.585578	126.922907	51.0	4.31	1.0	11.77	77.883333
9100	20221114	21:01	37.570672	126.913369	28.0	1.76	0.666667	8.288333	69.816667
7702	20221111	19:07	37.57891	126.930121	92.1	0.44	0.866667	17.271667	54.583333
4026	20221108	20:08	37.568123	126.918366	12.6	0.94	0.933333	12.18	67.533333
6982	20221110	18:38	37.569603	126.962192	43.5	1.73	0.933333	15.53	68.8
6070	20221109	21:00	37.585369	126.924951	3.6	0.86	1.0	11.7	78.0

Most frequently occurring

	날짜	시간	위도	경도	조도	휘도	달 위상	기온	습도	# duplicates
0	20221104	18:51	37.570506	126.945956	3.0	0.05	0.666667	6.435	33.25	2
1	20221108	18:36	37.568182	126.93256	6.8	0.2	0.933333	13.68	61.8	2
2	20221108	19:55	37.56758	126.923574	51.9	1.7	0.933333	12.375	66.666667	2
3	20221108	20:02	37.567197	126.923694	32.8	0.12	0.933333	12.27	67.133333	2
4	20221109	18:28	37.573541	126.935012	44.3	0.97	1.0	13.073333	70.933333	2

Overview

Variables

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring