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

`주중유동인구수(WD_SMS_CSCNT_AVG)` has 15 (3.0%) zeros	Zeros
`주말유동인구수(SW_SMS_CSCNT_AVG)` has 30 (6.0%) zeros	Zeros

Reproduction

Analysis started	2023-12-10 14:54:51.019706
Analysis finished	2023-12-10 14:54:59.309881
Duration	8.29 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.23

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	201605
95-th percentile	201606
Maximum	201606
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.5620897
Coefficient of variation (CV)	7.7483365 × 10^-6
Kurtosis	-1.1388799
Mean	201603.23
Median Absolute Deviation (MAD)	1
Skewness	0.091754887
Sum	1.0080162 × 10⁸
Variance	2.4401242
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
201602	96	19.2%
201603	94	18.8%
201605	93	18.6%
201604	92	18.4%
201601	88	17.6%
201606	37	7.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201601	88	17.6%
201602	96	19.2%
201603	94	18.8%
201604	92	18.4%
201605	93	18.6%
201606	37	7.4%

Value	Count	Frequency (%)
201606	37	7.4%
201605	93	18.6%
201604	92	18.4%
201603	94	18.8%
201602	96	19.2%
201601	88	17.6%

X좌표(X_COORD)
Real number (ℝ)

Distinct	240
Distinct (%)	48.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	961426.08

Minimum	958030
Maximum	962740
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	958030
5-th percentile	960248.95
Q1	960788
median	961414
Q3	962105.25
95-th percentile	962547
Maximum	962740
Range	4710
Interquartile range (IQR)	1317.25

Descriptive statistics

Standard deviation	758.21044
Coefficient of variation (CV)	0.00078863103
Kurtosis	-0.53646388
Mean	961426.08
Median Absolute Deviation (MAD)	675
Skewness	-0.23849218
Sum	4.8071304 × 10⁸
Variance	574883.07
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
962008	7	1.4%
961612	6	1.2%
962595	6	1.2%
960152	6	1.2%
961021	5	1.0%
961122	5	1.0%
962156	5	1.0%
960641	5	1.0%
961118	5	1.0%
961023	5	1.0%
Other values (230)	445	89.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
958030	1	0.2%
960051	1	0.2%
960103	2	0.4%
960149	1	0.2%
960150	1	0.2%
960151	2	0.4%
960152	6	1.2%
960153	1	0.2%
960199	1	0.2%
960200	3	0.6%

Value	Count	Frequency (%)
962740	1	0.2%
962691	1	0.2%
962644	1	0.2%
962643	4	0.8%
962642	2	0.4%
962597	1	0.2%
962595	6	1.2%
962594	4	0.8%
962548	3	0.6%
962547	3	0.6%

Y좌표(Y_COORD)
Real number (ℝ)

Distinct	236
Distinct (%)	47.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1953285.3

Minimum	1951521
Maximum	1955484
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1951521
5-th percentile	1951885.9
Q1	1952548.8
median	1952913
Q3	1954558.5
95-th percentile	1955124
Maximum	1955484
Range	3963
Interquartile range (IQR)	2009.75

Descriptive statistics

Standard deviation	1056.5381
Coefficient of variation (CV)	0.0005409031
Kurtosis	-0.95449974
Mean	1953285.3
Median Absolute Deviation (MAD)	559.5
Skewness	0.60433161
Sum	9.7664265 × 10⁸
Variance	1116272.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1955074	9	1.8%
1953165	8	1.6%
1954971	7	1.4%
1952552	7	1.4%
1951885	6	1.2%
1953266	6	1.2%
1953012	6	1.2%
1954662	6	1.2%
1952295	6	1.2%
1953060	5	1.0%
Other values (226)	434	86.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1951521	1	0.2%
1951524	1	0.2%
1951578	1	0.2%
1951627	1	0.2%
1951675	1	0.2%
1951678	1	0.2%
1951680	1	0.2%
1951730	1	0.2%
1951732	1	0.2%
1951782	1	0.2%

Value	Count	Frequency (%)
1955484	1	0.2%
1955433	1	0.2%
1955381	3	0.6%
1955331	1	0.2%
1955330	1	0.2%
1955280	2	0.4%
1955279	4	0.8%
1955278	1	0.2%
1955229	1	0.2%
1955228	1	0.2%

성별코드(GNDR_CD)
Categorical

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

1	261
2	239

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	1
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
1	261	52.2%
2	239	47.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	261	52.2%
2	239	47.8%

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

Distinct	20
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4439.92

Minimum	4
Maximum	9599
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	4
5-th percentile	1519
Q1	3034
median	4549
Q3	6064
95-th percentile	7579
Maximum	9599
Range	9595
Interquartile range (IQR)	3030

Descriptive statistics

Standard deviation	1910.8749
Coefficient of variation (CV)	0.43038498
Kurtosis	-0.73317358
Mean	4439.92
Median Absolute Deviation (MAD)	1515
Skewness	0.088343158
Sum	2219960
Variance	3651442.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
4549	56	11.2%
3539	42	8.4%
3034	42	8.4%
4044	42	8.4%
5559	40	8.0%
2024	38	7.6%
5054	38	7.6%
6569	37	7.4%
2529	32	6.4%
6064	32	6.4%
Other values (10)	101	20.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4	1	0.2%
509	4	0.8%
1014	14	2.8%
1519	21	4.2%
2024	38	7.6%
2529	32	6.4%
3034	42	8.4%
3539	42	8.4%
4044	42	8.4%
4549	56	11.2%

Value	Count	Frequency (%)
9599	1	0.2%
9094	2	0.4%
8589	3	0.6%
8084	7	1.4%
7579	24	4.8%
7074	24	4.8%
6569	37	7.4%
6064	32	6.4%
5559	40	8.0%
5054	38	7.6%

유입지코드(INFLOW_CD)
Real number (ℝ)

Distinct	281
Distinct (%)	56.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1408435 × 10⁹

Minimum	1.1110515 × 10⁹
Maximum	1.17407 × 10⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1.1110515 × 10⁹
5-th percentile	1.114055 × 10⁹
Q1	1.126054 × 10⁹
median	1.1365615 × 10⁹
Q3	1.156817 × 10⁹
95-th percentile	1.1710642 × 10⁹
Maximum	1.17407 × 10⁹
Range	63018500
Interquartile range (IQR)	30763000

Descriptive statistics

Standard deviation	18890906
Coefficient of variation (CV)	0.016558718
Kurtosis	-1.2008545
Mean	1.1408435 × 10⁹
Median Absolute Deviation (MAD)	14984500
Skewness	0.23512487
Sum	5.7042176 × 10¹¹
Variance	3.5686632 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1174070000	5	1.0%
1123065000	5	1.0%
1156071000	5	1.0%
1162076500	5	1.0%
1130554500	4	0.8%
1135057000	4	0.8%
1129078000	4	0.8%
1126057500	4	0.8%
1135061100	4	0.8%
1135066500	4	0.8%
Other values (271)	456	91.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1111051500	3	0.6%
1111054000	2	0.4%
1111055000	1	0.2%
1111056000	2	0.4%
1111057000	1	0.2%
1111058000	1	0.2%
1111060000	1	0.2%
1111061500	2	0.4%
1111063000	4	0.8%
1111064000	1	0.2%

Value	Count	Frequency (%)
1174070000	5	1.0%
1174069000	1	0.2%
1174066000	1	0.2%
1174065000	2	0.4%
1174062000	2	0.4%
1174060000	1	0.2%
1174059000	1	0.2%
1174058000	1	0.2%
1174057000	2	0.4%
1174055000	1	0.2%

주중유동인구수(WD_SMS_CSCNT_AVG)
Real number (ℝ)

ZEROS

Distinct	137
Distinct (%)	27.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0085488

Minimum	0
Maximum	0.3919
Zeros	15
Zeros (%)	3.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0.0004
Q1	0.0008
median	0.0019
Q3	0.004425
95-th percentile	0.02839
Maximum	0.3919
Range	0.3919
Interquartile range (IQR)	0.003625

Descriptive statistics

Standard deviation	0.032647174
Coefficient of variation (CV)	3.8189189
Kurtosis	81.301541
Mean	0.0085488
Median Absolute Deviation (MAD)	0.0013
Skewness	8.4972406
Sum	4.2744
Variance	0.001065838
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0006	27	5.4%
0.0004	24	4.8%
0.0005	23	4.6%
0.0009	22	4.4%
0.0007	17	3.4%
0.0012	16	3.2%
0.0	15	3.0%
0.0008	14	2.8%
0.001	13	2.6%
0.0011	13	2.6%
Other values (127)	316	63.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	15	3.0%
0.0002	1	0.2%
0.0003	8	1.6%
0.0004	24	4.8%
0.0005	23	4.6%
0.0006	27	5.4%
0.0007	17	3.4%
0.0008	14	2.8%
0.0009	22	4.4%
0.001	13	2.6%

Value	Count	Frequency (%)
0.3919	1	0.2%
0.3441	1	0.2%
0.295	1	0.2%
0.2674	1	0.2%
0.1851	1	0.2%
0.1542	1	0.2%
0.1291	1	0.2%
0.0847	1	0.2%
0.066	2	0.4%
0.0643	1	0.2%

주말유동인구수(SW_SMS_CSCNT_AVG)
Real number (ℝ)

ZEROS

Distinct	131
Distinct (%)	26.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0073626

Minimum	0
Maximum	0.2258
Zeros	30
Zeros (%)	6.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.0007
median	0.0018
Q3	0.004125
95-th percentile	0.030755
Maximum	0.2258
Range	0.2258
Interquartile range (IQR)	0.003425

Descriptive statistics

Standard deviation	0.021879354
Coefficient of variation (CV)	2.9716885
Kurtosis	47.311
Mean	0.0073626
Median Absolute Deviation (MAD)	0.0013
Skewness	6.2308927
Sum	3.6813
Variance	0.00047870611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0	30	6.0%
0.0005	30	6.0%
0.0006	22	4.4%
0.0007	22	4.4%
0.0008	21	4.2%
0.001	16	3.2%
0.0004	15	3.0%
0.0013	14	2.8%
0.0009	13	2.6%
0.002	12	2.4%
Other values (121)	305	61.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	30	6.0%
0.0002	2	0.4%
0.0003	12	2.4%
0.0004	15	3.0%
0.0005	30	6.0%
0.0006	22	4.4%
0.0007	22	4.4%
0.0008	21	4.2%
0.0009	13	2.6%
0.001	16	3.2%

Value	Count	Frequency (%)
0.2258	1	0.2%
0.2213	1	0.2%
0.148	1	0.2%
0.1414	1	0.2%
0.1161	1	0.2%
0.1078	1	0.2%
0.1029	1	0.2%
0.1004	1	0.2%
0.0839	1	0.2%
0.0832	1	0.2%

자치구(SIGUNGU)
Categorical

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

종로구	29
구로구	28
노원구	25
중구	23
동작구	23
Other values (20)	372

Length

Max length	4
Median length	3
Mean length	3.07
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 (%)
종로구	29	5.8%
구로구	28	5.6%
노원구	25	5.0%
중구	23	4.6%
동작구	23	4.6%
강동구	22	4.4%
서대문구	22	4.4%
강남구	22	4.4%
은평구	21	4.2%
금천구	21	4.2%
Other values (15)	264	52.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
종로구	29	5.8%
구로구	28	5.6%
노원구	25	5.0%
중구	23	4.6%
동작구	23	4.6%
강동구	22	4.4%
서대문구	22	4.4%
강남구	22	4.4%
은평구	21	4.2%
금천구	21	4.2%
Other values (15)	264	52.8%

Heatmap
Table

	기준년월(STD_YM)	X좌표(X_COORD)	Y좌표(Y_COORD)	성별코드(GNDR_CD)	연령대구분코드(AGE_GR_SCTN_CD)	유입지코드(INFLOW_CD)	주중유동인구수(WD_SMS_CSCNT_AVG)	주말유동인구수(SW_SMS_CSCNT_AVG)	자치구(SIGUNGU)
기준년월(STD_YM)	1.000	0.142	0.000	0.053	0.106	0.000	0.000	0.000	0.000
X좌표(X_COORD)	0.142	1.000	0.111	0.000	0.000	0.000	0.000	0.060	0.000
Y좌표(Y_COORD)	0.000	0.111	1.000	0.000	0.147	0.142	0.000	0.000	0.000
성별코드(GNDR_CD)	0.053	0.000	0.000	1.000	0.129	0.000	0.021	0.066	0.000
연령대구분코드(AGE_GR_SCTN_CD)	0.106	0.000	0.147	0.129	1.000	0.109	0.000	0.210	0.000
유입지코드(INFLOW_CD)	0.000	0.000	0.142	0.000	0.109	1.000	0.138	0.141	0.127
주중유동인구수(WD_SMS_CSCNT_AVG)	0.000	0.000	0.000	0.021	0.000	0.138	1.000	0.109	0.000
주말유동인구수(SW_SMS_CSCNT_AVG)	0.000	0.060	0.000	0.066	0.210	0.141	0.109	1.000	0.262
자치구(SIGUNGU)	0.000	0.000	0.000	0.000	0.000	0.127	0.000	0.262	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)	유입지코드(INFLOW_CD)	주중유동인구수(WD_SMS_CSCNT_AVG)	주말유동인구수(SW_SMS_CSCNT_AVG)	성별코드(GNDR_CD)	자치구(SIGUNGU)
기준년월(STD_YM)	1.000	-0.039	-0.018	-0.029	-0.034	0.017	-0.100	0.038	0.000
X좌표(X_COORD)	-0.039	1.000	-0.042	0.015	0.089	0.056	-0.022	0.000	0.000
Y좌표(Y_COORD)	-0.018	-0.042	1.000	0.044	-0.035	-0.027	-0.049	0.000	0.000
연령대구분코드(AGE_GR_SCTN_CD)	-0.029	0.015	0.044	1.000	0.000	0.040	-0.026	0.098	0.000
유입지코드(INFLOW_CD)	-0.034	0.089	-0.035	0.000	1.000	0.005	0.011	0.000	0.032
주중유동인구수(WD_SMS_CSCNT_AVG)	0.017	0.056	-0.027	0.040	0.005	1.000	-0.053	0.020	0.000
주말유동인구수(SW_SMS_CSCNT_AVG)	-0.100	-0.022	-0.049	-0.026	0.011	-0.053	1.000	0.049	0.105
성별코드(GNDR_CD)	0.038	0.000	0.000	0.098	0.000	0.020	0.049	1.000	0.000
자치구(SIGUNGU)	0.000	0.000	0.000	0.000	0.032	0.000	0.105	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)	유입지코드(INFLOW_CD)	주중유동인구수(WD_SMS_CSCNT_AVG)	주말유동인구수(SW_SMS_CSCNT_AVG)	자치구(SIGUNGU)
0	201604	961021	1952910	2	7579	1171056100	0.0003	0.1004	강동구
1	201602	962298	1953268	2	6569	1168070000	0.0026	0.0009	영등포구
2	201602	961414	1951885	1	3034	1130563000	0.0053	0.0028	서대문구
3	201603	961859	1953474	2	2024	1126066000	0.0012	0.0007	중구
4	201602	960691	1953216	2	2529	1130559000	0.0005	0.0005	금천구
5	201604	960546	1953014	2	5559	1126069000	0.008	0.0016	서대문구
6	201604	961318	1954560	2	5054	1132066000	0.003	0.0	도봉구
7	201605	962597	1954817	2	5559	1165065100	0.0011	0.0015	노원구
8	201606	962447	1951524	2	4044	1123057000	0.0009	0.001	양천구
9	201602	960347	1955279	1	4549	1111069000	0.0243	0.0019	종로구

	기준년월(STD_YM)	X좌표(X_COORD)	Y좌표(Y_COORD)	성별코드(GNDR_CD)	연령대구분코드(AGE_GR_SCTN_CD)	유입지코드(INFLOW_CD)	주중유동인구수(WD_SMS_CSCNT_AVG)	주말유동인구수(SW_SMS_CSCNT_AVG)	자치구(SIGUNGU)
490	201605	960149	1954561	2	7074	1117051000	0.0023	0.0031	동대문구
491	201602	960150	1953421	1	2529	1111051500	0.0004	0.0	구로구
492	201603	960494	1952654	2	4044	1156072000	0.003	0.0054	강서구
493	201606	961957	1954919	1	3539	1126065500	0.004	0.0	종로구
494	201603	961316	1955023	1	4549	1141061500	0.018	0.0097	강남구
495	201604	962594	1953062	2	4549	1123053600	0.0199	0.0048	성북구
496	201602	961907	1955022	1	5559	1114057000	0.0117	0.002	중구
497	201602	961612	1952347	2	3539	1162069500	0.0006	0.0004	관악구
498	201602	962150	1952342	1	6064	1168058000	0.0005	0.0008	서대문구
499	201601	960496	1955021	1	7074	1126054000	0.0027	0.0006	동대문구

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Interactions

Correlations

Missing values

Sample