gimi9 Pandas Profiling

Dataset statistics

Number of variables	5
Number of observations	100
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.5 KiB
Average record size in memory	46.3 B

Variable types

Numeric	4
Categorical	1

Dataset

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

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 12 (12.0%) zeros	Zeros

Reproduction

Analysis started	2023-12-11 22:41:40.161506
Analysis finished	2023-12-11 22:41:41.789451
Duration	1.63 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	201998.42

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	201902
Q1	201908
median	202007.5
Q3	202103
95-th percentile	202108
Maximum	202109
Range	208
Interquartile range (IQR)	195

Descriptive statistics

Standard deviation	83.497315
Coefficient of variation (CV)	0.00041335628
Kurtosis	-1.5645484
Mean	201998.42
Median Absolute Deviation (MAD)	97.5
Skewness	0.1299651
Sum	20199842
Variance	6971.8016
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
201902	6	6.0%
202105	6	6.0%
202107	6	6.0%
202011	6	6.0%
202009	5	5.0%
201901	4	4.0%
201907	4	4.0%
201912	4	4.0%
202109	4	4.0%
202004	4	4.0%
Other values (21)	51	51.0%

Minimum 10 values
Maximum 10 values

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

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

ma_fem_dc
Categorical

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

1	60
2	40

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

Common Values

Value	Count	Frequency (%)
1	60	60.0%
2	40	40.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	60	60.0%
2	40	40.0%

agegrp_dc
Real number (ℝ)

ZEROS

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

Minimum	0
Maximum	90
Zeros	12
Zeros (%)	12.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	28.760769
Coefficient of variation (CV)	0.64341765
Kurtosis	-1.0980177
Mean	44.7
Median Absolute Deviation (MAD)	20
Skewness	0.017310278
Sum	4470
Variance	827.18182
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

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

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
90	12	12.0%
80	7	7.0%
70	7	7.0%
60	13	13.0%
50	10	10.0%
40	13	13.0%
30	9	9.0%
20	10	10.0%
10	7	7.0%
0	12	12.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	1050407.6

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

Quantile statistics

Minimum	2
5-th percentile	35.8
Q1	2536.5
median	362676.5
Q3	1341416
95-th percentile	4385880.5
Maximum	6824744
Range	6824742
Interquartile range (IQR)	1338879.5

Descriptive statistics

Standard deviation	1591688.7
Coefficient of variation (CV)	1.5153058
Kurtosis	3.1891536
Mean	1050407.6
Median Absolute Deviation (MAD)	362472.5
Skewness	1.8947252
Sum	1.0504076 × 10⁸
Variance	2.5334729 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
75	2	2.0%
1950	1	1.0%
3288635	1	1.0%
399947	1	1.0%
495862	1	1.0%
10	1	1.0%
2881	1	1.0%
7630	1	1.0%
514444	1	1.0%
77017	1	1.0%
Other values (89)	89	89.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	1	1.0%
5	1	1.0%
7	1	1.0%
10	1	1.0%
32	1	1.0%
36	1	1.0%
39	1	1.0%
52	1	1.0%
56	1	1.0%
75	2	2.0%

Value	Count	Frequency (%)
6824744	1	1.0%
6515961	1	1.0%
6413439	1	1.0%
4823882	1	1.0%
4629147	1	1.0%
4373077	1	1.0%
4324272	1	1.0%
3977839	1	1.0%
3741927	1	1.0%
3436817	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	5.391152 × 10¹⁰

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

Quantile statistics

Minimum	134420
5-th percentile	858614.8
Q1	99966451
median	1.7154884 × 10¹⁰
Q3	8.070696 × 10¹⁰
95-th percentile	1.8670306 × 10¹¹
Maximum	3.0658159 × 10¹¹
Range	3.0658145 × 10¹¹
Interquartile range (IQR)	8.0606994 × 10¹⁰

Descriptive statistics

Standard deviation	7.5096471 × 10¹⁰
Coefficient of variation (CV)	1.3929578
Kurtosis	1.8836034
Mean	5.391152 × 10¹⁰
Median Absolute Deviation (MAD)	1.7152305 × 10¹⁰
Skewness	1.5778068
Sum	5.391152 × 10¹²
Variance	5.63948 × 10²¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85255299	1	1.0%
55418298661	1	1.0%
2424308	1	1.0%
26037727618	1	1.0%
38907814418	1	1.0%
653687	1	1.0%
122172678	1	1.0%
684575123	1	1.0%
36809748521	1	1.0%
6913349946	1	1.0%
Other values (90)	90	90.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
134420	1	1.0%
202300	1	1.0%
260714	1	1.0%
653687	1	1.0%
672715	1	1.0%
868399	1	1.0%
1744250	1	1.0%
1841611	1	1.0%
2391543	1	1.0%
2424308	1	1.0%

Value	Count	Frequency (%)
306581586287	1	1.0%
296217479689	1	1.0%
293329937600	1	1.0%
226246742522	1	1.0%
191103848741	1	1.0%
186471436938	1	1.0%
183035285353	1	1.0%
182160963990	1	1.0%
181360535814	1	1.0%
179767736210	1	1.0%

Phik (φk)
Auto

Heatmap
Table

	crym	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
crym	1.000	0.000	0.128	0.343	0.090
ma_fem_dc	0.000	1.000	0.087	0.496	0.497
agegrp_dc	0.128	0.087	1.000	0.673	0.628
tco_btc_u_ct	0.343	0.496	0.673	1.000	0.982
tco_btc_u_am	0.090	0.497	0.628	0.982	1.000

Heatmap
Table

	crym	agegrp_dc	tco_btc_u_ct	tco_btc_u_am	ma_fem_dc
crym	1.000	-0.105	0.129	0.136	0.000
agegrp_dc	-0.105	1.000	-0.011	0.013	0.056
tco_btc_u_ct	0.129	-0.011	1.000	0.997	0.479
tco_btc_u_am	0.136	0.013	0.997	1.000	0.482
ma_fem_dc	0.000	0.056	0.479	0.482	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	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
0	201902	1	10	1950	85255299
1	202004	2	40	4823882	226246742522
2	202107	1	20	667457	28904188009
3	201904	1	40	1467043	93846566877
4	202105	1	50	1292924	74427492918
5	202107	2	90	654	39648586
6	202105	2	40	6515961	296217479689
7	201909	1	90	313	27807810
8	202011	2	30	4373077	182160963990
9	201905	1	90	237	20436506

	crym	ma_fem_dc	agegrp_dc	tco_btc_u_ct	tco_btc_u_am
90	202104	1	80	12406	1062629111
91	202107	1	50	1331204	76327091119
92	202105	2	10	3125	137687550
93	201909	1	50	698251	45503274038
94	201903	2	0	2	202300
95	202108	1	60	420124	27813345411
96	202107	1	30	2289600	118766762952
97	202011	1	0	36	1744250
98	201905	2	70	81270	6766456864
99	202002	1	90	334	28809510

Overview

Variables

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample