gimi9 Pandas Profiling

Dataset statistics

Number of variables	7
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	693.4 KiB
Average record size in memory	71.0 B

Variable types

Categorical	2
Numeric	5

Dataset

Description	전입인구(전입지행정동, 전출지행정동, 연령, 성별, 전입사유, 인구수) 정보를 제공합니다.
Author	충청남도
URL	https://alldam.chungnam.go.kr/bigdata/collect/view.chungnam?menuCd=DOM_000000201001001000&apiIdx=94

Alerts

연령코드 has 129 (1.3%) zeros Zeros

Reproduction

Analysis started	2024-01-09 20:29:11.430144
Analysis finished	2024-01-09 20:29:14.888330
Duration	3.46 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

기준연월
Categorical

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

201002	5143
201001	4306
201003	551

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
201002	5143	51.4%
201001	4306	43.1%
201003	551	5.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
201002	5143	51.4%
201001	4306	43.1%
201003	551	5.5%

전입지행정동코드
Real number (ℝ)

Distinct	431
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.9957435 × 10⁹

Minimum	1.111 × 10⁹
Maximum	5.013 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1.111 × 10⁹
5-th percentile	1.156 × 10⁹
Q1	4.15 × 10⁹
median	4.413357 × 10⁹
Q3	4.423052 × 10⁹
95-th percentile	4.483032 × 10⁹
Maximum	5.013 × 10⁹
Range	3.902 × 10⁹
Interquartile range (IQR)	2.73052 × 10⁸

Descriptive statistics

Standard deviation	9.5503509 × 10⁸
Coefficient of variation (CV)	0.23901311
Kurtosis	3.4527696
Mean	3.9957435 × 10⁹
Median Absolute Deviation (MAD)	36357000
Skewness	-2.1642435
Sum	3.9957435 × 10¹³
Variance	9.1209202 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4413357000	290	2.9%
4413158000	258	2.6%
3017000000	203	2.0%
4413157000	202	2.0%
4483025000	200	2.0%
4413356000	199	2.0%
4420025300	193	1.9%
4473025000	160	1.6%
4413354000	158	1.6%
4425033000	137	1.4%
Other values (421)	8000	80.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1111000000	23	0.2%
1114000000	10	0.1%
1117000000	23	0.2%
1120000000	23	0.2%
1121500000	39	0.4%
1123000000	19	0.2%
1126000000	21	0.2%
1129000000	37	0.4%
1130500000	17	0.2%
1132000000	28	0.3%

Value	Count	Frequency (%)
5013000000	1	< 0.1%
5011000000	9	0.1%
4889000000	1	< 0.1%
4888000000	2	< 0.1%
4887000000	1	< 0.1%
4886000000	1	< 0.1%
4885000000	1	< 0.1%
4874000000	2	< 0.1%
4873000000	2	< 0.1%
4833000000	10	0.1%

전출지행정동코드
Real number (ℝ)

Distinct	425
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1267798 × 10⁹

Minimum	1.111 × 10⁹
Maximum	5.013 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	1.111 × 10⁹
5-th percentile	2.53915 × 10⁹
Q1	4.413125 × 10⁹
median	4.415057 × 10⁹
Q3	4.425033 × 10⁹
95-th percentile	4.483038 × 10⁹
Maximum	5.013 × 10⁹
Range	3.902 × 10⁹
Interquartile range (IQR)	11908000

Descriptive statistics

Standard deviation	8.0429849 × 10⁸
Coefficient of variation (CV)	0.19489736
Kurtosis	6.8952728
Mean	4.1267798 × 10⁹
Median Absolute Deviation (MAD)	9974500
Skewness	-2.7684991
Sum	4.1267798 × 10¹³
Variance	6.4689606 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4413357000	221	2.2%
4413159000	182	1.8%
4413354000	181	1.8%
4420025300	173	1.7%
3017000000	167	1.7%
4413356000	166	1.7%
4413157000	156	1.6%
4483025000	142	1.4%
4425033000	134	1.3%
3020000000	129	1.3%
Other values (415)	8349	83.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1111000000	10	0.1%
1114000000	5	0.1%
1117000000	8	0.1%
1120000000	16	0.2%
1121500000	18	0.2%
1123000000	16	0.2%
1126000000	14	0.1%
1129000000	26	0.3%
1130500000	10	0.1%
1132000000	13	0.1%

Value	Count	Frequency (%)
5013000000	2	< 0.1%
5011000000	17	0.2%
4888000000	2	< 0.1%
4887000000	3	< 0.1%
4885000000	3	< 0.1%
4884000000	1	< 0.1%
4882000000	3	< 0.1%
4874000000	1	< 0.1%
4873000000	4	< 0.1%
4833000000	13	0.1%

연령코드
Real number (ℝ)

ZEROS

Distinct	98
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.6004

Minimum	0
Maximum	100
Zeros	129
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	18
median	30
Q3	43
95-th percentile	67
Maximum	100
Range	100
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	18.609711
Coefficient of variation (CV)	0.58890746
Kurtosis	-0.026782755
Mean	31.6004
Median Absolute Deviation (MAD)	12
Skewness	0.48021359
Sum	316004
Variance	346.32135
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	302	3.0%
27	281	2.8%
29	275	2.8%
26	260	2.6%
30	232	2.3%
25	226	2.3%
12	212	2.1%
36	212	2.1%
35	208	2.1%
41	207	2.1%
Other values (88)	7585	75.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	129	1.3%
1	116	1.2%
2	131	1.3%
3	123	1.2%
4	123	1.2%
5	115	1.1%
6	205	2.1%
7	142	1.4%
8	142	1.4%
9	147	1.5%

Value	Count	Frequency (%)
100	1	< 0.1%
99	1	< 0.1%
97	1	< 0.1%
94	2	< 0.1%
93	2	< 0.1%
92	3	< 0.1%
91	3	< 0.1%
90	1	< 0.1%
89	3	< 0.1%
88	6	0.1%

성별코드
Categorical

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

1	5002
2	4998

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1	5002	50.0%
2	4998	50.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	5002	50.0%
2	4998	50.0%

전입사유코드
Real number (ℝ)

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

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

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	4
95-th percentile	9
Maximum	9
Range	8
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.9794165
Coefficient of variation (CV)	0.8176001
Kurtosis	-0.53910587
Mean	3.6441
Median Absolute Deviation (MAD)	2
Skewness	1.0396899
Sum	36441
Variance	8.8769229
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	2705	27.1%
3	2222	22.2%
2	2173	21.7%
9	2171	21.7%
4	572	5.7%
6	112	1.1%
5	45	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2705	27.1%
2	2173	21.7%
3	2222	22.2%
4	572	5.7%
5	45	0.4%
6	112	1.1%
9	2171	21.7%

Value	Count	Frequency (%)
9	2171	21.7%
6	112	1.1%
5	45	0.4%
4	572	5.7%
3	2222	22.2%
2	2173	21.7%
1	2705	27.1%

인구수
Real number (ℝ)

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

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

Quantile statistics

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

Descriptive statistics

Standard deviation	0.19273908
Coefficient of variation (CV)	0.18792812
Kurtosis	144.17812
Mean	1.0256
Median Absolute Deviation (MAD)	0
Skewness	10.21691
Sum	10256
Variance	0.037148355
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	9788	97.9%
2	180	1.8%
3	24	0.2%
4	5	0.1%
5	2	< 0.1%
6	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9788	97.9%
2	180	1.8%
3	24	0.2%
4	5	0.1%
5	2	< 0.1%
6	1	< 0.1%

Value	Count	Frequency (%)
6	1	< 0.1%
5	2	< 0.1%
4	5	0.1%
3	24	0.2%
2	180	1.8%
1	9788	97.9%

Heatmap
Table

	기준연월	전입지행정동코드	전출지행정동코드	연령코드	성별코드	전입사유코드	인구수
기준연월	1.000	0.477	0.148	0.118	0.008	0.080	0.011
전입지행정동코드	0.477	1.000	0.400	0.092	0.011	0.121	0.042
전출지행정동코드	0.148	0.400	1.000	0.080	0.004	0.220	0.000
연령코드	0.118	0.092	0.080	1.000	0.119	0.245	0.053
성별코드	0.008	0.011	0.004	0.119	1.000	0.088	0.028
전입사유코드	0.080	0.121	0.220	0.245	0.088	1.000	0.053
인구수	0.011	0.042	0.000	0.053	0.028	0.053	1.000

Heatmap
Table

	성별코드	기준연월
성별코드	1.000	0.014
기준연월	0.014	1.000

Heatmap
Table

	전입지행정동코드	전출지행정동코드	연령코드	전입사유코드	인구수	기준연월	성별코드
전입지행정동코드	1.000	-0.105	0.011	-0.041	0.032	0.367	0.009
전출지행정동코드	-0.105	1.000	-0.029	0.008	-0.007	0.100	0.004
연령코드	0.011	-0.029	1.000	0.032	-0.058	0.065	0.094
전입사유코드	-0.041	0.008	0.032	1.000	0.037	0.053	0.094
인구수	0.032	-0.007	-0.058	0.037	1.000	0.004	0.020
기준연월	0.367	0.100	0.065	0.053	0.004	1.000	0.014
성별코드	0.009	0.004	0.094	0.094	0.020	0.014	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

	기준연월	전입지행정동코드	전출지행정동코드	연령코드	성별코드	전입사유코드	인구수
60291	201002	4415057000	4415055000	8	1	2	1
37721	201002	1132000000	4480025300	10	1	2	1
47437	201002	4165000000	4425033000	18	1	9	1
73587	201002	4473036000	4413152000	58	2	1	1
23678	201001	4420061000	4420059000	2	1	3	2
81763	201003	1120000000	4471032000	20	2	1	1
36029	201001	4518000000	4413352000	30	2	9	1
24381	201001	4421031000	4421051000	7	2	4	1
50570	201002	4413156000	4413351000	36	1	1	1
43967	201002	4111700000	4471037000	50	2	2	1

	기준연월	전입지행정동코드	전출지행정동코드	연령코드	성별코드	전입사유코드	인구수
46103	201002	4139000000	4418036000	26	1	9	1
37839	201002	1135000000	4480035000	3	2	3	1
4443	201001	3017000000	4476032000	55	2	3	1
84246	201003	1174000000	4413159000	54	1	1	1
32905	201001	4481032000	4481035000	51	2	1	1
26033	201001	4421055000	4141000000	3	2	1	1
68992	201002	4423031000	4423025000	48	1	2	1
5632	201001	4113100000	4420025300	23	2	1	1
469	201001	1129000000	4415057000	21	1	9	1
36019	201001	4514000000	4481025000	26	2	9	1

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample