gimi9 Pandas Profiling

Dataset statistics

Number of variables	9
Number of observations	500
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	39.2 KiB
Average record size in memory	80.3 B

Variable types

Numeric	7
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:53.175102
Analysis finished	2024-04-16 19:18:58.409251
Duration	5.23 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	201858.3

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

Descriptive statistics

Standard deviation	50.260631
Coefficient of variation (CV)	0.00024898967
Kurtosis	-1.9844396
Mean	201858.3
Median Absolute Deviation (MAD)	11
Skewness	-0.07204636
Sum	1.0092915 × 10⁸
Variance	2526.1311
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
201809	29	5.8%
201802	28	5.6%
201807	27	5.4%
201908	27	5.4%
201903	26	5.2%
201910	25	5.0%
201904	22	4.4%
201911	22	4.4%
201907	21	4.2%
201906	21	4.2%
Other values (14)	252	50.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201801	21	4.2%
201802	28	5.6%
201803	16	3.2%
201804	15	3.0%
201805	18	3.6%
201806	19	3.8%
201807	27	5.4%
201808	19	3.8%
201809	29	5.8%
201810	12	2.4%

Value	Count	Frequency (%)
201912	20	4.0%
201911	22	4.4%
201910	25	5.0%
201909	19	3.8%
201908	27	5.4%
201907	21	4.2%
201906	21	4.2%
201905	21	4.2%
201904	22	4.4%
201903	26	5.2%

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

Distinct	269
Distinct (%)	53.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11446110

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	11140570
Q1	11290685
median	11470575
Q3	11620565
95-th percentile	11710690
Maximum	11740700
Range	630185
Interquartile range (IQR)	329880

Descriptive statistics

Standard deviation	189125.76
Coefficient of variation (CV)	0.016523148
Kurtosis	-1.2276861
Mean	11446110
Median Absolute Deviation (MAD)	164965
Skewness	-0.12567943
Sum	5.7230548 × 10⁹
Variance	3.5768553 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11710710	6	1.2%
11710690	6	1.2%
11650530	6	1.2%
11410700	6	1.2%
11320690	6	1.2%
11680650	5	1.0%
11560610	5	1.0%
11500510	5	1.0%
11590620	4	0.8%
11230740	4	0.8%
Other values (259)	447	89.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11110515	2	0.4%
11110530	1	0.2%
11110550	3	0.6%
11110560	1	0.2%
11110580	1	0.2%
11110640	3	0.6%
11110670	1	0.2%
11110710	3	0.6%
11140520	2	0.4%
11140540	4	0.8%

Value	Count	Frequency (%)
11740700	1	0.2%
11740685	3	0.6%
11740660	2	0.4%
11740610	3	0.6%
11740600	1	0.2%
11740580	1	0.2%
11740550	2	0.4%
11740515	2	0.4%
11710710	6	1.2%
11710690	6	1.2%

통계청상품코드(STAT_CD)
Categorical

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

A	135
B	126
E	90
L	53
J	32
Other values (4)	64

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	B
4th row	E
5th row	L

Common Values

Value	Count	Frequency (%)
A	135	27.0%
B	126	25.2%
E	90	18.0%
L	53	10.6%
J	32	6.4%
C	24	4.8%
F	23	4.6%
I	11	2.2%
G	6	1.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	135	27.0%
b	126	25.2%
e	90	18.0%
l	53	10.6%
j	32	6.4%
c	24	4.8%
f	23	4.6%
i	11	2.2%
g	6	1.2%

성별코드(SEX_CD)
Categorical

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

2	264
1	236

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	264	52.8%
1	236	47.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	264	52.8%
1	236	47.2%

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

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

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	7
Maximum	7
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.614388
Coefficient of variation (CV)	0.38826069
Kurtosis	-0.93529629
Mean	4.158
Median Absolute Deviation (MAD)	1
Skewness	0.13513298
Sum	2079
Variance	2.6062485
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
4	116	23.2%
3	93	18.6%
2	81	16.2%
5	78	15.6%
6	74	14.8%
7	47	9.4%
1	11	2.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11	2.2%
2	81	16.2%
3	93	18.6%
4	116	23.2%
5	78	15.6%
6	74	14.8%
7	47	9.4%

Value	Count	Frequency (%)
7	47	9.4%
6	74	14.8%
5	78	15.6%
4	116	23.2%
3	93	18.6%
2	81	16.2%
1	11	2.2%

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

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

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

Descriptive statistics

Standard deviation	1.6365992
Coefficient of variation (CV)	0.43411119
Kurtosis	-1.1511421
Mean	3.77
Median Absolute Deviation (MAD)	1
Skewness	-0.16647809
Sum	1885
Variance	2.6784569
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
6	98	19.6%
4	97	19.4%
5	90	18.0%
3	83	16.6%
2	78	15.6%
1	54	10.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	54	10.8%
2	78	15.6%
3	83	16.6%
4	97	19.4%
5	90	18.0%
6	98	19.6%

Value	Count	Frequency (%)
6	98	19.6%
5	90	18.0%
4	97	19.4%
3	83	16.6%
2	78	15.6%
1	54	10.8%

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

Distinct	114
Distinct (%)	22.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	150.638

Minimum	1
Maximum	13884
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	5
Q3	23
95-th percentile	377.3
Maximum	13884
Range	13883
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	956.34705
Coefficient of variation (CV)	6.3486441
Kurtosis	121.47736
Mean	150.638
Median Absolute Deviation (MAD)	4
Skewness	10.382158
Sum	75319
Variance	914599.69
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	115	23.0%
2	55	11.0%
3	42	8.4%
4	33	6.6%
5	22	4.4%
6	17	3.4%
7	11	2.2%
8	10	2.0%
9	9	1.8%
16	9	1.8%
Other values (104)	177	35.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	115	23.0%
2	55	11.0%
3	42	8.4%
4	33	6.6%
5	22	4.4%
6	17	3.4%
7	11	2.2%
8	10	2.0%
9	9	1.8%
10	8	1.6%

Value	Count	Frequency (%)
13884	1	0.2%
9855	1	0.2%
8251	1	0.2%
6438	1	0.2%
5423	1	0.2%
3824	1	0.2%
3015	1	0.2%
1781	1	0.2%
1452	1	0.2%
1168	1	0.2%

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

Distinct	131
Distinct (%)	26.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	174.97

Minimum	1
Maximum	26428
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	8.5
Q3	36
95-th percentile	356.2
Maximum	26428
Range	26427
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	1463.6984
Coefficient of variation (CV)	8.3654248
Kurtosis	253.94449
Mean	174.97
Median Absolute Deviation (MAD)	7.5
Skewness	15.445573
Sum	87485
Variance	2142413
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	93	18.6%
2	41	8.2%
3	36	7.2%
4	30	6.0%
7	17	3.4%
6	15	3.0%
17	10	2.0%
5	10	2.0%
10	8	1.6%
8	8	1.6%
Other values (121)	232	46.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	93	18.6%
2	41	8.2%
3	36	7.2%
4	30	6.0%
5	10	2.0%
6	15	3.0%
7	17	3.4%
8	8	1.6%
9	4	0.8%
10	8	1.6%

Value	Count	Frequency (%)
26428	1	0.2%
18229	1	0.2%
3360	1	0.2%
2794	1	0.2%
2513	1	0.2%
2326	1	0.2%
2117	1	0.2%
2050	1	0.2%
1730	1	0.2%
1402	1	0.2%

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

Distinct	233
Distinct (%)	46.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1820754

Minimum	1000
Maximum	2.56325 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1000
5-th percentile	2000
Q1	9000
median	38500
Q3	198500
95-th percentile	4936350
Maximum	2.56325 × 10⁸
Range	2.56324 × 10⁸
Interquartile range (IQR)	189500

Descriptive statistics

Standard deviation	14074180
Coefficient of variation (CV)	7.7298633
Kurtosis	239.20342
Mean	1820754
Median Absolute Deviation (MAD)	34500
Skewness	14.598483
Sum	9.10377 × 10⁸
Variance	1.9808253 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000	24	4.8%
5000	19	3.8%
4000	15	3.0%
10000	15	3.0%
3000	15	3.0%
1000	15	3.0%
6000	14	2.8%
14000	10	2.0%
9000	10	2.0%
12000	8	1.6%
Other values (223)	355	71.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	15	3.0%
2000	24	4.8%
3000	15	3.0%
4000	15	3.0%
5000	19	3.8%
6000	14	2.8%
7000	8	1.6%
8000	8	1.6%
9000	10	2.0%
10000	15	3.0%

Value	Count	Frequency (%)
256325000	1	0.2%
146115000	1	0.2%
87281000	1	0.2%
40373000	1	0.2%
27579000	1	0.2%
27235000	1	0.2%
22776000	1	0.2%
19564000	1	0.2%
17139000	1	0.2%
15510000	1	0.2%

Heatmap
Table

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
기준년월(STD_YM)	1.000	0.000	0.177	0.000	0.043	0.000	0.028	0.000	0.000
행정동코드(ADSTRD_CD)	0.000	1.000	0.000	0.000	0.000	0.156	0.000	0.000	0.139
통계청상품코드(STAT_CD)	0.177	0.000	1.000	0.108	0.000	0.052	0.162	0.000	0.047
성별코드(SEX_CD)	0.000	0.000	0.108	1.000	0.072	0.000	0.025	0.000	0.000
연령대코드(AGE_CD)	0.043	0.000	0.000	0.072	1.000	0.000	0.189	0.000	0.000
시간대코드(TIME_CD)	0.000	0.156	0.052	0.000	0.000	1.000	0.000	0.000	0.000
구매_고객수(ACC_CNT)	0.028	0.000	0.162	0.025	0.189	0.000	1.000	0.000	0.000
구매건수(PURH_CNT)	0.000	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000
구매금액(PURH_AMT)	0.000	0.139	0.047	0.000	0.000	0.000	0.000	0.000	1.000

Heatmap
Table

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

Heatmap
Table

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)
기준년월(STD_YM)	1.000	-0.012	-0.105	0.004	-0.009	0.000	0.021	0.160	0.000
행정동코드(ADSTRD_CD)	-0.012	1.000	-0.028	-0.063	-0.092	-0.034	-0.096	0.000	0.000
연령대코드(AGE_CD)	-0.105	-0.028	1.000	0.056	-0.013	-0.007	-0.009	0.000	0.077
시간대코드(TIME_CD)	0.004	-0.063	0.056	1.000	-0.038	-0.046	0.043	0.025	0.000
구매_고객수(ACC_CNT)	-0.009	-0.092	-0.013	-0.038	1.000	0.006	-0.053	0.080	0.018
구매건수(PURH_CNT)	0.000	-0.034	-0.007	-0.046	0.006	1.000	-0.019	0.000	0.000
구매금액(PURH_AMT)	0.021	-0.096	-0.009	0.043	-0.053	-0.019	1.000	0.034	0.000
통계청상품코드(STAT_CD)	0.160	0.000	0.000	0.025	0.080	0.000	0.034	1.000	0.107
성별코드(SEX_CD)	0.000	0.000	0.077	0.000	0.018	0.000	0.000	0.107	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)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
0	201807	11545700	B	2	3	4	1	661	4000
1	201911	11680531	A	1	1	6	11	1	143000
2	201909	11200690	B	1	3	5	7	4	14000
3	201905	11650540	E	1	3	2	9	1	549000
4	201809	11110670	L	1	3	1	3015	8	22776000
5	201803	11650530	G	2	3	2	1	355	7000
6	201811	11170660	E	1	4	5	110	74	159000
7	201807	11350600	G	2	6	5	1	2	2000
8	201809	11470680	B	2	5	1	2	7	1000
9	201907	11140540	F	2	3	4	4	4	40000

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
490	201904	11470540	B	1	2	1	13	27	6000
491	201910	11380625	F	1	7	2	15	5	40000
492	201807	11215870	L	1	6	4	5423	47	76000
493	201903	11500611	L	2	7	5	55	1	14000
494	201912	11545680	B	2	4	6	1	427	4928000
495	201906	11410585	A	1	6	4	2	1	467000
496	201908	11740685	B	2	3	1	16	11	2000
497	201807	11260630	E	1	7	5	4	2	42000
498	201802	11590620	B	1	7	5	1024	1	1000
499	201809	11500510	A	2	7	3	1	10	1000

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample