Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory498.0 KiB
Average record size in memory51.0 B

Variable types

Numeric3
DateTime1
Categorical1

Dataset

Description인천어린이과학관의 전시관 예약인원 가능한 날짜별 ,관람일별 잔여이원, 회차, 시간 정보를 제공합니다.(개인관람, 단체관람)
Author인천시설공단
URLhttps://data.incheon.go.kr/findData/publicDataDetail?dataId=15040843&srcSe=7661IVAWM27C61E190

Alerts

관람인원 is highly overall correlated with 관람요금High correlation
관람요금 is highly overall correlated with 관람인원High correlation
순번 has unique valuesUnique
관람요금 has 180 (1.8%) zerosZeros

Reproduction

Analysis started2024-03-18 04:23:51.335967
Analysis finished2024-03-18 04:23:54.445933
Duration3.11 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean49783.811
Minimum3
Maximum99985
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-18T13:23:54.553198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile4944.95
Q124222.75
median49559.5
Q375189.25
95-th percentile95357.05
Maximum99985
Range99982
Interquartile range (IQR)50966.5

Descriptive statistics

Standard deviation29164.126
Coefficient of variation (CV)0.58581545
Kurtosis-1.216874
Mean49783.811
Median Absolute Deviation (MAD)25443
Skewness0.019994288
Sum4.9783811 × 108
Variance8.5054623 × 108
MonotonicityNot monotonic
2024-03-18T13:23:54.745242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
11345 1
 
< 0.1%
84818 1
 
< 0.1%
52747 1
 
< 0.1%
94692 1
 
< 0.1%
93030 1
 
< 0.1%
91365 1
 
< 0.1%
4403 1
 
< 0.1%
85625 1
 
< 0.1%
34705 1
 
< 0.1%
8848 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
3 1
< 0.1%
6 1
< 0.1%
26 1
< 0.1%
29 1
< 0.1%
40 1
< 0.1%
41 1
< 0.1%
45 1
< 0.1%
57 1
< 0.1%
62 1
< 0.1%
64 1
< 0.1%
ValueCountFrequency (%)
99985 1
< 0.1%
99983 1
< 0.1%
99981 1
< 0.1%
99970 1
< 0.1%
99947 1
< 0.1%
99938 1
< 0.1%
99929 1
< 0.1%
99900 1
< 0.1%
99895 1
< 0.1%
99894 1
< 0.1%

예약일
Date

Distinct240
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-12-21 00:00:00
Maximum2022-11-11 00:00:00
2024-03-18T13:23:54.909923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T13:23:55.048265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

관람인원
Real number (ℝ)

HIGH CORRELATION 

Distinct52
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.2815
Minimum1
Maximum128
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-18T13:23:55.206924image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q12
median3
Q34
95-th percentile5
Maximum128
Range127
Interquartile range (IQR)2

Descriptive statistics

Standard deviation4.1995501
Coefficient of variation (CV)1.2797654
Kurtosis313.74133
Mean3.2815
Median Absolute Deviation (MAD)1
Skewness15.843422
Sum32815
Variance17.636221
MonotonicityNot monotonic
2024-03-18T13:23:55.340934image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
3 3478
34.8%
2 3082
30.8%
4 2409
24.1%
1 416
 
4.2%
5 357
 
3.6%
6 169
 
1.7%
15 10
 
0.1%
10 5
 
0.1%
24 5
 
0.1%
22 4
 
< 0.1%
Other values (42) 65
 
0.7%
ValueCountFrequency (%)
1 416
 
4.2%
2 3082
30.8%
3 3478
34.8%
4 2409
24.1%
5 357
 
3.6%
6 169
 
1.7%
10 5
 
0.1%
12 3
 
< 0.1%
13 1
 
< 0.1%
14 1
 
< 0.1%
ValueCountFrequency (%)
128 1
< 0.1%
118 1
< 0.1%
98 1
< 0.1%
94 1
< 0.1%
84 1
< 0.1%
83 1
< 0.1%
81 1
< 0.1%
80 1
< 0.1%
77 1
< 0.1%
76 1
< 0.1%

관람요금
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct34
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5435.35
Minimum0
Maximum130500
Zeros180
Zeros (%)1.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-18T13:23:55.458421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile2000
Q14000
median4000
Q38000
95-th percentile10000
Maximum130500
Range130500
Interquartile range (IQR)4000

Descriptive statistics

Standard deviation3662.982
Coefficient of variation (CV)0.67391833
Kurtosis250.75451
Mean5435.35
Median Absolute Deviation (MAD)2000
Skewness9.8747028
Sum54353500
Variance13417437
MonotonicityNot monotonic
2024-03-18T13:23:55.570849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=34)
ValueCountFrequency (%)
4000 3055
30.6%
8000 2168
21.7%
2000 1228
12.3%
6000 1000
 
10.0%
3000 959
 
9.6%
10000 528
 
5.3%
5000 294
 
2.9%
12000 248
 
2.5%
0 180
 
1.8%
7000 176
 
1.8%
Other values (24) 164
 
1.6%
ValueCountFrequency (%)
0 180
 
1.8%
1000 39
 
0.4%
2000 1228
12.3%
3000 959
 
9.6%
4000 3055
30.6%
5000 294
 
2.9%
6000 1000
 
10.0%
7000 176
 
1.8%
8000 2168
21.7%
9000 17
 
0.2%
ValueCountFrequency (%)
130500 1
< 0.1%
99000 1
< 0.1%
89000 1
< 0.1%
83000 1
< 0.1%
72000 1
< 0.1%
68000 1
< 0.1%
57000 1
< 0.1%
47000 1
< 0.1%
33000 1
< 0.1%
32000 2
< 0.1%

취소여부
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
5585 
취소
2524 
환불
1891 

Length

Max length2
Median length1
Mean length1.4415
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row환불
2nd row
3rd row
4th row취소
5th row취소

Common Values

ValueCountFrequency (%)
5585
55.9%
취소 2524
25.2%
환불 1891
 
18.9%

Length

2024-03-18T13:23:55.684065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-18T13:23:55.782020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
취소 2524
57.2%
환불 1891
42.8%

Interactions

2024-03-18T13:23:53.643034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T13:23:52.587927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T13:23:53.247215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T13:23:53.792764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T13:23:52.748603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T13:23:53.374116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T13:23:53.969195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T13:23:53.074075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-18T13:23:53.516499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-18T13:23:55.846602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번관람인원관람요금취소여부
순번1.0000.0810.0530.096
관람인원0.0811.0000.8240.084
관람요금0.0530.8241.0000.085
취소여부0.0960.0840.0851.000
2024-03-18T13:23:55.939705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번관람인원관람요금취소여부
순번1.0000.0540.0330.057
관람인원0.0541.0000.6290.037
관람요금0.0330.6291.0000.037
취소여부0.0570.0370.0371.000

Missing values

2024-03-18T13:23:54.244163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-18T13:23:54.381342image/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

순번예약일관람인원관람요금취소여부
11344113452022-01-1634000환불
84014840152022-07-3154000
87668876692022-08-0738000
85383853842022-08-0312000취소
25577255782022-03-0144000취소
96742967432022-08-27616000환불
25022250232022-02-2023000
41076410772022-04-1744000
41900419012022-04-3034000취소
21544215452022-02-26310000취소
순번예약일관람인원관람요금취소여부
545454552022-01-0723000
267026712022-01-0838000환불
645664572022-01-08410000취소
11347113482022-01-2222000환불
85633856342022-07-31150취소
29753297542022-03-0636000
31075310762022-03-1324000환불
29072290732022-03-1238000취소
95389953902022-08-1223000취소
76540765412022-07-2724000