gimi9 Pandas Profiling

Dataset statistics

Number of variables	5
Number of observations	55
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.5 KiB
Average record size in memory	47.3 B

Variable types

Categorical	3
Numeric	2

Dataset

Description	샘플 데이터
Author	코리아크레딧뷰로 / 장윤상
URL	https://www.bigdata-transportation.kr/frn/prdt/detail?prdtId=PRDTNUM_000000020200

Alerts

`BS_YR_MON` has constant value ""	Constant
`GENDER` is highly imbalanced (77.5%)	Imbalance

Reproduction

Analysis started	2024-01-14 00:46:38.563124
Analysis finished	2024-01-14 00:46:40.620056
Duration	2.06 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

BS_YR_MON
Categorical

CONSTANT

Distinct	1
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Memory size	568.0 B

202112	55

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
202112	55	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
202112	55	100.0%

ADM_CD
Real number (ℝ)

Distinct	38
Distinct (%)	69.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40667044

Minimum	28260515
Maximum	41630250
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	623.0 B

Quantile statistics

Minimum	28260515
5-th percentile	37257774
Q1	41220256
median	41360545
Q3	41550315
95-th percentile	41610250
Maximum	41630250
Range	13369735
Interquartile range (IQR)	330059

Descriptive statistics

Standard deviation	3011628.9
Coefficient of variation (CV)	0.074055761
Kurtosis	14.710947
Mean	40667044
Median Absolute Deviation (MAD)	169715
Skewness	-4.0149115
Sum	2.2366874 × 10⁹
Variance	9.0699087 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
41610250	4	7.3%
41590259	3	5.5%
41590253	3	5.5%
41370540	2	3.6%
41360256	2	3.6%
41190795	2	3.6%
41461530	2	3.6%
41360545	2	3.6%
41190742	2	3.6%
41550250	2	3.6%
Other values (28)	31	56.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
28260515	1	1.8%
28260575	1	1.8%
28260730	1	1.8%
41113650	1	1.8%
41190742	2	3.6%
41190744	1	1.8%
41190795	2	3.6%
41190800	1	1.8%
41190830	2	3.6%
41220253	1	1.8%

Value	Count	Frequency (%)
41630250	1	1.8%
41610250	4	7.3%
41590262	1	1.8%
41590259	3	5.5%
41590253	3	5.5%
41570570	1	1.8%
41550380	1	1.8%
41550250	2	3.6%
41500515	1	1.8%
41500253	1	1.8%

GENDER
Categorical

IMBALANCE

Distinct	2
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Memory size	568.0 B

1	53
2	2

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

Common Values

Value	Count	Frequency (%)
1	53	96.4%
2	2	3.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	53	96.4%
2	2	3.6%

AGE_CD
Real number (ℝ)

Distinct	7
Distinct (%)	12.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.545455

Minimum	40
Maximum	70
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	623.0 B

Quantile statistics

Minimum	40
5-th percentile	45
Q1	47.5
median	55
Q3	60
95-th percentile	66.5
Maximum	70
Range	30
Interquartile range (IQR)	12.5

Descriptive statistics

Standard deviation	7.7143881
Coefficient of variation (CV)	0.14143045
Kurtosis	-0.65043159
Mean	54.545455
Median Absolute Deviation (MAD)	5
Skewness	0.063307377
Sum	3000
Variance	59.511785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
55	17	30.9%
45	12	21.8%
60	11	20.0%
65	5	9.1%
50	5	9.1%
70	3	5.5%
40	2	3.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40	2	3.6%
45	12	21.8%
50	5	9.1%
55	17	30.9%
60	11	20.0%
65	5	9.1%
70	3	5.5%

Value	Count	Frequency (%)
70	3	5.5%
65	5	9.1%
60	11	20.0%
55	17	30.9%
50	5	9.1%
45	12	21.8%
40	2	3.6%

POP_CNT
Categorical

Distinct	4
Distinct (%)	7.3%
Missing	0
Missing (%)	0.0%
Memory size	568.0 B

4	38
5	10
7	4
6	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
4	38	69.1%
5	10	18.2%
7	4	7.3%
6	3	5.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	38	69.1%
5	10	18.2%
7	4	7.3%
6	3	5.5%

ADM_CD
AGE_CD

AGE_CD
ADM_CD

AGE_CD
ADM_CD

Heatmap
Table

	ADM_CD	GENDER	AGE_CD	POP_CNT
ADM_CD	1.000	0.000	0.152	0.000
GENDER	0.000	1.000	0.013	0.000
AGE_CD	0.152	0.013	1.000	0.000
POP_CNT	0.000	0.000	0.000	1.000

Heatmap
Table

	GENDER	POP_CNT
GENDER	1.000	0.000
POP_CNT	0.000	1.000

Heatmap
Table

	ADM_CD	AGE_CD	GENDER	POP_CNT
ADM_CD	1.000	-0.108	0.000	0.205
AGE_CD	-0.108	1.000	0.000	0.000
GENDER	0.000	0.000	1.000	0.000
POP_CNT	0.205	0.000	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

	BS_YR_MON	ADM_CD	GENDER	AGE_CD	POP_CNT
0	202112	41590259	2	45	4
1	202112	41570570	1	45	4
2	202112	41190800	1	55	4
3	202112	41220630	1	45	4
4	202112	41590253	1	70	5
5	202112	41271600	1	65	4
6	202112	41360570	1	45	4
7	202112	41220256	1	50	4
8	202112	41461525	1	45	4
9	202112	41390597	1	55	4

	BS_YR_MON	ADM_CD	GENDER	AGE_CD	POP_CNT
45	202112	41590262	1	55	4
46	202112	41610250	1	60	4
47	202112	41220253	1	55	4
48	202112	41590259	1	45	7
49	202112	41190830	1	60	4
50	202112	28260575	1	45	4
51	202112	28260515	1	55	6
52	202112	41590253	1	45	4
53	202112	41190795	1	55	4
54	202112	41220635	1	60	4

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample