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

Numeric	7
Text	1
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:18:08.902605
Analysis finished	2024-04-16 19:18:14.609950
Duration	5.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	201852.93

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	201801
Q1	201806
median	201811.5
Q3	201907
95-th percentile	201911.05
Maximum	201912
Range	111
Interquartile range (IQR)	101

Descriptive statistics

Standard deviation	50.184526
Coefficient of variation (CV)	0.00024861925
Kurtosis	-1.9674829
Mean	201852.93
Median Absolute Deviation (MAD)	10.5
Skewness	0.14362306
Sum	1.0092647 × 10⁸
Variance	2518.4866
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
201801	28	5.6%
201802	28	5.6%
201909	28	5.6%
201809	27	5.4%
201907	27	5.4%
201807	25	5.0%
201912	25	5.0%
201811	24	4.8%
201810	23	4.6%
201901	22	4.4%
Other values (14)	243	48.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201801	28	5.6%
201802	28	5.6%
201803	18	3.6%
201804	17	3.4%
201805	22	4.4%
201806	16	3.2%
201807	25	5.0%
201808	22	4.4%
201809	27	5.4%
201810	23	4.6%

Value	Count	Frequency (%)
201912	25	5.0%
201911	19	3.8%
201910	11	2.2%
201909	28	5.6%
201908	19	3.8%
201907	27	5.4%
201906	12	2.4%
201905	18	3.6%
201904	17	3.4%
201903	19	3.8%

블록코드(BLCK_CD)
Text

Distinct	332
Distinct (%)	66.4%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	6
Median length	6
Mean length	5.734
Min length	3

Characters and Unicode

Total characters	2867
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	211 ?
Unique (%)	42.2%

Sample

1st row	214*
2nd row	292*
3rd row	227*
4th row	382*
5th row	193

Value	Count	Frequency (%)
221	6	1.2%
290	5	1.0%
150	5	1.0%
292	5	1.0%
215	5	1.0%
293	5	1.0%
242	4	0.8%
146	4	0.8%
182	4	0.8%
222	4	0.8%
Other values (270)	453	90.6%

Most occurring characters

Value	Count	Frequency (%)
*	1377	48.0%
2	321	11.2%
1	222	7.7%
3	207	7.2%
4	173	6.0%
5	111	3.9%
0	103	3.6%
8	101	3.5%
6	85	3.0%
9	84	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1490	52.0%
Other Punctuation	1377	48.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	321	21.5%
1	222	14.9%
3	207	13.9%
4	173	11.6%
5	111	7.4%
0	103	6.9%
8	101	6.8%
6	85	5.7%
9	84	5.6%
7	83	5.6%

Other Punctuation

Value	Count	Frequency (%)
*	1377	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2867	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
*	1377	48.0%
2	321	11.2%
1	222	7.7%
3	207	7.2%
4	173	6.0%
5	111	3.9%
0	103	3.6%
8	101	3.5%
6	85	3.0%
9	84	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2867	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
*	1377	48.0%
2	321	11.2%
1	222	7.7%
3	207	7.2%
4	173	6.0%
5	111	3.9%
0	103	3.6%
8	101	3.5%
6	85	3.0%
9	84	2.9%

통계청상품코드(STAT_CD)
Categorical

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

A	251
E	104
B	79
L	39
J	13
Other values (4)	14

Length

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

Unique

Unique	1 ?
Unique (%)	0.2%

Sample

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

Common Values

Value	Count	Frequency (%)
A	251	50.2%
E	104	20.8%
B	79	15.8%
L	39	7.8%
J	13	2.6%
I	6	1.2%
C	5	1.0%
G	2	0.4%
F	1	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	251	50.2%
e	104	20.8%
b	79	15.8%
l	39	7.8%
j	13	2.6%
i	6	1.2%
c	5	1.0%
g	2	0.4%
f	1	0.2%

성별코드(SEX_CD)
Categorical

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

2	336
1	164

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

Common Values

Value	Count	Frequency (%)
2	336	67.2%
1	164	32.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	336	67.2%
1	164	32.8%

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

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

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.3353525
Coefficient of variation (CV)	0.31946232
Kurtosis	-0.65129183
Mean	4.18
Median Absolute Deviation (MAD)	1
Skewness	0.19484828
Sum	2090
Variance	1.7831663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	130	26.0%
3	118	23.6%
5	115	23.0%
6	62	12.4%
2	50	10.0%
7	24	4.8%
1	1	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	0.2%
2	50	10.0%
3	118	23.6%
4	130	26.0%
5	115	23.0%
6	62	12.4%
7	24	4.8%

Value	Count	Frequency (%)
7	24	4.8%
6	62	12.4%
5	115	23.0%
4	130	26.0%
3	118	23.6%
2	50	10.0%
1	1	0.2%

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

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

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.1664997
Coefficient of variation (CV)	0.27127899
Kurtosis	-0.41932147
Mean	4.3
Median Absolute Deviation (MAD)	1
Skewness	-0.4342838
Sum	2150
Variance	1.3607214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
5	177	35.4%
4	118	23.6%
3	101	20.2%
6	72	14.4%
2	26	5.2%
1	6	1.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6	1.2%
2	26	5.2%
3	101	20.2%
4	118	23.6%
5	177	35.4%
6	72	14.4%

Value	Count	Frequency (%)
6	72	14.4%
5	177	35.4%
4	118	23.6%
3	101	20.2%
2	26	5.2%
1	6	1.2%

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

Distinct	169
Distinct (%)	33.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9918018.6

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

Quantile statistics

Minimum	27110
5-th percentile	41280.5
Q1	11230560
median	11380690
Q3	11650530
95-th percentile	11710680
Maximum	11740685
Range	11713575
Interquartile range (IQR)	419970

Descriptive statistics

Standard deviation	3926258.5
Coefficient of variation (CV)	0.39587126
Kurtosis	2.5274555
Mean	9918018.6
Median Absolute Deviation (MAD)	180010
Skewness	-2.1214318
Sum	4.9590093 × 10⁹
Variance	1.5415506 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11710680	31	6.2%
11230560	23	4.6%
11350621	22	4.4%
11140540	20	4.0%
11650530	19	3.8%
11320690	18	3.6%
11710642	16	3.2%
11380690	16	3.2%
11710710	16	3.2%
11500620	14	2.8%
Other values (159)	305	61.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
27110	1	0.2%
28110	2	0.4%
28185	1	0.2%
28237	2	0.4%
30200	1	0.2%
41111	1	0.2%
41113	2	0.4%
41117	1	0.2%
41131	1	0.2%
41135	6	1.2%

Value	Count	Frequency (%)
11740685	1	0.2%
11710710	16	3.2%
11710690	3	0.6%
11710680	31	6.2%
11710670	3	0.6%
11710650	2	0.4%
11710647	1	0.2%
11710642	16	3.2%
11710631	1	0.2%
11710620	5	1.0%

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

Distinct	33
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.66

Minimum	1
Maximum	78
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	17.05
Maximum	78
Range	77
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	7.2385906
Coefficient of variation (CV)	1.5533456
Kurtosis	28.628517
Mean	4.66
Median Absolute Deviation (MAD)	1
Skewness	4.4419861
Sum	2330
Variance	52.397194
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=33)

Value	Count	Frequency (%)
1	198	39.6%
2	85	17.0%
3	41	8.2%
4	34	6.8%
5	29	5.8%
6	22	4.4%
7	16	3.2%
9	11	2.2%
10	10	2.0%
11	7	1.4%
Other values (23)	47	9.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	198	39.6%
2	85	17.0%
3	41	8.2%
4	34	6.8%
5	29	5.8%
6	22	4.4%
7	16	3.2%
8	2	0.4%
9	11	2.2%
10	10	2.0%

Value	Count	Frequency (%)
78	1	0.2%
44	1	0.2%
42	1	0.2%
40	2	0.4%
39	1	0.2%
36	2	0.4%
32	1	0.2%
31	2	0.4%
28	1	0.2%
27	1	0.2%

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

Distinct	47
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.628

Minimum	1
Maximum	153
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	8
95-th percentile	30.05
Maximum	153
Range	152
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	14.402099
Coefficient of variation (CV)	1.888057
Kurtosis	44.327269
Mean	7.628
Median Absolute Deviation (MAD)	2
Skewness	5.72332
Sum	3814
Variance	207.42046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
1	141	28.2%
2	86	17.2%
3	47	9.4%
4	37	7.4%
6	25	5.0%
5	22	4.4%
7	14	2.8%
10	13	2.6%
12	11	2.2%
8	11	2.2%
Other values (37)	93	18.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	141	28.2%
2	86	17.2%
3	47	9.4%
4	37	7.4%
5	22	4.4%
6	25	5.0%
7	14	2.8%
8	11	2.2%
9	9	1.8%
10	13	2.6%

Value	Count	Frequency (%)
153	1	0.2%
139	1	0.2%
120	1	0.2%
93	1	0.2%
62	1	0.2%
58	1	0.2%
55	2	0.4%
51	1	0.2%
48	1	0.2%
47	1	0.2%

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

Distinct	141
Distinct (%)	28.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	51392

Minimum	1000
Maximum	1914000
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	16500
Q3	51000
95-th percentile	199000
Maximum	1914000
Range	1913000
Interquartile range (IQR)	46000

Descriptive statistics

Standard deviation	118847.46
Coefficient of variation (CV)	2.3125674
Kurtosis	126.80247
Mean	51392
Median Absolute Deviation (MAD)	13500
Skewness	9.2399443
Sum	25696000
Variance	1.412472 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1000	38	7.6%
5000	27	5.4%
3000	23	4.6%
2000	20	4.0%
4000	18	3.6%
8000	16	3.2%
6000	14	2.8%
12000	13	2.6%
10000	13	2.6%
9000	13	2.6%
Other values (131)	305	61.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	38	7.6%
2000	20	4.0%
3000	23	4.6%
4000	18	3.6%
5000	27	5.4%
6000	14	2.8%
7000	12	2.4%
8000	16	3.2%
9000	13	2.6%
10000	13	2.6%

Value	Count	Frequency (%)
1914000	1	0.2%
869000	1	0.2%
657000	1	0.2%
463000	1	0.2%
437000	1	0.2%
410000	1	0.2%
393000	1	0.2%
382000	1	0.2%
378000	1	0.2%
320000	1	0.2%

Heatmap
Table

	기준년월(STD_YM)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
기준년월(STD_YM)	1.000	0.055	0.000	0.000	0.030	0.000	0.000	0.066	0.124
통계청상품코드(STAT_CD)	0.055	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000
성별코드(SEX_CD)	0.000	0.000	1.000	0.000	0.078	0.082	0.035	0.000	0.000
연령대코드(AGE_CD)	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.028	0.000
시간대코드(TIME_CD)	0.030	0.000	0.078	0.000	1.000	0.000	0.000	0.112	0.060
구매지역(PURH_AREA)	0.000	0.000	0.082	0.000	0.000	1.000	0.057	0.000	0.000
구매_고객수(ACC_CNT)	0.000	0.000	0.035	0.000	0.000	0.057	1.000	0.099	0.000
구매건수(PURH_CNT)	0.066	0.000	0.000	0.028	0.112	0.000	0.099	1.000	0.000
구매금액(PURH_AMT)	0.124	0.000	0.000	0.000	0.060	0.000	0.000	0.000	1.000

Heatmap
Table

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

Heatmap
Table

	기준년월(STD_YM)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)
기준년월(STD_YM)	1.000	0.076	0.009	0.003	0.021	0.049	0.086	0.039	0.000
연령대코드(AGE_CD)	0.076	1.000	0.085	0.012	-0.008	0.029	-0.004	0.000	0.000
시간대코드(TIME_CD)	0.009	0.085	1.000	-0.068	0.054	0.055	0.008	0.000	0.055
구매지역(PURH_AREA)	0.003	0.012	-0.068	1.000	-0.001	0.060	-0.009	0.000	0.047
구매_고객수(ACC_CNT)	0.021	-0.008	0.054	-0.001	1.000	0.030	0.017	0.000	0.037
구매건수(PURH_CNT)	0.049	0.029	0.055	0.060	0.030	1.000	-0.014	0.000	0.000
구매금액(PURH_AMT)	0.086	-0.004	0.008	-0.009	0.017	-0.014	1.000	0.000	0.000
통계청상품코드(STAT_CD)	0.039	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000
성별코드(SEX_CD)	0.000	0.000	0.055	0.047	0.037	0.000	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)	블록코드(BLCK_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
0	201801	214*	A	2	2	4	11710642	3	1	68000
1	201811	292*	B	2	4	5	11140540	2	1	61000
2	201908	227*	A	2	3	4	11650621	4	1	28000
3	201812	382*	A	1	4	4	11380690	1	2	56000
4	201901	193	A	1	5	3	11710631	1	3	2000
5	201807	242*	A	1	5	4	11650530	11	1	15000
6	201802	224*	A	2	5	4	28237	5	2	77000
7	201905	282	J	1	5	4	11710620	1	1	7000
8	201909	130*	A	2	4	4	11140540	40	2	32000
9	201812	215	E	2	5	6	41360	9	16	4000

	기준년월(STD_YM)	블록코드(BLCK_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매지역(PURH_AREA)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
490	201804	337*	B	2	5	5	41465	5	2	1000
491	201909	142*	A	2	6	6	11560610	1	2	869000
492	201912	220*	L	2	3	4	11380530	11	4	153000
493	201810	218*	A	2	4	6	11710680	7	7	16000
494	201912	257*	A	2	4	3	50110	1	3	55000
495	201805	260*	A	2	6	3	11350560	1	12	1000
496	201811	567	E	2	4	5	11140540	2	1	5000
497	201807	455*	J	2	4	3	11320670	1	1	15000
498	201810	216*	C	2	3	3	11350621	7	5	26000
499	201903	229*	A	1	4	5	11350625	4	44	63000

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