gimi9 Pandas Profiling

Dataset statistics

Number of variables	10
Number of observations	500
Missing cells	75
Missing cells (%)	1.5%
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	8
Categorical	2

Dataset

Description	샘플 데이터
Author	신한카드
URL	https://bigdata.seoul.go.kr/data/selectSampleData.do?sample_data_seq=50

Alerts

`시간대(TM)` has constant value ""	Constant
`유입지_시군구코드(C_SGG_CD)` has 75 (15.0%) missing values	Missing

Reproduction

Analysis started	2023-12-10 14:52:25.458157
Analysis finished	2023-12-10 14:52:34.402851
Duration	8.94 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

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

Distinct	252
Distinct (%)	50.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1114635.4

Minimum	1101053
Maximum	1125074
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1101053
5-th percentile	1102058
Q1	1108071.8
median	1115070.5
Q3	1122053.2
95-th percentile	1124071.3
Maximum	1125074
Range	24021
Interquartile range (IQR)	13981.5

Descriptive statistics

Standard deviation	7528.3759
Coefficient of variation (CV)	0.006754115
Kurtosis	-1.214018
Mean	1114635.4
Median Absolute Deviation (MAD)	6987
Skewness	-0.33621625
Sum	5.5731772 × 10⁸
Variance	56676444
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1123064	12	2.4%
1114077	9	1.8%
1114066	8	1.6%
1119074	7	1.4%
1118051	7	1.4%
1122067	5	1.0%
1123063	5	1.0%
1125067	5	1.0%
1113075	5	1.0%
1101072	4	0.8%
Other values (242)	433	86.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1101053	2	0.4%
1101054	1	0.2%
1101055	1	0.2%
1101061	2	0.4%
1101068	1	0.2%
1101071	1	0.2%
1101072	4	0.8%
1101073	3	0.6%
1102052	2	0.4%
1102054	4	0.8%

Value	Count	Frequency (%)
1125074	4	0.8%
1125073	1	0.2%
1125072	1	0.2%
1125071	2	0.4%
1125070	1	0.2%
1125067	5	1.0%
1125066	1	0.2%
1125065	1	0.2%
1125063	1	0.2%
1125058	1	0.2%

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

Distinct	474
Distinct (%)	94.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.114411 × 10¹²

Minimum	1.101053 × 10¹²
Maximum	1.125073 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	1.101053 × 10¹²
5-th percentile	1.102059 × 10¹²
Q1	1.1070698 × 10¹²
median	1.116051 × 10¹²
Q3	1.121325 × 10¹²
95-th percentile	1.124065 × 10¹²
Maximum	1.125073 × 10¹²
Range	2.402001 × 10¹⁰
Interquartile range (IQR)	1.4255263 × 10¹⁰

Descriptive statistics

Standard deviation	7.4415153 × 10⁹
Coefficient of variation (CV)	0.006677532
Kurtosis	-1.2806913
Mean	1.114411 × 10¹²
Median Absolute Deviation (MAD)	6.015025 × 10⁹
Skewness	-0.28385241
Sum	5.5720551 × 10¹⁴
Variance	5.537615 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1114066100004	3	0.6%
1123077040001	3	0.6%
1122053010010	2	0.4%
1123064030006	2	0.4%
1115060040011	2	0.4%
1123064070006	2	0.4%
1117056010002	2	0.4%
1111058060002	2	0.4%
1107060050005	2	0.4%
1123053010005	2	0.4%
Other values (464)	478	95.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1101053020002	1	0.2%
1101056020001	1	0.2%
1101061020002	1	0.2%
1101061030004	1	0.2%
1101061030005	1	0.2%
1101063020001	1	0.2%
1101063030002	1	0.2%
1101071020004	1	0.2%
1101072010002	1	0.2%
1101072010004	1	0.2%

Value	Count	Frequency (%)
1125073030012	1	0.2%
1125073030010	1	0.2%
1125073030006	1	0.2%
1125073020001	1	0.2%
1125073010001	1	0.2%
1125072010017	1	0.2%
1125067020013	1	0.2%
1125066020301	1	0.2%
1125066010008	1	0.2%
1125065010004	1	0.2%

업종코드(SE_UPJONG)
Categorical

Distinct	21
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

sb08	117
sb01	78
sb06	65
sb02	33
sb19	30
Other values (16)	177

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Unique

Unique	1 ?
Unique (%)	0.2%

Sample

1st row	sb04
2nd row	sb01
3rd row	sb01
4th row	sb02
5th row	sb01

Common Values

Value	Count	Frequency (%)
sb08	117	23.4%
sb01	78	15.6%
sb06	65	13.0%
sb02	33	6.6%
sb19	30	6.0%
sb03	22	4.4%
sb09	19	3.8%
sb15	18	3.6%
sb14	18	3.6%
sb04	16	3.2%
Other values (11)	84	16.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sb08	117	23.4%
sb01	78	15.6%
sb06	65	13.0%
sb02	33	6.6%
sb19	30	6.0%
sb03	22	4.4%
sb09	19	3.8%
sb15	18	3.6%
sb14	18	3.6%
sb11	16	3.2%
Other values (11)	84	16.8%

이용년월(TS_YM)
Real number (ℝ)

Distinct	24
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	201642.56

Minimum	201512
Maximum	201711
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	201512
5-th percentile	201512
Q1	201604
median	201610
Q3	201705
95-th percentile	201710
Maximum	201711
Range	199
Interquartile range (IQR)	101

Descriptive statistics

Standard deviation	59.773578
Coefficient of variation (CV)	0.00029643335
Kurtosis	-0.81167641
Mean	201642.56
Median Absolute Deviation (MAD)	9
Skewness	-0.30851298
Sum	1.0082128 × 10⁸
Variance	3572.8806
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
201512	34	6.8%
201609	29	5.8%
201604	29	5.8%
201602	24	4.8%
201601	24	4.8%
201708	22	4.4%
201706	22	4.4%
201603	22	4.4%
201710	22	4.4%
201707	21	4.2%
Other values (14)	251	50.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201512	34	6.8%
201601	24	4.8%
201602	24	4.8%
201603	22	4.4%
201604	29	5.8%
201605	19	3.8%
201606	18	3.6%
201607	14	2.8%
201608	19	3.8%
201609	29	5.8%

Value	Count	Frequency (%)
201711	16	3.2%
201710	22	4.4%
201709	20	4.0%
201708	22	4.4%
201707	21	4.2%
201706	22	4.4%
201705	21	4.2%
201704	17	3.4%
201703	20	4.0%
201702	15	3.0%

요일코드(DAW_CCD)
Real number (ℝ)

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

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

Descriptive statistics

Standard deviation	1.9078689
Coefficient of variation (CV)	0.460171
Kurtosis	-1.1422218
Mean	4.146
Median Absolute Deviation (MAD)	2
Skewness	-0.10897173
Sum	2073
Variance	3.6399639
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
5	87	17.4%
4	83	16.6%
6	76	15.2%
2	74	14.8%
7	67	13.4%
3	60	12.0%
1	53	10.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	53	10.6%
2	74	14.8%
3	60	12.0%
4	83	16.6%
5	87	17.4%
6	76	15.2%
7	67	13.4%

Value	Count	Frequency (%)
7	67	13.4%
6	76	15.2%
5	87	17.4%
4	83	16.6%
3	60	12.0%
2	74	14.8%
1	53	10.6%

시간대(TM)
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

t4	500

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	t4
2nd row	t4
3rd row	t4
4th row	t4
5th row	t4

Common Values

Value	Count	Frequency (%)
t4	500	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
t4	500	100.0%

유입지_시도코드(C_SIDO_CD)
Real number (ℝ)

Distinct	15
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.004

Minimum	11
Maximum	48
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	11
5-th percentile	11
Q1	11
median	11
Q3	41
95-th percentile	44.05
Maximum	48
Range	37
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	14.652145
Coefficient of variation (CV)	0.61040431
Kurtosis	-1.7684743
Mean	24.004
Median Absolute Deviation (MAD)	0
Skewness	0.33012428
Sum	12002
Variance	214.68535
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
11	271	54.2%
41	147	29.4%
28	10	2.0%
27	10	2.0%
45	9	1.8%
30	8	1.6%
48	8	1.6%
29	7	1.4%
43	6	1.2%
42	5	1.0%
Other values (5)	19	3.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	271	54.2%
26	4	0.8%
27	10	2.0%
28	10	2.0%
29	7	1.4%
30	8	1.6%
31	3	0.6%
41	147	29.4%
42	5	1.0%
43	6	1.2%

Value	Count	Frequency (%)
48	8	1.6%
47	3	0.6%
46	5	1.0%
45	9	1.8%
44	4	0.8%
43	6	1.2%
42	5	1.0%
41	147	29.4%
31	3	0.6%
30	8	1.6%

유입지_시군구코드(C_SGG_CD)
Real number (ℝ)

MISSING

Distinct	47
Distinct (%)	11.1%
Missing	75
Missing (%)	15.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.268235

Minimum	11
Maximum	83
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	11
5-th percentile	11
Q1	22
median	38
Q3	57
95-th percentile	71
Maximum	83
Range	72
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	19.35343
Coefficient of variation (CV)	0.48061281
Kurtosis	-1.1288186
Mean	40.268235
Median Absolute Deviation (MAD)	17
Skewness	0.14462225
Sum	17114
Variance	374.55524
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
59	27	5.4%
11	25	5.0%
17	20	4.0%
68	17	3.4%
38	16	3.2%
56	15	3.0%
71	15	3.0%
21	15	3.0%
53	13	2.6%
50	13	2.6%
Other values (37)	249	49.8%
(Missing)	75	15.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	25	5.0%
13	10	2.0%
14	9	1.8%
15	7	1.4%
17	20	4.0%
19	8	1.6%
20	11	2.2%
21	15	3.0%
22	2	0.4%
23	11	2.2%

Value	Count	Frequency (%)
83	3	0.6%
82	2	0.4%
74	11	2.2%
71	15	3.0%
68	17	3.4%
67	1	0.2%
65	9	1.8%
63	1	0.2%
62	8	1.6%
61	5	1.0%

이용건수(USECT_CORR)
Real number (ℝ)

Distinct	44
Distinct (%)	8.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39.57928

Minimum	4.94
Maximum	2618.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	4.94
5-th percentile	4.94
Q1	4.94
median	9.88
Q3	19.76
95-th percentile	144.001
Maximum	2618.2
Range	2613.26
Interquartile range (IQR)	14.82

Descriptive statistics

Standard deviation	156.45675
Coefficient of variation (CV)	3.9529964
Kurtosis	171.92044
Mean	39.57928
Median Absolute Deviation (MAD)	4.94
Skewness	11.876466
Sum	19789.64
Variance	24478.715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
4.94	217	43.4%
9.88	93	18.6%
14.82	42	8.4%
19.76	25	5.0%
24.7	14	2.8%
29.64	14	2.8%
34.58	13	2.6%
54.34	12	2.4%
39.52	9	1.8%
44.46	8	1.6%
Other values (34)	53	10.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4.94	217	43.4%
9.88	93	18.6%
14.82	42	8.4%
19.76	25	5.0%
24.7	14	2.8%
29.64	14	2.8%
34.58	13	2.6%
39.52	9	1.8%
44.46	8	1.6%
49.4	4	0.8%

Value	Count	Frequency (%)
2618.2	1	0.2%
1635.14	1	0.2%
963.3	1	0.2%
607.62	1	0.2%
553.28	1	0.2%
424.84	1	0.2%
365.56	1	0.2%
355.68	1	0.2%
350.74	1	0.2%
326.04	1	0.2%

이용금액(AMT_CORR)
Real number (ℝ)

Distinct	353
Distinct (%)	70.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	786786.64

Minimum	2964
Maximum	37026876
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.5 KiB

Quantile statistics

Minimum	2964
5-th percentile	14701.44
Q1	45460.35
median	126217
Q3	402610
95-th percentile	2924997.5
Maximum	37026876
Range	37023912
Interquartile range (IQR)	357149.65

Descriptive statistics

Standard deviation	3032595.3
Coefficient of variation (CV)	3.8544062
Kurtosis	92.498041
Mean	786786.64
Median Absolute Deviation (MAD)	103987
Skewness	8.9766282
Sum	3.9339332 × 10⁸
Variance	9.1966344 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22230.0	11	2.2%
79040.0	9	1.8%
39520.0	8	1.6%
59280.0	8	1.6%
108680.0	6	1.2%
49400.0	6	1.2%
24700.0	5	1.0%
19760.0	5	1.0%
29640.0	5	1.0%
88920.0	5	1.0%
Other values (343)	432	86.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2964.0	1	0.2%
4446.0	1	0.2%
4693.0	1	0.2%
4940.0	3	0.6%
5928.0	1	0.2%
6916.0	1	0.2%
7410.0	2	0.4%
7904.0	2	0.4%
8892.0	2	0.4%
9880.0	1	0.2%

Value	Count	Frequency (%)
37026875.86	1	0.2%
35366497.4	1	0.2%
29246578.4	1	0.2%
17556611.8	1	0.2%
14828398.0	1	0.2%
14227200.0	1	0.2%
12003804.8	1	0.2%
7489040.0	1	0.2%
6518626.4	1	0.2%
5605368.6	1	0.2%

Phik (φk)
Auto

Heatmap
Table

	행정동코드(M_DONG_CD)	블록코드(BLOCK_ID)	업종코드(SE_UPJONG)	이용년월(TS_YM)	요일코드(DAW_CCD)	유입지_시도코드(C_SIDO_CD)	유입지_시군구코드(C_SGG_CD)	이용건수(USECT_CORR)	이용금액(AMT_CORR)
행정동코드(M_DONG_CD)	1.000	0.000	0.106	0.000	0.000	0.000	0.000	0.182	0.143
블록코드(BLOCK_ID)	0.000	1.000	0.000	0.000	0.132	0.000	0.000	0.000	0.000
업종코드(SE_UPJONG)	0.106	0.000	1.000	0.056	0.081	0.000	0.000	0.000	0.177
이용년월(TS_YM)	0.000	0.000	0.056	1.000	0.000	0.000	0.058	0.000	0.000
요일코드(DAW_CCD)	0.000	0.132	0.081	0.000	1.000	0.031	0.000	0.000	0.000
유입지_시도코드(C_SIDO_CD)	0.000	0.000	0.000	0.000	0.031	1.000	0.000	0.000	0.000
유입지_시군구코드(C_SGG_CD)	0.000	0.000	0.000	0.058	0.000	0.000	1.000	0.000	0.046
이용건수(USECT_CORR)	0.182	0.000	0.000	0.000	0.000	0.000	0.000	1.000	0.000
이용금액(AMT_CORR)	0.143	0.000	0.177	0.000	0.000	0.000	0.046	0.000	1.000

Heatmap
Table

	행정동코드(M_DONG_CD)	블록코드(BLOCK_ID)	이용년월(TS_YM)	요일코드(DAW_CCD)	유입지_시도코드(C_SIDO_CD)	유입지_시군구코드(C_SGG_CD)	이용건수(USECT_CORR)	이용금액(AMT_CORR)	업종코드(SE_UPJONG)
행정동코드(M_DONG_CD)	1.000	0.019	0.085	0.015	-0.035	-0.046	-0.012	0.012	0.039
블록코드(BLOCK_ID)	0.019	1.000	0.042	-0.047	0.060	0.032	0.003	-0.028	0.000
이용년월(TS_YM)	0.085	0.042	1.000	-0.017	0.010	0.011	-0.068	-0.002	0.106
요일코드(DAW_CCD)	0.015	-0.047	-0.017	1.000	0.011	-0.023	-0.016	0.040	0.028
유입지_시도코드(C_SIDO_CD)	-0.035	0.060	0.010	0.011	1.000	0.032	-0.039	0.021	0.000
유입지_시군구코드(C_SGG_CD)	-0.046	0.032	0.011	-0.023	0.032	1.000	0.034	-0.074	0.000
이용건수(USECT_CORR)	-0.012	0.003	-0.068	-0.016	-0.039	0.034	1.000	0.051	0.000
이용금액(AMT_CORR)	0.012	-0.028	-0.002	0.040	0.021	-0.074	0.051	1.000	0.066
업종코드(SE_UPJONG)	0.039	0.000	0.106	0.028	0.000	0.000	0.000	0.066	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

	행정동코드(M_DONG_CD)	블록코드(BLOCK_ID)	업종코드(SE_UPJONG)	이용년월(TS_YM)	요일코드(DAW_CCD)	시간대(TM)	유입지_시도코드(C_SIDO_CD)	유입지_시군구코드(C_SGG_CD)	이용건수(USECT_CORR)	이용금액(AMT_CORR)
0	1121058	1112056020022	sb04	201708	3	t4	41	32	9.88	186732.0
1	1122067	1106083020003	sb01	201604	6	t4	11	59	4.94	49400.0
2	1123077	1123053010008	sb01	201602	2	t4	11	<NA>	9.88	18772.0
3	1114071	1103074040001	sb02	201704	2	t4	11	62	24.7	58687.2
4	1104065	1101056020001	sb01	201601	5	t4	41	35	19.76	9880.0
5	1123065	1111052011202	sb02	201609	2	t4	29	57	4.94	49400.0
6	1115064	1122060020002	sb01	201609	2	t4	11	53	19.76	49400.0
7	1115064	1121052030005	sb08	201601	7	t4	11	28	103.74	50388.0
8	1107071	1113075040001	sb06	201605	5	t4	11	<NA>	4.94	103740.0
9	1115051	1122067010001	sb05	201603	5	t4	11	<NA>	4.94	113620.0

	행정동코드(M_DONG_CD)	블록코드(BLOCK_ID)	업종코드(SE_UPJONG)	이용년월(TS_YM)	요일코드(DAW_CCD)	시간대(TM)	유입지_시도코드(C_SIDO_CD)	유입지_시군구코드(C_SGG_CD)	이용건수(USECT_CORR)	이용금액(AMT_CORR)
490	1116059	1107073030005	sb08	201705	6	t4	41	41	9.88	347282.0
491	1105061	1122054030003	sb08	201701	2	t4	46	57	4.94	48412.0
492	1103069	1124065020003	sb08	201701	4	t4	11	31	4.94	58884.8
493	1116071	1113073040001	sb22	201706	4	t4	41	23	4.94	219928.8
494	1120073	1124051010022	sb03	201707	5	t4	41	71	19.76	14820.0
495	1110060	1123071020003	sb08	201708	6	t4	41	25	9.88	34580.0
496	1102068	1123080020001	sb19	201602	4	t4	42	21	4.94	10868.0
497	1120052	1122066030001	sb10	201605	2	t4	11	82	19.76	123500.0
498	1120052	1124066010201	sb06	201711	1	t4	11	71	9.88	537472.0
499	1123079	1124061010009	sb15	201610	2	t4	11	38	4.94	2346747.0

Overview

Variables

Common Values

Length

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample