gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	10000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	605.5 KiB
Average record size in memory	62.0 B

Variable types

Numeric	6

Dataset

Description	기준일ID,시간대구분,행정동코드,총생활인구수,중국인체류인구수,중국외외국인체류인구수
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-14993/S/1/datasetView.do

Alerts

`총생활인구수` 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 419 (4.2%) zeros	Zeros
`중국인체류인구수` has 1056 (10.6%) zeros	Zeros

Reproduction

Analysis started	2024-04-27 03:39:22.134483
Analysis finished	2024-04-27 03:39:37.824841
Duration	15.69 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

기준일ID
Real number (ℝ)

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20240411

Minimum	20240406
Maximum	20240415
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	20240406
5-th percentile	20240406
Q1	20240408
median	20240411
Q3	20240413
95-th percentile	20240415
Maximum	20240415
Range	9
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.8327168
Coefficient of variation (CV)	1.3995352 × 10^-7
Kurtosis	-1.2110366
Mean	20240411
Median Absolute Deviation (MAD)	2
Skewness	-0.005947694
Sum	2.0240411 × 10¹¹
Variance	8.0242844
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
20240415	1042	10.4%
20240408	1040	10.4%
20240410	1029	10.3%
20240409	1027	10.3%
20240407	1022	10.2%
20240412	1017	10.2%
20240414	1016	10.2%
20240413	1002	10.0%
20240411	996	10.0%
20240406	809	8.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20240406	809	8.1%
20240407	1022	10.2%
20240408	1040	10.4%
20240409	1027	10.3%
20240410	1029	10.3%
20240411	996	10.0%
20240412	1017	10.2%
20240413	1002	10.0%
20240414	1016	10.2%
20240415	1042	10.4%

Value	Count	Frequency (%)
20240415	1042	10.4%
20240414	1016	10.2%
20240413	1002	10.0%
20240412	1017	10.2%
20240411	996	10.0%
20240410	1029	10.3%
20240409	1027	10.3%
20240408	1040	10.4%
20240407	1022	10.2%
20240406	809	8.1%

시간대구분
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.2636

Minimum	0
Maximum	23
Zeros	419
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5
median	11
Q3	17
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.8720476
Coefficient of variation (CV)	0.61011111
Kurtosis	-1.1953185
Mean	11.2636
Median Absolute Deviation (MAD)	6
Skewness	0.031767373
Sum	112636
Variance	47.225038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
15	463	4.6%
7	453	4.5%
2	448	4.5%
4	438	4.4%
3	435	4.3%
1	434	4.3%
12	431	4.3%
19	427	4.3%
14	426	4.3%
5	422	4.2%
Other values (14)	5623	56.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	419	4.2%
1	434	4.3%
2	448	4.5%
3	435	4.3%
4	438	4.4%
5	422	4.2%
6	420	4.2%
7	453	4.5%
8	414	4.1%
9	406	4.1%

Value	Count	Frequency (%)
23	385	3.9%
22	365	3.6%
21	381	3.8%
20	384	3.8%
19	427	4.3%
18	404	4.0%
17	417	4.2%
16	410	4.1%
15	463	4.6%
14	426	4.3%

행정동코드
Real number (ℝ)

Distinct	424
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11433044

Minimum	11110515
Maximum	11740700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	11110515
5-th percentile	11140580
Q1	11260655
median	11440600
Q3	11590680
95-th percentile	11710680
Maximum	11740700
Range	630185
Interquartile range (IQR)	330025

Descriptive statistics

Standard deviation	191573.16
Coefficient of variation (CV)	0.016756094
Kurtosis	-1.2638537
Mean	11433044
Median Absolute Deviation (MAD)	179940
Skewness	-0.0067294743
Sum	1.1433044 × 10¹¹
Variance	3.6700276 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11260690	37	0.4%
11590651	36	0.4%
11350695	36	0.4%
11530520	36	0.4%
11305600	35	0.4%
11740685	34	0.3%
11410700	34	0.3%
11380625	34	0.3%
11110680	34	0.3%
11290760	33	0.3%
Other values (414)	9651	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11110515	26	0.3%
11110530	14	0.1%
11110540	29	0.3%
11110550	20	0.2%
11110560	22	0.2%
11110570	19	0.2%
11110580	25	0.2%
11110600	22	0.2%
11110615	17	0.2%
11110630	23	0.2%

Value	Count	Frequency (%)
11740700	23	0.2%
11740690	24	0.2%
11740685	34	0.3%
11740660	24	0.2%
11740650	19	0.2%
11740640	24	0.2%
11740620	24	0.2%
11740610	22	0.2%
11740600	23	0.2%
11740590	22	0.2%

총생활인구수
Real number (ℝ)

HIGH CORRELATION

Distinct	9975
Distinct (%)	99.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	411.72262

Minimum	0.001
Maximum	22794.677
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0.001
5-th percentile	11.57009
Q1	33.96665
median	75.15705
Q3	215.81375
95-th percentile	1805.7595
Maximum	22794.677
Range	22794.676
Interquartile range (IQR)	181.8471

Descriptive statistics

Standard deviation	1318.7959
Coefficient of variation (CV)	3.2031173
Kurtosis	91.698279
Mean	411.72262
Median Absolute Deviation (MAD)	52.81445
Skewness	8.2365875
Sum	4117226.2
Variance	1739222.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56.6781	2	< 0.1%
11.5026	2	< 0.1%
34.068	2	< 0.1%
79.6373	2	< 0.1%
37.991	2	< 0.1%
14.1159	2	< 0.1%
56.6637	2	< 0.1%
13.38	2	< 0.1%
105.815	2	< 0.1%
36.6743	2	< 0.1%
Other values (9965)	9980	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.001	1	< 0.1%
0.0267	1	< 0.1%
0.0973	1	< 0.1%
0.0981	1	< 0.1%
0.0989	1	< 0.1%
0.1408	1	< 0.1%
0.2776	1	< 0.1%
0.491	1	< 0.1%
0.5228	1	< 0.1%
0.5783	1	< 0.1%

Value	Count	Frequency (%)
22794.6771	1	< 0.1%
22760.5918	1	< 0.1%
21694.7704	1	< 0.1%
21345.1819	1	< 0.1%
20314.0628	1	< 0.1%
20021.3915	1	< 0.1%
18924.9136	1	< 0.1%
18772.9866	1	< 0.1%
18636.1488	1	< 0.1%
18472.8182	1	< 0.1%

중국인체류인구수
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	8719
Distinct (%)	87.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	127.28509

Minimum	0
Maximum	5267.808
Zeros	1056
Zeros (%)	10.6%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	8.160575
median	24.82545
Q3	81.02785
95-th percentile	627.78951
Maximum	5267.808
Range	5267.808
Interquartile range (IQR)	72.867275

Descriptive statistics

Standard deviation	335.87074
Coefficient of variation (CV)	2.6387282
Kurtosis	45.812707
Mean	127.28509
Median Absolute Deviation (MAD)	23.5906
Skewness	5.7956142
Sum	1272850.9
Variance	112809.16
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	1056	10.6%
8.9471	5	0.1%
14.3346	4	< 0.1%
0.0002	4	< 0.1%
8.947	4	< 0.1%
10.0678	4	< 0.1%
0.001	4	< 0.1%
8.8822	4	< 0.1%
8.4244	4	< 0.1%
10.4512	4	< 0.1%
Other values (8709)	8907	89.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	1056	10.6%
0.0001	3	< 0.1%
0.0002	4	< 0.1%
0.0003	1	< 0.1%
0.0004	1	< 0.1%
0.0005	2	< 0.1%
0.0006	2	< 0.1%
0.0007	1	< 0.1%
0.0008	1	< 0.1%
0.001	4	< 0.1%

Value	Count	Frequency (%)
5267.808	1	< 0.1%
4796.0224	1	< 0.1%
4577.2702	1	< 0.1%
4383.691	1	< 0.1%
4322.9618	1	< 0.1%
4047.9348	1	< 0.1%
3663.2629	1	< 0.1%
3660.5318	1	< 0.1%
3603.6023	1	< 0.1%
3554.3201	1	< 0.1%

중국외외국인체류인구수
Real number (ℝ)

HIGH CORRELATION

Distinct	9954
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	284.43754

Minimum	0
Maximum	19464.051
Zeros	10
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	166.0 KiB

Quantile statistics

Minimum	0
5-th percentile	6.919475
Q1	20.65635
median	45.07205
Q3	130.3883
95-th percentile	1185.5078
Maximum	19464.051
Range	19464.051
Interquartile range (IQR)	109.73195

Descriptive statistics

Standard deviation	1038.0564
Coefficient of variation (CV)	3.6495058
Kurtosis	122.04243
Mean	284.43754
Median Absolute Deviation (MAD)	31.32315
Skewness	9.6138303
Sum	2844375.4
Variance	1077561.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	10	0.1%
11.6658	2	< 0.1%
15.6238	2	< 0.1%
32.1075	2	< 0.1%
38.9559	2	< 0.1%
6.5746	2	< 0.1%
17.8053	2	< 0.1%
27.9373	2	< 0.1%
37.9483	2	< 0.1%
38.769	2	< 0.1%
Other values (9944)	9972	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	10	0.1%
0.0002	1	< 0.1%
0.001	1	< 0.1%
0.0075	1	< 0.1%
0.0104	1	< 0.1%
0.0199	1	< 0.1%
0.0267	1	< 0.1%
0.0305	1	< 0.1%
0.0349	1	< 0.1%
0.0432	1	< 0.1%

Value	Count	Frequency (%)
19464.0506	1	< 0.1%
18746.7418	1	< 0.1%
18155.1922	1	< 0.1%
18080.0406	1	< 0.1%
17813.9593	1	< 0.1%
17745.585	1	< 0.1%
16399.2766	1	< 0.1%
16000.2235	1	< 0.1%
15987.4094	1	< 0.1%
15950.8058	1	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	기준일ID	시간대구분	행정동코드	총생활인구수	중국인체류인구수	중국외외국인체류인구수
기준일ID	1.000	0.021	0.000	0.046	0.032	0.039
시간대구분	0.021	1.000	0.000	0.050	0.020	0.048
행정동코드	0.000	0.000	1.000	0.295	0.300	0.277
총생활인구수	0.046	0.050	0.295	1.000	0.871	0.982
중국인체류인구수	0.032	0.020	0.300	0.871	1.000	0.823
중국외외국인체류인구수	0.039	0.048	0.277	0.982	0.823	1.000

Heatmap
Table

	기준일ID	시간대구분	행정동코드	총생활인구수	중국인체류인구수	중국외외국인체류인구수
기준일ID	1.000	0.042	-0.007	-0.015	-0.003	-0.018
시간대구분	0.042	1.000	-0.008	-0.022	-0.011	-0.029
행정동코드	-0.007	-0.008	1.000	-0.023	-0.055	-0.021
총생활인구수	-0.015	-0.022	-0.023	1.000	0.882	0.919
중국인체류인구수	-0.003	-0.011	-0.055	0.882	1.000	0.675
중국외외국인체류인구수	-0.018	-0.029	-0.021	0.919	0.675	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

	기준일ID	시간대구분	행정동코드	총생활인구수	중국인체류인구수	중국외외국인체류인구수
56933	20240410	14	11290760	43.453	9.988	33.4651
6009	20240415	14	11215820	113.622	79.9425	33.6798
37769	20240412	17	11170530	932.4442	118.5385	813.9062
50603	20240411	23	11320710	36.7243	9.1651	27.5593
15858	20240414	13	11350670	7.2641	7.2641	0.0
39820	20240412	21	11710580	165.404	55.6805	109.7234
28687	20240413	19	11545670	134.7205	106.9032	27.8175
86194	20240407	11	11305535	165.3342	61.4007	103.9336
34300	20240412	8	11710531	42.9813	0.0	42.981
7908	20240415	18	11545610	240.0126	145.6448	94.3681

	기준일ID	시간대구분	행정동코드	총생활인구수	중국인체류인구수	중국외외국인체류인구수
17898	20240414	18	11230730	69.8248	30.5602	39.2647
39479	20240412	21	11200520	62.9793	26.6496	36.33
94110	20240406	5	11740600	52.8527	14.5086	38.3448
72878	20240408	3	11710540	28.9261	8.6874	20.2386
27743	20240413	17	11380590	10.1528	0.0	10.1528
45938	20240411	12	11320660	20.8932	0.0	20.8932
42486	20240411	4	11230660	71.569	25.8171	45.7522
59417	20240410	20	11215730	164.1647	57.4103	106.7543
82138	20240407	1	11590660	90.6103	32.7825	57.8277
98453	20240406	16	11260550	11.6098	2.678	8.932

Overview

Variables

Interactions

Correlations

Missing values

Sample