gimi9 Pandas Profiling

Dataset statistics

Number of variables	5
Number of observations	80
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.6 KiB
Average record size in memory	45.6 B

Variable types

DateTime	1
Numeric	4

Dataset

Description	인천광역시 남동구 독거노인수에 대한 데이터로 남동구 전체인구수, 65세 이상 인구수, 65세 이상 인구비율, 독거노인수 등을 제공합니다.
Author	인천광역시 남동구
URL	https://data.incheon.go.kr/findData/publicDataDetail?dataId=15113333&srcSe=7661IVAWM27C61E190

Alerts

`남동구 전체인구수(명)` is highly overall correlated with `65세 이상 인구수(명)` and 2 other fields	High correlation
`65세 이상 인구수(명)` is highly overall correlated with `남동구 전체인구수(명)` and 2 other fields	High correlation
`65세 이상 인구비율(퍼센트)` is highly overall correlated with `남동구 전체인구수(명)` and 2 other fields	High correlation
`독거노인수(명)` is highly overall correlated with `남동구 전체인구수(명)` and 2 other fields	High correlation
`기준일` has unique values	Unique
`65세 이상 인구수(명)` has unique values	Unique

Reproduction

Analysis started	2024-03-18 05:11:29.303218
Analysis finished	2024-03-18 05:11:32.337106
Duration	3.03 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

기준일
Date

UNIQUE

Distinct	80
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	772.0 B

Minimum	2017-01-31 00:00:00
Maximum	2023-08-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

남동구 전체인구수(명)
Real number (ℝ)

HIGH CORRELATION

Distinct	78
Distinct (%)	97.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	525442.04

Minimum	497181
Maximum	538976
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	852.0 B

Quantile statistics

Minimum	497181
5-th percentile	501433.65
Q1	518177.5
median	531075.5
Q3	535600.25
95-th percentile	538575.05
Maximum	538976
Range	41795
Interquartile range (IQR)	17422.75

Descriptive statistics

Standard deviation	12108.51
Coefficient of variation (CV)	0.023044425
Kurtosis	-0.50426773
Mean	525442.04
Median Absolute Deviation (MAD)	6570
Skewness	-0.82866354
Sum	42035363
Variance	1.4661601 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
531526	2	2.5%
532257	2	2.5%
531364	1	1.2%
521719	1	1.2%
518272	1	1.2%
518372	1	1.2%
518662	1	1.2%
518988	1	1.2%
519667	1	1.2%
520683	1	1.2%
Other values (68)	68	85.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
497181	1	1.2%
498379	1	1.2%
499891	1	1.2%
500534	1	1.2%
501481	1	1.2%
502526	1	1.2%
503689	1	1.2%
505213	1	1.2%
506181	1	1.2%
506911	1	1.2%

Value	Count	Frequency (%)
538976	1	1.2%
538936	1	1.2%
538847	1	1.2%
538709	1	1.2%
538568	1	1.2%
538360	1	1.2%
538352	1	1.2%
537923	1	1.2%
537795	1	1.2%
537496	1	1.2%

65세 이상 인구수(명)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	80
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	68662.875

Minimum	54389
Maximum	83797
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	852.0 B

Quantile statistics

Minimum	54389
5-th percentile	56032.75
Q1	61363.5
median	68862.5
Q3	75774.25
95-th percentile	82129.85
Maximum	83797
Range	29408
Interquartile range (IQR)	14410.75

Descriptive statistics

Standard deviation	8504.4965
Coefficient of variation (CV)	0.12385873
Kurtosis	-1.2041641
Mean	68662.875
Median Absolute Deviation (MAD)	7378.5
Skewness	0.058252504
Sum	5493030
Variance	72326461
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
54389	1	1.2%
69324	1	1.2%
75633	1	1.2%
75273	1	1.2%
74956	1	1.2%
74603	1	1.2%
74235	1	1.2%
73883	1	1.2%
73583	1	1.2%
73300	1	1.2%
Other values (70)	70	87.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
54389	1	1.2%
54738	1	1.2%
55186	1	1.2%
55534	1	1.2%
56059	1	1.2%
56347	1	1.2%
56826	1	1.2%
57193	1	1.2%
57520	1	1.2%
57873	1	1.2%

Value	Count	Frequency (%)
83797	1	1.2%
83263	1	1.2%
82887	1	1.2%
82507	1	1.2%
82110	1	1.2%
81682	1	1.2%
81089	1	1.2%
80600	1	1.2%
80000	1	1.2%
79601	1	1.2%

65세 이상 인구비율(퍼센트)
Real number (ℝ)

HIGH CORRELATION

Distinct	59
Distinct (%)	73.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.09125

Minimum	10.2
Maximum	16.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	852.0 B

Quantile statistics

Minimum	10.2
5-th percentile	10.495
Q1	11.375
median	12.95
Q3	14.625
95-th percentile	16.405
Maximum	16.9
Range	6.7
Interquartile range (IQR)	3.25

Descriptive statistics

Standard deviation	1.9420851
Coefficient of variation (CV)	0.14834986
Kurtosis	-1.1450839
Mean	13.09125
Median Absolute Deviation (MAD)	1.65
Skewness	0.26304757
Sum	1047.3
Variance	3.7716946
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12.1	3	3.8%
14.2	3	3.8%
11.2	3	3.8%
11.4	2	2.5%
14.5	2	2.5%
10.3	2	2.5%
15.2	2	2.5%
15.6	2	2.5%
12.3	2	2.5%
11.8	2	2.5%
Other values (49)	57	71.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.2	1	1.2%
10.3	2	2.5%
10.4	1	1.2%
10.5	2	2.5%
10.6	2	2.5%
10.7	2	2.5%
10.8	2	2.5%
10.9	1	1.2%
11.0	1	1.2%
11.1	2	2.5%

Value	Count	Frequency (%)
16.9	1	1.2%
16.7	1	1.2%
16.6	1	1.2%
16.5	1	1.2%
16.4	1	1.2%
16.3	1	1.2%
16.1	1	1.2%
15.9	1	1.2%
15.8	1	1.2%
15.6	2	2.5%

독거노인수(명)
Real number (ℝ)

HIGH CORRELATION

Distinct	79
Distinct (%)	98.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17649.45

Minimum	12610
Maximum	23520
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	852.0 B

Quantile statistics

Minimum	12610
5-th percentile	13444.45
Q1	14976.75
median	17176.5
Q3	20136.5
95-th percentile	22907.15
Maximum	23520
Range	10910
Interquartile range (IQR)	5159.75

Descriptive statistics

Standard deviation	3070.2721
Coefficient of variation (CV)	0.17395852
Kurtosis	-1.1048553
Mean	17649.45
Median Absolute Deviation (MAD)	2618.5
Skewness	0.22966208
Sum	1411956
Variance	9426570.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16443	2	2.5%
12610	1	1.2%
19167	1	1.2%
20192	1	1.2%
20094	1	1.2%
19931	1	1.2%
19766	1	1.2%
19621	1	1.2%
19438	1	1.2%
19309	1	1.2%
Other values (69)	69	86.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12610	1	1.2%
13132	1	1.2%
13228	1	1.2%
13301	1	1.2%
13452	1	1.2%
13458	1	1.2%
13554	1	1.2%
13626	1	1.2%
13689	1	1.2%
13769	1	1.2%

Value	Count	Frequency (%)
23520	1	1.2%
23352	1	1.2%
23228	1	1.2%
23062	1	1.2%
22899	1	1.2%
22501	1	1.2%
22246	1	1.2%
22078	1	1.2%
21864	1	1.2%
21782	1	1.2%

Phik (φk)
Auto

Heatmap
Table

	기준일	남동구 전체인구수(명)	65세 이상 인구수(명)	65세 이상 인구비율(퍼센트)	독거노인수(명)
기준일	1.000	1.000	1.000	1.000	1.000
남동구 전체인구수(명)	1.000	1.000	0.963	0.955	0.976
65세 이상 인구수(명)	1.000	0.963	1.000	0.975	0.980
65세 이상 인구비율(퍼센트)	1.000	0.955	0.975	1.000	0.985
독거노인수(명)	1.000	0.976	0.980	0.985	1.000

Heatmap
Table

	남동구 전체인구수(명)	65세 이상 인구수(명)	65세 이상 인구비율(퍼센트)	독거노인수(명)
남동구 전체인구수(명)	1.000	-0.872	-0.872	-0.871
65세 이상 인구수(명)	-0.872	1.000	1.000	1.000
65세 이상 인구비율(퍼센트)	-0.872	1.000	1.000	0.999
독거노인수(명)	-0.871	1.000	0.999	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

	기준일	남동구 전체인구수(명)	65세 이상 인구수(명)	65세 이상 인구비율(퍼센트)	독거노인수(명)
0	2017-01-31	531364	54389	10.2	12610
1	2017-02-28	531022	54738	10.3	13132
2	2017-03-31	531129	55186	10.3	13228
3	2017-04-30	531490	55534	10.4	13301
4	2017-05-31	531923	56059	10.5	13452
5	2017-06-30	532184	56347	10.5	13458
6	2017-07-31	533655	56826	10.6	13554
7	2017-08-31	534860	57193	10.6	13626
8	2017-09-30	535591	57520	10.7	13689
9	2017-10-31	536428	57873	10.7	13769

	기준일	남동구 전체인구수(명)	65세 이상 인구수(명)	65세 이상 인구비율(퍼센트)	독거노인수(명)
70	2022-11-30	506911	79601	15.6	21782
71	2022-12-31	506181	80000	15.8	21864
72	2023-01-31	505213	80600	15.9	22078
73	2023-02-28	503689	81089	16.1	22246
74	2023-03-31	502526	81682	16.3	22501
75	2023-04-30	501481	82110	16.4	22899
76	2023-05-31	500534	82507	16.5	23062
77	2023-06-30	499891	82887	16.6	23228
78	2023-07-31	498379	83263	16.7	23352
79	2023-08-31	497181	83797	16.9	23520

Overview

Variables

Interactions

Correlations

Missing values

Sample