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	43.1 KiB
Average record size in memory	88.3 B

Variable types

Text	2
Categorical	2
Numeric	6

Dataset

Description	샘플 데이터
Author	롯데멤버스
URL	https://bigdata.seoul.go.kr/data/selectSampleData.do?sample_data_seq=56

Reproduction

Analysis started	2023-12-10 14:58:31.161603
Analysis finished	2023-12-10 14:58:40.633900
Duration	9.47 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

주거지역(RES_AREA_CD)
Text

Distinct	172
Distinct (%)	34.4%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1500
Distinct characters	35
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	60 ?
Unique (%)	12.0%

Sample

1st row	K07
2nd row	R13
3rd row	C07
4th row	K11
5th row	R13

Value	Count	Frequency (%)
d12	11	2.2%
e13	10	2.0%
i02	10	2.0%
i04	10	2.0%
j02	9	1.8%
r07	9	1.8%
k07	8	1.6%
r13	8	1.6%
c01	7	1.4%
d05	7	1.4%
Other values (162)	411	82.2%

Most occurring characters

Value	Count	Frequency (%)
0	397	26.5%
1	154	10.3%
2	116	7.7%
3	81	5.4%
4	57	3.8%
5	53	3.5%
R	52	3.5%
7	42	2.8%
D	39	2.6%
6	39	2.6%
Other values (25)	470	31.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1000	66.7%
Uppercase Letter	500	33.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	52	10.4%
D	39	7.8%
I	31	6.2%
T	27	5.4%
M	24	4.8%
K	24	4.8%
Q	23	4.6%
A	22	4.4%
C	20	4.0%
G	20	4.0%
Other values (15)	218	43.6%

Decimal Number

Value	Count	Frequency (%)
0	397	39.7%
1	154	15.4%
2	116	11.6%
3	81	8.1%
4	57	5.7%
5	53	5.3%
7	42	4.2%
6	39	3.9%
8	38	3.8%
9	23	2.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	1000	66.7%
Latin	500	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	52	10.4%
D	39	7.8%
I	31	6.2%
T	27	5.4%
M	24	4.8%
K	24	4.8%
Q	23	4.6%
A	22	4.4%
C	20	4.0%
G	20	4.0%
Other values (15)	218	43.6%

Common

Value	Count	Frequency (%)
0	397	39.7%
1	154	15.4%
2	116	11.6%
3	81	8.1%
4	57	5.7%
5	53	5.3%
7	42	4.2%
6	39	3.9%
8	38	3.8%
9	23	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1500	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	397	26.5%
1	154	10.3%
2	116	7.7%
3	81	5.4%
4	57	3.8%
5	53	3.5%
R	52	3.5%
7	42	2.8%
D	39	2.6%
6	39	2.6%
Other values (25)	470	31.3%

소비지역(USE_AREA_CD)
Text

Distinct	122
Distinct (%)	24.4%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1500
Distinct characters	35
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	43 ?
Unique (%)	8.6%

Sample

1st row	X41
2nd row	X16
3rd row	X11
4th row	I02
5th row	T09

Value	Count	Frequency (%)
r09	35	7.0%
r13	26	5.2%
t09	22	4.4%
x11	21	4.2%
k07	21	4.2%
i02	18	3.6%
o04	15	3.0%
i04	14	2.8%
d08	13	2.6%
f02	11	2.2%
Other values (112)	304	60.8%

Most occurring characters

Value	Count	Frequency (%)
0	372	24.8%
1	182	12.1%
2	114	7.6%
R	87	5.8%
3	67	4.5%
9	66	4.4%
4	62	4.1%
5	45	3.0%
7	39	2.6%
I	37	2.5%
Other values (25)	429	28.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1000	66.7%
Uppercase Letter	500	33.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	87	17.4%
I	37	7.4%
T	35	7.0%
X	31	6.2%
K	28	5.6%
D	28	5.6%
O	27	5.4%
F	24	4.8%
A	23	4.6%
U	22	4.4%
Other values (15)	158	31.6%

Decimal Number

Value	Count	Frequency (%)
0	372	37.2%
1	182	18.2%
2	114	11.4%
3	67	6.7%
9	66	6.6%
4	62	6.2%
5	45	4.5%
7	39	3.9%
6	30	3.0%
8	23	2.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	1000	66.7%
Latin	500	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	87	17.4%
I	37	7.4%
T	35	7.0%
X	31	6.2%
K	28	5.6%
D	28	5.6%
O	27	5.4%
F	24	4.8%
A	23	4.6%
U	22	4.4%
Other values (15)	158	31.6%

Common

Value	Count	Frequency (%)
0	372	37.2%
1	182	18.2%
2	114	11.4%
3	67	6.7%
9	66	6.6%
4	62	6.2%
5	45	4.5%
7	39	3.9%
6	30	3.0%
8	23	2.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1500	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	372	24.8%
1	182	12.1%
2	114	7.6%
R	87	5.8%
3	67	4.5%
9	66	4.4%
4	62	4.1%
5	45	3.0%
7	39	2.6%
I	37	2.5%
Other values (25)	429	28.6%

성별(GENDER)
Categorical

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

2	319
1	181

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
2	319	63.8%
1	181	36.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	319	63.8%
1	181	36.2%

연령(AGE_GR_CD)
Real number (ℝ)

Distinct	12
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.074

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	4
median	6
Q3	8
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.5118006
Coefficient of variation (CV)	0.41353319
Kurtosis	-0.54296587
Mean	6.074
Median Absolute Deviation (MAD)	2
Skewness	0.29835335
Sum	3037
Variance	6.3091423
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	75	15.0%
5	71	14.2%
4	65	13.0%
8	63	12.6%
7	58	11.6%
3	44	8.8%
2	38	7.6%
9	35	7.0%
10	24	4.8%
11	14	2.8%
Other values (2)	13	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.2%
2	38	7.6%
3	44	8.8%
4	65	13.0%
5	71	14.2%
6	75	15.0%
7	58	11.6%
8	63	12.6%
9	35	7.0%
10	24	4.8%

Value	Count	Frequency (%)
12	12	2.4%
11	14	2.8%
10	24	4.8%
9	35	7.0%
8	63	12.6%
7	58	11.6%
6	75	15.0%
5	71	14.2%
4	65	13.0%
3	44	8.8%

이용년월일(DATE)
Real number (ℝ)

Distinct	401
Distinct (%)	80.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20179799

Minimum	20170101
Maximum	20191230
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	20170101
5-th percentile	20170223
Q1	20170828
median	20180509
Q3	20190304
95-th percentile	20191109
Maximum	20191230
Range	21129
Interquartile range (IQR)	19475.5

Descriptive statistics

Standard deviation	8122.2174
Coefficient of variation (CV)	0.00040249248
Kurtosis	-1.4541222
Mean	20179799
Median Absolute Deviation (MAD)	9697
Skewness	0.16590089
Sum	1.0089899 × 10¹⁰
Variance	65970415
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20170120	4	0.8%
20180902	4	0.8%
20170928	4	0.8%
20180303	3	0.6%
20170619	3	0.6%
20171103	3	0.6%
20180518	3	0.6%
20180221	3	0.6%
20171220	3	0.6%
20170116	3	0.6%
Other values (391)	467	93.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20170101	1	0.2%
20170103	1	0.2%
20170111	1	0.2%
20170113	2	0.4%
20170114	1	0.2%
20170116	3	0.6%
20170120	4	0.8%
20170121	1	0.2%
20170125	1	0.2%
20170126	1	0.2%

Value	Count	Frequency (%)
20191230	1	0.2%
20191228	1	0.2%
20191226	2	0.4%
20191223	2	0.4%
20191221	1	0.2%
20191218	1	0.2%
20191216	2	0.4%
20191210	2	0.4%
20191209	1	0.2%
20191207	1	0.2%

업종(UPJONG_CD)
Categorical

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

4	281
2	77
1	76
3	66

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
4	281	56.2%
2	77	15.4%
1	76	15.2%
3	66	13.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	281	56.2%
2	77	15.4%
1	76	15.2%
3	66	13.2%

품목_및_가맹점(ITEM_CD)
Real number (ℝ)

Distinct	18
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.842

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	6
median	12
Q3	15
95-th percentile	20
Maximum	20
Range	19
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	5.4985001
Coefficient of variation (CV)	0.50714813
Kurtosis	-0.90000453
Mean	10.842
Median Absolute Deviation (MAD)	4
Skewness	-0.17370823
Sum	5421
Variance	30.233503
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
6	68	13.6%
16	63	12.6%
12	59	11.8%
9	47	9.4%
20	40	8.0%
15	38	7.6%
1	36	7.2%
11	28	5.6%
2	27	5.4%
13	25	5.0%
Other values (8)	69	13.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	36	7.2%
2	27	5.4%
4	5	1.0%
5	3	0.6%
6	68	13.6%
7	24	4.8%
8	2	0.4%
9	47	9.4%
10	1	0.2%
11	28	5.6%

Value	Count	Frequency (%)
20	40	8.0%
19	4	0.8%
18	14	2.8%
16	63	12.6%
15	38	7.6%
14	16	3.2%
13	25	5.0%
12	59	11.8%
11	28	5.6%
10	1	0.2%

이용고객수(USE_CUSTM_CNT)
Real number (ℝ)

Distinct	16
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.694

Minimum	1
Maximum	46
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	4
Maximum	46
Range	45
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.9519132
Coefficient of variation (CV)	1.7425698
Kurtosis	121.99183
Mean	1.694
Median Absolute Deviation (MAD)	0
Skewness	9.7180733
Sum	847
Variance	8.7137916
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
1	404	80.8%
2	41	8.2%
3	19	3.8%
4	14	2.8%
5	6	1.2%
6	4	0.8%
16	2	0.4%
9	2	0.4%
46	1	0.2%
17	1	0.2%
Other values (6)	6	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	404	80.8%
2	41	8.2%
3	19	3.8%
4	14	2.8%
5	6	1.2%
6	4	0.8%
7	1	0.2%
8	1	0.2%
9	2	0.4%
11	1	0.2%

Value	Count	Frequency (%)
46	1	0.2%
30	1	0.2%
17	1	0.2%
16	2	0.4%
13	1	0.2%
12	1	0.2%
11	1	0.2%
9	2	0.4%
8	1	0.2%
7	1	0.2%

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

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

Minimum	1
Maximum	66
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	7
Maximum	66
Range	65
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	4.1477792
Coefficient of variation (CV)	1.7695304
Kurtosis	118.54133
Mean	2.344
Median Absolute Deviation (MAD)	0
Skewness	9.0516586
Sum	1172
Variance	17.204072
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
1	320	64.0%
2	75	15.0%
3	41	8.2%
4	14	2.8%
5	13	2.6%
6	9	1.8%
7	6	1.2%
13	3	0.6%
15	3	0.6%
9	3	0.6%
Other values (10)	13	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	320	64.0%
2	75	15.0%
3	41	8.2%
4	14	2.8%
5	13	2.6%
6	9	1.8%
7	6	1.2%
8	2	0.4%
9	3	0.6%
10	1	0.2%

Value	Count	Frequency (%)
66	1	0.2%
32	1	0.2%
22	1	0.2%
20	1	0.2%
19	1	0.2%
16	2	0.4%
15	3	0.6%
13	3	0.6%
12	1	0.2%
11	2	0.4%

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

Distinct	56
Distinct (%)	11.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11954

Minimum	1000
Maximum	202000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1000
5-th percentile	1000
Q1	4000
median	7000
Q3	15000
95-th percentile	36050
Maximum	202000
Range	201000
Interquartile range (IQR)	11000

Descriptive statistics

Standard deviation	15560.467
Coefficient of variation (CV)	1.3016954
Kurtosis	47.99704
Mean	11954
Median Absolute Deviation (MAD)	5000
Skewness	5.1888316
Sum	5977000
Variance	2.4212814 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000	52	10.4%
5000	48	9.6%
1000	39	7.8%
4000	35	7.0%
6000	32	6.4%
3000	29	5.8%
10000	28	5.6%
8000	26	5.2%
9000	20	4.0%
15000	17	3.4%
Other values (46)	174	34.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	39	7.8%
2000	52	10.4%
3000	29	5.8%
4000	35	7.0%
5000	48	9.6%
6000	32	6.4%
7000	16	3.2%
8000	26	5.2%
9000	20	4.0%
10000	28	5.6%

Value	Count	Frequency (%)
202000	1	0.2%
90000	1	0.2%
88000	1	0.2%
73000	1	0.2%
72000	1	0.2%
69000	1	0.2%
66000	2	0.4%
64000	1	0.2%
63000	1	0.2%
61000	1	0.2%

Heatmap
Table

	성별(GENDER)	연령(AGE_GR_CD)	이용년월일(DATE)	업종(UPJONG_CD)	품목_및_가맹점(ITEM_CD)	이용고객수(USE_CUSTM_CNT)	이용건수(USE_CNT)	이용금액(USE_AMT)
성별(GENDER)	1.000	0.000	0.000	0.000	0.111	0.097	0.000	0.000
연령(AGE_GR_CD)	0.000	1.000	0.082	0.000	0.000	0.086	0.000	0.000
이용년월일(DATE)	0.000	0.082	1.000	0.000	0.000	0.108	0.000	0.059
업종(UPJONG_CD)	0.000	0.000	0.000	1.000	0.114	0.071	0.126	0.000
품목_및_가맹점(ITEM_CD)	0.111	0.000	0.000	0.114	1.000	0.000	0.000	0.088
이용고객수(USE_CUSTM_CNT)	0.097	0.086	0.108	0.071	0.000	1.000	0.000	0.000
이용건수(USE_CNT)	0.000	0.000	0.000	0.126	0.000	0.000	1.000	0.370
이용금액(USE_AMT)	0.000	0.000	0.059	0.000	0.088	0.000	0.370	1.000

Heatmap
Table

	성별(GENDER)	업종(UPJONG_CD)
성별(GENDER)	1.000	0.000
업종(UPJONG_CD)	0.000	1.000

Heatmap
Table

	연령(AGE_GR_CD)	이용년월일(DATE)	품목_및_가맹점(ITEM_CD)	이용고객수(USE_CUSTM_CNT)	이용건수(USE_CNT)	이용금액(USE_AMT)	성별(GENDER)	업종(UPJONG_CD)
연령(AGE_GR_CD)	1.000	-0.034	0.042	-0.007	0.019	-0.129	0.000	0.000
이용년월일(DATE)	-0.034	1.000	-0.010	-0.051	-0.040	-0.064	0.000	0.000
품목_및_가맹점(ITEM_CD)	0.042	-0.010	1.000	0.063	-0.024	0.083	0.084	0.068
이용고객수(USE_CUSTM_CNT)	-0.007	-0.051	0.063	1.000	0.036	-0.016	0.069	0.045
이용건수(USE_CNT)	0.019	-0.040	-0.024	0.036	1.000	-0.046	0.000	0.081
이용금액(USE_AMT)	-0.129	-0.064	0.083	-0.016	-0.046	1.000	0.000	0.000
성별(GENDER)	0.000	0.000	0.084	0.069	0.000	0.000	1.000	0.000
업종(UPJONG_CD)	0.000	0.000	0.068	0.045	0.081	0.000	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

	주거지역(RES_AREA_CD)	소비지역(USE_AREA_CD)	성별(GENDER)	연령(AGE_GR_CD)	이용년월일(DATE)	업종(UPJONG_CD)	품목_및_가맹점(ITEM_CD)	이용고객수(USE_CUSTM_CNT)	이용건수(USE_CNT)	이용금액(USE_AMT)
0	K07	X41	1	4	20180324	1	1	1	4	20000
1	R13	X16	2	4	20180725	4	15	1	3	9000
2	C07	X11	2	2	20191025	1	16	2	1	24000
3	K11	I02	2	7	20190128	3	11	4	4	4000
4	R13	T09	1	7	20190927	4	12	1	2	6000
5	D09	V12	1	5	20170731	4	13	1	1	16000
6	I04	B06	2	7	20180504	3	16	3	1	36000
7	L01	O04	2	6	20180807	1	2	1	3	8000
8	P10	T06	1	6	20190515	1	16	1	2	4000
9	V09	Y03	1	8	20170207	4	1	1	1	21000

	주거지역(RES_AREA_CD)	소비지역(USE_AREA_CD)	성별(GENDER)	연령(AGE_GR_CD)	이용년월일(DATE)	업종(UPJONG_CD)	품목_및_가맹점(ITEM_CD)	이용고객수(USE_CUSTM_CNT)	이용건수(USE_CNT)	이용금액(USE_AMT)
490	L02	O02	2	6	20190219	4	6	9	1	6000
491	W64	I02	2	5	20190904	3	15	1	15	23000
492	R14	R09	1	3	20190920	4	15	3	1	4000
493	A12	X20	2	12	20170615	4	9	1	3	1000
494	Q03	B07	2	5	20190325	4	15	1	2	20000
495	V12	C01	2	4	20191207	4	9	1	1	6000
496	O03	H02	2	6	20180715	3	11	2	1	1000
497	P02	I04	2	5	20181028	4	9	1	1	5000
498	I02	R09	1	5	20170415	4	1	1	1	22000
499	M06	Q04	1	4	20180717	3	14	1	1	6000

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample