Overview

Dataset statistics

Number of variables12
Number of observations276
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory26.5 KiB
Average record size in memory98.5 B

Variable types

Numeric2
Categorical4
DateTime4
Boolean2

Dataset

Description대구시설공단 체육시설 시설물관련정보입니다.
Author대구시설공단
URLhttps://www.data.go.kr/data/15088097/fileData.do

Alerts

센터코드 has constant value ""Constant
비회원예약구분 has constant value ""Constant
단체개인구분 has constant value ""Constant
예약이용시작시간 is highly overall correlated with 예약이용종료시간High correlation
예약이용종료시간 is highly overall correlated with 예약이용시작시간 and 1 other fieldsHigh correlation
시설이용합계금액 is highly overall correlated with 예약이용종료시간High correlation
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 16:26:42.747015
Analysis finished2023-12-12 16:26:43.630252
Duration0.88 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct276
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean138.5
Minimum1
Maximum276
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 KiB
2023-12-13T01:26:43.690145image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile14.75
Q169.75
median138.5
Q3207.25
95-th percentile262.25
Maximum276
Range275
Interquartile range (IQR)137.5

Descriptive statistics

Standard deviation79.818544
Coefficient of variation (CV)0.57630718
Kurtosis-1.2
Mean138.5
Median Absolute Deviation (MAD)69
Skewness0
Sum38226
Variance6371
MonotonicityStrictly increasing
2023-12-13T01:26:43.808817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
184 1
 
0.4%
190 1
 
0.4%
189 1
 
0.4%
188 1
 
0.4%
187 1
 
0.4%
186 1
 
0.4%
185 1
 
0.4%
183 1
 
0.4%
175 1
 
0.4%
Other values (266) 266
96.4%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
276 1
0.4%
275 1
0.4%
274 1
0.4%
273 1
0.4%
272 1
0.4%
271 1
0.4%
270 1
0.4%
269 1
0.4%
268 1
0.4%
267 1
0.4%

센터코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
서재문화체육센터
276 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서재문화체육센터
2nd row서재문화체육센터
3rd row서재문화체육센터
4th row서재문화체육센터
5th row서재문화체육센터

Common Values

ValueCountFrequency (%)
서재문화체육센터 276
100.0%

Length

2023-12-13T01:26:43.982049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:26:44.084868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서재문화체육센터 276
100.0%

시설예약접수일자
Date

Distinct56
Distinct (%)20.3%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
Minimum2021-01-18 00:00:00
Maximum2021-07-13 00:00:00
2023-12-13T01:26:44.193623image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:26:44.328227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

비회원예약구분
Boolean

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size408.0 B
False
276 
ValueCountFrequency (%)
False 276
100.0%
2023-12-13T01:26:44.424975image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

단체개인구분
Boolean

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size408.0 B
False
276 
ValueCountFrequency (%)
False 276
100.0%
2023-12-13T01:26:44.510622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

시설이용인원
Real number (ℝ)

Distinct8
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.6123188
Minimum1
Maximum19
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.6 KiB
2023-12-13T01:26:44.584499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q31
95-th percentile18
Maximum19
Range18
Interquartile range (IQR)0

Descriptive statistics

Standard deviation5.5809801
Coefficient of variation (CV)1.5449855
Kurtosis1.5118992
Mean3.6123188
Median Absolute Deviation (MAD)0
Skewness1.7949325
Sum997
Variance31.147339
MonotonicityNot monotonic
2023-12-13T01:26:44.683788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
1 224
81.2%
18 11
 
4.0%
12 11
 
4.0%
15 9
 
3.3%
10 6
 
2.2%
19 6
 
2.2%
14 5
 
1.8%
16 4
 
1.4%
ValueCountFrequency (%)
1 224
81.2%
10 6
 
2.2%
12 11
 
4.0%
14 5
 
1.8%
15 9
 
3.3%
16 4
 
1.4%
18 11
 
4.0%
19 6
 
2.2%
ValueCountFrequency (%)
19 6
 
2.2%
18 11
 
4.0%
16 4
 
1.4%
15 9
 
3.3%
14 5
 
1.8%
12 11
 
4.0%
10 6
 
2.2%
1 224
81.2%

예약이용시작일
Date

Distinct107
Distinct (%)38.8%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
Minimum2021-01-27 00:00:00
Maximum2021-07-31 00:00:00
2023-12-13T01:26:44.797229image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:26:44.921273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

예약이용시작시간
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
20:00
91 
21:00
64 
9:00
39 
14:00
37 
18:00
12 
Other values (9)
33 

Length

Max length5
Median length5
Mean length4.8224638
Min length4

Unique

Unique2 ?
Unique (%)0.7%

Sample

1st row9:00
2nd row14:00
3rd row14:00
4th row15:00
5th row9:00

Common Values

ValueCountFrequency (%)
20:00 91
33.0%
21:00 64
23.2%
9:00 39
14.1%
14:00 37
13.4%
18:00 12
 
4.3%
8:00 10
 
3.6%
16:00 6
 
2.2%
10:00 5
 
1.8%
15:00 3
 
1.1%
19:00 3
 
1.1%
Other values (4) 6
 
2.2%

Length

2023-12-13T01:26:45.043665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
20:00 91
33.0%
21:00 64
23.2%
9:00 39
14.1%
14:00 37
13.4%
18:00 12
 
4.3%
8:00 10
 
3.6%
16:00 6
 
2.2%
10:00 5
 
1.8%
15:00 3
 
1.1%
19:00 3
 
1.1%
Other values (4) 6
 
2.2%

예약이용종료일
Date

Distinct107
Distinct (%)38.8%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
Minimum2021-01-27 00:00:00
Maximum2021-07-31 00:00:00
2023-12-13T01:26:45.147861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:26:45.273139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

예약이용종료시간
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
22:00
89 
21:00
66 
12:00
21 
16:00
19 
17:00
19 
Other values (9)
62 

Length

Max length5
Median length5
Mean length4.9855072
Min length4

Unique

Unique2 ?
Unique (%)0.7%

Sample

1st row11:00
2nd row16:00
3rd row15:00
4th row16:00
5th row11:00

Common Values

ValueCountFrequency (%)
22:00 89
32.2%
21:00 66
23.9%
12:00 21
 
7.6%
16:00 19
 
6.9%
17:00 19
 
6.9%
10:00 15
 
5.4%
11:00 14
 
5.1%
19:00 11
 
4.0%
15:00 7
 
2.5%
20:00 5
 
1.8%
Other values (4) 10
 
3.6%

Length

2023-12-13T01:26:45.417594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
22:00 89
32.2%
21:00 66
23.9%
12:00 21
 
7.6%
16:00 19
 
6.9%
17:00 19
 
6.9%
10:00 15
 
5.4%
11:00 14
 
5.1%
19:00 11
 
4.0%
15:00 7
 
2.5%
20:00 5
 
1.8%
Other values (4) 10
 
3.6%

시설이용합계금액
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
40,000
163 
73,300
50 
80,000
42 
30,000
 
6
45,000
 
6
Other values (5)
 
9

Length

Max length6
Median length6
Mean length5.9855072
Min length5

Unique

Unique3 ?
Unique (%)1.1%

Sample

1st row80,000
2nd row60,000
3rd row30,000
4th row30,000
5th row80,000

Common Values

ValueCountFrequency (%)
40,000 163
59.1%
73,300 50
 
18.1%
80,000 42
 
15.2%
30,000 6
 
2.2%
45,000 6
 
2.2%
15,000 4
 
1.4%
3,000 2
 
0.7%
60,000 1
 
0.4%
9,000 1
 
0.4%
6,000 1
 
0.4%

Length

2023-12-13T01:26:45.521904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:26:45.630798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
40,000 163
59.1%
73,300 50
 
18.1%
80,000 42
 
15.2%
30,000 6
 
2.2%
45,000 6
 
2.2%
15,000 4
 
1.4%
3,000 2
 
0.7%
60,000 1
 
0.4%
9,000 1
 
0.4%
6,000 1
 
0.4%

등록일시
Date

Distinct190
Distinct (%)68.8%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
Minimum2021-01-18 08:08:00
Maximum2021-07-13 14:03:00
2023-12-13T01:26:45.740587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:26:45.860389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-13T01:26:43.205156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:26:43.045798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:26:43.286721image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:26:43.116324image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T01:26:45.954909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시설예약접수일자시설이용인원예약이용시작시간예약이용종료시간시설이용합계금액
순번1.0000.9900.5290.5790.6160.685
시설예약접수일자0.9901.0000.7580.9600.9680.960
시설이용인원0.5290.7581.0000.3520.3200.085
예약이용시작시간0.5790.9600.3521.0000.9830.790
예약이용종료시간0.6160.9680.3200.9831.0000.847
시설이용합계금액0.6850.9600.0850.7900.8471.000
2023-12-13T01:26:46.050368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
예약이용종료시간시설이용합계금액예약이용시작시간
예약이용종료시간1.0000.5510.731
시설이용합계금액0.5511.0000.467
예약이용시작시간0.7310.4671.000
2023-12-13T01:26:46.137575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번시설이용인원예약이용시작시간예약이용종료시간시설이용합계금액
순번1.0000.2900.2710.3010.276
시설이용인원0.2901.0000.1780.1600.043
예약이용시작시간0.2710.1781.0000.7310.467
예약이용종료시간0.3010.1600.7311.0000.551
시설이용합계금액0.2760.0430.4670.5511.000

Missing values

2023-12-13T01:26:43.404877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T01:26:43.574517image/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서재문화체육센터2021-01-18NN12021-01-319:002021-01-3111:0080,0002021-01-18 8:08
12서재문화체육센터2021-01-27NN12021-01-2714:002021-01-2716:0060,0002021-01-27 10:46
23서재문화체육센터2021-01-27NN12021-01-2714:002021-01-2715:0030,0002021-01-27 13:46
34서재문화체육센터2021-01-27NN12021-01-2715:002021-01-2716:0030,0002021-01-27 13:46
45서재문화체육센터2021-02-16NN12021-02-219:002021-02-2111:0080,0002021-02-16 9:50
56서재문화체육센터2021-02-16NN12021-02-219:002021-02-2110:0040,0002021-02-16 9:51
67서재문화체육센터2021-02-16NN12021-02-2110:002021-02-2111:0040,0002021-02-16 9:51
78서재문화체육센터2021-02-17NN12021-02-1821:002021-02-1822:0040,0002021-02-17 16:10
89서재문화체육센터2021-03-03NN12021-03-0420:002021-03-0422:0080,0002021-03-03 11:01
910서재문화체육센터2021-03-03NN12021-03-1120:002021-03-1121:0040,0002021-03-03 11:02
순번센터코드시설예약접수일자비회원예약구분단체개인구분시설이용인원예약이용시작일예약이용시작시간예약이용종료일예약이용종료시간시설이용합계금액등록일시
266267서재문화체육센터2021-06-30NN12021-07-2414:002021-07-2417:0073,3002021-06-30 9:51
267268서재문화체육센터2021-06-30NN12021-07-319:002021-07-3112:0073,3002021-06-30 9:52
268269서재문화체육센터2021-06-30NN12021-07-049:002021-07-0412:0073,3002021-06-30 9:55
269270서재문화체육센터2021-06-30NN12021-07-1714:002021-07-1717:0073,3002021-06-30 9:55
270271서재문화체육센터2021-06-30NN12021-07-0414:002021-07-0416:0073,3002021-06-30 10:17
271272서재문화체육센터2021-06-30NN12021-07-0314:002021-07-0317:0073,3002021-06-30 16:56
272273서재문화체육센터2021-07-02NN12021-07-049:002021-07-0411:0080,0002021-07-02 11:13
273274서재문화체육센터2021-07-12NN12021-07-148:002021-07-149:0015,0002021-07-12 15:53
274275서재문화체육센터2021-07-12NN12021-07-149:002021-07-1410:0030,0002021-07-12 15:53
275276서재문화체육센터2021-07-13NN12021-07-189:002021-07-1811:0080,0002021-07-13 14:03