gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	48
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.6 KiB
Average record size in memory	55.8 B

Variable types

Numeric	5
Categorical	1

Dataset

Description	부산교통공사_열차운행실적_20211231
Author	부산교통공사
URL	http://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3057438

Alerts

`계획(횟수)` is highly overall correlated with `실적(횟수)` and 3 other fields	High correlation
`실적(횟수)` is highly overall correlated with `계획(횟수)` and 3 other fields	High correlation
`계획(운행거리Km)` is highly overall correlated with `계획(횟수)` and 3 other fields	High correlation
`실적(운행거리Km)` is highly overall correlated with `계획(횟수)` and 3 other fields	High correlation
`호선별` is highly overall correlated with `계획(횟수)` and 3 other fields	High correlation

Reproduction

Analysis started	2023-12-10 16:15:19.185519
Analysis finished	2023-12-10 16:15:22.471999
Duration	3.29 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

월별
Real number (ℝ)

Distinct	12
Distinct (%)	25.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.5

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	564.0 B

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3.75
median	6.5
Q3	9.25
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5.5

Descriptive statistics

Standard deviation	3.4885832
Coefficient of variation (CV)	0.53670511
Kurtosis	-1.2175129
Mean	6.5
Median Absolute Deviation (MAD)	3
Skewness	0
Sum	312
Variance	12.170213
Monotonicity	Increasing

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	4	8.3%
2	4	8.3%
3	4	8.3%
4	4	8.3%
5	4	8.3%
6	4	8.3%
7	4	8.3%
8	4	8.3%
9	4	8.3%
10	4	8.3%
Other values (2)	8	16.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4	8.3%
2	4	8.3%
3	4	8.3%
4	4	8.3%
5	4	8.3%
6	4	8.3%
7	4	8.3%
8	4	8.3%
9	4	8.3%
10	4	8.3%

Value	Count	Frequency (%)
12	4	8.3%
11	4	8.3%
10	4	8.3%
9	4	8.3%
8	4	8.3%
7	4	8.3%
6	4	8.3%
5	4	8.3%
4	4	8.3%
3	4	8.3%

호선별
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	8.3%
Missing	0
Missing (%)	0.0%
Memory size	516.0 B

1호선	12
2호선	12
3호선	12
4호선	12

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

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

Common Values

Value	Count	Frequency (%)
1호선	12	25.0%
2호선	12	25.0%
3호선	12	25.0%
4호선	12	25.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1호선	12	25.0%
2호선	12	25.0%
3호선	12	25.0%
4호선	12	25.0%

계획(횟수)
Real number (ℝ)

HIGH CORRELATION

Distinct	40
Distinct (%)	83.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9949.2708

Minimum	8348
Maximum	11144
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	564.0 B

Quantile statistics

Minimum	8348
5-th percentile	8971.7
Q1	9373.5
median	9653
Q3	10692
95-th percentile	11097.8
Maximum	11144
Range	2796
Interquartile range (IQR)	1318.5

Descriptive statistics

Standard deviation	775.53638
Coefficient of variation (CV)	0.077949067
Kurtosis	-1.2792745
Mean	9949.2708
Median Absolute Deviation (MAD)	642
Skewness	0.017209883
Sum	477565
Variance	601456.67
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
9116	3	6.2%
9376	3	6.2%
10400	3	6.2%
10812	3	6.2%
10967	1	2.1%
9382	1	2.1%
10486	1	2.1%
9450	1	2.1%
9188	1	2.1%
10578	1	2.1%
Other values (30)	30	62.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8348	1	2.1%
8582	1	2.1%
8894	1	2.1%
9116	3	6.2%
9142	1	2.1%
9184	1	2.1%
9188	1	2.1%
9228	1	2.1%
9316	1	2.1%
9366	1	2.1%

Value	Count	Frequency (%)
11144	1	2.1%
11129	1	2.1%
11123	1	2.1%
11051	1	2.1%
10967	1	2.1%
10934	1	2.1%
10922	1	2.1%
10812	3	6.2%
10708	1	2.1%
10704	1	2.1%

실적(횟수)
Real number (ℝ)

HIGH CORRELATION

Distinct	40
Distinct (%)	83.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9948.9583

Minimum	8348
Maximum	11144
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	564.0 B

Quantile statistics

Minimum	8348
5-th percentile	8971.7
Q1	9373.5
median	9653
Q3	10692
95-th percentile	11097.8
Maximum	11144
Range	2796
Interquartile range (IQR)	1318.5

Descriptive statistics

Standard deviation	775.13406
Coefficient of variation (CV)	0.077911077
Kurtosis	-1.279003
Mean	9948.9583
Median Absolute Deviation (MAD)	642
Skewness	0.016450093
Sum	477550
Variance	600832.81
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
9116	3	6.2%
9376	3	6.2%
10400	3	6.2%
10812	3	6.2%
10967	1	2.1%
9382	1	2.1%
10486	1	2.1%
9450	1	2.1%
9188	1	2.1%
10578	1	2.1%
Other values (30)	30	62.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8348	1	2.1%
8582	1	2.1%
8894	1	2.1%
9116	3	6.2%
9142	1	2.1%
9184	1	2.1%
9188	1	2.1%
9228	1	2.1%
9316	1	2.1%
9366	1	2.1%

Value	Count	Frequency (%)
11144	1	2.1%
11129	1	2.1%
11123	1	2.1%
11051	1	2.1%
10967	1	2.1%
10922	1	2.1%
10919	1	2.1%
10812	3	6.2%
10708	1	2.1%
10704	1	2.1%

계획(운행거리Km)
Real number (ℝ)

HIGH CORRELATION

Distinct	40
Distinct (%)	83.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	285355.84

Minimum	100176
Maximum	456143.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	564.0 B

Quantile statistics

Minimum	100176
5-th percentile	109392
Q1	144682.65
median	278608.6
Q3	428888.8
95-th percentile	453833.76
Maximum	456143.8
Range	355967.8
Interquartile range (IQR)	284206.15

Descriptive statistics

Standard deviation	149225.86
Coefficient of variation (CV)	0.52294656
Kurtosis	-1.9659764
Mean	285355.84
Median Absolute Deviation (MAD)	150439.8
Skewness	-0.042359462
Sum	13697080
Variance	2.2268356 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
109392.0	3	6.2%
169705.6	3	6.2%
442876.4	3	6.2%
416525.6	3	6.2%
422499.0	1	2.1%
112584.0	1	2.1%
446549.4	1	2.1%
171045.0	1	2.1%
110256.0	1	2.1%
407539.4	1	2.1%
Other values (30)	30	62.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100176.0	1	2.1%
106728.0	1	2.1%
109392.0	3	6.2%
110208.0	1	2.1%
110256.0	1	2.1%
110736.0	1	2.1%
111792.0	1	2.1%
112392.0	1	2.1%
112584.0	1	2.1%
112728.0	1	2.1%

Value	Count	Frequency (%)
456143.8	1	2.1%
455934.2	1	2.1%
454929.4	1	2.1%
451799.0	1	2.1%
448205.4	1	2.1%
446549.4	1	2.1%
445499.8	1	2.1%
442876.4	3	6.2%
431733.2	1	2.1%
429367.6	1	2.1%

실적(운행거리Km)
Real number (ℝ)

HIGH CORRELATION

Distinct	40
Distinct (%)	83.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	285347.59

Minimum	100176
Maximum	456143.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	564.0 B

Quantile statistics

Minimum	100176
5-th percentile	109392
Q1	144682.65
median	278608.6
Q3	428888.8
95-th percentile	453833.76
Maximum	456143.8
Range	355967.8
Interquartile range (IQR)	284206.15

Descriptive statistics

Standard deviation	149218.2
Coefficient of variation (CV)	0.52293485
Kurtosis	-1.9659254
Mean	285347.59
Median Absolute Deviation (MAD)	150439.8
Skewness	-0.042338763
Sum	13696684
Variance	2.2266071 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=40)

Value	Count	Frequency (%)
109392.0	3	6.2%
169705.6	3	6.2%
442876.4	3	6.2%
416525.6	3	6.2%
422499.0	1	2.1%
112584.0	1	2.1%
446549.4	1	2.1%
171045.0	1	2.1%
110256.0	1	2.1%
407539.4	1	2.1%
Other values (30)	30	62.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
100176.0	1	2.1%
106728.0	1	2.1%
109392.0	3	6.2%
110208.0	1	2.1%
110256.0	1	2.1%
110736.0	1	2.1%
111792.0	1	2.1%
112392.0	1	2.1%
112584.0	1	2.1%
112728.0	1	2.1%

Value	Count	Frequency (%)
456143.8	1	2.1%
455934.2	1	2.1%
454929.4	1	2.1%
451799.0	1	2.1%
448205.4	1	2.1%
446549.4	1	2.1%
445499.8	1	2.1%
442876.4	3	6.2%
431733.2	1	2.1%
429367.6	1	2.1%

Phik (φk)
Auto

Heatmap
Table

	월별	호선별	계획(횟수)	실적(횟수)	계획(운행거리Km)	실적(운행거리Km)
월별	1.000	0.000	0.000	0.000	0.000	0.000
호선별	0.000	1.000	0.862	0.862	0.932	0.932
계획(횟수)	0.000	0.862	1.000	1.000	0.893	0.893
실적(횟수)	0.000	0.862	1.000	1.000	0.893	0.893
계획(운행거리Km)	0.000	0.932	0.893	0.893	1.000	1.000
실적(운행거리Km)	0.000	0.932	0.893	0.893	1.000	1.000

Heatmap
Table

	월별	계획(횟수)	실적(횟수)	계획(운행거리Km)	실적(운행거리Km)	호선별
월별	1.000	0.037	0.038	0.022	0.023	0.000
계획(횟수)	0.037	1.000	1.000	0.848	0.848	0.650
실적(횟수)	0.038	1.000	1.000	0.848	0.848	0.650
계획(운행거리Km)	0.022	0.848	0.848	1.000	1.000	0.808
실적(운행거리Km)	0.023	0.848	0.848	1.000	1.000	0.808
호선별	0.000	0.650	0.650	0.808	0.808	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

	월별	호선별	계획(횟수)	실적(횟수)	계획(운행거리Km)	실적(운행거리Km)
0	1	1호선	10967	10967	422499.0	422499.0
1	1	2호선	10518	10518	448205.4	448205.4
2	1	3호선	9484	9484	171660.4	171660.4
3	1	4호선	9228	9228	110736.0	110736.0
4	2	1호선	9923	9923	382371.2	382371.2
5	2	2호선	9500	9500	404890.4	404890.4
6	2	3호선	8582	8582	155334.2	155334.2
7	2	4호선	8348	8348	100176.0	100176.0
8	3	1호선	11144	11144	429367.6	429367.6
9	3	2호선	10708	10708	456143.8	456143.8

	월별	호선별	계획(횟수)	실적(횟수)	계획(운행거리Km)	실적(운행거리Km)
38	10	3호선	9438	9438	170827.8	170827.8
39	10	4호선	9184	9184	110208.0	110208.0
40	11	1호선	10812	10812	416525.6	416525.6
41	11	2호선	10400	10400	442876.4	442876.4
42	11	3호선	9376	9376	169705.6	169705.6
43	11	4호선	9116	9116	109392.0	109392.0
44	12	1호선	11123	11123	428452.8	428452.8
45	12	2호선	10688	10688	454929.4	454929.4
46	12	3호선	9638	9638	174447.8	174447.8
47	12	4호선	9366	9366	112392.0	112392.0

Overview

Variables

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample