gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	100
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.3 KiB
Average record size in memory	54.3 B

Variable types

Numeric	4
Categorical	2

Dataset

Description	샘플 데이터
Author	이승훈
URL	https://www.bigdata-transportation.kr/frn/prdt/detail?prdtId=PRDTNUM_000000020068

Alerts

`tco_btc_u_ct` is highly overall correlated with `tco_btc_u_am`	High correlation
`tco_btc_u_am` is highly overall correlated with `tco_btc_u_ct`	High correlation
`tco_btc_u_am` has unique values	Unique
`agegrp_dc` has 7 (7.0%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 22:42:57.559137
Analysis finished	2023-12-11 22:43:00.670891
Duration	3.11 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

crym
Real number (ℝ)

Distinct	30
Distinct (%)	30.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	202007.24

Minimum	201901
Maximum	202109
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	201901
5-th percentile	201904
Q1	201911
median	202007
Q3	202103
95-th percentile	202107.05
Maximum	202109
Range	208
Interquartile range (IQR)	192

Descriptive statistics

Standard deviation	81.358059
Coefficient of variation (CV)	0.00040274823
Kurtosis	-1.5188779
Mean	202007.24
Median Absolute Deviation (MAD)	96
Skewness	-0.018637234
Sum	20200724
Variance	6619.1337
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
202105	8	8.0%
202002	6	6.0%
202103	6	6.0%
202107	6	6.0%
202003	6	6.0%
201912	6	6.0%
202008	5	5.0%
201905	5	5.0%
201911	4	4.0%
202106	4	4.0%
Other values (20)	44	44.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
201901	1	1.0%
201902	2	2.0%
201903	1	1.0%
201904	4	4.0%
201905	5	5.0%
201906	2	2.0%
201907	1	1.0%
201908	4	4.0%
201910	3	3.0%
201911	4	4.0%

Value	Count	Frequency (%)
202109	3	3.0%
202108	2	2.0%
202107	6	6.0%
202106	4	4.0%
202105	8	8.0%
202103	6	6.0%
202102	2	2.0%
202101	3	3.0%
202012	2	2.0%
202011	2	2.0%

tco_btc_nm
Categorical

Distinct	4
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

백화점	28
편의점	25
할인점	24
슈퍼마켓	23

Length

Max length	4
Median length	3
Mean length	3.23
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	백화점
2nd row	슈퍼마켓
3rd row	슈퍼마켓
4th row	슈퍼마켓
5th row	편의점

Common Values

Value	Count	Frequency (%)
백화점	28	28.0%
편의점	25	25.0%
할인점	24	24.0%
슈퍼마켓	23	23.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
백화점	28	28.0%
편의점	25	25.0%
할인점	24	24.0%
슈퍼마켓	23	23.0%

ma_fem_dc
Categorical

Distinct	2
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

2	53
1	47

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

Common Values

Value	Count	Frequency (%)
2	53	53.0%
1	47	47.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	53	53.0%
1	47	47.0%

agegrp_dc
Real number (ℝ)

ZEROS

Distinct	10
Distinct (%)	10.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.5

Minimum	0
Maximum	90
Zeros	7
Zeros (%)	7.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	20
median	40
Q3	70
95-th percentile	90
Maximum	90
Range	90
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	29.176405
Coefficient of variation (CV)	0.62744958
Kurtosis	-1.2761346
Mean	46.5
Median Absolute Deviation (MAD)	30
Skewness	0.045722128
Sum	4650
Variance	851.26263
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
40	13	13.0%
90	13	13.0%
10	12	12.0%
30	11	11.0%
80	11	11.0%
20	9	9.0%
70	9	9.0%
50	8	8.0%
0	7	7.0%
60	7	7.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	7.0%
10	12	12.0%
20	9	9.0%
30	11	11.0%
40	13	13.0%
50	8	8.0%
60	7	7.0%
70	9	9.0%
80	11	11.0%
90	13	13.0%

Value	Count	Frequency (%)
90	13	13.0%
80	11	11.0%
70	9	9.0%
60	7	7.0%
50	8	8.0%
40	13	13.0%
30	11	11.0%
20	9	9.0%
10	12	12.0%
0	7	7.0%

tco_btc_u_ct
Real number (ℝ)

HIGH CORRELATION

Distinct	99
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	360648.88

Minimum	2
Maximum	1884227
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	2
5-th percentile	15.6
Q1	851
median	75142
Q3	722234.5
95-th percentile	1342931
Maximum	1884227
Range	1884225
Interquartile range (IQR)	721383.5

Descriptive statistics

Standard deviation	486558.64
Coefficient of variation (CV)	1.3491201
Kurtosis	0.68031441
Mean	360648.88
Median Absolute Deviation (MAD)	75057
Skewness	1.2821826
Sum	36064888
Variance	2.3673931 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7	2	2.0%
36341	1	1.0%
93700	1	1.0%
819043	1	1.0%
262888	1	1.0%
172	1	1.0%
126211	1	1.0%
892884	1	1.0%
304	1	1.0%
351	1	1.0%
Other values (89)	89	89.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	1.0%
3	1	1.0%
7	2	2.0%
8	1	1.0%
16	1	1.0%
20	1	1.0%
150	1	1.0%
172	1	1.0%
186	1	1.0%
227	1	1.0%

Value	Count	Frequency (%)
1884227	1	1.0%
1830950	1	1.0%
1509703	1	1.0%
1439825	1	1.0%
1425087	1	1.0%
1338607	1	1.0%
1233206	1	1.0%
1195632	1	1.0%
1172701	1	1.0%
1168581	1	1.0%

tco_btc_u_am
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	100
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2924248 × 10¹⁰

Minimum	64440
Maximum	1.1167907 × 10¹¹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	64440
5-th percentile	316966.5
Q1	29791869
median	3.0131374 × 10⁹
Q3	1.4503365 × 10¹⁰
95-th percentile	5.1153544 × 10¹⁰
Maximum	1.1167907 × 10¹¹
Range	1.11679 × 10¹¹
Interquartile range (IQR)	1.4473573 × 10¹⁰

Descriptive statistics

Standard deviation	2.2287654 × 10¹⁰
Coefficient of variation (CV)	1.7244837
Kurtosis	7.0715301
Mean	1.2924248 × 10¹⁰
Median Absolute Deviation (MAD)	3.0108511 × 10⁹
Skewness	2.5870553
Sum	1.2924248 × 10¹²
Variance	4.9673952 × 10²⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6281147892	1	1.0%
317680	1	1.0%
69380789624	1	1.0%
33293852352	1	1.0%
13416930	1	1.0%
13379343512	1	1.0%
6675718140	1	1.0%
17241830	1	1.0%
3281340	1	1.0%
1607607360	1	1.0%
Other values (90)	90	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
64440	1	1.0%
133840	1	1.0%
167350	1	1.0%
176980	1	1.0%
303410	1	1.0%
317680	1	1.0%
399360	1	1.0%
1080430	1	1.0%
2190940	1	1.0%
2381640	1	1.0%

Value	Count	Frequency (%)
111679066260	1	1.0%
96783919915	1	1.0%
94230612454	1	1.0%
84731099846	1	1.0%
69380789624	1	1.0%
50194215215	1	1.0%
46650621371	1	1.0%
45116007528	1	1.0%
43280162754	1	1.0%
42741951411	1	1.0%

Heatmap
Table

	crym	tco_btc_nm	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
crym	1.000	0.000	0.000	0.265	0.304	0.000
tco_btc_nm	0.000	1.000	0.000	0.125	0.000	0.319
ma_fem_dc	0.000	0.000	1.000	0.000	0.299	0.244
agegrp_dc	0.265	0.125	0.000	1.000	0.758	0.540
tco_btc_u_ct	0.304	0.000	0.299	0.758	1.000	0.727
tco_btc_u_am	0.000	0.319	0.244	0.540	0.727	1.000

Heatmap
Table

	tco_btc_nm	ma_fem_dc
tco_btc_nm	1.000	0.000
ma_fem_dc	0.000	1.000

Heatmap
Table

	crym	agegrp_dc	tco_btc_u_ct	tco_btc_u_am	tco_btc_nm	ma_fem_dc
crym	1.000	0.134	-0.076	-0.054	0.000	0.000
agegrp_dc	0.134	1.000	-0.013	0.039	0.066	0.000
tco_btc_u_ct	-0.076	-0.013	1.000	0.916	0.000	0.218
tco_btc_u_am	-0.054	0.039	0.916	1.000	0.201	0.236
tco_btc_nm	0.000	0.066	0.000	0.201	1.000	0.000
ma_fem_dc	0.000	0.000	0.218	0.236	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

	crym	tco_btc_nm	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
0	202109	백화점	1	20	36341	6281147892
1	201910	슈퍼마켓	2	0	20	399360
2	201911	슈퍼마켓	2	30	1091894	17577063590
3	202109	슈퍼마켓	2	30	718964	13244677283
4	202011	편의점	1	40	1509703	12172435983
5	202106	백화점	1	60	128408	14676678107
6	202106	할인점	2	50	860332	32532709185
7	202103	편의점	1	80	4771	39100330
8	202007	편의점	2	70	40799	328412874
9	201911	편의점	2	50	881914	5524067099

	crym	tco_btc_nm	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
90	202105	슈퍼마켓	2	40	1830950	36695974361
91	202105	할인점	2	10	301	13650710
92	202106	편의점	2	90	227	2190940
93	202011	편의점	1	20	524063	3413521507
94	202103	백화점	2	60	420424	50194215215
95	202107	할인점	2	80	15698	596912799
96	202102	슈퍼마켓	2	60	787012	17882074170
97	201904	할인점	1	50	395541	16461173760
98	202012	편의점	2	80	5321	46377120
99	201906	할인점	2	40	1168581	42741951411

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample