gimi9 Pandas Profiling

Dataset statistics

Number of variables	8
Number of observations	10000
Missing cells	10000
Missing cells (%)	12.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	771.5 KiB
Average record size in memory	79.0 B

Variable types

Numeric	5
Categorical	2
Unsupported	1

Dataset

Description	경기도_BMS 공통일자 정보
Author	경기도
URL	https://data.gg.go.kr/portal/data/service/selectServicePage.do?&infId=Z5AMQ5BX3QVVO7RGOLH333026625&infSeq=1

Alerts

`연도` is highly overall correlated with `연월일`	High correlation
`연월일` is highly overall correlated with `연도`	High correlation
`요일순번` is highly overall correlated with `요일` and 1 other fields	High correlation
`요일` is highly overall correlated with `요일순번` and 1 other fields	High correlation
`휴일여부` is highly overall correlated with `요일순번` and 1 other fields	High correlation
`휴일여부명` has 10000 (100.0%) missing values	Missing
`연월일` has unique values	Unique
`휴일여부명` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-12-10 22:28:05.173781
Analysis finished	2023-12-10 22:28:09.127462
Duration	3.95 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연도
Real number (ℝ)

HIGH CORRELATION

Distinct	31
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2014.9793

Minimum	2000
Maximum	2030
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	2000
5-th percentile	2001
Q1	2007
median	2015
Q3	2023
95-th percentile	2029
Maximum	2030
Range	30
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	8.928821
Coefficient of variation (CV)	0.0044312222
Kurtosis	-1.1965978
Mean	2014.9793
Median Absolute Deviation (MAD)	8
Skewness	0.00033060113
Sum	20149793
Variance	79.723844
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
2014	340	3.4%
2017	330	3.3%
2018	330	3.3%
2000	329	3.3%
2026	328	3.3%
2008	327	3.3%
2010	327	3.3%
2024	327	3.3%
2022	327	3.3%
2002	326	3.3%
Other values (21)	6709	67.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2000	329	3.3%
2001	322	3.2%
2002	326	3.3%
2003	313	3.1%
2004	319	3.2%
2005	323	3.2%
2006	321	3.2%
2007	319	3.2%
2008	327	3.3%
2009	323	3.2%

Value	Count	Frequency (%)
2030	318	3.2%
2029	318	3.2%
2028	321	3.2%
2027	313	3.1%
2026	328	3.3%
2025	318	3.2%
2024	327	3.3%
2023	325	3.2%
2022	327	3.3%
2021	314	3.1%

월
Real number (ℝ)

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5282

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

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	10
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4495209
Coefficient of variation (CV)	0.52840307
Kurtosis	-1.2052583
Mean	6.5282
Median Absolute Deviation (MAD)	3
Skewness	-0.0038003324
Sum	65282
Variance	11.899195
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
12	869	8.7%
7	852	8.5%
5	845	8.5%
3	841	8.4%
8	840	8.4%
10	839	8.4%
1	839	8.4%
6	839	8.4%
4	837	8.4%
11	819	8.2%
Other values (2)	1580	15.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	839	8.4%
2	774	7.7%
3	841	8.4%
4	837	8.4%
5	845	8.5%
6	839	8.4%
7	852	8.5%
8	840	8.4%
9	806	8.1%
10	839	8.4%

Value	Count	Frequency (%)
12	869	8.7%
11	819	8.2%
10	839	8.4%
9	806	8.1%
8	840	8.4%
7	852	8.5%
6	839	8.4%
5	845	8.5%
4	837	8.4%
3	841	8.4%

일
Real number (ℝ)

Distinct	31
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.6627

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

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7986516
Coefficient of variation (CV)	0.56175829
Kurtosis	-1.1915853
Mean	15.6627
Median Absolute Deviation (MAD)	8
Skewness	0.015663845
Sum	156627
Variance	77.41627
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	343	3.4%
17	339	3.4%
6	338	3.4%
8	337	3.4%
13	335	3.4%
5	335	3.4%
9	334	3.3%
26	334	3.3%
24	333	3.3%
2	333	3.3%
Other values (21)	6639	66.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	343	3.4%
2	333	3.3%
3	314	3.1%
4	330	3.3%
5	335	3.4%
6	338	3.4%
7	321	3.2%
8	337	3.4%
9	334	3.3%
10	325	3.2%

Value	Count	Frequency (%)
31	196	2.0%
30	291	2.9%
29	299	3.0%
28	324	3.2%
27	324	3.2%
26	334	3.3%
25	324	3.2%
24	333	3.3%
23	332	3.3%
22	321	3.2%

연월일
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	10000
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20150461

Minimum	20000101
Maximum	20301230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	20000101
5-th percentile	20010711
Q1	20071015
median	20150618
Q3	20230315
95-th percentile	20290601
Maximum	20301230
Range	301129
Interquartile range (IQR)	159300.5

Descriptive statistics

Standard deviation	89288.071
Coefficient of variation (CV)	0.0044310683
Kurtosis	-1.1965249
Mean	20150461
Median Absolute Deviation (MAD)	79650
Skewness	0.00033144059
Sum	2.0150461 × 10¹¹
Variance	7.9723596 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20271206	1	< 0.1%
20190706	1	< 0.1%
20000116	1	< 0.1%
20100906	1	< 0.1%
20170808	1	< 0.1%
20081028	1	< 0.1%
20071018	1	< 0.1%
20190811	1	< 0.1%
20100116	1	< 0.1%
20120522	1	< 0.1%
Other values (9990)	9990	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20000101	1	< 0.1%
20000102	1	< 0.1%
20000103	1	< 0.1%
20000105	1	< 0.1%
20000107	1	< 0.1%
20000108	1	< 0.1%
20000109	1	< 0.1%
20000110	1	< 0.1%
20000111	1	< 0.1%
20000112	1	< 0.1%

Value	Count	Frequency (%)
20301230	1	< 0.1%
20301229	1	< 0.1%
20301228	1	< 0.1%
20301227	1	< 0.1%
20301226	1	< 0.1%
20301225	1	< 0.1%
20301224	1	< 0.1%
20301223	1	< 0.1%
20301222	1	< 0.1%
20301221	1	< 0.1%

요일순번
Real number (ℝ)

HIGH CORRELATION

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9924

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

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	6
95-th percentile	7
Maximum	7
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.0039321
Coefficient of variation (CV)	0.5019367
Kurtosis	-1.2538323
Mean	3.9924
Median Absolute Deviation (MAD)	2
Skewness	0.0075265714
Sum	39924
Variance	4.0157438
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	1445	14.4%
1	1439	14.4%
7	1437	14.4%
4	1431	14.3%
3	1421	14.2%
6	1414	14.1%
5	1413	14.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1439	14.4%
2	1445	14.4%
3	1421	14.2%
4	1431	14.3%
5	1413	14.1%
6	1414	14.1%
7	1437	14.4%

Value	Count	Frequency (%)
7	1437	14.4%
6	1414	14.1%
5	1413	14.1%
4	1431	14.3%
3	1421	14.2%
2	1445	14.4%
1	1439	14.4%

요일
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

월	1445
일	1439
토	1437
수	1431
화	1421
Other values (2)	2827

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	월
2nd row	일
3rd row	수
4th row	토
5th row	일

Common Values

Value	Count	Frequency (%)
월	1445	14.4%
일	1439	14.4%
토	1437	14.4%
수	1431	14.3%
화	1421	14.2%
금	1414	14.1%
목	1413	14.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
월	1445	14.4%
일	1439	14.4%
토	1437	14.4%
수	1431	14.3%
화	1421	14.2%
금	1414	14.1%
목	1413	14.1%

휴일여부
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	156.2 KiB

8	7040
7	1426
1	1425
9	109

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
8	7040	70.4%
7	1426	14.3%
1	1425	14.2%
9	109	1.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
8	7040	70.4%
7	1426	14.3%
1	1425	14.2%
9	109	1.1%

휴일여부명
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	10000
Missing (%)	100.0%
Memory size	166.0 KiB

Heatmap
Table

	연도	월	일	연월일	요일순번	요일	휴일여부
연도	1.000	0.000	0.000	0.994	0.000	0.000	0.151
월	0.000	1.000	0.000	0.009	0.000	0.000	0.060
일	0.000	0.000	1.000	0.000	0.000	0.000	0.045
연월일	0.994	0.009	0.000	1.000	0.000	0.000	0.151
요일순번	0.000	0.000	0.000	0.000	1.000	1.000	0.874
요일	0.000	0.000	0.000	0.000	1.000	1.000	0.874
휴일여부	0.151	0.060	0.045	0.151	0.874	0.874	1.000

Heatmap
Table

	휴일여부	요일
휴일여부	1.000	0.813
요일	0.813	1.000

Heatmap
Table

	연도	월	일	연월일	요일순번	요일	휴일여부
연도	1.000	-0.002	-0.005	0.999	-0.001	0.000	0.091
월	-0.002	1.000	0.012	0.030	-0.001	0.000	0.036
일	-0.005	0.012	1.000	-0.002	-0.001	0.000	0.018
연월일	0.999	0.030	-0.002	1.000	-0.002	0.000	0.091
요일순번	-0.001	-0.001	-0.001	-0.002	1.000	1.000	0.813
요일	0.000	0.000	0.000	0.000	1.000	1.000	0.813
휴일여부	0.091	0.036	0.018	0.091	0.813	0.813	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

	연도	월	일	연월일	요일순번	요일	휴일여부	휴일여부명
6293	2027	12	6	20271206	2	월	8	<NA>
7616	2000	10	15	20001015	1	일	1	<NA>
8175	2015	7	22	20150722	4	수	8	<NA>
7791	2030	8	10	20300810	7	토	7	<NA>
637	2014	1	5	20140105	1	일	1	<NA>
6509	2028	7	24	20280724	2	월	8	<NA>
267	2012	12	8	20121208	7	토	7	<NA>
9782	2020	3	24	20200324	3	화	8	<NA>
8880	2017	8	7	20170807	2	월	8	<NA>
9526	2019	6	24	20190624	2	월	8	<NA>

	연도	월	일	연월일	요일순번	요일	휴일여부	휴일여부명
5389	2004	4	13	20040413	3	화	8	<NA>
9226	2018	8	10	20180810	6	금	8	<NA>
3966	2021	3	1	20210301	2	월	9	<NA>
6322	2028	1	4	20280104	3	화	8	<NA>
3292	2025	7	9	20250709	4	수	8	<NA>
1515	2011	1	31	20110131	2	월	8	<NA>
5560	2004	10	10	20041010	1	일	1	<NA>
4261	2000	12	30	20001230	7	토	7	<NA>
2895	2024	5	19	20240519	1	일	1	<NA>
4161	2000	9	12	20000912	3	화	8	<NA>

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample