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_000000020070

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 6 (6.0%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 22:34:06.298829
Analysis finished	2023-12-11 22:34:08.207300
Duration	1.91 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

crym
Real number (ℝ)

Distinct	31
Distinct (%)	31.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	202007.68

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	201901.95
Q1	201908.75
median	202008
Q3	202103
95-th percentile	202108.05
Maximum	202109
Range	208
Interquartile range (IQR)	194.25

Descriptive statistics

Standard deviation	81.430751
Coefficient of variation (CV)	0.00040310721
Kurtosis	-1.4930435
Mean	202007.68
Median Absolute Deviation (MAD)	96
Skewness	-0.051918613
Sum	20200768
Variance	6630.9673
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
202104	6	6.0%
202001	6	6.0%
202004	6	6.0%
202109	5	5.0%
201901	5	5.0%
201908	5	5.0%
202102	5	5.0%
202009	5	5.0%
202103	4	4.0%
201903	4	4.0%
Other values (21)	49	49.0%

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
202109	5	5.0%
202108	3	3.0%
202107	2	2.0%
202106	4	4.0%
202105	3	3.0%
202104	6	6.0%
202103	4	4.0%
202102	5	5.0%
202101	2	2.0%
202012	4	4.0%

tco_btc_nm
Categorical

Distinct	6
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Memory size	932.0 B

양식	19
한식	18
패스트푸드점	16
중식	16
일식	16

Length

Max length	7
Median length	2
Mean length	3.39
Min length	2

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	한식
2nd row	한식
3rd row	패스트푸드점
4th row	중식
5th row	패밀리레스토랑

Common Values

Value	Count	Frequency (%)
양식	19	19.0%
한식	18	18.0%
패스트푸드점	16	16.0%
중식	16	16.0%
일식	16	16.0%
패밀리레스토랑	15	15.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
양식	19	19.0%
한식	18	18.0%
패스트푸드점	16	16.0%
중식	16	16.0%
일식	16	16.0%
패밀리레스토랑	15	15.0%

ma_fem_dc
Categorical

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

2	55
1	45

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

Common Values

Value	Count	Frequency (%)
2	55	55.0%
1	45	45.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2	55	55.0%
1	45	45.0%

agegrp_dc
Real number (ℝ)

ZEROS

Distinct	11
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48.01

Minimum	0
Maximum	90
Zeros	6
Zeros (%)	6.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

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

Descriptive statistics

Standard deviation	28.833375
Coefficient of variation (CV)	0.6005702
Kurtosis	-1.2077581
Mean	48.01
Median Absolute Deviation (MAD)	25
Skewness	-0.0053748641
Sum	4801
Variance	831.36354
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
90	16	16.0%
20	12	12.0%
50	12	12.0%
30	11	11.0%
60	10	10.0%
70	9	9.0%
40	8	8.0%
10	8	8.0%
80	7	7.0%
0	6	6.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	6.0%
1	1	1.0%
10	8	8.0%
20	12	12.0%
30	11	11.0%
40	8	8.0%
50	12	12.0%
60	10	10.0%
70	9	9.0%
80	7	7.0%

Value	Count	Frequency (%)
90	16	16.0%
80	7	7.0%
70	9	9.0%
60	10	10.0%
50	12	12.0%
40	8	8.0%
30	11	11.0%
20	12	12.0%
10	8	8.0%
1	1	1.0%

tco_btc_u_ct
Real number (ℝ)

HIGH CORRELATION

Distinct	94
Distinct (%)	94.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	67453.52

Minimum	1
Maximum	1060537
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	1
5-th percentile	3.95
Q1	133
median	10890.5
Q3	51715.5
95-th percentile	291021.55
Maximum	1060537
Range	1060536
Interquartile range (IQR)	51582.5

Descriptive statistics

Standard deviation	179356.67
Coefficient of variation (CV)	2.6589669
Kurtosis	17.395881
Mean	67453.52
Median Absolute Deviation (MAD)	10871
Skewness	4.1319748
Sum	6745352
Variance	3.2168817 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	3	3.0%
8	2	2.0%
4	2	2.0%
1	2	2.0%
79	2	2.0%
246	1	1.0%
25905	1	1.0%
990	1	1.0%
63	1	1.0%
75928	1	1.0%
Other values (84)	84	84.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	2.0%
3	3	3.0%
4	2	2.0%
5	1	1.0%
6	1	1.0%
8	2	2.0%
9	1	1.0%
18	1	1.0%
21	1	1.0%
28	1	1.0%

Value	Count	Frequency (%)
1060537	1	1.0%
941663	1	1.0%
750012	1	1.0%
652516	1	1.0%
601929	1	1.0%
274658	1	1.0%
166331	1	1.0%
155229	1	1.0%
127654	1	1.0%
123638	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	2.0653704 × 10⁹

Minimum	11300
Maximum	3.5095694 × 10¹⁰
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.0 KiB

Quantile statistics

Minimum	11300
5-th percentile	87101.5
Q1	4422896.2
median	2.8802816 × 10⁸
Q3	1.1443574 × 10⁹
95-th percentile	1.0477941 × 10¹⁰
Maximum	3.5095694 × 10¹⁰
Range	3.5095683 × 10¹⁰
Interquartile range (IQR)	1.1399345 × 10⁹

Descriptive statistics

Standard deviation	6.163912 × 10⁹
Coefficient of variation (CV)	2.9844099
Kurtosis	18.152536
Mean	2.0653704 × 10⁹
Median Absolute Deviation (MAD)	2.8766618 × 10⁸
Skewness	4.2640165
Sum	2.0653704 × 10¹¹
Variance	3.7993811 × 10¹⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10569700	1	1.0%
461281060	1	1.0%
32431865	1	1.0%
1710940	1	1.0%
2389736689	1	1.0%
1757686619	1	1.0%
388670	1	1.0%
2814924708	1	1.0%
62649448	1	1.0%
346393052	1	1.0%
Other values (90)	90	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11300	1	1.0%
11900	1	1.0%
18300	1	1.0%
54700	1	1.0%
57300	1	1.0%
88670	1	1.0%
121000	1	1.0%
136000	1	1.0%
267510	1	1.0%
322000	1	1.0%

Value	Count	Frequency (%)
35095694329	1	1.0%
34290593671	1	1.0%
25710094140	1	1.0%
21547254530	1	1.0%
20958438518	1	1.0%
9926335563	1	1.0%
5337501031	1	1.0%
3540284474	1	1.0%
2814924708	1	1.0%
2468140521	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.225	0.173	0.000	0.000	0.212
tco_btc_nm	0.225	1.000	0.296	0.168	0.227	0.139
ma_fem_dc	0.173	0.296	1.000	0.000	0.136	0.000
agegrp_dc	0.000	0.168	0.000	1.000	0.363	0.312
tco_btc_u_ct	0.000	0.227	0.136	0.363	1.000	0.973
tco_btc_u_am	0.212	0.139	0.000	0.312	0.973	1.000

Heatmap
Table

	ma_fem_dc	tco_btc_nm
ma_fem_dc	1.000	0.207
tco_btc_nm	0.207	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.226	0.092	0.088	0.123	0.109
agegrp_dc	-0.226	1.000	-0.199	-0.170	0.081	0.000
tco_btc_u_ct	0.092	-0.199	1.000	0.973	0.124	0.096
tco_btc_u_am	0.088	-0.170	0.973	1.000	0.083	0.000
tco_btc_nm	0.123	0.081	0.124	0.083	1.000	0.207
ma_fem_dc	0.109	0.000	0.096	0.000	0.207	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	202011	한식	2	90	246	10569700
1	202107	한식	1	40	750012	25710094140
2	201909	패스트푸드점	2	0	3	18300
3	202012	중식	2	20	17873	406857103
4	201904	패밀리레스토랑	2	40	21435	616699189
5	201906	한식	2	70	63915	2333739304
6	201906	패밀리레스토랑	2	90	6	267510
7	202106	패밀리레스토랑	1	70	588	16440541
8	202105	패스트푸드점	1	30	127654	1129891501
9	202004	패스트푸드점	1	50	79002	733793500

	crym	tco_btc_nm	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
90	201903	한식	1	10	1660	47893260
91	202102	패스트푸드점	2	30	105852	977222517
92	201907	일식	2	90	38	1476800
93	201901	한식	2	10	1960	52190270
94	202009	중식	2	70	6534	159002901
95	202003	일식	2	50	41874	1613375817
96	202105	일식	1	60	17227	910181493
97	201901	패밀리레스토랑	2	80	101	3313215
98	202102	양식	2	20	18377	608221948
99	201906	양식	2	50	50678	1500078742

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample