gimi9 Pandas Profiling

Dataset statistics

Number of variables	9
Number of observations	500
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	39.2 KiB
Average record size in memory	80.3 B

Variable types

Numeric	7
Categorical	2

Dataset

Description	샘플 데이터
Author	SKT
URL	https://bigdata.seoul.go.kr/data/selectSampleData.do?sample_data_seq=49

Alerts

시간대코드(TMST_CD) has 14 (2.8%) zeros Zeros

Reproduction

Analysis started	2023-12-10 14:55:05.351791
Analysis finished	2023-12-10 14:55:13.279118
Duration	7.93 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

기준년월(STD_YM)
Real number (ℝ)

Distinct	6
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	201603.12

Minimum	201601
Maximum	201606
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	201601
5-th percentile	201601
Q1	201602
median	201603
Q3	201604
95-th percentile	201606
Maximum	201606
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.5689318
Coefficient of variation (CV)	7.7822794 × 10^-6
Kurtosis	-1.1557525
Mean	201603.12
Median Absolute Deviation (MAD)	1
Skewness	0.15010432
Sum	1.0080156 × 10⁸
Variance	2.4615471
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
201601	102	20.4%
201602	97	19.4%
201604	91	18.2%
201603	90	18.0%
201605	88	17.6%
201606	32	6.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201601	102	20.4%
201602	97	19.4%
201603	90	18.0%
201604	91	18.2%
201605	88	17.6%
201606	32	6.4%

Value	Count	Frequency (%)
201606	32	6.4%
201605	88	17.6%
201604	91	18.2%
201603	90	18.0%
201602	97	19.4%
201601	102	20.4%

X좌표(X_COORD)
Real number (ℝ)

Distinct	448
Distinct (%)	89.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	954004.36

Minimum	950990
Maximum	957176
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	950990
5-th percentile	951772
Q1	952803.75
median	953879
Q3	955256.5
95-th percentile	956390.05
Maximum	957176
Range	6186
Interquartile range (IQR)	2452.75

Descriptive statistics

Standard deviation	1458.4437
Coefficient of variation (CV)	0.00152876
Kurtosis	-0.95316507
Mean	954004.36
Median Absolute Deviation (MAD)	1184
Skewness	0.15056783
Sum	4.7700218 × 10⁸
Variance	2127058.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
951772	4	0.8%
952022	3	0.6%
952173	3	0.6%
952804	3	0.6%
956091	3	0.6%
956292	2	0.4%
955749	2	0.4%
951332	2	0.4%
956391	2	0.4%
955455	2	0.4%
Other values (438)	474	94.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
950990	1	0.2%
950991	2	0.4%
951089	1	0.2%
951138	1	0.2%
951236	1	0.2%
951332	2	0.4%
951383	1	0.2%
951384	1	0.2%
951428	1	0.2%
951482	1	0.2%

Value	Count	Frequency (%)
957176	1	0.2%
957127	1	0.2%
957125	1	0.2%
957077	1	0.2%
957029	1	0.2%
956980	1	0.2%
956830	1	0.2%
956829	1	0.2%
956781	1	0.2%
956779	1	0.2%

Y좌표(Y_COORD)
Real number (ℝ)

Distinct	430
Distinct (%)	86.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1948363.8

Minimum	1945449
Maximum	1950797
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1945449
5-th percentile	1946487.6
Q1	1947404
median	1948386
Q3	1949291.5
95-th percentile	1950384.2
Maximum	1950797
Range	5348
Interquartile range (IQR)	1887.5

Descriptive statistics

Standard deviation	1186.6699
Coefficient of variation (CV)	0.00060905972
Kurtosis	-0.81227223
Mean	1948363.8
Median Absolute Deviation (MAD)	960.5
Skewness	0.032139118
Sum	9.7418188 × 10⁸
Variance	1408185.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1946374	4	0.8%
1948517	3	0.6%
1947619	3	0.6%
1948158	3	0.6%
1946530	3	0.6%
1948074	3	0.6%
1949451	3	0.6%
1949347	3	0.6%
1946829	2	0.4%
1948843	2	0.4%
Other values (420)	471	94.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1945449	2	0.4%
1945962	1	0.2%
1946019	2	0.4%
1946065	1	0.2%
1946176	1	0.2%
1946271	1	0.2%
1946279	1	0.2%
1946321	1	0.2%
1946333	1	0.2%
1946372	1	0.2%

Value	Count	Frequency (%)
1950797	1	0.2%
1950745	1	0.2%
1950744	1	0.2%
1950694	1	0.2%
1950693	1	0.2%
1950692	1	0.2%
1950690	1	0.2%
1950642	2	0.4%
1950585	2	0.4%
1950542	1	0.2%

성별코드(GNDR_CD)
Categorical

Distinct	2
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

1	251
2	249

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1	251	50.2%
2	249	49.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	251	50.2%
2	249	49.8%

연령대코드(AGE_GR_SCTN_CD)
Real number (ℝ)

Distinct	17
Distinct (%)	3.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4222.77

Minimum	509
Maximum	8589
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	509
5-th percentile	1014
Q1	2529
median	4044
Q3	6064
95-th percentile	7579
Maximum	8589
Range	8080
Interquartile range (IQR)	3535

Descriptive statistics

Standard deviation	2037.4255
Coefficient of variation (CV)	0.48248555
Kurtosis	-1.0369264
Mean	4222.77
Median Absolute Deviation (MAD)	1515
Skewness	0.11234846
Sum	2111385
Variance	4151102.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
2024	45	9.0%
6064	44	8.8%
2529	43	8.6%
5559	43	8.6%
3539	38	7.6%
3034	38	7.6%
4549	35	7.0%
4044	33	6.6%
1519	32	6.4%
6569	31	6.2%
Other values (7)	118	23.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
509	9	1.8%
1014	22	4.4%
1519	32	6.4%
2024	45	9.0%
2529	43	8.6%
3034	38	7.6%
3539	38	7.6%
4044	33	6.6%
4549	35	7.0%
5054	29	5.8%

Value	Count	Frequency (%)
8589	4	0.8%
8084	12	2.4%
7579	18	3.6%
7074	24	4.8%
6569	31	6.2%
6064	44	8.8%
5559	43	8.6%
5054	29	5.8%
4549	35	7.0%
4044	33	6.6%

요일코드(WKDY_CD)
Real number (ℝ)

Distinct	7
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.924

Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 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.0155269
Coefficient of variation (CV)	0.5136409
Kurtosis	-1.2910601
Mean	3.924
Median Absolute Deviation (MAD)	2
Skewness	0.026146895
Sum	1962
Variance	4.0623487
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
6	78	15.6%
1	78	15.6%
2	75	15.0%
3	71	14.2%
5	69	13.8%
4	65	13.0%
7	64	12.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	78	15.6%
2	75	15.0%
3	71	14.2%
4	65	13.0%
5	69	13.8%
6	78	15.6%
7	64	12.8%

Value	Count	Frequency (%)
7	64	12.8%
6	78	15.6%
5	69	13.8%
4	65	13.0%
3	71	14.2%
2	75	15.0%
1	78	15.6%

시간대코드(TMST_CD)
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.086

Minimum	0
Maximum	23
Zeros	14
Zeros (%)	2.8%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	9
median	13
Q3	18
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	6.0600373
Coefficient of variation (CV)	0.46309318
Kurtosis	-0.61621013
Mean	13.086
Median Absolute Deviation (MAD)	4
Skewness	-0.36186638
Sum	6543
Variance	36.724052
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
12	38	7.6%
11	34	6.8%
14	30	6.0%
20	30	6.0%
16	28	5.6%
17	27	5.4%
15	27	5.4%
13	26	5.2%
18	25	5.0%
8	25	5.0%
Other values (14)	210	42.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	2.8%
1	15	3.0%
2	9	1.8%
3	9	1.8%
4	6	1.2%
5	8	1.6%
6	9	1.8%
7	18	3.6%
8	25	5.0%
9	23	4.6%

Value	Count	Frequency (%)
23	14	2.8%
22	24	4.8%
21	22	4.4%
20	30	6.0%
19	20	4.0%
18	25	5.0%
17	27	5.4%
16	28	5.6%
15	27	5.4%
14	30	6.0%

유동인구수(FLOW_POP_CNT)
Real number (ℝ)

Distinct	92
Distinct (%)	18.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.22254

Minimum	0.01
Maximum	4.09
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.01
Q1	0.04
median	0.1
Q3	0.23
95-th percentile	0.861
Maximum	4.09
Range	4.08
Interquartile range (IQR)	0.19

Descriptive statistics

Standard deviation	0.37936841
Coefficient of variation (CV)	1.7047201
Kurtosis	35.024562
Mean	0.22254
Median Absolute Deviation (MAD)	0.07
Skewness	4.9308227
Sum	111.27
Variance	0.14392039
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.01	53	10.6%
0.04	34	6.8%
0.05	31	6.2%
0.07	24	4.8%
0.02	24	4.8%
0.03	22	4.4%
0.08	18	3.6%
0.1	18	3.6%
0.06	18	3.6%
0.09	15	3.0%
Other values (82)	243	48.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	53	10.6%
0.02	24	4.8%
0.03	22	4.4%
0.04	34	6.8%
0.05	31	6.2%
0.06	18	3.6%
0.07	24	4.8%
0.08	18	3.6%
0.09	15	3.0%
0.1	18	3.6%

Value	Count	Frequency (%)
4.09	1	0.2%
3.08	1	0.2%
2.9	1	0.2%
2.24	1	0.2%
1.94	1	0.2%
1.58	1	0.2%
1.53	1	0.2%
1.4	1	0.2%
1.38	1	0.2%
1.28	1	0.2%

자치구(SIGUNGU)
Categorical

Distinct	25
Distinct (%)	5.0%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

강북구	33
강동구	31
용산구	29
양천구	26
은평구	25
Other values (20)	356

Length

Max length	4
Median length	3
Mean length	3.094
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	서대문구
2nd row	서대문구
3rd row	강북구
4th row	은평구
5th row	강남구

Common Values

Value	Count	Frequency (%)
강북구	33	6.6%
강동구	31	6.2%
용산구	29	5.8%
양천구	26	5.2%
은평구	25	5.0%
영등포구	25	5.0%
송파구	24	4.8%
강남구	23	4.6%
노원구	22	4.4%
서초구	20	4.0%
Other values (15)	242	48.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
강북구	33	6.6%
강동구	31	6.2%
용산구	29	5.8%
양천구	26	5.2%
은평구	25	5.0%
영등포구	25	5.0%
송파구	24	4.8%
강남구	23	4.6%
노원구	22	4.4%
서초구	20	4.0%
Other values (15)	242	48.4%

Heatmap
Table

	기준년월(STD_YM)	X좌표(X_COORD)	Y좌표(Y_COORD)	성별코드(GNDR_CD)	연령대코드(AGE_GR_SCTN_CD)	요일코드(WKDY_CD)	시간대코드(TMST_CD)	유동인구수(FLOW_POP_CNT)	자치구(SIGUNGU)
기준년월(STD_YM)	1.000	0.000	0.147	0.000	0.073	0.000	0.000	0.123	0.118
X좌표(X_COORD)	0.000	1.000	0.119	0.177	0.123	0.096	0.194	0.000	0.157
Y좌표(Y_COORD)	0.147	0.119	1.000	0.036	0.139	0.069	0.165	0.000	0.000
성별코드(GNDR_CD)	0.000	0.177	0.036	1.000	0.067	0.000	0.082	0.096	0.000
연령대코드(AGE_GR_SCTN_CD)	0.073	0.123	0.139	0.067	1.000	0.000	0.005	0.000	0.000
요일코드(WKDY_CD)	0.000	0.096	0.069	0.000	0.000	1.000	0.000	0.000	0.000
시간대코드(TMST_CD)	0.000	0.194	0.165	0.082	0.005	0.000	1.000	0.000	0.115
유동인구수(FLOW_POP_CNT)	0.123	0.000	0.000	0.096	0.000	0.000	0.000	1.000	0.273
자치구(SIGUNGU)	0.118	0.157	0.000	0.000	0.000	0.000	0.115	0.273	1.000

Heatmap
Table

	성별코드(GNDR_CD)	자치구(SIGUNGU)
성별코드(GNDR_CD)	1.000	0.000
자치구(SIGUNGU)	0.000	1.000

Heatmap
Table

	기준년월(STD_YM)	X좌표(X_COORD)	Y좌표(Y_COORD)	연령대코드(AGE_GR_SCTN_CD)	요일코드(WKDY_CD)	시간대코드(TMST_CD)	유동인구수(FLOW_POP_CNT)	성별코드(GNDR_CD)	자치구(SIGUNGU)
기준년월(STD_YM)	1.000	0.001	0.009	-0.003	-0.024	-0.020	0.070	0.000	0.036
X좌표(X_COORD)	0.001	1.000	0.012	-0.013	-0.059	-0.010	0.006	0.125	0.051
Y좌표(Y_COORD)	0.009	0.012	1.000	0.064	-0.095	0.013	-0.001	0.000	0.000
연령대코드(AGE_GR_SCTN_CD)	-0.003	-0.013	0.064	1.000	-0.006	0.029	-0.041	0.061	0.033
요일코드(WKDY_CD)	-0.024	-0.059	-0.095	-0.006	1.000	0.053	-0.098	0.000	0.000
시간대코드(TMST_CD)	-0.020	-0.010	0.013	0.029	0.053	1.000	0.009	0.062	0.039
유동인구수(FLOW_POP_CNT)	0.070	0.006	-0.001	-0.041	-0.098	0.009	1.000	0.072	0.109
성별코드(GNDR_CD)	0.000	0.125	0.000	0.061	0.000	0.062	0.072	1.000	0.000
자치구(SIGUNGU)	0.036	0.051	0.000	0.033	0.000	0.039	0.109	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

	기준년월(STD_YM)	X좌표(X_COORD)	Y좌표(Y_COORD)	성별코드(GNDR_CD)	연령대코드(AGE_GR_SCTN_CD)	요일코드(WKDY_CD)	시간대코드(TMST_CD)	유동인구수(FLOW_POP_CNT)	자치구(SIGUNGU)
0	201601	956340	1949772	2	8084	5	9	0.03	서대문구
1	201601	952173	1947151	2	4044	2	2	0.12	서대문구
2	201601	953986	1949513	2	509	5	5	0.04	강북구
3	201604	955908	1949357	2	6064	6	22	0.05	은평구
4	201606	955016	1949204	2	5559	5	10	0.05	강남구
5	201604	952407	1948478	1	1519	3	13	0.81	송파구
6	201605	955596	1948286	2	7074	7	17	0.05	서대문구
7	201603	956537	1948950	2	1014	3	15	0.07	송파구
8	201601	951966	1949143	1	6569	4	16	0.01	광진구
9	201601	951621	1947902	1	1519	4	20	0.02	광진구

	기준년월(STD_YM)	X좌표(X_COORD)	Y좌표(Y_COORD)	성별코드(GNDR_CD)	연령대코드(AGE_GR_SCTN_CD)	요일코드(WKDY_CD)	시간대코드(TMST_CD)	유동인구수(FLOW_POP_CNT)	자치구(SIGUNGU)
490	201605	952109	1949649	2	2529	1	22	0.12	영등포구
491	201604	956340	1948281	1	4044	3	10	0.16	용산구
492	201605	952950	1948378	1	6569	4	1	0.8	강동구
493	201604	953733	1948415	2	1519	4	19	0.01	용산구
494	201603	955705	1946019	2	2024	1	17	0.27	마포구
495	201604	951384	1947310	1	5559	2	18	0.05	송파구
496	201603	955654	1947197	1	3539	6	18	0.22	강북구
497	201601	951531	1948621	1	1519	1	17	0.19	서초구
498	201604	952962	1949134	2	2024	7	10	0.02	서초구
499	201606	952915	1948283	1	3034	5	3	0.16	노원구

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Interactions

Correlations

Missing values

Sample