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

Reproduction

Analysis started	2024-04-16 19:19:15.001824
Analysis finished	2024-04-16 19:19:21.918923
Duration	6.92 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	201856.77

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	201806
median	201901
Q3	201906
95-th percentile	201911
Maximum	201912
Range	111
Interquartile range (IQR)	100

Descriptive statistics

Standard deviation	50.209842
Coefficient of variation (CV)	0.00024873995
Kurtosis	-1.9887696
Mean	201856.77
Median Absolute Deviation (MAD)	11
Skewness	-0.023681185
Sum	1.0092838 × 10⁸
Variance	2521.0282
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
201803	31	6.2%
201910	28	5.6%
201909	28	5.6%
201904	26	5.2%
201903	25	5.0%
201902	24	4.8%
201806	24	4.8%
201804	24	4.8%
201805	24	4.8%
201809	22	4.4%
Other values (14)	244	48.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201801	20	4.0%
201802	20	4.0%
201803	31	6.2%
201804	24	4.8%
201805	24	4.8%
201806	24	4.8%
201807	18	3.6%
201808	10	2.0%
201809	22	4.4%
201810	16	3.2%

Value	Count	Frequency (%)
201912	14	2.8%
201911	19	3.8%
201910	28	5.6%
201909	28	5.6%
201908	11	2.2%
201907	12	2.4%
201906	22	4.4%
201905	22	4.4%
201904	26	5.2%
201903	25	5.0%

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

Distinct	170
Distinct (%)	34.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11450276

Minimum	11110530
Maximum	11740685
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	11110530
5-th percentile	11140540
Q1	11290555
median	11440710
Q3	11650581
95-th percentile	11710710
Maximum	11740685
Range	630155
Interquartile range (IQR)	360026

Descriptive statistics

Standard deviation	199382.21
Coefficient of variation (CV)	0.017412874
Kurtosis	-1.3610926
Mean	11450276
Median Absolute Deviation (MAD)	209850
Skewness	-0.13295222
Sum	5.7251379 × 10⁹
Variance	3.9753264 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11140540	28	5.6%
11710710	24	4.8%
11380690	16	3.2%
11710642	16	3.2%
11230560	15	3.0%
11545610	12	2.4%
11710680	12	2.4%
11500620	11	2.2%
11350621	11	2.2%
11200570	10	2.0%
Other values (160)	345	69.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11110530	2	0.4%
11110550	1	0.2%
11110560	1	0.2%
11110615	4	0.8%
11110650	1	0.2%
11140520	1	0.2%
11140540	28	5.6%
11140550	5	1.0%
11140590	1	0.2%
11140665	1	0.2%

Value	Count	Frequency (%)
11740685	1	0.2%
11740660	1	0.2%
11740610	1	0.2%
11740550	1	0.2%
11740540	1	0.2%
11710710	24	4.8%
11710690	1	0.2%
11710680	12	2.4%
11710650	1	0.2%
11710646	1	0.2%

통계청상품코드(STAT_CD)
Categorical

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

A	207
E	89
B	83
L	69
J	19
Other values (4)	33

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
A	207	41.4%
E	89	17.8%
B	83	16.6%
L	69	13.8%
J	19	3.8%
C	12	2.4%
I	12	2.4%
F	6	1.2%
G	3	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	207	41.4%
e	89	17.8%
b	83	16.6%
l	69	13.8%
j	19	3.8%
c	12	2.4%
i	12	2.4%
f	6	1.2%
g	3	0.6%

성별코드(SEX_CD)
Categorical

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

2	316
1	184

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

Common Values

Value	Count	Frequency (%)
2	316	63.2%
1	184	36.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	316	63.2%
1	184	36.8%

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

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

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.3757476
Coefficient of variation (CV)	0.35752276
Kurtosis	-0.7009158
Mean	3.848
Median Absolute Deviation (MAD)	1
Skewness	0.34032592
Sum	1924
Variance	1.8926814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	140	28.0%
4	104	20.8%
5	101	20.2%
2	87	17.4%
6	49	9.8%
7	16	3.2%
1	3	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3	0.6%
2	87	17.4%
3	140	28.0%
4	104	20.8%
5	101	20.2%
6	49	9.8%
7	16	3.2%

Value	Count	Frequency (%)
7	16	3.2%
6	49	9.8%
5	101	20.2%
4	104	20.8%
3	140	28.0%
2	87	17.4%
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.228

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.2276115
Coefficient of variation (CV)	0.29035277
Kurtosis	-0.52545776
Mean	4.228
Median Absolute Deviation (MAD)	1
Skewness	-0.43535391
Sum	2114
Variance	1.5070301
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	166	33.2%
4	123	24.6%
3	89	17.8%
6	72	14.4%
2	43	8.6%
1	7	1.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	7	1.4%
2	43	8.6%
3	89	17.8%
4	123	24.6%
5	166	33.2%
6	72	14.4%

Value	Count	Frequency (%)
6	72	14.4%
5	166	33.2%
4	123	24.6%
3	89	17.8%
2	43	8.6%
1	7	1.4%

구매자지역(BUYER_AREA)
Real number (ℝ)

Distinct	320
Distinct (%)	64.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8095495.7

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

Quantile statistics

Minimum	26260
5-th percentile	30148.5
Q1	45137.5
median	11305582
Q3	11549401
95-th percentile	11710670
Maximum	11740700
Range	11714440
Interquartile range (IQR)	11504264

Descriptive statistics

Standard deviation	5206085.3
Coefficient of variation (CV)	0.64308419
Kurtosis	-1.1831055
Mean	8095495.7
Median Absolute Deviation (MAD)	285058
Skewness	-0.90390605
Sum	4.0477478 × 10⁹
Variance	2.7103324 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41210	6	1.2%
41281	5	1.0%
41570	5	1.0%
41173	5	1.0%
11470550	4	0.8%
41310	4	0.8%
11710641	4	0.8%
41271	4	0.8%
11710610	4	0.8%
11230610	4	0.8%
Other values (310)	455	91.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
26260	2	0.4%
26320	1	0.2%
26350	2	0.4%
26410	1	0.2%
26440	1	0.2%
26500	1	0.2%
27200	1	0.2%
27230	2	0.4%
27290	2	0.4%
28140	1	0.2%

Value	Count	Frequency (%)
11740700	1	0.2%
11740685	3	0.6%
11740660	1	0.2%
11740650	1	0.2%
11740610	3	0.6%
11740590	1	0.2%
11740570	1	0.2%
11740560	1	0.2%
11740550	1	0.2%
11740540	3	0.6%

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

Distinct	50
Distinct (%)	10.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.15

Minimum	1
Maximum	1200
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	5
95-th percentile	34
Maximum	1200
Range	1199
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	69.172373
Coefficient of variation (CV)	5.6931994
Kurtosis	210.16204
Mean	12.15
Median Absolute Deviation (MAD)	1
Skewness	13.624865
Sum	6075
Variance	4784.8171
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	203	40.6%
2	87	17.4%
3	49	9.8%
4	32	6.4%
5	19	3.8%
6	14	2.8%
8	10	2.0%
10	9	1.8%
7	7	1.4%
13	5	1.0%
Other values (40)	65	13.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	203	40.6%
2	87	17.4%
3	49	9.8%
4	32	6.4%
5	19	3.8%
6	14	2.8%
7	7	1.4%
8	10	2.0%
9	4	0.8%
10	9	1.8%

Value	Count	Frequency (%)
1200	1	0.2%
808	1	0.2%
276	1	0.2%
273	1	0.2%
251	1	0.2%
181	1	0.2%
138	1	0.2%
128	1	0.2%
124	1	0.2%
101	1	0.2%

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

Distinct	58
Distinct (%)	11.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.874

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

Descriptive statistics

Standard deviation	181.99678
Coefficient of variation (CV)	7.6232211
Kurtosis	234.73199
Mean	23.874
Median Absolute Deviation (MAD)	2
Skewness	14.550249
Sum	11937
Variance	33122.828
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	158	31.6%
2	86	17.2%
3	45	9.0%
4	35	7.0%
5	26	5.2%
6	22	4.4%
8	15	3.0%
7	15	3.0%
9	9	1.8%
10	8	1.6%
Other values (48)	81	16.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	158	31.6%
2	86	17.2%
3	45	9.0%
4	35	7.0%
5	26	5.2%
6	22	4.4%
7	15	3.0%
8	15	3.0%
9	9	1.8%
10	8	1.6%

Value	Count	Frequency (%)
3286	1	0.2%
1928	1	0.2%
1231	1	0.2%
510	1	0.2%
453	1	0.2%
228	1	0.2%
204	1	0.2%
174	1	0.2%
166	1	0.2%
142	1	0.2%

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

Distinct	129
Distinct (%)	25.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57972

Minimum	1000
Maximum	3333000
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	41000
95-th percentile	197350
Maximum	3333000
Range	3332000
Interquartile range (IQR)	36000

Descriptive statistics

Standard deviation	214927.19
Coefficient of variation (CV)	3.7074311
Kurtosis	140.08911
Mean	57972
Median Absolute Deviation (MAD)	10000
Skewness	10.753895
Sum	28986000
Variance	4.6193699 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	37	7.4%
1000	32	6.4%
3000	30	6.0%
2000	27	5.4%
4000	21	4.2%
6000	17	3.4%
15000	17	3.4%
9000	17	3.4%
10000	16	3.2%
7000	15	3.0%
Other values (119)	271	54.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	32	6.4%
2000	27	5.4%
3000	30	6.0%
4000	21	4.2%
5000	37	7.4%
6000	17	3.4%
7000	15	3.0%
8000	13	2.6%
9000	17	3.4%
10000	16	3.2%

Value	Count	Frequency (%)
3333000	1	0.2%
2366000	1	0.2%
1625000	1	0.2%
927000	1	0.2%
618000	1	0.2%
608000	1	0.2%
598000	1	0.2%
579000	1	0.2%
499000	1	0.2%
469000	1	0.2%

Heatmap
Table

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매자지역(BUYER_AREA)	구매고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
기준년월(STD_YM)	1.000	0.122	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
행정동코드(ADSTRD_CD)	0.122	1.000	0.000	0.151	0.000	0.063	0.000	0.000	0.100	0.000
통계청상품코드(STAT_CD)	0.000	0.000	1.000	0.098	0.000	0.033	0.000	0.000	0.000	0.000
성별코드(SEX_CD)	0.000	0.151	0.098	1.000	0.000	0.101	0.000	0.000	0.056	0.158
연령대코드(AGE_CD)	0.000	0.000	0.000	0.000	1.000	0.000	0.067	0.095	0.000	0.000
시간대코드(TIME_CD)	0.000	0.063	0.033	0.101	0.000	1.000	0.000	0.077	0.000	0.000
구매자지역(BUYER_AREA)	0.000	0.000	0.000	0.000	0.067	0.000	1.000	0.054	0.000	0.000
구매고객수(ACC_CNT)	0.000	0.000	0.000	0.000	0.095	0.077	0.054	1.000	0.000	0.000
구매건수(PURH_CNT)	0.000	0.100	0.000	0.056	0.000	0.000	0.000	0.000	1.000	0.000
구매금액(PURH_AMT)	0.000	0.000	0.000	0.158	0.000	0.000	0.000	0.000	0.000	1.000

Heatmap
Table

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

Heatmap
Table

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매자지역(BUYER_AREA)	구매고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)
기준년월(STD_YM)	1.000	0.037	-0.016	-0.019	-0.003	-0.089	0.006	0.010	0.000	0.013
행정동코드(ADSTRD_CD)	0.037	1.000	0.012	-0.028	0.064	-0.019	0.030	-0.018	0.000	0.115
연령대코드(AGE_CD)	-0.016	0.012	1.000	-0.024	0.019	0.003	-0.017	-0.039	0.000	0.000
시간대코드(TIME_CD)	-0.019	-0.028	-0.024	1.000	0.010	-0.020	0.058	0.042	0.015	0.072
구매자지역(BUYER_AREA)	-0.003	0.064	0.019	0.010	1.000	-0.017	0.039	0.026	0.000	0.000
구매고객수(ACC_CNT)	-0.089	-0.019	0.003	-0.020	-0.017	1.000	-0.024	0.013	0.000	0.000
구매건수(PURH_CNT)	0.006	0.030	-0.017	0.058	0.039	-0.024	1.000	0.017	0.000	0.068
구매금액(PURH_AMT)	0.010	-0.018	-0.039	0.042	0.026	0.013	0.017	1.000	0.000	0.110
통계청상품코드(STAT_CD)	0.000	0.000	0.000	0.015	0.000	0.000	0.000	0.000	1.000	0.097
성별코드(SEX_CD)	0.013	0.115	0.000	0.072	0.000	0.000	0.068	0.110	0.097	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)	구매자지역(BUYER_AREA)	구매고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
0	201904	11530530	E	1	4	4	41410	2	17	17000
1	201805	11380530	A	1	3	6	45130	6	4	2000
2	201906	11440660	A	2	5	4	41390	1	1	1000
3	201910	11215860	C	1	2	5	41287	2	2	1000
4	201901	11140540	A	1	6	6	11500620	2	1	1000
5	201905	11710580	A	2	5	6	11680590	1	6	24000
6	201905	11170685	A	2	2	5	41465	12	2	46000
7	201905	11410660	E	1	3	5	43760	8	1	17000
8	201911	11500570	A	2	6	3	11740560	3	1	73000
9	201810	11200550	A	2	3	4	11410620	3	2	49000

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매자지역(BUYER_AREA)	구매고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
490	201909	11710680	E	2	2	4	11305555	1	4	25000
491	201806	11410620	B	2	3	6	11215730	1	9	5000
492	201906	11710642	A	2	2	4	11710620	7	3	499000
493	201902	11140540	E	2	5	5	48250	1	6	336000
494	201810	11680650	F	1	3	6	11215770	1	2	110000
495	201901	11200570	A	1	2	6	11740685	2	2	10000
496	201804	11740610	E	2	4	3	11680660	4	1	10000
497	201803	11290725	A	1	2	2	11710641	2	8	14000
498	201902	11140540	B	1	2	4	11680510	1	1	87000
499	201912	11620565	I	1	2	4	11305575	2	1	14000

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample