gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	5771
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	304.5 KiB
Average record size in memory	54.0 B

Variable types

Numeric	5
Categorical	1

Dataset

Description	순번,년도,차수,일차(1일차,2일차),분반번호,교육신청idx(tb_edu_join테이블)
Author	서울특별시
URL	https://data.seoul.go.kr/dataList/OA-15707/S/1/datasetView.do

Alerts

`년도` is highly overall correlated with `차수` and 1 other fields	High correlation
`차수` is highly overall correlated with `년도` and 1 other fields	High correlation
`교육신청idx(tb_edu_join테이블)` is highly overall correlated with `년도` and 1 other fields	High correlation
`순번` has unique values	Unique

Reproduction

Analysis started	2024-05-11 06:08:43.744790
Analysis finished	2024-05-11 06:08:49.158937
Duration	5.41 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

순번
Real number (ℝ)

UNIQUE

Distinct	5771
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4579.7881

Minimum	21
Maximum	9996
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	21
5-th percentile	484.5
Q1	2489.5
median	4506
Q3	6631.5
95-th percentile	8740.5
Maximum	9996
Range	9975
Interquartile range (IQR)	4142

Descriptive statistics

Standard deviation	2528.6176
Coefficient of variation (CV)	0.55212546
Kurtosis	-0.92790599
Mean	4579.7881
Median Absolute Deviation (MAD)	2090
Skewness	0.05748183
Sum	26429957
Variance	6393906.9
Monotonicity	Strictly decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9996	1	< 0.1%
3279	1	< 0.1%
3281	1	< 0.1%
3282	1	< 0.1%
3283	1	< 0.1%
3284	1	< 0.1%
3285	1	< 0.1%
3286	1	< 0.1%
3287	1	< 0.1%
3288	1	< 0.1%
Other values (5761)	5761	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
21	1	< 0.1%
42	1	< 0.1%
43	1	< 0.1%
44	1	< 0.1%
45	1	< 0.1%
46	1	< 0.1%
47	1	< 0.1%
48	1	< 0.1%
49	1	< 0.1%
50	1	< 0.1%

Value	Count	Frequency (%)
9996	1	< 0.1%
9987	1	< 0.1%
9971	1	< 0.1%
9959	1	< 0.1%
9945	1	< 0.1%
9943	1	< 0.1%
9933	1	< 0.1%
9920	1	< 0.1%
9900	1	< 0.1%
9897	1	< 0.1%

년도
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2018.6862

Minimum	2017
Maximum	2024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	2017
5-th percentile	2017
Q1	2018
median	2019
Q3	2019
95-th percentile	2021
Maximum	2024
Range	7
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.2780434
Coefficient of variation (CV)	0.00063310654
Kurtosis	-0.54169604
Mean	2018.6862
Median Absolute Deviation (MAD)	1
Skewness	0.55444282
Sum	11649838
Variance	1.633395
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2018	1838	31.8%
2019	1670	28.9%
2017	1047	18.1%
2021	893	15.5%
2020	320	5.5%
2024	3	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2017	1047	18.1%
2018	1838	31.8%
2019	1670	28.9%
2020	320	5.5%
2021	893	15.5%
2024	3	0.1%

Value	Count	Frequency (%)
2024	3	0.1%
2021	893	15.5%
2020	320	5.5%
2019	1670	28.9%
2018	1838	31.8%
2017	1047	18.1%

차수
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.3671807

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	10
95-th percentile	13
Maximum	13
Range	12
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	4.1810612
Coefficient of variation (CV)	0.77900511
Kurtosis	-1.1600698
Mean	5.3671807
Median Absolute Deviation (MAD)	2
Skewness	0.62422121
Sum	30974
Variance	17.481273
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	1165	20.2%
3	946	16.4%
2	780	13.5%
11	675	11.7%
4	587	10.2%
13	510	8.8%
10	416	7.2%
6	309	5.4%
7	276	4.8%
9	54	0.9%
Other values (2)	53	0.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1165	20.2%
2	780	13.5%
3	946	16.4%
4	587	10.2%
6	309	5.4%
7	276	4.8%
8	15	0.3%
9	54	0.9%
10	416	7.2%
11	675	11.7%

Value	Count	Frequency (%)
13	510	8.8%
12	38	0.7%
11	675	11.7%
10	416	7.2%
9	54	0.9%
8	15	0.3%
7	276	4.8%
6	309	5.4%
4	587	10.2%
3	946	16.4%

일차(1일차,2일차)
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	45.2 KiB

1	2978
2	2793

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

Common Values

Value	Count	Frequency (%)
1	2978	51.6%
2	2793	48.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	2978	51.6%
2	2793	48.4%

분반번호
Real number (ℝ)

Distinct	20
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.9199446

Minimum	1
Maximum	20
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	5
Q3	8
95-th percentile	14
Maximum	20
Range	19
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	4.0944866
Coefficient of variation (CV)	0.69164273
Kurtosis	0.70964612
Mean	5.9199446
Median Absolute Deviation (MAD)	3
Skewness	1.0273737
Sum	34164
Variance	16.764821
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
3	656	11.4%
1	655	11.3%
4	640	11.1%
2	626	10.8%
6	542	9.4%
5	540	9.4%
7	464	8.0%
8	422	7.3%
11	240	4.2%
12	207	3.6%
Other values (10)	779	13.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	655	11.3%
2	626	10.8%
3	656	11.4%
4	640	11.1%
5	540	9.4%
6	542	9.4%
7	464	8.0%
8	422	7.3%
9	177	3.1%
10	156	2.7%

Value	Count	Frequency (%)
20	27	0.5%
19	27	0.5%
18	41	0.7%
17	38	0.7%
16	50	0.9%
15	69	1.2%
14	82	1.4%
13	112	1.9%
12	207	3.6%
11	240	4.2%

교육신청idx(tb_edu_join테이블)
Real number (ℝ)

HIGH CORRELATION

Distinct	3266
Distinct (%)	56.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3070.1814

Minimum	2
Maximum	6229
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	50.9 KiB

Quantile statistics

Minimum	2
5-th percentile	329
Q1	1876
median	3064
Q3	4335
95-th percentile	5474
Maximum	6229
Range	6227
Interquartile range (IQR)	2459

Descriptive statistics

Standard deviation	1556.7977
Coefficient of variation (CV)	0.50707027
Kurtosis	-0.95328421
Mean	3070.1814
Median Absolute Deviation (MAD)	1218
Skewness	-0.093126159
Sum	17718017
Variance	2423619.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1819	2	< 0.1%
3326	2	< 0.1%
3393	2	< 0.1%
3392	2	< 0.1%
3366	2	< 0.1%
3278	2	< 0.1%
3276	2	< 0.1%
3337	2	< 0.1%
3318	2	< 0.1%
3313	2	< 0.1%
Other values (3256)	5751	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	2	< 0.1%
3	1	< 0.1%
4	2	< 0.1%
5	1	< 0.1%
7	1	< 0.1%
9	1	< 0.1%
10	2	< 0.1%
11	2	< 0.1%
12	1	< 0.1%
14	1	< 0.1%

Value	Count	Frequency (%)
6229	1	< 0.1%
6175	1	< 0.1%
6107	1	< 0.1%
5638	2	< 0.1%
5637	2	< 0.1%
5636	2	< 0.1%
5634	2	< 0.1%
5633	2	< 0.1%
5632	1	< 0.1%
5631	2	< 0.1%

Phik (φk)
Auto

Heatmap
Table

	순번	년도	차수	일차(1일차,2일차)	분반번호	교육신청idx(tb_edu_join테이블)
순번	1.000	0.952	0.753	0.139	0.596	0.932
년도	0.952	1.000	0.740	0.000	0.525	0.864
차수	0.753	0.740	1.000	0.000	0.468	0.766
일차(1일차,2일차)	0.139	0.000	0.000	1.000	0.000	0.049
분반번호	0.596	0.525	0.468	0.000	1.000	0.615
교육신청idx(tb_edu_join테이블)	0.932	0.864	0.766	0.049	0.615	1.000

Heatmap
Table

	순번	년도	차수	분반번호	교육신청idx(tb_edu_join테이블)	일차(1일차,2일차)
순번	1.000	0.395	0.213	0.079	0.401	0.107
년도	0.395	1.000	0.572	0.010	0.966	0.000
차수	0.213	0.572	1.000	0.141	0.687	0.000
분반번호	0.079	0.010	0.141	1.000	0.069	0.000
교육신청idx(tb_edu_join테이블)	0.401	0.966	0.687	0.069	1.000	0.038
일차(1일차,2일차)	0.107	0.000	0.000	0.000	0.038	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

	순번	년도	차수	일차(1일차,2일차)	분반번호	교육신청idx(tb_edu_join테이블)
0	9996	2018	1	2	4	1819
1	9987	2018	1	2	4	1821
2	9971	2018	1	2	4	1783
3	9959	2018	1	2	4	1686
4	9945	2018	1	2	4	1818
5	9943	2018	1	2	4	1820
6	9933	2018	1	2	4	1589
7	9920	2018	1	2	4	1796
8	9900	2018	1	2	4	1744
9	9897	2018	1	2	4	1579

	순번	년도	차수	일차(1일차,2일차)	분반번호	교육신청idx(tb_edu_join테이블)
5761	50	2017	1	1	11	872
5762	49	2017	1	1	11	254
5763	48	2017	1	1	11	341
5764	47	2017	1	1	11	314
5765	46	2017	1	1	11	323
5766	45	2017	1	1	11	329
5767	44	2017	1	1	11	268
5768	43	2017	1	1	11	331
5769	42	2017	1	1	11	166
5770	21	2018	1	2	4	1592

Overview

Variables

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample