gimi9 Pandas Profiling

Dataset statistics

Number of variables	6
Number of observations	151
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	7.8 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.3%) zeros	Zeros

Reproduction

Analysis started	2024-01-28 15:08:30.637307
Analysis finished	2024-01-28 15:08:32.134749
Duration	1.5 second
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연번
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	151
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	76

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

Quantile statistics

Minimum	1
5-th percentile	8.5
Q1	38.5
median	76
Q3	113.5
95-th percentile	143.5
Maximum	151
Range	150
Interquartile range (IQR)	75

Descriptive statistics

Standard deviation	43.734045
Coefficient of variation (CV)	0.57544796
Kurtosis	-1.2
Mean	76
Median Absolute Deviation (MAD)	38
Skewness	0
Sum	11476
Variance	1912.6667
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	0.7%
105	1	0.7%
98	1	0.7%
99	1	0.7%
100	1	0.7%
101	1	0.7%
102	1	0.7%
103	1	0.7%
104	1	0.7%
106	1	0.7%
Other values (141)	141	93.4%

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
151	1	0.7%
150	1	0.7%
149	1	0.7%
148	1	0.7%
147	1	0.7%
146	1	0.7%
145	1	0.7%
144	1	0.7%
143	1	0.7%
142	1	0.7%

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

CONSTANT

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

시립	151

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 (%)
시립	151	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
시립	151	100.0%

미술관명
Categorical

CONSTANT

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

송암미술관	151

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 (%)
송암미술관	151	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

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

연도
Real number (ℝ)

HIGH CORRELATION

Distinct	14
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2137.1391

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	2022.5
Maximum	20190
Range	18179
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	1478.9196
Coefficient of variation (CV)	0.69200907
Kurtosis	150.99813
Mean	2137.1391
Median Absolute Deviation (MAD)	3
Skewness	12.288092
Sum	322708
Variance	2187203.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
2011	12	7.9%
2012	12	7.9%
2013	12	7.9%
2014	12	7.9%
2015	12	7.9%
2016	12	7.9%
2017	12	7.9%
2018	12	7.9%
2020	12	7.9%
2021	12	7.9%
Other values (4)	31	20.5%

Minimum 10 values
Maximum 10 values

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

Value	Count	Frequency (%)
20190	1	0.7%
2023	7	4.6%
2022	12	7.9%
2021	12	7.9%
2020	12	7.9%
2019	11	7.3%
2018	12	7.9%
2017	12	7.9%
2016	12	7.9%
2015	12	7.9%

월
Real number (ℝ)

Distinct	12
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.384106

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
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.4503351
Coefficient of variation (CV)	0.54045706
Kurtosis	-1.2014501
Mean	6.384106
Median Absolute Deviation (MAD)	3
Skewness	0.049627784
Sum	964
Variance	11.904812
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	13	8.6%
2	13	8.6%
3	13	8.6%
4	13	8.6%
5	13	8.6%
6	13	8.6%
7	13	8.6%
8	12	7.9%
9	12	7.9%
10	12	7.9%
Other values (2)	24	15.9%

Minimum 10 values
Maximum 10 values

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

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

이용객수
Real number (ℝ)

ZEROS

Distinct	142
Distinct (%)	94.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1129.6623

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

Quantile statistics

Minimum	0
5-th percentile	194.5
Q1	616.5
median	1018
Q3	1480.5
95-th percentile	2596
Maximum	4787
Range	4787
Interquartile range (IQR)	864

Descriptive statistics

Standard deviation	741.87558
Coefficient of variation (CV)	0.65672335
Kurtosis	4.1532993
Mean	1129.6623
Median Absolute Deviation (MAD)	437
Skewness	1.4750271
Sum	170579
Variance	550379.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5	3.3%
767	3	2.0%
1230	2	1.3%
759	2	1.3%
1279	2	1.3%
1846	1	0.7%
460	1	0.7%
451	1	0.7%
571	1	0.7%
1392	1	0.7%
Other values (132)	132	87.4%

Minimum 10 values
Maximum 10 values

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

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

Phik (φk)
Auto

Heatmap
Table

	연번	연도	월	이용객수
연번	1.000	0.000	0.000	0.309
연도	0.000	1.000	0.147	0.000
월	0.000	0.147	1.000	0.494
이용객수	0.309	0.000	0.494	1.000

Heatmap
Table

	연번	연도	월	이용객수
연번	1.000	0.992	0.022	-0.260
연도	0.992	1.000	-0.060	-0.279
월	0.022	-0.060	1.000	0.336
이용객수	-0.260	-0.279	0.336	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

	연번	유형(국립_도립_시립)	미술관명	연도	월	이용객수
141	142	시립	송암미술관	2022	10	993
142	143	시립	송암미술관	2022	11	1279
143	144	시립	송암미술관	2022	12	767
144	145	시립	송암미술관	2023	1	569
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

Overview

Variables

Common Values

Length

Common Values (Plot)

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample