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:03.871174
Analysis finished	2024-04-16 19:19:10.579375
Duration	6.71 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.75

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

Descriptive statistics

Standard deviation	50.20311
Coefficient of variation (CV)	0.00024871031
Kurtosis	-1.9773268
Mean	201853.75
Median Absolute Deviation (MAD)	11
Skewness	0.11111396
Sum	1.0092688 × 10⁸
Variance	2520.3522
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
201804	27	5.4%
201904	26	5.2%
201803	26	5.2%
201810	26	5.2%
201806	25	5.0%
201907	23	4.6%
201909	23	4.6%
201801	23	4.6%
201812	23	4.6%
201911	22	4.4%
Other values (14)	256	51.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201801	23	4.6%
201802	18	3.6%
201803	26	5.2%
201804	27	5.4%
201805	18	3.6%
201806	25	5.0%
201807	20	4.0%
201808	21	4.2%
201809	18	3.6%
201810	26	5.2%

Value	Count	Frequency (%)
201912	16	3.2%
201911	22	4.4%
201910	21	4.2%
201909	23	4.6%
201908	19	3.8%
201907	23	4.6%
201906	19	3.8%
201905	20	4.0%
201904	26	5.2%
201903	13	2.6%

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

Distinct	270
Distinct (%)	54.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	225331.65

Minimum	8661
Maximum	502407
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	8661
5-th percentile	17200.15
Q1	149493.75
median	218641.5
Q3	356939.25
95-th percentile	422185
Maximum	502407
Range	493746
Interquartile range (IQR)	207445.5

Descriptive statistics

Standard deviation	143774.8
Coefficient of variation (CV)	0.63805859
Kurtosis	-1.0033935
Mean	225331.65
Median Absolute Deviation (MAD)	134634
Skewness	0.066258661
Sum	1.1266582 × 10⁸
Variance	2.0671192 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
206648	20	4.0%
155402	15	3.0%
502147	14	2.8%
19587	13	2.6%
122837	13	2.6%
362962	12	2.4%
409372	12	2.4%
413592	12	2.4%
229979	12	2.4%
422185	9	1.8%
Other values (260)	368	73.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8661	7	1.4%
9291	1	0.2%
9478	1	0.2%
9911	1	0.2%
11478	1	0.2%
11689	1	0.2%
11749	1	0.2%
14142	1	0.2%
14274	1	0.2%
14374	1	0.2%

Value	Count	Frequency (%)
502407	1	0.2%
502147	14	2.8%
500232	3	0.6%
499597	1	0.2%
422428	1	0.2%
422185	9	1.8%
422022	1	0.2%
422008	1	0.2%
421981	1	0.2%
421635	1	0.2%

통계청상품코드(STAT_CD)
Categorical

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

A	240
E	86
B	78
L	48
I	17
Other values (4)	31

Length

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

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
A	240	48.0%
E	86	17.2%
B	78	15.6%
L	48	9.6%
I	17	3.4%
J	15	3.0%
C	9	1.8%
F	4	0.8%
G	3	0.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	240	48.0%
e	86	17.2%
b	78	15.6%
l	48	9.6%
i	17	3.4%
j	15	3.0%
c	9	1.8%
f	4	0.8%
g	3	0.6%

성별코드(SEX_CD)
Categorical

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

2	305
1	195

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

Common Values

Value	Count	Frequency (%)
2	305	61.0%
1	195	39.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	305	61.0%
1	195	39.0%

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

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

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.3435454
Coefficient of variation (CV)	0.34770844
Kurtosis	-0.40363872
Mean	3.864
Median Absolute Deviation (MAD)	1
Skewness	0.33912226
Sum	1932
Variance	1.8051142
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	142	28.4%
3	114	22.8%
5	100	20.0%
2	87	17.4%
6	33	6.6%
7	21	4.2%
1	3	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3	0.6%
2	87	17.4%
3	114	22.8%
4	142	28.4%
5	100	20.0%
6	33	6.6%
7	21	4.2%

Value	Count	Frequency (%)
7	21	4.2%
6	33	6.6%
5	100	20.0%
4	142	28.4%
3	114	22.8%
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.188

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.3145768
Coefficient of variation (CV)	0.31389131
Kurtosis	-0.63135505
Mean	4.188
Median Absolute Deviation (MAD)	1
Skewness	-0.43547238
Sum	2094
Variance	1.7281122
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	155	31.0%
4	112	22.4%
3	89	17.8%
6	82	16.4%
2	50	10.0%
1	12	2.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	12	2.4%
2	50	10.0%
3	89	17.8%
4	112	22.4%
5	155	31.0%
6	82	16.4%

Value	Count	Frequency (%)
6	82	16.4%
5	155	31.0%
4	112	22.4%
3	89	17.8%
2	50	10.0%
1	12	2.4%

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

Distinct	299
Distinct (%)	59.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7918351.2

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

Quantile statistics

Minimum	26380
5-th percentile	28245
Q1	42130
median	11305652
Q3	11560665
95-th percentile	11710631
Maximum	11740685
Range	11714305
Interquartile range (IQR)	11518535

Descriptive statistics

Standard deviation	5289022.6
Coefficient of variation (CV)	0.66794494
Kurtosis	-1.3267514
Mean	7918351.2
Median Absolute Deviation (MAD)	315072.5
Skewness	-0.82125057
Sum	3.9591756 × 10⁹
Variance	2.797376 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41360	12	2.4%
28237	7	1.4%
41310	7	1.4%
28200	6	1.2%
11710670	5	1.0%
45111	5	1.0%
41285	5	1.0%
11680720	4	0.8%
41590	4	0.8%
11215810	4	0.8%
Other values (289)	441	88.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
26380	1	0.2%
26410	1	0.2%
26440	1	0.2%
27260	3	0.6%
27710	1	0.2%
28110	1	0.2%
28140	1	0.2%
28185	2	0.4%
28200	6	1.2%
28237	7	1.4%

Value	Count	Frequency (%)
11740685	2	0.4%
11740660	1	0.2%
11740640	2	0.4%
11740620	2	0.4%
11740580	1	0.2%
11740540	1	0.2%
11740520	1	0.2%
11710720	1	0.2%
11710710	1	0.2%
11710690	2	0.4%

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

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

Minimum	1
Maximum	819
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	30
Maximum	819
Range	818
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	48.826506
Coefficient of variation (CV)	4.7039023
Kurtosis	172.95163
Mean	10.38
Median Absolute Deviation (MAD)	1
Skewness	12.028327
Sum	5190
Variance	2384.0277
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	224	44.8%
2	78	15.6%
3	37	7.4%
4	33	6.6%
5	23	4.6%
10	11	2.2%
6	10	2.0%
9	8	1.6%
7	7	1.4%
8	6	1.2%
Other values (42)	63	12.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	224	44.8%
2	78	15.6%
3	37	7.4%
4	33	6.6%
5	23	4.6%
6	10	2.0%
7	7	1.4%
8	6	1.2%
9	8	1.6%
10	11	2.2%

Value	Count	Frequency (%)
819	1	0.2%
475	1	0.2%
357	1	0.2%
217	1	0.2%
214	1	0.2%
170	1	0.2%
114	1	0.2%
108	1	0.2%
99	1	0.2%
71	1	0.2%

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

Distinct	66
Distinct (%)	13.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.516

Minimum	1
Maximum	1276
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	61.4
Maximum	1276
Range	1275
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	78.178318
Coefficient of variation (CV)	4.4632518
Kurtosis	158.4386
Mean	17.516
Median Absolute Deviation (MAD)	2
Skewness	11.368304
Sum	8758
Variance	6111.8494
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	154	30.8%
2	86	17.2%
3	49	9.8%
4	31	6.2%
6	23	4.6%
5	22	4.4%
8	13	2.6%
7	11	2.2%
10	10	2.0%
9	9	1.8%
Other values (56)	92	18.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	154	30.8%
2	86	17.2%
3	49	9.8%
4	31	6.2%
5	22	4.4%
6	23	4.6%
7	11	2.2%
8	13	2.6%
9	9	1.8%
10	10	2.0%

Value	Count	Frequency (%)
1276	1	0.2%
811	1	0.2%
430	1	0.2%
404	1	0.2%
303	1	0.2%
256	1	0.2%
251	1	0.2%
212	1	0.2%
193	1	0.2%
191	1	0.2%

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

Distinct	121
Distinct (%)	24.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	106726

Minimum	1000
Maximum	8800000
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	11000
Q3	36000
95-th percentile	252200
Maximum	8800000
Range	8799000
Interquartile range (IQR)	32000

Descriptive statistics

Standard deviation	588775.87
Coefficient of variation (CV)	5.5167051
Kurtosis	132.88035
Mean	106726
Median Absolute Deviation (MAD)	9000
Skewness	10.780328
Sum	53363000
Variance	3.4665702 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000	40	8.0%
4000	37	7.4%
1000	34	6.8%
5000	32	6.4%
3000	29	5.8%
9000	22	4.4%
8000	15	3.0%
10000	14	2.8%
7000	14	2.8%
20000	14	2.8%
Other values (111)	249	49.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	34	6.8%
2000	40	8.0%
3000	29	5.8%
4000	37	7.4%
5000	32	6.4%
6000	11	2.2%
7000	14	2.8%
8000	15	3.0%
9000	22	4.4%
10000	14	2.8%

Value	Count	Frequency (%)
8800000	1	0.2%
6251000	1	0.2%
5328000	1	0.2%
3558000	1	0.2%
1838000	1	0.2%
1666000	1	0.2%
1628000	1	0.2%
1419000	1	0.2%
1318000	1	0.2%
1279000	1	0.2%

Heatmap
Table

	기준년월(STD_YM)	블록코드(BLCK_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매자지역(BUYER_AREA)	구매고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
기준년월(STD_YM)	1.000	0.000	0.000	0.019	0.000	0.000	0.000	0.073	0.019	0.000
블록코드(BLCK_CD)	0.000	1.000	0.000	0.113	0.103	0.000	0.000	0.000	0.000	0.258
통계청상품코드(STAT_CD)	0.000	0.000	1.000	0.035	0.000	0.000	0.083	0.140	0.278	0.000
성별코드(SEX_CD)	0.019	0.113	0.035	1.000	0.032	0.000	0.161	0.000	0.000	0.047
연령대코드(AGE_CD)	0.000	0.103	0.000	0.032	1.000	0.087	0.051	0.037	0.000	0.000
시간대코드(TIME_CD)	0.000	0.000	0.000	0.000	0.087	1.000	0.140	0.337	0.000	0.000
구매자지역(BUYER_AREA)	0.000	0.000	0.083	0.161	0.051	0.140	1.000	0.084	0.000	0.015
구매고객수(ACC_CNT)	0.073	0.000	0.140	0.000	0.037	0.337	0.084	1.000	0.323	0.000
구매건수(PURH_CNT)	0.019	0.000	0.278	0.000	0.000	0.000	0.000	0.323	1.000	0.000
구매금액(PURH_AMT)	0.000	0.258	0.000	0.047	0.000	0.000	0.015	0.000	0.000	1.000

Heatmap
Table

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

Heatmap
Table

	기준년월(STD_YM)	블록코드(BLCK_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매자지역(BUYER_AREA)	구매고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)
기준년월(STD_YM)	1.000	-0.008	-0.003	-0.047	0.049	0.006	0.065	0.108	0.000	0.000
블록코드(BLCK_CD)	-0.008	1.000	0.052	-0.034	-0.047	0.064	0.009	-0.026	0.000	0.102
연령대코드(AGE_CD)	-0.003	0.052	1.000	0.028	0.081	0.005	0.048	0.028	0.000	0.034
시간대코드(TIME_CD)	-0.047	-0.034	0.028	1.000	-0.025	-0.016	-0.016	0.008	0.000	0.000
구매자지역(BUYER_AREA)	0.049	-0.047	0.081	-0.025	1.000	-0.043	0.023	0.058	0.088	0.107
구매고객수(ACC_CNT)	0.006	0.064	0.005	-0.016	-0.043	1.000	0.065	-0.011	0.069	0.000
구매건수(PURH_CNT)	0.065	0.009	0.048	-0.016	0.023	0.065	1.000	0.022	0.141	0.000
구매금액(PURH_AMT)	0.108	-0.026	0.028	0.008	0.058	-0.011	0.022	1.000	0.000	0.043
통계청상품코드(STAT_CD)	0.000	0.000	0.000	0.000	0.088	0.069	0.141	0.000	1.000	0.034
성별코드(SEX_CD)	0.000	0.102	0.034	0.000	0.107	0.000	0.000	0.043	0.034	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)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매자지역(BUYER_AREA)	구매고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
0	201911	206648	I	2	2	6	11680720	7	12	77000
1	201805	225172	E	1	3	6	11710520	3	1	8000
2	201905	224659	F	1	3	6	11710632	1	10	10000
3	201805	413188	A	2	4	4	11710580	3	95	23000
4	201803	364511	A	1	2	4	11680656	6	1	1000
5	201806	19587	B	1	5	5	11170685	1	25	7000
6	201910	362962	L	1	6	3	11620565	357	4	1000
7	201902	189947	E	1	3	3	28260	1	1	31000
8	201908	413592	B	2	6	4	11620715	5	2	240000
9	201906	417990	B	2	7	4	11680720	1	10	21000

	기준년월(STD_YM)	블록코드(BLCK_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매자지역(BUYER_AREA)	구매고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
490	201804	275451	L	1	4	6	11740520	1	1	3558000
491	201806	153212	B	2	3	4	11710532	1	3	8000
492	201805	273675	A	1	7	6	11710532	6	6	143000
493	201906	409372	B	1	5	4	45111	2	4	9000
494	201906	22870	A	1	2	5	11440720	1	1	10000
495	201809	274538	I	2	3	2	11650621	1	1	1000
496	201804	353409	A	2	3	4	11470510	4	2	139000
497	201806	223026	A	1	4	5	41190	1	3	40000
498	201907	8661	A	2	4	5	11650651	3	2	4000
499	201806	207141	L	2	4	6	41150	1	2	2000

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample