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	8
Categorical	2

Dataset

Description	샘플 데이터
Author	서울시(신용보증재단)
URL	https://bigdata.seoul.go.kr/data/selectSampleData.do?sample_data_seq=324

Alerts

구매_고객수(ACC_CNT) is highly skewed (γ1 = 21.64978997) Skewed

Reproduction

Analysis started	2024-04-16 19:18:19.418150
Analysis finished	2024-04-16 19:18:26.358510
Duration	6.94 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	201857.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	201901
Q3	201906
95-th percentile	201911
Maximum	201912
Range	111
Interquartile range (IQR)	99

Descriptive statistics

Standard deviation	50.086014
Coefficient of variation (CV)	0.00024812546
Kurtosis	-1.9879911
Mean	201857.62
Median Absolute Deviation (MAD)	11
Skewness	-0.040308591
Sum	1.0092881 × 10⁸
Variance	2508.6088
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
201810	32	6.4%
201905	27	5.4%
201903	25	5.0%
201806	24	4.8%
201811	24	4.8%
201906	24	4.8%
201911	24	4.8%
201803	23	4.6%
201909	23	4.6%
201904	22	4.4%
Other values (14)	252	50.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201801	18	3.6%
201802	16	3.2%
201803	23	4.6%
201804	22	4.4%
201805	19	3.8%
201806	24	4.8%
201807	14	2.8%
201808	20	4.0%
201809	15	3.0%
201810	32	6.4%

Value	Count	Frequency (%)
201912	17	3.4%
201911	24	4.8%
201910	22	4.4%
201909	23	4.6%
201908	20	4.0%
201907	18	3.6%
201906	24	4.8%
201905	27	5.4%
201904	22	4.4%
201903	25	5.0%

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

Distinct	283
Distinct (%)	56.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11461532

Minimum	11110515
Maximum	11740700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	11110515
5-th percentile	11140680
Q1	11290694
median	11500525
Q3	11650530
95-th percentile	11710680
Maximum	11740700
Range	630185
Interquartile range (IQR)	359836.5

Descriptive statistics

Standard deviation	191466.07
Coefficient of variation (CV)	0.016705103
Kurtosis	-1.3041653
Mean	11461532
Median Absolute Deviation (MAD)	180011
Skewness	-0.18383082
Sum	5.730766 × 10⁹
Variance	3.6659254 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11650621	6	1.2%
11710580	5	1.0%
11650530	5	1.0%
11560620	4	0.8%
11680565	4	0.8%
11545630	4	0.8%
11410615	4	0.8%
11170625	4	0.8%
11440660	4	0.8%
11260565	4	0.8%
Other values (273)	456	91.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11110515	1	0.2%
11110530	1	0.2%
11110540	1	0.2%
11110550	2	0.4%
11110570	1	0.2%
11110580	2	0.4%
11110615	1	0.2%
11110650	2	0.4%
11110680	1	0.2%
11140540	1	0.2%

Value	Count	Frequency (%)
11740700	2	0.4%
11740685	3	0.6%
11740660	1	0.2%
11740640	1	0.2%
11740600	2	0.4%
11740590	2	0.4%
11740580	1	0.2%
11740570	3	0.6%
11740560	1	0.2%
11740515	2	0.4%

통계청상품코드(STAT_CD)
Categorical

Distinct	9
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

A	217
E	97
B	93
L	45
I	22
Other values (4)	26

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B
2nd row	A
3rd row	C
4th row	L
5th row	A

Common Values

Value	Count	Frequency (%)
A	217	43.4%
E	97	19.4%
B	93	18.6%
L	45	9.0%
I	22	4.4%
J	11	2.2%
G	8	1.6%
C	5	1.0%
F	2	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	217	43.4%
e	97	19.4%
b	93	18.6%
l	45	9.0%
i	22	4.4%
j	11	2.2%
g	8	1.6%
c	5	1.0%
f	2	0.4%

성별코드(SEX_CD)
Categorical

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

2	304
1	196

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	1

Common Values

Value	Count	Frequency (%)
2	304	60.8%
1	196	39.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	304	60.8%
1	196	39.2%

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

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

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.3365391
Coefficient of variation (CV)	0.34323037
Kurtosis	-0.57350426
Mean	3.894
Median Absolute Deviation (MAD)	1
Skewness	0.28067975
Sum	1947
Variance	1.7863367
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	140	28.0%
3	119	23.8%
5	92	18.4%
2	81	16.2%
6	50	10.0%
7	15	3.0%
1	3	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3	0.6%
2	81	16.2%
3	119	23.8%
4	140	28.0%
5	92	18.4%
6	50	10.0%
7	15	3.0%

Value	Count	Frequency (%)
7	15	3.0%
6	50	10.0%
5	92	18.4%
4	140	28.0%
3	119	23.8%
2	81	16.2%
1	3	0.6%

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

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

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

Descriptive statistics

Standard deviation	1.2786688
Coefficient of variation (CV)	0.30634136
Kurtosis	-0.68713646
Mean	4.174
Median Absolute Deviation (MAD)	1
Skewness	-0.33445535
Sum	2087
Variance	1.634994
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	142	28.4%
4	126	25.2%
3	93	18.6%
6	81	16.2%
2	50	10.0%
1	8	1.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	8	1.6%
2	50	10.0%
3	93	18.6%
4	126	25.2%
5	142	28.4%
6	81	16.2%

Value	Count	Frequency (%)
6	81	16.2%
5	142	28.4%
4	126	25.2%
3	93	18.6%
2	50	10.0%
1	8	1.6%

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

Distinct	213
Distinct (%)	42.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8244034.1

Minimum	26290
Maximum	11740700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	26290
5-th percentile	28260
Q1	44667.5
median	11320710
Q3	11560610
95-th percentile	11710710
Maximum	11740700
Range	11714410
Interquartile range (IQR)	11515942

Descriptive statistics

Standard deviation	5150260.4
Coefficient of variation (CV)	0.62472575
Kurtosis	-1.0614288
Mean	8244034.1
Median Absolute Deviation (MAD)	329820
Skewness	-0.96823632
Sum	4.122017 × 10⁹
Variance	2.6525182 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11140540	21	4.2%
11710710	19	3.8%
11710680	13	2.6%
11545610	11	2.2%
11500620	11	2.2%
11350621	10	2.0%
11230560	10	2.0%
11560535	9	1.8%
11650530	8	1.6%
11710642	8	1.6%
Other values (203)	380	76.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
26290	1	0.2%
26710	1	0.2%
27140	1	0.2%
27230	1	0.2%
28110	3	0.6%
28185	4	0.8%
28237	6	1.2%
28245	5	1.0%
28260	6	1.2%
29140	2	0.4%

Value	Count	Frequency (%)
11740700	1	0.2%
11740685	1	0.2%
11740640	1	0.2%
11740620	1	0.2%
11740610	1	0.2%
11740600	1	0.2%
11740550	1	0.2%
11740530	1	0.2%
11710710	19	3.8%
11710680	13	2.6%

구매_고객수(ACC_CNT)
Real number (ℝ)

SKEWED

Distinct	41
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.398

Minimum	1
Maximum	3324
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	2
Q3	4
95-th percentile	20.05
Maximum	3324
Range	3323
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	150.01743
Coefficient of variation (CV)	11.197002
Kurtosis	478.06461
Mean	13.398
Median Absolute Deviation (MAD)	1
Skewness	21.64979
Sum	6699
Variance	22505.23
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
1	221	44.2%
2	82	16.4%
3	47	9.4%
4	26	5.2%
5	21	4.2%
7	17	3.4%
6	14	2.8%
14	6	1.2%
18	6	1.2%
11	6	1.2%
Other values (31)	54	10.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	221	44.2%
2	82	16.4%
3	47	9.4%
4	26	5.2%
5	21	4.2%
6	14	2.8%
7	17	3.4%
8	5	1.0%
9	5	1.0%
10	4	0.8%

Value	Count	Frequency (%)
3324	1	0.2%
284	1	0.2%
264	1	0.2%
161	1	0.2%
146	1	0.2%
110	1	0.2%
104	1	0.2%
95	1	0.2%
78	1	0.2%
60	1	0.2%

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

Distinct	60
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.098

Minimum	1
Maximum	1814
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	3
Q3	9
95-th percentile	45.2
Maximum	1814
Range	1813
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	135.15104
Coefficient of variation (CV)	5.851201
Kurtosis	130.35414
Mean	23.098
Median Absolute Deviation (MAD)	2
Skewness	10.941474
Sum	11549
Variance	18265.804
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	152	30.4%
2	62	12.4%
3	49	9.8%
5	33	6.6%
4	33	6.6%
10	18	3.6%
9	15	3.0%
6	15	3.0%
7	12	2.4%
8	12	2.4%
Other values (50)	99	19.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	152	30.4%
2	62	12.4%
3	49	9.8%
4	33	6.6%
5	33	6.6%
6	15	3.0%
7	12	2.4%
8	12	2.4%
9	15	3.0%
10	18	3.6%

Value	Count	Frequency (%)
1814	1	0.2%
1756	1	0.2%
1249	1	0.2%
714	1	0.2%
610	1	0.2%
330	1	0.2%
326	1	0.2%
304	1	0.2%
289	1	0.2%
185	1	0.2%

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

Distinct	143
Distinct (%)	28.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120564

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

Quantile statistics

Minimum	1000
5-th percentile	1000
Q1	5000
median	13000
Q3	43250
95-th percentile	339050
Maximum	9484000
Range	9483000
Interquartile range (IQR)	38250

Descriptive statistics

Standard deviation	609304.08
Coefficient of variation (CV)	5.0537812
Kurtosis	133.79813
Mean	120564
Median Absolute Deviation (MAD)	11000
Skewness	10.563016
Sum	60282000
Variance	3.7125146 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000	40	8.0%
1000	34	6.8%
4000	26	5.2%
3000	20	4.0%
7000	20	4.0%
8000	20	4.0%
9000	19	3.8%
6000	19	3.8%
5000	19	3.8%
15000	13	2.6%
Other values (133)	270	54.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	34	6.8%
2000	40	8.0%
3000	20	4.0%
4000	26	5.2%
5000	19	3.8%
6000	19	3.8%
7000	20	4.0%
8000	20	4.0%
9000	19	3.8%
10000	10	2.0%

Value	Count	Frequency (%)
9484000	1	0.2%
5078000	1	0.2%
4726000	1	0.2%
4692000	1	0.2%
2897000	1	0.2%
2457000	1	0.2%
2302000	1	0.2%
1416000	1	0.2%
1315000	1	0.2%
1191000	1	0.2%

Heatmap
Table

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
기준년월(STD_YM)	1.000	0.000	0.108	0.000	0.000	0.100	0.113	0.000	0.000	0.000
행정동코드(ADSTRD_CD)	0.000	1.000	0.000	0.000	0.140	0.168	0.000	0.000	0.000	0.128
통계청상품코드(STAT_CD)	0.108	0.000	1.000	0.000	0.000	0.000	0.061	0.000	0.297	0.000
성별코드(SEX_CD)	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.036	0.000
연령대코드(AGE_CD)	0.000	0.140	0.000	0.000	1.000	0.126	0.000	0.000	0.000	0.000
시간대코드(TIME_CD)	0.100	0.168	0.000	0.000	0.126	1.000	0.000	0.000	0.000	0.000
구매지역(PURH_AREA)	0.113	0.000	0.061	0.000	0.000	0.000	1.000	0.000	0.058	0.000
구매_고객수(ACC_CNT)	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000	0.000
구매건수(PURH_CNT)	0.000	0.000	0.297	0.036	0.000	0.000	0.058	0.000	1.000	0.071
구매금액(PURH_AMT)	0.000	0.128	0.000	0.000	0.000	0.000	0.000	0.000	0.071	1.000

Heatmap
Table

	통계청상품코드(STAT_CD)	성별코드(SEX_CD)
통계청상품코드(STAT_CD)	1.000	0.000
성별코드(SEX_CD)	0.000	1.000

Heatmap
Table

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)
기준년월(STD_YM)	1.000	0.018	0.041	0.065	-0.039	0.044	-0.067	-0.047	0.081	0.000
행정동코드(ADSTRD_CD)	0.018	1.000	-0.019	-0.020	-0.058	-0.036	0.019	-0.014	0.000	0.000
연령대코드(AGE_CD)	0.041	-0.019	1.000	0.070	-0.017	0.024	0.025	-0.067	0.000	0.000
시간대코드(TIME_CD)	0.065	-0.020	0.070	1.000	-0.052	0.097	-0.047	-0.074	0.000	0.000
구매지역(PURH_AREA)	-0.039	-0.058	-0.017	-0.052	1.000	0.068	-0.034	-0.003	0.062	0.000
구매_고객수(ACC_CNT)	0.044	-0.036	0.024	0.097	0.068	1.000	0.084	-0.013	0.000	0.000
구매건수(PURH_CNT)	-0.067	0.019	0.025	-0.047	-0.034	0.084	1.000	-0.004	0.175	0.044
구매금액(PURH_AMT)	-0.047	-0.014	-0.067	-0.074	-0.003	-0.013	-0.004	1.000	0.000	0.000
통계청상품코드(STAT_CD)	0.081	0.000	0.000	0.000	0.062	0.000	0.175	0.000	1.000	0.000
성별코드(SEX_CD)	0.000	0.000	0.000	0.000	0.000	0.000	0.044	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

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
0	201912	11110650	B	2	4	2	11710680	1	9	3000
1	201804	11620725	A	2	3	5	11320690	3	7	1000
2	201911	11215840	C	2	4	4	45180	1	1	3000
3	201807	11200580	L	2	4	2	11290660	1	11	287000
4	201906	11650530	A	1	4	6	41360	4	1814	380000
5	201803	11380690	A	2	3	3	11560610	12	19	18000
6	201904	11500615	B	2	3	4	11680650	4	2	9000
7	201810	11710566	E	2	3	4	11110640	4	28	205000
8	201909	11350611	B	1	3	5	41173	6	2	147000
9	201804	11740570	A	2	3	5	11380690	9	2	7000

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
490	201902	11680700	C	2	4	6	41150	7	1756	2000
491	201810	11230570	I	1	4	3	11140550	19	7	16000
492	201908	11500540	E	1	4	6	11680650	1	1	50000
493	201910	11500560	J	2	2	4	11230570	1	4	7000
494	201812	11290525	J	2	6	4	11545610	6	7	87000
495	201804	11590660	A	2	1	1	11230730	1	3	30000
496	201805	11545700	L	2	4	6	11470650	4	39	9000
497	201803	11350640	A	2	5	6	11260630	4	1	8000
498	201808	11740515	A	2	4	4	41390	1	2	151000
499	201809	11320514	E	2	4	6	11350621	2	5	2000

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample