gimi9 Pandas Profiling

Dataset statistics

Number of variables	10
Number of observations	440
Missing cells	440
Missing cells (%)	10.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	37.9 KiB
Average record size in memory	88.3 B

Variable types

Numeric	7
Categorical	2
Unsupported	1

Dataset

Description	연령별 경제활동인구 분기별 현황입니다. 연령, 시도명, 생산가능인구, 경제활동인구, 비경제활동인구수, 경제활동참가율, 고용률 정보를 제공합니다.
Author	충청남도
URL	https://alldam.chungnam.go.kr/bigdata/collect/view.chungnam?menuCd=DOM_000000201001001000&apiIdx=139

Alerts

`승인상태(W : 대기` has constant value ""	Constant
`15세이상 생산가능인구(천명)` is highly overall correlated with `경제활동인구(천명)` and 2 other fields	High correlation
`경제활동인구(천명)` is highly overall correlated with `15세이상 생산가능인구(천명)` and 2 other fields	High correlation
`비경제활동인구수(천명)` is highly overall correlated with `15세이상 생산가능인구(천명)` and 2 other fields	High correlation
`경제활동참가율` is highly overall correlated with `고용률`	High correlation
`고용률` is highly overall correlated with `경제활동참가율`	High correlation
`시도명` is highly overall correlated with `15세이상 생산가능인구(천명)` and 2 other fields	High correlation
`S : 승인)` has 440 (100.0%) missing values	Missing
`S : 승인)` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`연령구분` has 44 (10.0%) zeros	Zeros

Reproduction

Analysis started	2024-01-09 22:05:58.456402
Analysis finished	2024-01-09 22:06:02.779375
Duration	4.32 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

기준분기
Real number (ℝ)

Distinct	22
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	202029.68

Minimum	201801
Maximum	202302
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	201801
5-th percentile	201802
Q1	201902
median	202003.5
Q3	202201
95-th percentile	202301
Maximum	202302
Range	501
Interquartile range (IQR)	299

Descriptive statistics

Standard deviation	160.09291
Coefficient of variation (CV)	0.00079242271
Kurtosis	-1.171088
Mean	202029.68
Median Absolute Deviation (MAD)	102
Skewness	0.079696598
Sum	88893060
Variance	25629.739
Monotonicity	Increasing

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
201801	20	4.5%
202101	20	4.5%
202302	20	4.5%
202301	20	4.5%
202204	20	4.5%
202203	20	4.5%
202202	20	4.5%
202201	20	4.5%
202104	20	4.5%
202103	20	4.5%
Other values (12)	240	54.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201801	20	4.5%
201802	20	4.5%
201803	20	4.5%
201804	20	4.5%
201901	20	4.5%
201902	20	4.5%
201903	20	4.5%
201904	20	4.5%
202001	20	4.5%
202002	20	4.5%

Value	Count	Frequency (%)
202302	20	4.5%
202301	20	4.5%
202204	20	4.5%
202203	20	4.5%
202202	20	4.5%
202201	20	4.5%
202104	20	4.5%
202103	20	4.5%
202102	20	4.5%
202101	20	4.5%

연령구분
Real number (ℝ)

ZEROS

Distinct	10
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.8

Minimum	0
Maximum	75
Zeros	44
Zeros (%)	10.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	20
median	45
Q3	63
95-th percentile	75
Maximum	75
Range	75
Interquartile range (IQR)	43

Descriptive statistics

Standard deviation	24.770031
Coefficient of variation (CV)	0.59258448
Kurtosis	-1.2704432
Mean	41.8
Median Absolute Deviation (MAD)	21.5
Skewness	-0.27873412
Sum	18392
Variance	613.55444
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	44	10.0%
10	44	10.0%
20	44	10.0%
30	44	10.0%
40	44	10.0%
50	44	10.0%
60	44	10.0%
63	44	10.0%
70	44	10.0%
75	44	10.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	44	10.0%
10	44	10.0%
20	44	10.0%
30	44	10.0%
40	44	10.0%
50	44	10.0%
60	44	10.0%
63	44	10.0%
70	44	10.0%
75	44	10.0%

Value	Count	Frequency (%)
75	44	10.0%
70	44	10.0%
63	44	10.0%
60	44	10.0%
50	44	10.0%
40	44	10.0%
30	44	10.0%
20	44	10.0%
10	44	10.0%
0	44	10.0%

시도명
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	3.6 KiB

계	220
충청남도	220

Length

Max length	4
Median length	2.5
Mean length	2.5
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 (%)
계	220	50.0%
충청남도	220	50.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
계	220	50.0%
충청남도	220	50.0%

15세이상 생산가능인구(천명)
Real number (ℝ)

HIGH CORRELATION

Distinct	434
Distinct (%)	98.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7309.6959

Minimum	95.5
Maximum	45377.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	95.5
5-th percentile	200.59
Q1	333.85
median	2080.45
Q3	8424.65
95-th percentile	37182.66
Maximum	45377.9
Range	45282.4
Interquartile range (IQR)	8090.8

Descriptive statistics

Standard deviation	11790.819
Coefficient of variation (CV)	1.6130382
Kurtosis	4.1645595
Mean	7309.6959
Median Absolute Deviation (MAD)	1918.65
Skewness	2.2933256
Sum	3216266.2
Variance	1.3902341 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
332.0	2	0.5%
331.7	2	0.5%
338.2	2	0.5%
332.5	2	0.5%
339.4	2	0.5%
269.5	2	0.5%
266.2	1	0.2%
8743.6	1	0.2%
1893.2	1	0.2%
97.0	1	0.2%
Other values (424)	424	96.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
95.5	1	0.2%
95.6	1	0.2%
95.9	1	0.2%
96.0	1	0.2%
96.6	1	0.2%
97.0	1	0.2%
97.1	1	0.2%
97.5	1	0.2%
97.8	1	0.2%
99.4	1	0.2%

Value	Count	Frequency (%)
45377.9	1	0.2%
45357.9	1	0.2%
45317.1	1	0.2%
45270.5	1	0.2%
45242.3	1	0.2%
45210.6	1	0.2%
45178.4	1	0.2%
45106.0	1	0.2%
45048.2	1	0.2%
44987.4	1	0.2%

경제활동인구(천명)
Real number (ℝ)

HIGH CORRELATION

Distinct	431
Distinct (%)	98.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4583.1509

Minimum	5.1
Maximum	29492.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	5.1
5-th percentile	51.46
Q1	224.225
median	1122.05
Q3	5476.975
95-th percentile	25886.715
Maximum	29492.5
Range	29487.4
Interquartile range (IQR)	5252.75

Descriptive statistics

Standard deviation	7805.6397
Coefficient of variation (CV)	1.7031165
Kurtosis	3.9787973
Mean	4583.1509
Median Absolute Deviation (MAD)	1001.95
Skewness	2.2871015
Sum	2016586.4
Variance	60928011
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.3	2	0.5%
276.4	2	0.5%
162.2	2	0.5%
7.8	2	0.5%
6.2	2	0.5%
283.1	2	0.5%
257.9	2	0.5%
267.7	2	0.5%
281.1	2	0.5%
274.8	1	0.2%
Other values (421)	421	95.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.1	1	0.2%
5.2	1	0.2%
5.9	1	0.2%
6.2	2	0.5%
6.5	1	0.2%
7.1	1	0.2%
7.3	2	0.5%
7.8	2	0.5%
7.9	1	0.2%
8.6	1	0.2%

Value	Count	Frequency (%)
29492.5	1	0.2%
29227.4	1	0.2%
29142.7	1	0.2%
28956.8	1	0.2%
28684.5	1	0.2%
28596.0	1	0.2%
28451.1	1	0.2%
28444.7	1	0.2%
28431.9	1	0.2%
28359.5	1	0.2%

비경제활동인구수(천명)
Real number (ℝ)

HIGH CORRELATION

Distinct	426
Distinct (%)	96.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2726.5441

Minimum	44.5
Maximum	17239.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	44.5
5-th percentile	59.475
Q1	137.8
median	1009.05
Q3	2767.75
95-th percentile	11881.06
Maximum	17239.4
Range	17194.9
Interquartile range (IQR)	2629.95

Descriptive statistics

Standard deviation	4179.158
Coefficient of variation (CV)	1.5327674
Kurtosis	3.9164406
Mean	2726.5441
Median Absolute Deviation (MAD)	937.4
Skewness	2.1468719
Sum	1199679.4
Variance	17465362
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
97.4	5	1.1%
62.1	2	0.5%
68.7	2	0.5%
101.3	2	0.5%
198.7	2	0.5%
62.0	2	0.5%
69.8	2	0.5%
102.8	2	0.5%
86.1	2	0.5%
107.7	2	0.5%
Other values (416)	417	94.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
44.5	1	0.2%
48.6	1	0.2%
49.6	1	0.2%
49.7	1	0.2%
50.6	1	0.2%
50.7	1	0.2%
51.4	1	0.2%
51.9	1	0.2%
52.4	1	0.2%
52.8	1	0.2%

Value	Count	Frequency (%)
17239.4	1	0.2%
16888.8	1	0.2%
16851.0	1	0.2%
16781.2	1	0.2%
16744.2	1	0.2%
16733.7	1	0.2%
16676.8	1	0.2%
16673.4	1	0.2%
16668.2	1	0.2%
16654.9	1	0.2%

경제활동참가율
Real number (ℝ)

HIGH CORRELATION

Distinct	271
Distinct (%)	61.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.847045

Minimum	5.1
Maximum	85.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	5.1
5-th percentile	7.995
Q1	44.775
median	63.5
Q3	77.425
95-th percentile	81.705
Maximum	85.1
Range	80
Interquartile range (IQR)	32.65

Descriptive statistics

Standard deviation	22.744424
Coefficient of variation (CV)	0.40009861
Kurtosis	-0.30666887
Mean	56.847045
Median Absolute Deviation (MAD)	15.4
Skewness	-0.85530986
Sum	25012.7
Variance	517.30883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
80.0	5	1.1%
79.8	5	1.1%
77.8	5	1.1%
62.4	5	1.1%
77.5	4	0.9%
79.7	4	0.9%
65.8	4	0.9%
78.0	4	0.9%
46.8	4	0.9%
78.2	4	0.9%
Other values (261)	396	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.1	1	0.2%
5.2	1	0.2%
6.1	1	0.2%
6.3	2	0.5%
6.4	2	0.5%
6.9	3	0.7%
7.1	2	0.5%
7.2	2	0.5%
7.4	2	0.5%
7.5	2	0.5%

Value	Count	Frequency (%)
85.1	1	0.2%
84.7	1	0.2%
84.6	1	0.2%
84.4	1	0.2%
84.3	1	0.2%
84.2	1	0.2%
84.1	1	0.2%
83.5	1	0.2%
82.9	2	0.5%
82.8	1	0.2%

고용률
Real number (ℝ)

HIGH CORRELATION

Distinct	277
Distinct (%)	63.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.550227

Minimum	4.6
Maximum	83.4
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	4.6
5-th percentile	7.2
Q1	42.475
median	60
Q3	75.225
95-th percentile	80.11
Maximum	83.4
Range	78.8
Interquartile range (IQR)	32.75

Descriptive statistics

Standard deviation	22.560754
Coefficient of variation (CV)	0.41357763
Kurtosis	-0.45908169
Mean	54.550227
Median Absolute Deviation (MAD)	16.1
Skewness	-0.76776368
Sum	24002.1
Variance	508.98761
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
75.7	7	1.6%
78.4	5	1.1%
78.3	5	1.1%
80.5	4	0.9%
76.5	4	0.9%
42.6	4	0.9%
27.7	4	0.9%
6.3	4	0.9%
78.8	4	0.9%
77.6	4	0.9%
Other values (267)	395	89.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.6	1	0.2%
5.2	1	0.2%
5.4	1	0.2%
5.9	2	0.5%
6.0	1	0.2%
6.1	1	0.2%
6.3	4	0.9%
6.4	1	0.2%
6.7	2	0.5%
6.8	2	0.5%

Value	Count	Frequency (%)
83.4	1	0.2%
83.3	1	0.2%
83.0	2	0.5%
82.8	1	0.2%
82.6	1	0.2%
82.3	1	0.2%
82.0	1	0.2%
81.7	1	0.2%
81.5	1	0.2%
81.2	2	0.5%

승인상태(W : 대기
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	3.6 KiB

S	440

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
S	440	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
s	440	100.0%

S : 승인)
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	440
Missing (%)	100.0%
Memory size	4.0 KiB

Phik (φk)
Auto

Heatmap
Table

	기준분기	연령구분	시도명	15세이상 생산가능인구(천명)	경제활동인구(천명)	비경제활동인구수(천명)	경제활동참가율	고용률
기준분기	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
연령구분	0.000	1.000	0.000	0.794	0.786	0.781	0.963	0.960
시도명	0.000	0.000	1.000	0.988	0.682	0.952	0.117	0.000
15세이상 생산가능인구(천명)	0.000	0.794	0.988	1.000	0.897	0.926	0.688	0.669
경제활동인구(천명)	0.000	0.786	0.682	0.897	1.000	0.872	0.621	0.619
비경제활동인구수(천명)	0.000	0.781	0.952	0.926	0.872	1.000	0.677	0.636
경제활동참가율	0.000	0.963	0.117	0.688	0.621	0.677	1.000	0.985
고용률	0.000	0.960	0.000	0.669	0.619	0.636	0.985	1.000

Heatmap
Table

	기준분기	연령구분	15세이상 생산가능인구(천명)	경제활동인구(천명)	비경제활동인구수(천명)	경제활동참가율	고용률	시도명
기준분기	1.000	0.000	-0.018	-0.012	-0.019	0.013	0.040	0.000
연령구분	0.000	1.000	0.067	0.012	0.081	-0.122	-0.132	0.000
15세이상 생산가능인구(천명)	-0.018	0.067	1.000	0.927	0.910	0.105	0.115	0.899
경제활동인구(천명)	-0.012	0.012	0.927	1.000	0.747	0.393	0.403	0.812
비경제활동인구수(천명)	-0.019	0.081	0.910	0.747	1.000	-0.275	-0.266	0.804
경제활동참가율	0.013	-0.122	0.105	0.393	-0.275	1.000	0.996	0.133
고용률	0.040	-0.132	0.115	0.403	-0.266	0.996	1.000	0.000
시도명	0.000	0.000	0.899	0.812	0.804	0.133	0.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

	기준분기	연령구분	시도명	15세이상 생산가능인구(천명)	경제활동인구(천명)	비경제활동인구수(천명)	경제활동참가율	고용률	승인상태(W : 대기	S : 승인)
0	201801	0	계	44088.4	27464.0	16624.4	62.3	59.6	S	<NA>
1	201801	10	계	2817.9	255.2	2562.7	9.1	8.0	S	<NA>
2	201801	20	계	6379.6	4054.4	2325.2	63.6	57.2	S	<NA>
3	201801	30	계	7420.5	5797.8	1622.7	78.1	75.6	S	<NA>
4	201801	40	계	8483.5	6849.2	1634.3	80.7	78.7	S	<NA>
5	201801	50	계	8411.7	6411.3	2000.4	76.2	74.3	S	<NA>
6	201801	60	계	10575.2	4096.1	6479.1	38.7	36.6	S	<NA>
7	201801	63	계	36819.2	25346.6	11472.6	68.8	66.0	S	<NA>
8	201801	70	계	5799.3	1728.5	4070.8	29.8	26.3	S	<NA>
9	201801	75	계	9197.5	4309.6	4887.9	46.9	42.1	S	<NA>

	기준분기	연령구분	시도명	15세이상 생산가능인구(천명)	경제활동인구(천명)	비경제활동인구수(천명)	경제활동참가율	고용률	승인상태(W : 대기	S : 승인)
430	202302	0	충청남도	1923.0	1309.6	613.4	68.1	66.5	S	<NA>
431	202302	10	충청남도	97.5	6.2	91.4	6.4	6.4	S	<NA>
432	202302	20	충청남도	254.8	170.0	84.8	66.7	61.0	S	<NA>
433	202302	30	충청남도	277.3	226.8	50.6	81.8	80.5	S	<NA>
434	202302	40	충청남도	331.9	267.7	64.2	80.7	79.2	S	<NA>
435	202302	50	충청남도	344.4	277.1	67.3	80.5	79.1	S	<NA>
436	202302	60	충청남도	617.1	361.9	255.2	58.6	58.0	S	<NA>
437	202302	63	충청남도	1484.9	1076.8	408.0	72.5	70.5	S	<NA>
438	202302	70	충청남도	204.9	58.8	146.1	28.7	26.2	S	<NA>
439	202302	75	충청남도	352.3	176.1	176.1	50.0	45.9	S	<NA>

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample