gimi9 Pandas Profiling

Dataset statistics

Number of variables	10
Number of observations	500
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	42.6 KiB
Average record size in memory	87.3 B

Variable types

Numeric	7
Categorical	3

Dataset

Description	샘플 데이터
Author	신한카드
URL	https://bigdata.seoul.go.kr/data/selectSampleData.do?sample_data_seq=50

Reproduction

Analysis started	2023-12-10 14:52:12.560001
Analysis finished	2023-12-10 14:52:19.922850
Duration	7.36 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

행정동코드(M_DONG_CD)
Real number (ℝ)

Distinct	268
Distinct (%)	53.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1114783.1

Minimum	1101056
Maximum	1125074
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1101056
5-th percentile	1103063.9
Q1	1109065
median	1115062.5
Q3	1121070
95-th percentile	1124065.1
Maximum	1125074
Range	24018
Interquartile range (IQR)	12005

Descriptive statistics

Standard deviation	6914.1041
Coefficient of variation (CV)	0.0062021966
Kurtosis	-1.1328431
Mean	1114783.1
Median Absolute Deviation (MAD)	6000.5
Skewness	-0.23226926
Sum	5.5739157 × 10⁸
Variance	47804836
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1123064	9	1.8%
1124071	7	1.4%
1119072	7	1.4%
1119056	6	1.2%
1111060	5	1.0%
1121062	5	1.0%
1111051	5	1.0%
1120072	5	1.0%
1106088	5	1.0%
1114076	4	0.8%
Other values (258)	442	88.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1101056	1	0.2%
1101061	2	0.4%
1101063	1	0.2%
1101064	3	0.6%
1101067	1	0.2%
1102052	1	0.2%
1102054	4	0.8%
1102055	2	0.4%
1102059	1	0.2%
1102069	1	0.2%

Value	Count	Frequency (%)
1125074	3	0.6%
1125073	1	0.2%
1125072	4	0.8%
1125067	3	0.6%
1125065	1	0.2%
1125052	1	0.2%
1124081	1	0.2%
1124077	1	0.2%
1124071	7	1.4%
1124069	2	0.4%

블록코드(BLOCK_ID)
Real number (ℝ)

Distinct	479
Distinct (%)	95.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1147393 × 10¹²

Minimum	1.101053 × 10¹²
Maximum	1.125074 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1.101053 × 10¹²
5-th percentile	1.1030627 × 10¹²
Q1	1.108083 × 10¹²
median	1.1150625 × 10¹²
Q3	1.1210795 × 10¹²
95-th percentile	1.1241305 × 10¹²
Maximum	1.125074 × 10¹²
Range	2.402102 × 10¹⁰
Interquartile range (IQR)	1.299647 × 10¹⁰

Descriptive statistics

Standard deviation	7.1969117 × 10⁹
Coefficient of variation (CV)	0.0064561386
Kurtosis	-1.1962999
Mean	1.1147393 × 10¹²
Median Absolute Deviation (MAD)	6.01851 × 10⁹
Skewness	-0.23802217
Sum	5.5736966 × 10¹⁴
Variance	5.1795538 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1116058010023	2	0.4%
1124071010010	2	0.4%
1125054010007	2	0.4%
1121081020006	2	0.4%
1120055010002	2	0.4%
1111056050003	2	0.4%
1123064030006	2	0.4%
1116069010006	2	0.4%
1124068020003	2	0.4%
1123079010001	2	0.4%
Other values (469)	480	96.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1101053010005	1	0.2%
1101053020002	1	0.2%
1101053020004	1	0.2%
1101054010002	1	0.2%
1101055020002	1	0.2%
1101056020012	1	0.2%
1101058030001	1	0.2%
1101061030001	1	0.2%
1101064020004	1	0.2%
1101067010002	1	0.2%

Value	Count	Frequency (%)
1125074030501	1	0.2%
1125074020203	1	0.2%
1125074020007	1	0.2%
1125073030301	1	0.2%
1125073010006	1	0.2%
1125072020030	1	0.2%
1125071022501	1	0.2%
1125071020026	1	0.2%
1125067020023	1	0.2%
1125067010012	1	0.2%

업종코드(SE_UPJONG)
Categorical

Distinct	21
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

sb08	112
sb01	71
sb06	46
sb19	37
sb09	35
Other values (16)	199

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	sb11
2nd row	sb08
3rd row	sb01
4th row	sb11
5th row	sb09

Common Values

Value	Count	Frequency (%)
sb08	112	22.4%
sb01	71	14.2%
sb06	46	9.2%
sb19	37	7.4%
sb09	35	7.0%
sb03	32	6.4%
sb02	30	6.0%
sb11	21	4.2%
sb14	15	3.0%
sb04	15	3.0%
Other values (11)	86	17.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sb08	112	22.4%
sb01	71	14.2%
sb06	46	9.2%
sb19	37	7.4%
sb09	35	7.0%
sb03	32	6.4%
sb02	30	6.0%
sb11	21	4.2%
sb14	15	3.0%
sb04	15	3.0%
Other values (11)	86	17.2%

이용년월(TS_YM)
Real number (ℝ)

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

Minimum	201512
Maximum	201711
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	201512
5-th percentile	201512
Q1	201605
median	201611
Q3	201706
95-th percentile	201710
Maximum	201711
Range	199
Interquartile range (IQR)	101

Descriptive statistics

Standard deviation	58.377242
Coefficient of variation (CV)	0.00028950208
Kurtosis	-0.83420072
Mean	201647.06
Median Absolute Deviation (MAD)	90
Skewness	-0.36259214
Sum	1.0082353 × 10⁸
Variance	3407.9024
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
201709	28	5.6%
201601	27	5.4%
201512	27	5.4%
201609	25	5.0%
201701	25	5.0%
201703	23	4.6%
201605	23	4.6%
201707	22	4.4%
201603	22	4.4%
201608	22	4.4%
Other values (14)	256	51.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201512	27	5.4%
201601	27	5.4%
201602	15	3.0%
201603	22	4.4%
201604	18	3.6%
201605	23	4.6%
201606	20	4.0%
201607	21	4.2%
201608	22	4.4%
201609	25	5.0%

Value	Count	Frequency (%)
201711	19	3.8%
201710	17	3.4%
201709	28	5.6%
201708	19	3.8%
201707	22	4.4%
201706	22	4.4%
201705	22	4.4%
201704	20	4.0%
201703	23	4.6%
201702	13	2.6%

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

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

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	1.9590558
Coefficient of variation (CV)	0.48063195
Kurtosis	-1.1948654
Mean	4.076
Median Absolute Deviation (MAD)	2
Skewness	0.020106747
Sum	2038
Variance	3.8378998
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	85	17.0%
7	78	15.6%
3	77	15.4%
2	73	14.6%
6	68	13.6%
5	62	12.4%
1	57	11.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	57	11.4%
2	73	14.6%
3	77	15.4%
4	85	17.0%
5	62	12.4%
6	68	13.6%
7	78	15.6%

Value	Count	Frequency (%)
7	78	15.6%
6	68	13.6%
5	62	12.4%
4	85	17.0%
3	77	15.4%
2	73	14.6%
1	57	11.4%

시간대(TM)
Categorical

Distinct	4
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

t4	175
t3	163
t2	109
t1	53

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	t4
2nd row	t2
3rd row	t4
4th row	t3
5th row	t1

Common Values

Value	Count	Frequency (%)
t4	175	35.0%
t3	163	32.6%
t2	109	21.8%
t1	53	10.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
t4	175	35.0%
t3	163	32.6%
t2	109	21.8%
t1	53	10.6%

성별코드(SEX_CCD)
Categorical

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

M	259
F	241

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
M	259	51.8%
F	241	48.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
m	259	51.8%
f	241	48.2%

연령대구분(AGE_GB)
Real number (ℝ)

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

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

Descriptive statistics

Standard deviation	1.4958915
Coefficient of variation (CV)	0.42400553
Kurtosis	-1.0263262
Mean	3.528
Median Absolute Deviation (MAD)	1
Skewness	0.068340349
Sum	1764
Variance	2.2376914
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2	110	22.0%
4	110	22.0%
3	96	19.2%
5	83	16.6%
6	60	12.0%
1	41	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	41	8.2%
2	110	22.0%
3	96	19.2%
4	110	22.0%
5	83	16.6%
6	60	12.0%

Value	Count	Frequency (%)
6	60	12.0%
5	83	16.6%
4	110	22.0%
3	96	19.2%
2	110	22.0%
1	41	8.2%

이용건수(USECT_CORR)
Real number (ℝ)

Distinct	51
Distinct (%)	10.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	41.71336

Minimum	4.94
Maximum	1274.52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	4.94
5-th percentile	4.94
Q1	4.94
median	9.88
Q3	29.64
95-th percentile	172.9
Maximum	1274.52
Range	1269.58
Interquartile range (IQR)	24.7

Descriptive statistics

Standard deviation	109.76434
Coefficient of variation (CV)	2.6313953
Kurtosis	65.1815
Mean	41.71336
Median Absolute Deviation (MAD)	4.94
Skewness	7.2454981
Sum	20856.68
Variance	12048.21
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.94	189	37.8%
9.88	68	13.6%
19.76	40	8.0%
14.82	39	7.8%
29.64	26	5.2%
24.7	18	3.6%
34.58	17	3.4%
44.46	10	2.0%
39.52	10	2.0%
54.34	8	1.6%
Other values (41)	75	15.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.94	189	37.8%
9.88	68	13.6%
14.82	39	7.8%
19.76	40	8.0%
24.7	18	3.6%
29.64	26	5.2%
34.58	17	3.4%
39.52	10	2.0%
44.46	10	2.0%
49.4	6	1.2%

Value	Count	Frequency (%)
1274.52	1	0.2%
1136.2	1	0.2%
978.12	1	0.2%
671.84	1	0.2%
602.68	1	0.2%
508.82	1	0.2%
405.08	1	0.2%
395.2	1	0.2%
316.16	1	0.2%
291.46	1	0.2%

이용금액(AMT_CORR)
Real number (ℝ)

Distinct	382
Distinct (%)	76.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1336130.8

Minimum	2717
Maximum	1.8257153 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	2717
5-th percentile	17759.3
Q1	66097.2
median	170430
Q3	502225.1
95-th percentile	3517922.2
Maximum	1.8257153 × 10⁸
Range	1.8256882 × 10⁸
Interquartile range (IQR)	436127.9

Descriptive statistics

Standard deviation	8929220.8
Coefficient of variation (CV)	6.6828941
Kurtosis	343.49741
Mean	1336130.8
Median Absolute Deviation (MAD)	133380
Skewness	17.388713
Sum	6.6806541 × 10⁸
Variance	7.9730984 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
74100.0	8	1.6%
49400.0	7	1.4%
113620.0	7	1.4%
14820.0	6	1.2%
34580.0	6	1.2%
83980.0	5	1.0%
123500.0	5	1.0%
22230.0	5	1.0%
44460.0	5	1.0%
39520.0	5	1.0%
Other values (372)	441	88.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2717.0	1	0.2%
4940.0	2	0.4%
5434.0	1	0.2%
7904.0	1	0.2%
8645.0	1	0.2%
8892.0	1	0.2%
9880.0	4	0.8%
10868.0	1	0.2%
12350.0	2	0.4%
12844.0	1	0.2%

Value	Count	Frequency (%)
182571532.0	1	0.2%
44801255.2	1	0.2%
36633271.48	1	0.2%
33023603.6	1	0.2%
32150310.4	1	0.2%
16257885.8	1	0.2%
15184078.0	1	0.2%
12854374.0	1	0.2%
12821770.0	1	0.2%
11005332.0	1	0.2%

Heatmap
Table

	행정동코드(M_DONG_CD)	블록코드(BLOCK_ID)	업종코드(SE_UPJONG)	이용년월(TS_YM)	요일코드(DAW_CCD)	시간대(TM)	성별코드(SEX_CCD)	연령대구분(AGE_GB)	이용건수(USECT_CORR)	이용금액(AMT_CORR)
행정동코드(M_DONG_CD)	1.000	0.000	0.150	0.000	0.095	0.000	0.109	0.104	0.094	0.000
블록코드(BLOCK_ID)	0.000	1.000	0.186	0.000	0.118	0.081	0.000	0.000	0.000	0.000
업종코드(SE_UPJONG)	0.150	0.186	1.000	0.000	0.055	0.000	0.196	0.254	0.000	0.218
이용년월(TS_YM)	0.000	0.000	0.000	1.000	0.000	0.047	0.000	0.067	0.000	0.000
요일코드(DAW_CCD)	0.095	0.118	0.055	0.000	1.000	0.000	0.000	0.039	0.082	0.000
시간대(TM)	0.000	0.081	0.000	0.047	0.000	1.000	0.000	0.080	0.000	0.000
성별코드(SEX_CCD)	0.109	0.000	0.196	0.000	0.000	0.000	1.000	0.030	0.070	0.000
연령대구분(AGE_GB)	0.104	0.000	0.254	0.067	0.039	0.080	0.030	1.000	0.000	0.077
이용건수(USECT_CORR)	0.094	0.000	0.000	0.000	0.082	0.000	0.070	0.000	1.000	0.000
이용금액(AMT_CORR)	0.000	0.000	0.218	0.000	0.000	0.000	0.000	0.077	0.000	1.000

Heatmap
Table

	시간대(TM)	성별코드(SEX_CCD)	업종코드(SE_UPJONG)
시간대(TM)	1.000	0.000	0.000
성별코드(SEX_CCD)	0.000	1.000	0.169
업종코드(SE_UPJONG)	0.000	0.169	1.000

Heatmap
Table

	행정동코드(M_DONG_CD)	블록코드(BLOCK_ID)	이용년월(TS_YM)	요일코드(DAW_CCD)	연령대구분(AGE_GB)	이용건수(USECT_CORR)	이용금액(AMT_CORR)	업종코드(SE_UPJONG)	시간대(TM)	성별코드(SEX_CCD)
행정동코드(M_DONG_CD)	1.000	-0.003	0.034	0.046	0.041	0.089	0.041	0.056	0.000	0.074
블록코드(BLOCK_ID)	-0.003	1.000	0.013	-0.047	-0.065	-0.085	0.059	0.067	0.045	0.000
이용년월(TS_YM)	0.034	0.013	1.000	-0.038	0.016	-0.013	-0.027	0.087	0.025	0.000
요일코드(DAW_CCD)	0.046	-0.047	-0.038	1.000	0.045	0.053	-0.054	0.018	0.000	0.000
연령대구분(AGE_GB)	0.041	-0.065	0.016	0.045	1.000	-0.015	-0.125	0.115	0.052	0.021
이용건수(USECT_CORR)	0.089	-0.085	-0.013	0.053	-0.015	1.000	0.012	0.000	0.000	0.070
이용금액(AMT_CORR)	0.041	0.059	-0.027	-0.054	-0.125	0.012	1.000	0.117	0.000	0.000
업종코드(SE_UPJONG)	0.056	0.067	0.087	0.018	0.115	0.000	0.117	1.000	0.000	0.169
시간대(TM)	0.000	0.045	0.025	0.000	0.052	0.000	0.000	0.000	1.000	0.000
성별코드(SEX_CCD)	0.074	0.000	0.000	0.000	0.021	0.070	0.000	0.169	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

	행정동코드(M_DONG_CD)	블록코드(BLOCK_ID)	업종코드(SE_UPJONG)	이용년월(TS_YM)	요일코드(DAW_CCD)	시간대(TM)	성별코드(SEX_CCD)	연령대구분(AGE_GB)	이용건수(USECT_CORR)	이용금액(AMT_CORR)
0	1116063	1118057040004	sb11	201711	5	t4	M	6	9.88	17784.0
1	1104065	1118054020017	sb08	201703	2	t2	M	2	4.94	123500.0
2	1120053	1108065010907	sb01	201701	7	t4	M	3	103.74	782496.0
3	1119056	1114060020001	sb11	201608	1	t3	M	2	29.64	306280.0
4	1108064	1114059030303	sb09	201512	2	t1	M	4	4.94	47918.0
5	1123077	1103065020002	sb06	201606	4	t2	M	4	4.94	127946.0
6	1123075	1125067020023	sb20	201612	7	t3	F	1	19.76	256880.0
7	1117067	1111065030003	sb06	201608	3	t2	M	5	34.58	122512.0
8	1123064	1115063020010	sb01	201601	2	t4	F	2	4.94	296894.0
9	1102059	1118052040005	sb12	201709	1	t3	M	5	59.28	37050.0

	행정동코드(M_DONG_CD)	블록코드(BLOCK_ID)	업종코드(SE_UPJONG)	이용년월(TS_YM)	요일코드(DAW_CCD)	시간대(TM)	성별코드(SEX_CCD)	연령대구분(AGE_GB)	이용건수(USECT_CORR)	이용금액(AMT_CORR)
490	1111060	1103066020004	sb08	201604	3	t4	F	5	9.88	44460.0
491	1108078	1119068040003	sb08	201601	2	t2	M	2	19.76	6514378.0
492	1112057	1105064020022	sb06	201706	6	t4	F	6	14.82	83980.0
493	1118054	1119072040008	sb09	201703	4	t1	F	2	9.88	429780.0
494	1106087	1121063020015	sb08	201706	1	t4	F	2	9.88	674310.0
495	1110051	1125053010003	sb10	201604	2	t2	M	2	4.94	66196.0
496	1114076	1123064030006	sb08	201607	4	t4	F	3	4.94	33023603.6
497	1114076	1108068010004	sb02	201604	4	t3	F	3	128.44	985530.0
498	1112071	1120055020021	sb06	201609	3	t2	M	2	4.94	107494.4
499	1106091	1101056020012	sb09	201605	4	t2	M	1	9.88	1066743.6

Overview

Variables

Common Values

Length

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample