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:17:59.858753
Analysis finished	2024-04-16 19:18:04.924815
Duration	5.07 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

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.13233
Coefficient of variation (CV)	0.00024836058
Kurtosis	-1.970743
Mean	201853
Median Absolute Deviation (MAD)	11
Skewness	0.13514378
Sum	1.009265 × 10⁸
Variance	2513.2505
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
201803	32	6.4%
201810	29	5.8%
201802	26	5.2%
201805	25	5.0%
201907	23	4.6%
201908	23	4.6%
201812	23	4.6%
201910	22	4.4%
201806	21	4.2%
201901	21	4.2%
Other values (14)	255	51.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201801	21	4.2%
201802	26	5.2%
201803	32	6.4%
201804	18	3.6%
201805	25	5.0%
201806	21	4.2%
201807	15	3.0%
201808	20	4.0%
201809	20	4.0%
201810	29	5.8%

Value	Count	Frequency (%)
201912	16	3.2%
201911	17	3.4%
201910	22	4.4%
201909	19	3.8%
201908	23	4.6%
201907	23	4.6%
201906	19	3.8%
201905	20	4.0%
201904	21	4.2%
201903	14	2.8%

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

Distinct	294
Distinct (%)	58.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11435948

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

Quantile statistics

Minimum	11110530
5-th percentile	11140644
Q1	11290605
median	11440570
Q3	11590665
95-th percentile	11710642
Maximum	11740700
Range	630170
Interquartile range (IQR)	300060

Descriptive statistics

Standard deviation	185625.46
Coefficient of variation (CV)	0.01623175
Kurtosis	-1.2228394
Mean	11435948
Median Absolute Deviation (MAD)	150060
Skewness	-0.025754672
Sum	5.7179742 × 10⁹
Variance	3.445681 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11410565	6	1.2%
11680690	6	1.2%
11710647	5	1.0%
11650530	5	1.0%
11230705	5	1.0%
11710650	4	0.8%
11410655	4	0.8%
11200560	4	0.8%
11380530	4	0.8%
11530540	4	0.8%
Other values (284)	453	90.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11110530	1	0.2%
11110540	2	0.4%
11110560	1	0.2%
11110600	2	0.4%
11110630	1	0.2%
11110650	3	0.6%
11110690	2	0.4%
11110710	2	0.4%
11140540	2	0.4%
11140550	1	0.2%

Value	Count	Frequency (%)
11740700	1	0.2%
11740650	1	0.2%
11740640	2	0.4%
11740600	1	0.2%
11740560	1	0.2%
11740550	2	0.4%
11740540	3	0.6%
11740530	1	0.2%
11710690	1	0.2%
11710680	1	0.2%

통계청상품코드(STAT_CD)
Categorical

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

A	99
E	95
B	87
L	79
I	39
Other values (4)	101

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	E
3rd row	J
4th row	B
5th row	B

Common Values

Value	Count	Frequency (%)
A	99	19.8%
E	95	19.0%
B	87	17.4%
L	79	15.8%
I	39	7.8%
J	35	7.0%
C	30	6.0%
G	19	3.8%
F	17	3.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
a	99	19.8%
e	95	19.0%
b	87	17.4%
l	79	15.8%
i	39	7.8%
j	35	7.0%
c	30	6.0%
g	19	3.8%
f	17	3.4%

성별코드(SEX_CD)
Categorical

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

2	263
1	237

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	263	52.6%
1	237	47.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	263	52.6%
1	237	47.4%

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

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

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.606763
Coefficient of variation (CV)	0.39439446
Kurtosis	-0.86229552
Mean	4.074
Median Absolute Deviation (MAD)	1
Skewness	0.11195062
Sum	2037
Variance	2.5816874
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	108	21.6%
4	105	21.0%
5	85	17.0%
6	72	14.4%
2	72	14.4%
7	39	7.8%
1	19	3.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	19	3.8%
2	72	14.4%
3	108	21.6%
4	105	21.0%
5	85	17.0%
6	72	14.4%
7	39	7.8%

Value	Count	Frequency (%)
7	39	7.8%
6	72	14.4%
5	85	17.0%
4	105	21.0%
3	108	21.6%
2	72	14.4%
1	19	3.8%

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

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

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.4026085
Coefficient of variation (CV)	0.3567163
Kurtosis	-0.85896816
Mean	3.932
Median Absolute Deviation (MAD)	1
Skewness	-0.14115221
Sum	1966
Variance	1.9673106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	123	24.6%
4	110	22.0%
5	104	20.8%
6	83	16.6%
2	59	11.8%
1	21	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	21	4.2%
2	59	11.8%
3	123	24.6%
4	110	22.0%
5	104	20.8%
6	83	16.6%

Value	Count	Frequency (%)
6	83	16.6%
5	104	20.8%
4	110	22.0%
3	123	24.6%
2	59	11.8%
1	21	4.2%

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

Distinct	117
Distinct (%)	23.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.024

Minimum	1
Maximum	2529
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	7
Q3	27.25
95-th percentile	194.35
Maximum	2529
Range	2528
Interquartile range (IQR)	25.25

Descriptive statistics

Standard deviation	178.35805
Coefficient of variation (CV)	3.6381783
Kurtosis	106.93029
Mean	49.024
Median Absolute Deviation (MAD)	6
Skewness	9.254239
Sum	24512
Variance	31811.595
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	107	21.4%
2	55	11.0%
3	34	6.8%
5	24	4.8%
7	20	4.0%
4	15	3.0%
9	13	2.6%
8	12	2.4%
14	11	2.2%
6	10	2.0%
Other values (107)	199	39.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	107	21.4%
2	55	11.0%
3	34	6.8%
4	15	3.0%
5	24	4.8%
6	10	2.0%
7	20	4.0%
8	12	2.4%
9	13	2.6%
10	9	1.8%

Value	Count	Frequency (%)
2529	1	0.2%
1964	1	0.2%
1304	1	0.2%
804	1	0.2%
750	1	0.2%
746	1	0.2%
572	1	0.2%
504	1	0.2%
498	1	0.2%
460	1	0.2%

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

Distinct	135
Distinct (%)	27.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	99.12

Minimum	1
Maximum	4760
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	10
Q3	37
95-th percentile	438.2
Maximum	4760
Range	4759
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	373.80955
Coefficient of variation (CV)	3.7712828
Kurtosis	79.718571
Mean	99.12
Median Absolute Deviation (MAD)	9
Skewness	8.0449229
Sum	49560
Variance	139733.58
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	72	14.4%
2	55	11.0%
4	35	7.0%
3	26	5.2%
6	15	3.0%
7	14	2.8%
5	14	2.8%
14	13	2.6%
10	13	2.6%
18	11	2.2%
Other values (125)	232	46.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	72	14.4%
2	55	11.0%
3	26	5.2%
4	35	7.0%
5	14	2.8%
6	15	3.0%
7	14	2.8%
8	4	0.8%
9	10	2.0%
10	13	2.6%

Value	Count	Frequency (%)
4760	1	0.2%
3608	1	0.2%
3547	1	0.2%
1893	1	0.2%
1776	1	0.2%
1419	1	0.2%
1298	1	0.2%
1261	1	0.2%
1260	1	0.2%
1075	1	0.2%

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

Distinct	273
Distinct (%)	54.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	722868

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

Quantile statistics

Minimum	1000
5-th percentile	2000
Q1	14000
median	63000
Q3	307250
95-th percentile	2335950
Maximum	64841000
Range	64840000
Interquartile range (IQR)	293250

Descriptive statistics

Standard deviation	3561238.1
Coefficient of variation (CV)	4.92654
Kurtosis	221.48796
Mean	722868
Median Absolute Deviation (MAD)	58000
Skewness	13.429494
Sum	3.61434 × 10⁸
Variance	1.2682417 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	20	4.0%
5000	17	3.4%
1000	16	3.2%
2000	14	2.8%
3000	11	2.2%
8000	11	2.2%
15000	8	1.6%
13000	7	1.4%
4000	6	1.2%
11000	5	1.0%
Other values (263)	385	77.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000	16	3.2%
2000	14	2.8%
3000	11	2.2%
4000	6	1.2%
5000	17	3.4%
6000	4	0.8%
7000	5	1.0%
8000	11	2.2%
9000	4	0.8%
10000	20	4.0%

Value	Count	Frequency (%)
64841000	1	0.2%
30178000	1	0.2%
15859000	1	0.2%
14573000	1	0.2%
12066000	1	0.2%
11924000	1	0.2%
11720000	1	0.2%
9094000	1	0.2%
8363000	1	0.2%
6421000	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.122	0.155	0.000	0.000	0.000	0.000	0.000	0.014
행정동코드(ADSTRD_CD)	0.122	1.000	0.000	0.087	0.115	0.106	0.000	0.047	0.150
통계청상품코드(STAT_CD)	0.155	0.000	1.000	0.027	0.150	0.000	0.000	0.055	0.000
성별코드(SEX_CD)	0.000	0.087	0.027	1.000	0.089	0.061	0.117	0.000	0.014
연령대코드(AGE_CD)	0.000	0.115	0.150	0.089	1.000	0.000	0.189	0.130	0.000
시간대코드(TIME_CD)	0.000	0.106	0.000	0.061	0.000	1.000	0.000	0.000	0.092
구매_고객수(ACC_CNT)	0.000	0.000	0.000	0.117	0.189	0.000	1.000	0.000	0.000
구매건수(PURH_CNT)	0.000	0.047	0.055	0.000	0.130	0.000	0.000	1.000	0.172
구매금액(PURH_AMT)	0.014	0.150	0.000	0.014	0.000	0.092	0.000	0.172	1.000

Heatmap
Table

	통계청상품코드(STAT_CD)	성별코드(SEX_CD)
통계청상품코드(STAT_CD)	1.000	0.027
성별코드(SEX_CD)	0.027	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.094	-0.052	0.005	0.034	-0.110	0.015	0.140	0.000
행정동코드(ADSTRD_CD)	-0.094	1.000	0.024	0.063	-0.006	0.102	0.036	0.000	0.061
연령대코드(AGE_CD)	-0.052	0.024	1.000	0.040	-0.000	-0.003	-0.017	0.079	0.094
시간대코드(TIME_CD)	0.005	0.063	0.040	1.000	-0.039	-0.045	-0.011	0.000	0.043
구매_고객수(ACC_CNT)	0.034	-0.006	-0.000	-0.039	1.000	0.044	-0.043	0.000	0.125
구매건수(PURH_CNT)	-0.110	0.102	-0.003	-0.045	0.044	1.000	0.005	0.026	0.000
구매금액(PURH_AMT)	0.015	0.036	-0.017	-0.011	-0.043	0.005	1.000	0.000	0.016
통계청상품코드(STAT_CD)	0.140	0.000	0.079	0.000	0.000	0.026	0.000	1.000	0.027
성별코드(SEX_CD)	0.000	0.061	0.094	0.043	0.125	0.000	0.016	0.027	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	201907	11200720	E	1	4	5	5	16	436000
1	201809	11140635	E	1	7	4	179	18	110000
2	201805	11380632	J	2	3	5	5	2	1000
3	201901	11215830	B	1	6	4	331	681	23000
4	201802	11140635	B	1	6	1	9	1	22000
5	201909	11350710	L	2	7	2	18	4	5246000
6	201811	11590630	A	2	6	5	1	14	103000
7	201804	11260630	A	1	4	4	3	1	31000
8	201811	11530760	E	2	3	4	3	200	220000
9	201806	11500560	E	1	4	6	3	9	293000

	기준년월(STD_YM)	행정동코드(ADSTRD_CD)	통계청상품코드(STAT_CD)	성별코드(SEX_CD)	연령대코드(AGE_CD)	시간대코드(TIME_CD)	구매_고객수(ACC_CNT)	구매건수(PURH_CNT)	구매금액(PURH_AMT)
490	201812	11740540	J	2	3	4	33	1	152000
491	201908	11110630	J	1	5	3	48	28	11000
492	201812	11230705	L	1	4	3	41	3	78000
493	201812	11140625	I	2	6	3	7	1	10000
494	201803	11680650	A	2	4	5	1	40	4000
495	201803	11170520	L	2	4	4	1	3	63000
496	201909	11440730	A	1	2	4	38	3	16000
497	201904	11530520	B	1	6	5	504	15	10000
498	201908	11350580	E	2	4	5	38	5	3000
499	201908	11350670	F	1	5	1	750	215	176000

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample