gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	155
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	8.0 KiB
Average record size in memory	52.9 B

Variable types

Numeric	4
Categorical	2

Dataset

Description	2011~2023년까지 송암미술관 월별 이용객 수를 제공합니다.* 매주 월요일, 공휴일 다음날은 휴관일입니다.* 2020년에 153일 임시휴관을 하였고, 1개의 프로그램을 제외한 모든 교육프로그램이 온라인으로 진행되었습니다.
Author	인천광역시
URL	https://data.incheon.go.kr/findData/publicDataDetail?dataId=15078940&srcSe=7661IVAWM27C61E190

Alerts

`유형(국립_도립_시립)` has constant value ""	Constant
`미술관명` has constant value ""	Constant
`연번` is highly overall correlated with `연도`	High correlation
`연도` is highly overall correlated with `연번`	High correlation
`연번` has unique values	Unique
`이용객수` has 5 (3.2%) zeros	Zeros

Reproduction

Analysis started	2024-01-28 15:08:23.358995
Analysis finished	2024-01-28 15:08:24.992701
Duration	1.63 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연번
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	155
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78

Minimum	1
Maximum	155
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	1
5-th percentile	8.7
Q1	39.5
median	78
Q3	116.5
95-th percentile	147.3
Maximum	155
Range	154
Interquartile range (IQR)	77

Descriptive statistics

Standard deviation	44.888751
Coefficient of variation (CV)	0.57549681
Kurtosis	-1.2
Mean	78
Median Absolute Deviation (MAD)	39
Skewness	0
Sum	12090
Variance	2015
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.6%
108	1	0.6%
101	1	0.6%
102	1	0.6%
103	1	0.6%
104	1	0.6%
105	1	0.6%
106	1	0.6%
107	1	0.6%
109	1	0.6%
Other values (145)	145	93.5%

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
155	1	0.6%
154	1	0.6%
153	1	0.6%
152	1	0.6%
151	1	0.6%
150	1	0.6%
149	1	0.6%
148	1	0.6%
147	1	0.6%
146	1	0.6%

유형(국립_도립_시립)
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.3 KiB

시립	155

Length

Max length	2
Median length	2
Mean length	2
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 (%)
시립	155	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
시립	155	100.0%

미술관명
Categorical

CONSTANT

Distinct	1
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.3 KiB

송암미술관	155

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	송암미술관
2nd row	송암미술관
3rd row	송암미술관
4th row	송암미술관
5th row	송암미술관

Common Values

Value	Count	Frequency (%)
송암미술관	155	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
송암미술관	155	100.0%

연도
Real number (ℝ)

HIGH CORRELATION

Distinct	14
Distinct (%)	9.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2134.1935

Minimum	2011
Maximum	20190
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	2011
5-th percentile	2011
Q1	2014
median	2017
Q3	2020
95-th percentile	2023
Maximum	20190
Range	18179
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	1459.6994
Coefficient of variation (CV)	0.68395832
Kurtosis	154.99794
Mean	2134.1935
Median Absolute Deviation (MAD)	3
Skewness	12.449776
Sum	330800
Variance	2130722.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2011	12	7.7%
2012	12	7.7%
2013	12	7.7%
2014	12	7.7%
2015	12	7.7%
2016	12	7.7%
2017	12	7.7%
2018	12	7.7%
2020	12	7.7%
2021	12	7.7%
Other values (4)	35	22.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2011	12	7.7%
2012	12	7.7%
2013	12	7.7%
2014	12	7.7%
2015	12	7.7%
2016	12	7.7%
2017	12	7.7%
2018	12	7.7%
2019	11	7.1%
2020	12	7.7%

Value	Count	Frequency (%)
20190	1	0.6%
2023	11	7.1%
2022	12	7.7%
2021	12	7.7%
2020	12	7.7%
2019	11	7.1%
2018	12	7.7%
2017	12	7.7%
2016	12	7.7%
2015	12	7.7%

월
Real number (ℝ)

Distinct	12
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.4645161

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3.5
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5.5

Descriptive statistics

Standard deviation	3.4458283
Coefficient of variation (CV)	0.53303731
Kurtosis	-1.2118766
Mean	6.4645161
Median Absolute Deviation (MAD)	3
Skewness	0.0045476572
Sum	1002
Variance	11.873733
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	13	8.4%
2	13	8.4%
3	13	8.4%
4	13	8.4%
5	13	8.4%
6	13	8.4%
7	13	8.4%
8	13	8.4%
9	13	8.4%
10	13	8.4%
Other values (2)	25	16.1%

Minimum 10 values
Maximum 10 values

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

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

이용객수
Real number (ℝ)

ZEROS

Distinct	146
Distinct (%)	94.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1148.9935

Minimum	0
Maximum	4787
Zeros	5
Zeros (%)	3.2%
Negative	0
Negative (%)	0.0%
Memory size	1.5 KiB

Quantile statistics

Minimum	0
5-th percentile	205.1
Q1	645
median	1034
Q3	1512.5
95-th percentile	2525.2
Maximum	4787
Range	4787
Interquartile range (IQR)	867.5

Descriptive statistics

Standard deviation	744.92693
Coefficient of variation (CV)	0.64832995
Kurtosis	3.7598593
Mean	1148.9935
Median Absolute Deviation (MAD)	437
Skewness	1.3870371
Sum	178094
Variance	554916.14
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5	3.2%
767	3	1.9%
1230	2	1.3%
759	2	1.3%
1279	2	1.3%
2773	1	0.6%
451	1	0.6%
571	1	0.6%
1392	1	0.6%
1659	1	0.6%
Other values (136)	136	87.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5	3.2%
25	1	0.6%
158	1	0.6%
168	1	0.6%
221	1	0.6%
230	1	0.6%
242	1	0.6%
277	1	0.6%
285	1	0.6%
305	1	0.6%

Value	Count	Frequency (%)
4787	1	0.6%
3394	1	0.6%
3251	1	0.6%
3218	1	0.6%
3044	1	0.6%
2930	1	0.6%
2909	1	0.6%
2773	1	0.6%
2419	1	0.6%
2197	1	0.6%

Phik (φk)
Auto

Heatmap
Table

	연번	연도	월	이용객수
연번	1.000	0.000	0.000	0.405
연도	0.000	1.000	0.159	0.000
월	0.000	0.159	1.000	0.465
이용객수	0.405	0.000	0.465	1.000

Heatmap
Table

	연번	연도	월	이용객수
연번	1.000	0.992	0.060	-0.192
연도	0.992	1.000	-0.022	-0.213
월	0.060	-0.022	1.000	0.351
이용객수	-0.192	-0.213	0.351	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

	연번	유형(국립_도립_시립)	미술관명	연도	월	이용객수
0	1	시립	송암미술관	2011	1	1034
1	2	시립	송암미술관	2011	2	538
2	3	시립	송암미술관	2011	3	285
3	4	시립	송암미술관	2011	4	421
4	5	시립	송암미술관	2011	5	1675
5	6	시립	송암미술관	2011	6	1795
6	7	시립	송암미술관	2011	7	1320
7	8	시립	송암미술관	2011	8	3394
8	9	시립	송암미술관	2011	9	954
9	10	시립	송암미술관	2011	10	1385

	연번	유형(국립_도립_시립)	미술관명	연도	월	이용객수
145	146	시립	송암미술관	2023	2	965
146	147	시립	송암미술관	2023	3	1180
147	148	시립	송암미술관	2023	4	1829
148	149	시립	송암미술관	2023	5	1555
149	150	시립	송암미술관	2023	6	0
150	151	시립	송암미술관	2023	7	0
151	152	시립	송암미술관	2023	8	1160
152	153	시립	송암미술관	2023	9	1991
153	154	시립	송암미술관	2023	10	2167
154	155	시립	송암미술관	2023	11	2197

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample