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.6 KiB
Average record size in memory	89.3 B

Variable types

Numeric	7
Text	1
Categorical	2

Dataset

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

Alerts

구매_고객수(ACC_CNT) is highly imbalanced (83.3%) Imbalance

Reproduction

Analysis started	2023-12-10 14:50:40.234209
Analysis finished	2023-12-10 14:50:46.390834
Duration	6.16 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

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

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

Minimum	201801
Maximum	201912
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	201801
5-th percentile	201802
Q1	201807
median	201812
Q3	201907
95-th percentile	201911
Maximum	201912
Range	111
Interquartile range (IQR)	100

Descriptive statistics

Standard deviation	50.136278
Coefficient of variation (CV)	0.00024837938
Kurtosis	-1.9734067
Mean	201853.62
Median Absolute Deviation (MAD)	11
Skewness	0.12746739
Sum	1.0092681 × 10⁸
Variance	2513.6464
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
201809	32	6.4%
201808	30	6.0%
201812	29	5.8%
201907	28	5.6%
201908	26	5.2%
201910	25	5.0%
201801	24	4.8%
201807	23	4.6%
201904	23	4.6%
201909	23	4.6%
Other values (14)	237	47.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201801	24	4.8%
201802	14	2.8%
201803	23	4.6%
201804	15	3.0%
201805	21	4.2%
201806	23	4.6%
201807	23	4.6%
201808	30	6.0%
201809	32	6.4%
201810	17	3.4%

Value	Count	Frequency (%)
201912	22	4.4%
201911	15	3.0%
201910	25	5.0%
201909	23	4.6%
201908	26	5.2%
201907	28	5.6%
201906	13	2.6%
201905	14	2.8%
201904	23	4.6%
201903	13	2.6%

블록코드(BLCK_CD)
Text

Distinct	314
Distinct (%)	62.8%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	6
Median length	6
Mean length	5.75
Min length	4

Characters and Unicode

Total characters	2875
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

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

Unique

Unique	204 ?
Unique (%)	40.8%

Sample

1st row	294*
2nd row	479*
3rd row	228*
4th row	406*
5th row	181*

Value	Count	Frequency (%)
267	8	1.6%
277	7	1.4%
269	7	1.4%
351	6	1.2%
490	5	1.0%
216	5	1.0%
298	5	1.0%
222	5	1.0%
239	5	1.0%
294	5	1.0%
Other values (258)	442	88.4%

Most occurring characters

Value	Count	Frequency (%)
*	1392	48.4%
2	302	10.5%
1	214	7.4%
3	178	6.2%
4	169	5.9%
9	123	4.3%
5	119	4.1%
7	114	4.0%
6	101	3.5%
8	96	3.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1483	51.6%
Other Punctuation	1392	48.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	302	20.4%
1	214	14.4%
3	178	12.0%
4	169	11.4%
9	123	8.3%
5	119	8.0%
7	114	7.7%
6	101	6.8%
8	96	6.5%
0	67	4.5%

Other Punctuation

Value	Count	Frequency (%)
*	1392	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2875	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
*	1392	48.4%
2	302	10.5%
1	214	7.4%
3	178	6.2%
4	169	5.9%
9	123	4.3%
5	119	4.1%
7	114	4.0%
6	101	3.5%
8	96	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2875	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
*	1392	48.4%
2	302	10.5%
1	214	7.4%
3	178	6.2%
4	169	5.9%
9	123	4.3%
5	119	4.1%
7	114	4.0%
6	101	3.5%
8	96	3.3%

성별코드(SEX_CD)
Categorical

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

2	359
1	141

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

Common Values

Value	Count	Frequency (%)
2	359	71.8%
1	141	28.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	359	71.8%
1	141	28.2%

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

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

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	2
Q1	3
median	4
Q3	5
95-th percentile	6
Maximum	7
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.2629386
Coefficient of variation (CV)	0.29535516
Kurtosis	-0.48796716
Mean	4.276
Median Absolute Deviation (MAD)	1
Skewness	0.1463018
Sum	2138
Variance	1.595014
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	153	30.6%
5	120	24.0%
3	103	20.6%
6	65	13.0%
2	36	7.2%
7	22	4.4%
1	1	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.2%
2	36	7.2%
3	103	20.6%
4	153	30.6%
5	120	24.0%
6	65	13.0%
7	22	4.4%

Value	Count	Frequency (%)
7	22	4.4%
6	65	13.0%
5	120	24.0%
4	153	30.6%
3	103	20.6%
2	36	7.2%
1	1	0.2%

상품코드(LMPH_CD)
Real number (ℝ)

Distinct	216
Distinct (%)	43.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1469531.5

Minimum	1010102
Maximum	10010104
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1010102
5-th percentile	1010601
Q1	1011501
median	1050302
Q3	1070201
95-th percentile	5010302.1
Maximum	10010104
Range	9000002
Interquartile range (IQR)	58700

Descriptive statistics

Standard deviation	1275028.3
Coefficient of variation (CV)	0.86764276
Kurtosis	15.433516
Mean	1469531.5
Median Absolute Deviation (MAD)	34300
Skewness	3.7207544
Sum	7.3476573 × 10⁸
Variance	1.6256972 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1070109	16	3.2%
1011107	15	3.0%
1060103	11	2.2%
1080101	11	2.2%
1070106	11	2.2%
1011601	10	2.0%
1010708	9	1.8%
1070201	8	1.6%
1060201	8	1.6%
1011106	7	1.4%
Other values (206)	394	78.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1010102	1	0.2%
1010104	1	0.2%
1010202	1	0.2%
1010203	2	0.4%
1010204	1	0.2%
1010205	2	0.4%
1010206	2	0.4%
1010207	1	0.2%
1010212	2	0.4%
1010305	1	0.2%

Value	Count	Frequency (%)
10010104	1	0.2%
9029999	2	0.4%
9029906	1	0.2%
8029902	1	0.2%
8020807	1	0.2%
7010202	1	0.2%
6111001	1	0.2%
6030307	1	0.2%
5030804	1	0.2%
5030701	1	0.2%

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

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

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	2
Q1	4
median	5
Q3	5
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.0871356
Coefficient of variation (CV)	0.24991622
Kurtosis	-0.34635295
Mean	4.35
Median Absolute Deviation (MAD)	1
Skewness	-0.49434392
Sum	2175
Variance	1.1818637
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	200	40.0%
4	126	25.2%
3	85	17.0%
6	60	12.0%
2	27	5.4%
1	2	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.4%
2	27	5.4%
3	85	17.0%
4	126	25.2%
5	200	40.0%
6	60	12.0%

Value	Count	Frequency (%)
6	60	12.0%
5	200	40.0%
4	126	25.2%
3	85	17.0%
2	27	5.4%
1	2	0.4%

구매지역(PURH_AREA)
Real number (ℝ)

Distinct	136
Distinct (%)	27.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10026545

Minimum	27260
Maximum	11740610
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	27260
5-th percentile	41284.4
Q1	11230570
median	11380690
Q3	11575682
95-th percentile	11710680
Maximum	11740610
Range	11713350
Interquartile range (IQR)	345112.5

Descriptive statistics

Standard deviation	3799425.2
Coefficient of variation (CV)	0.37893665
Kurtosis	3.1020102
Mean	10026545
Median Absolute Deviation (MAD)	179845
Skewness	-2.2521704
Sum	5.0132723 × 10⁹
Variance	1.4435632 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11380690	27	5.4%
11545610	25	5.0%
11350621	19	3.8%
11230560	18	3.6%
11710680	17	3.4%
11710642	17	3.4%
11320690	16	3.2%
11560535	15	3.0%
11305534	15	3.0%
11530530	13	2.6%
Other values (126)	318	63.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
27260	1	0.2%
28185	2	0.4%
28237	3	0.6%
28260	1	0.2%
29140	2	0.4%
29200	1	0.2%
30200	3	0.6%
41113	1	0.2%
41117	2	0.4%
41131	1	0.2%

Value	Count	Frequency (%)
11740610	1	0.2%
11710710	13	2.6%
11710690	2	0.4%
11710680	17	3.4%
11710670	4	0.8%
11710647	1	0.2%
11710646	1	0.2%
11710642	17	3.4%
11710620	2	0.4%
11710600	1	0.2%

구매_고객수(ACC_CNT)
Categorical

IMBALANCE

Distinct	3
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

1	481
2	14
3	5

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

Common Values

Value	Count	Frequency (%)
1	481	96.2%
2	14	2.8%
3	5	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	481	96.2%
2	14	2.8%
3	5	1.0%

구매건수(PURH_CNT)
Real number (ℝ)

Distinct	11
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.624

Minimum	1
Maximum	17
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	4
Maximum	17
Range	16
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.5083681
Coefficient of variation (CV)	0.9287981
Kurtosis	35.099767
Mean	1.624
Median Absolute Deviation (MAD)	0
Skewness	5.007691
Sum	812
Variance	2.2751743
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
1	345	69.0%
2	98	19.6%
3	27	5.4%
4	10	2.0%
7	5	1.0%
6	5	1.0%
5	5	1.0%
9	2	0.4%
12	1	0.2%
13	1	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	345	69.0%
2	98	19.6%
3	27	5.4%
4	10	2.0%
5	5	1.0%
6	5	1.0%
7	5	1.0%
9	2	0.4%
12	1	0.2%
13	1	0.2%

Value	Count	Frequency (%)
17	1	0.2%
13	1	0.2%
12	1	0.2%
9	2	0.4%
7	5	1.0%
6	5	1.0%
5	5	1.0%
4	10	2.0%
3	27	5.4%
2	98	19.6%

구매금액(PURH_AMT)
Real number (ℝ)

Distinct	52
Distinct (%)	10.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13114

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

Quantile statistics

Minimum	1000
5-th percentile	1000
Q1	2000
median	5000
Q3	9000
95-th percentile	31050
Maximum	1739000
Range	1738000
Interquartile range (IQR)	7000

Descriptive statistics

Standard deviation	81032.62
Coefficient of variation (CV)	6.1790926
Kurtosis	415.50053
Mean	13114
Median Absolute Deviation (MAD)	3000
Skewness	19.719575
Sum	6557000
Variance	6.5662856 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000	73	14.6%
1000	63	12.6%
3000	54	10.8%
4000	47	9.4%
5000	44	8.8%
6000	38	7.6%
7000	27	5.4%
8000	25	5.0%
10000	15	3.0%
9000	13	2.6%
Other values (42)	101	20.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	63	12.6%
2000	73	14.6%
3000	54	10.8%
4000	47	9.4%
5000	44	8.8%
6000	38	7.6%
7000	27	5.4%
8000	25	5.0%
9000	13	2.6%
10000	15	3.0%

Value	Count	Frequency (%)
1739000	1	0.2%
381000	1	0.2%
284000	1	0.2%
155000	1	0.2%
110000	1	0.2%
66000	1	0.2%
65000	1	0.2%
54000	1	0.2%
52000	1	0.2%
51000	1	0.2%

Heatmap
Table

	기준년월(STD_YM)	성별코드(SEX_CD)	연령대코드(AGE_CD)	상품코드(LMPH_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
기준년월(STD_YM)	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.014
성별코드(SEX_CD)	0.000	1.000	0.069	0.000	0.000	0.000	0.033	0.044	0.119
연령대코드(AGE_CD)	0.000	0.069	1.000	0.000	0.033	0.071	0.000	0.000	0.000
상품코드(LMPH_CD)	0.000	0.000	0.000	1.000	0.000	0.247	0.000	0.000	0.000
시간대코드(TIME_CD)	0.000	0.000	0.033	0.000	1.000	0.116	0.000	0.000	0.024
구매지역(PURH_AREA)	0.000	0.000	0.071	0.247	0.116	1.000	0.024	0.000	0.000
구매_고객수(ACC_CNT)	0.000	0.033	0.000	0.000	0.000	0.024	1.000	0.000	0.000
구매건수(PURH_CNT)	0.000	0.044	0.000	0.000	0.000	0.000	0.000	1.000	0.000
구매금액(PURH_AMT)	0.014	0.119	0.000	0.000	0.024	0.000	0.000	0.000	1.000

Heatmap
Table

	구매_고객수(ACC_CNT)	성별코드(SEX_CD)
구매_고객수(ACC_CNT)	1.000	0.055
성별코드(SEX_CD)	0.055	1.000

Heatmap
Table

	기준년월(STD_YM)	연령대코드(AGE_CD)	상품코드(LMPH_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매건수(PURH_CNT)	구매금액(PURH_AMT)	성별코드(SEX_CD)	구매_고객수(ACC_CNT)
기준년월(STD_YM)	1.000	-0.008	0.031	-0.022	0.010	-0.007	-0.004	0.000	0.000
연령대코드(AGE_CD)	-0.008	1.000	0.014	0.090	0.008	-0.029	-0.048	0.073	0.000
상품코드(LMPH_CD)	0.031	0.014	1.000	-0.010	0.028	-0.055	0.038	0.000	0.000
시간대코드(TIME_CD)	-0.022	0.090	-0.010	1.000	-0.049	-0.056	0.060	0.000	0.000
구매지역(PURH_AREA)	0.010	0.008	0.028	-0.049	1.000	-0.017	0.004	0.000	0.041
구매건수(PURH_CNT)	-0.007	-0.029	-0.055	-0.056	-0.017	1.000	0.020	0.033	0.000
구매금액(PURH_AMT)	-0.004	-0.048	0.038	0.060	0.004	0.020	1.000	0.071	0.000
성별코드(SEX_CD)	0.000	0.073	0.000	0.000	0.000	0.033	0.071	1.000	0.055
구매_고객수(ACC_CNT)	0.000	0.000	0.000	0.000	0.041	0.000	0.000	0.055	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)	블록코드(BLCK_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	상품코드(LMPH_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
0	201908	294*	2	4	1070104	3	11350700	1	1	5000
1	201902	479*	1	4	1070109	3	11680531	1	1	381000
2	201902	228*	1	5	1020602	5	11680545	1	1	3000
3	201910	406*	1	5	2010204	3	11545610	1	1	49000
4	201807	181*	1	5	1060103	5	11710680	1	3	32000
5	201904	521*	2	6	1070109	4	11200560	1	2	10000
6	201906	498*	1	3	1011899	6	11140540	1	1	4000
7	201909	265	1	3	1011106	2	11650530	1	1	5000
8	201910	219*	2	2	1060201	4	41117	1	2	2000
9	201905	222*	1	6	1011399	4	11710642	1	1	1000

	기준년월(STD_YM)	블록코드(BLCK_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	상품코드(LMPH_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
490	201809	330*	2	2	1011101	5	11140540	1	1	38000
491	201801	376*	1	5	1011601	5	11350700	1	1	6000
492	201907	412*	2	4	1011107	5	11530530	1	2	1000
493	201911	436*	1	5	1010901	5	11305534	1	2	3000
494	201803	267*	2	5	1050802	4	11440630	1	1	16000
495	201805	283*	1	4	1070108	5	11305534	1	6	6000
496	201811	107*	1	6	1010708	5	11710710	1	1	21000
497	201809	276*	2	6	1011603	4	11545610	1	5	1000
498	201803	347	2	3	1050699	3	41570	1	1	33000
499	201904	463*	2	4	1090202	3	11710642	1	1	21000

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

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