Overview

Dataset statistics

Number of variables6
Number of observations158
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.2 KiB
Average record size in memory52.8 B

Variable types

Numeric4
Categorical2

Dataset

Description2011~2024년까지 송암미술관 월별 이용객 수를 제공합니다.* 매주 월요일, 공휴일 다음날은 휴관일입니다.* 2020년에 153일 임시휴관을 하였고, 1개의 프로그램을 제외한 모든 교육프로그램이 온라인으로 진행되었습니다.
Author인천광역시
URLhttps://www.data.go.kr/data/15078940/fileData.do

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 valuesUnique
이용객수 has 5 (3.2%) zerosZeros

Reproduction

Analysis started2024-04-06 08:24:02.737965
Analysis finished2024-04-06 08:24:06.396396
Duration3.66 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct158
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean79.5
Minimum1
Maximum158
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-04-06T17:24:06.540191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile8.85
Q140.25
median79.5
Q3118.75
95-th percentile150.15
Maximum158
Range157
Interquartile range (IQR)78.5

Descriptive statistics

Standard deviation45.754781
Coefficient of variation (CV)0.57553184
Kurtosis-1.2
Mean79.5
Median Absolute Deviation (MAD)39.5
Skewness0
Sum12561
Variance2093.5
MonotonicityStrictly increasing
2024-04-06T17:24:06.827844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.6%
110 1
 
0.6%
103 1
 
0.6%
104 1
 
0.6%
105 1
 
0.6%
106 1
 
0.6%
107 1
 
0.6%
108 1
 
0.6%
109 1
 
0.6%
111 1
 
0.6%
Other values (148) 148
93.7%
ValueCountFrequency (%)
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%
ValueCountFrequency (%)
158 1
0.6%
157 1
0.6%
156 1
0.6%
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%

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

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
시립
158 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
시립 158
100.0%

Length

2024-04-06T17:24:07.118645image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:24:07.344153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시립 158
100.0%

미술관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
송암미술관
158 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
송암미술관 158
100.0%

Length

2024-04-06T17:24:07.609838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-06T17:24:07.823046image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
송암미술관 158
100.0%

연도
Real number (ℝ)

HIGH CORRELATION 

Distinct15
Distinct (%)9.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2132.0949
Minimum2011
Maximum20190
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-04-06T17:24:08.071619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2011
5-th percentile2011
Q12014
median2017
Q32020
95-th percentile2023
Maximum20190
Range18179
Interquartile range (IQR)6

Descriptive statistics

Standard deviation1445.7652
Coefficient of variation (CV)0.67809607
Kurtosis157.99777
Mean2132.0949
Median Absolute Deviation (MAD)3
Skewness12.569673
Sum336871
Variance2090237
MonotonicityNot monotonic
2024-04-06T17:24:08.409894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
2011 12
 
7.6%
2012 12
 
7.6%
2013 12
 
7.6%
2014 12
 
7.6%
2015 12
 
7.6%
2016 12
 
7.6%
2017 12
 
7.6%
2018 12
 
7.6%
2020 12
 
7.6%
2021 12
 
7.6%
Other values (5) 38
24.1%
ValueCountFrequency (%)
2011 12
7.6%
2012 12
7.6%
2013 12
7.6%
2014 12
7.6%
2015 12
7.6%
2016 12
7.6%
2017 12
7.6%
2018 12
7.6%
2019 11
7.0%
2020 12
7.6%
ValueCountFrequency (%)
20190 1
 
0.6%
2024 2
 
1.3%
2023 12
7.6%
2022 12
7.6%
2021 12
7.6%
2020 12
7.6%
2019 11
7.0%
2018 12
7.6%
2017 12
7.6%
2016 12
7.6%


Real number (ℝ)

Distinct12
Distinct (%)7.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.4367089
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-04-06T17:24:08.755437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median6
Q39
95-th percentile12
Maximum12
Range11
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.4868882
Coefficient of variation (CV)0.54171911
Kurtosis-1.2313162
Mean6.4367089
Median Absolute Deviation (MAD)3
Skewness0.015974912
Sum1017
Variance12.158389
MonotonicityNot monotonic
2024-04-06T17:24:08.986273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
1 14
8.9%
2 14
8.9%
3 13
8.2%
4 13
8.2%
5 13
8.2%
6 13
8.2%
7 13
8.2%
8 13
8.2%
9 13
8.2%
10 13
8.2%
Other values (2) 26
16.5%
ValueCountFrequency (%)
1 14
8.9%
2 14
8.9%
3 13
8.2%
4 13
8.2%
5 13
8.2%
6 13
8.2%
7 13
8.2%
8 13
8.2%
9 13
8.2%
10 13
8.2%
ValueCountFrequency (%)
12 13
8.2%
11 13
8.2%
10 13
8.2%
9 13
8.2%
8 13
8.2%
7 13
8.2%
6 13
8.2%
5 13
8.2%
4 13
8.2%
3 13
8.2%

이용객수
Real number (ℝ)

ZEROS 

Distinct149
Distinct (%)94.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1162.6266
Minimum0
Maximum4787
Zeros5
Zeros (%)3.2%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2024-04-06T17:24:09.326985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile213.05
Q1658.75
median1064
Q31552.25
95-th percentile2472.1
Maximum4787
Range4787
Interquartile range (IQR)893.5

Descriptive statistics

Standard deviation744.43156
Coefficient of variation (CV)0.64030151
Kurtosis3.5609947
Mean1162.6266
Median Absolute Deviation (MAD)459
Skewness1.3256586
Sum183695
Variance554178.35
MonotonicityNot monotonic
2024-04-06T17:24:09.622832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 5
 
3.2%
767 3
 
1.9%
1230 2
 
1.3%
759 2
 
1.3%
1279 2
 
1.3%
1678 1
 
0.6%
1392 1
 
0.6%
1659 1
 
0.6%
928 1
 
0.6%
2773 1
 
0.6%
Other values (139) 139
88.0%
ValueCountFrequency (%)
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%
ValueCountFrequency (%)
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%

Interactions

2024-04-06T17:24:05.283142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:03.028660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:03.811170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:04.539953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:05.476861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:03.224386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:04.032383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:04.727956image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:05.692226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:03.425493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:04.214501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:04.922333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:05.851087image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:03.592772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:04.374939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:24:05.123486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T17:24:10.252540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연도이용객수
연번1.0000.0000.0000.419
연도0.0001.0000.1670.000
0.0000.1671.0000.461
이용객수0.4190.0000.4611.000
2024-04-06T17:24:10.485343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번연도이용객수
연번1.0000.9920.043-0.139
연도0.9921.000-0.037-0.161
0.043-0.0371.0000.326
이용객수-0.139-0.1610.3261.000

Missing values

2024-04-06T17:24:06.096107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:24:06.324276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

연번유형(국립_도립_시립)미술관명연도이용객수
01시립송암미술관201111034
12시립송암미술관20112538
23시립송암미술관20113285
34시립송암미술관20114421
45시립송암미술관201151675
56시립송암미술관201161795
67시립송암미술관201171320
78시립송암미술관201183394
89시립송암미술관20119954
910시립송암미술관2011101385
연번유형(국립_도립_시립)미술관명연도이용객수
148149시립송암미술관202351555
149150시립송암미술관202360
150151시립송암미술관202370
151152시립송암미술관202381160
152153시립송암미술관202391991
153154시립송암미술관2023102167
154155시립송암미술관2023112197
155156시립송암미술관2023121948
156157시립송암미술관202411931
157158시립송암미술관202421722