Overview

Dataset statistics

Number of variables9
Number of observations2511
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory181.6 KiB
Average record size in memory74.1 B

Variable types

Numeric2
Categorical4
Text1
DateTime2

Dataset

Description경기도 화성시의 화성 드림파크 대관 현황입니다. 신청일자, 예약시작일시, 예약종료일시, 이용요금을 확인할 수 있습니다.
Author화성도시공사
URLhttps://www.data.go.kr/data/15126952/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
이용요금 is highly overall correlated with 단체명 and 1 other fieldsHigh correlation
단체명 is highly overall correlated with 이용요금 and 1 other fieldsHigh correlation
비고 is highly overall correlated with 이용요금 and 1 other fieldsHigh correlation
단체명 is highly imbalanced (57.9%)Imbalance
연번 has unique valuesUnique
이용요금 has 1155 (46.0%) zerosZeros

Reproduction

Analysis started2024-03-15 01:24:00.227945
Analysis finished2024-03-15 01:24:02.644289
Duration2.42 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct2511
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1256
Minimum1
Maximum2511
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size22.2 KiB
2024-03-15T10:24:02.860794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile126.5
Q1628.5
median1256
Q31883.5
95-th percentile2385.5
Maximum2511
Range2510
Interquartile range (IQR)1255

Descriptive statistics

Standard deviation725.00759
Coefficient of variation (CV)0.57723534
Kurtosis-1.2
Mean1256
Median Absolute Deviation (MAD)628
Skewness0
Sum3153816
Variance525636
MonotonicityStrictly increasing
2024-03-15T10:24:03.308111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1679 1
 
< 0.1%
1672 1
 
< 0.1%
1673 1
 
< 0.1%
1674 1
 
< 0.1%
1675 1
 
< 0.1%
1676 1
 
< 0.1%
1677 1
 
< 0.1%
1678 1
 
< 0.1%
1680 1
 
< 0.1%
Other values (2501) 2501
99.6%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2511 1
< 0.1%
2510 1
< 0.1%
2509 1
< 0.1%
2508 1
< 0.1%
2507 1
< 0.1%
2506 1
< 0.1%
2505 1
< 0.1%
2504 1
< 0.1%
2503 1
< 0.1%
2502 1
< 0.1%

구분
Categorical

Distinct8
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size19.7 KiB
메인리틀
372 
주니어3
360 
리틀3
325 
여성
321 
주니어1
292 
Other values (3)
841 

Length

Max length4
Median length4
Mean length3.3910793
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row리틀3
2nd row주니어2
3rd row리틀3
4th row리틀3
5th row주니어2

Common Values

ValueCountFrequency (%)
메인리틀 372
14.8%
주니어3 360
14.3%
리틀3 325
12.9%
여성 321
12.8%
주니어1 292
11.6%
리틀1 284
11.3%
주니어2 279
11.1%
리틀2 278
11.1%

Length

2024-03-15T10:24:03.777192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T10:24:04.110805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
메인리틀 372
14.8%
주니어3 360
14.3%
리틀3 325
12.9%
여성 321
12.8%
주니어1 292
11.6%
리틀1 284
11.3%
주니어2 279
11.1%
리틀2 278
11.1%

단체명
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct50
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size19.7 KiB
한국리틀야구연맹
1408 
화성시체육회
438 
한국여자야구연맹
274 
화성시야구소프트볼협회
 
89
우성베이스AC
 
31
Other values (45)
271 

Length

Max length15
Median length8
Mean length7.4767025
Min length2

Unique

Unique11 ?
Unique (%)0.4%

Sample

1st row화성시체육회
2nd row화성시야구소프트볼협회
3rd row화성시체육회
4th row화성시체육회
5th row화성시야구소프트볼협회

Common Values

ValueCountFrequency (%)
한국리틀야구연맹 1408
56.1%
화성시체육회 438
 
17.4%
한국여자야구연맹 274
 
10.9%
화성시야구소프트볼협회 89
 
3.5%
우성베이스AC 31
 
1.2%
화푸야 26
 
1.0%
트레져스 24
 
1.0%
팀네이버스 19
 
0.8%
슬러거즈어게인 19
 
0.8%
펌킨스 18
 
0.7%
Other values (40) 165
 
6.6%

Length

2024-03-15T10:24:04.391593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
한국리틀야구연맹 1408
55.9%
화성시체육회 438
 
17.4%
한국여자야구연맹 274
 
10.9%
화성시야구소프트볼협회 89
 
3.5%
우성베이스ac 31
 
1.2%
화푸야 26
 
1.0%
트레져스 24
 
1.0%
팀네이버스 19
 
0.8%
슬러거즈어게인 19
 
0.8%
펌킨스 18
 
0.7%
Other values (47) 173
 
6.9%

신청일자
Text

Distinct254
Distinct (%)10.1%
Missing0
Missing (%)0.0%
Memory size19.7 KiB
2024-03-15T10:24:05.459220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length13
Mean length13
Min length13

Characters and Unicode

Total characters32643
Distinct characters20
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique38 ?
Unique (%)1.5%

Sample

1st row2023-01-07(토)
2nd row2023-01-07(토)
3rd row2023-01-08(일)
4th row2023-01-08(일)
5th row2023-01-08(일)
ValueCountFrequency (%)
2023-11-12(일 32
 
1.3%
2023-11-11(토 32
 
1.3%
2023-06-25(일 32
 
1.3%
2023-06-22(목 31
 
1.2%
2023-03-18(토 31
 
1.2%
2023-06-21(수 31
 
1.2%
2023-11-25(토 29
 
1.2%
2023-06-03(토 29
 
1.2%
2023-06-24(토 29
 
1.2%
2023-06-18(일 29
 
1.2%
Other values (244) 2206
87.9%
2024-03-15T10:24:06.843065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 6284
19.3%
0 5649
17.3%
- 5022
15.4%
3 3176
9.7%
) 2511
 
7.7%
( 2511
 
7.7%
1 2021
 
6.2%
토 805
 
2.5%
6 748
 
2.3%
일 737
 
2.3%
Other values (10) 3179
9.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 20088
61.5%
Dash Punctuation 5022
 
15.4%
Close Punctuation 2511
 
7.7%
Open Punctuation 2511
 
7.7%
Other Letter 2511
 
7.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 6284
31.3%
0 5649
28.1%
3 3176
15.8%
1 2021
 
10.1%
6 748
 
3.7%
5 506
 
2.5%
4 489
 
2.4%
9 487
 
2.4%
7 371
 
1.8%
8 357
 
1.8%
Other Letter
ValueCountFrequency (%)
토 805
32.1%
일 737
29.4%
수 248
 
9.9%
금 201
 
8.0%
월 200
 
8.0%
화 162
 
6.5%
목 158
 
6.3%
Dash Punctuation
ValueCountFrequency (%)
- 5022
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2511
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2511
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 30132
92.3%
Hangul 2511
 
7.7%

Most frequent character per script

Common
ValueCountFrequency (%)
2 6284
20.9%
0 5649
18.7%
- 5022
16.7%
3 3176
10.5%
) 2511
 
8.3%
( 2511
 
8.3%
1 2021
 
6.7%
6 748
 
2.5%
5 506
 
1.7%
4 489
 
1.6%
Other values (3) 1215
 
4.0%
Hangul
ValueCountFrequency (%)
토 805
32.1%
일 737
29.4%
수 248
 
9.9%
금 201
 
8.0%
월 200
 
8.0%
화 162
 
6.5%
목 158
 
6.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 30132
92.3%
Hangul 2511
 
7.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 6284
20.9%
0 5649
18.7%
- 5022
16.7%
3 3176
10.5%
) 2511
 
8.3%
( 2511
 
8.3%
1 2021
 
6.7%
6 748
 
2.5%
5 506
 
1.7%
4 489
 
1.6%
Other values (3) 1215
 
4.0%
Hangul
ValueCountFrequency (%)
토 805
32.1%
일 737
29.4%
수 248
 
9.9%
금 201
 
8.0%
월 200
 
8.0%
화 162
 
6.5%
목 158
 
6.3%

예약시작일시
Date

Distinct713
Distinct (%)28.4%
Missing0
Missing (%)0.0%
Memory size19.7 KiB
Minimum2023-01-07 13:00:00
Maximum2023-12-31 13:00:00
2024-03-15T10:24:07.240407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T10:24:07.676424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

예약종료일시
Date

Distinct713
Distinct (%)28.4%
Missing0
Missing (%)0.0%
Memory size19.7 KiB
Minimum2023-01-07 16:00:00
Maximum2023-12-31 16:00:00
2024-03-15T10:24:08.128586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T10:24:08.466784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

이용요금
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct10
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean36328.156
Minimum0
Maximum150000
Zeros1155
Zeros (%)46.0%
Negative0
Negative (%)0.0%
Memory size22.2 KiB
2024-03-15T10:24:08.848244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median40000
Q364000
95-th percentile80000
Maximum150000
Range150000
Interquartile range (IQR)64000

Descriptive statistics

Standard deviation35431.779
Coefficient of variation (CV)0.97532557
Kurtosis-1.5305213
Mean36328.156
Median Absolute Deviation (MAD)40000
Skewness0.15233653
Sum91220000
Variance1.255411 × 109
MonotonicityNot monotonic
2024-03-15T10:24:09.220886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
0 1155
46.0%
80000 534
21.3%
64000 483
19.2%
40000 191
 
7.6%
56000 88
 
3.5%
50000 26
 
1.0%
100000 22
 
0.9%
150000 6
 
0.2%
120000 4
 
0.2%
70000 2
 
0.1%
ValueCountFrequency (%)
0 1155
46.0%
40000 191
 
7.6%
50000 26
 
1.0%
56000 88
 
3.5%
64000 483
19.2%
70000 2
 
0.1%
80000 534
21.3%
100000 22
 
0.9%
120000 4
 
0.2%
150000 6
 
0.2%
ValueCountFrequency (%)
150000 6
 
0.2%
120000 4
 
0.2%
100000 22
 
0.9%
80000 534
21.3%
70000 2
 
0.1%
64000 483
19.2%
56000 88
 
3.5%
50000 26
 
1.0%
40000 191
 
7.6%
0 1155
46.0%

비고
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size19.7 KiB
화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사
997 
어린이,청소년,군인 감면
713 
<NA>
519 
국가,지방자치단체,지방의회,화성시 체육회 주최 또는 주관하는 경기 및 행사
147 
화성시 체육회 종목단체에 등록된 동호회
 
90
Other values (7)
 
45

Length

Max length43
Median length32
Mean length21.459578
Min length4

Unique

Unique2 ?
Unique (%)0.1%

Sample

1st row 화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사
2nd row 화성시 체육회 종목단체에 등록된 동호회
3rd row 화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사
4th row 화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사
5th row 화성시 체육회 종목단체에 등록된 동호회

Common Values

ValueCountFrequency (%)
화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사 997
39.7%
어린이,청소년,군인 감면 713
28.4%
<NA> 519
20.7%
국가,지방자치단체,지방의회,화성시 체육회 주최 또는 주관하는 경기 및 행사 147
 
5.9%
화성시 체육회 종목단체에 등록된 동호회 90
 
3.6%
75% 환불 (사용자사유) 15
 
0.6%
100% 환불 (천재지변_우천) 11
 
0.4%
1일4시간 10만원 기준. 초과시 시간당 20%가산 9
 
0.4%
상업용 촬영 5
 
0.2%
50% 환불 (사용자사유) 3
 
0.1%
Other values (2) 2
 
0.1%

Length

2024-03-15T10:24:09.666678image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
체육회 1234
10.5%
주최 1144
9.8%
또는 1144
9.8%
주관하는 1144
9.8%
경기 1144
9.8%
및 1144
9.8%
행사 1144
9.8%
화성시,화성시 997
8.5%
감면 713
6.1%
어린이,청소년,군인 713
6.1%
Other values (22) 1181
10.1%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size19.7 KiB
2023-12-31
2511 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-31
2nd row2023-12-31
3rd row2023-12-31
4th row2023-12-31
5th row2023-12-31

Common Values

ValueCountFrequency (%)
2023-12-31 2511
100.0%

Length

2024-03-15T10:24:10.074021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T10:24:10.372281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-31 2511
100.0%

Interactions

2024-03-15T10:24:01.332594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T10:24:00.802021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T10:24:01.614708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T10:24:01.060532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T10:24:10.554995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번구분단체명이용요금비고
연번1.0000.1970.6410.4360.616
구분0.1971.0000.7160.6370.451
단체명0.6410.7161.0000.9350.993
이용요금0.4360.6370.9351.0000.890
비고0.6160.4510.9930.8901.000
2024-03-15T10:24:10.821978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분비고단체명
구분1.0000.2320.361
비고0.2321.0000.843
단체명0.3610.8431.000
2024-03-15T10:24:11.065361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번이용요금구분단체명비고
연번1.0000.0090.0950.2580.318
이용요금0.0091.0000.2590.6970.703
구분0.0950.2591.0000.3610.232
단체명0.2580.6970.3611.0000.843
비고0.3180.7030.2320.8431.000

Missing values

2024-03-15T10:24:01.991449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T10:24:02.457202image/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리틀3화성시체육회2023-01-07(토)2023-01-07 13:002023-01-07 16:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
12주니어2화성시야구소프트볼협회2023-01-07(토)2023-01-07 13:002023-01-07 16:0056000화성시 체육회 종목단체에 등록된 동호회2023-12-31
23리틀3화성시체육회2023-01-08(일)2023-01-08 10:002023-01-08 13:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
34리틀3화성시체육회2023-01-08(일)2023-01-08 13:002023-01-08 16:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
45주니어2화성시야구소프트볼협회2023-01-08(일)2023-01-08 13:002023-01-08 16:0056000화성시 체육회 종목단체에 등록된 동호회2023-12-31
56주니어3화성시체육회2023-01-08(일)2023-01-08 13:002023-01-08 16:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
67리틀1군포시리틀야구단2023-01-10(화)2023-01-10 13:002023-01-10 16:0040000어린이,청소년,군인 감면2023-12-31
78리틀1군포시리틀야구단2023-01-11(수)2023-01-11 13:002023-01-11 16:0040000어린이,청소년,군인 감면2023-12-31
89리틀3화성시체육회2023-01-11(수)2023-01-11 10:002023-01-11 13:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
910리틀3화성시체육회2023-01-11(수)2023-01-11 13:002023-01-11 16:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
연번구분단체명신청일자예약시작일시예약종료일시이용요금비고데이터기준일자
25012502주니어2팀네이버스2023-12-17(일)2023-12-17 10:002023-12-17 13:008000075% 환불 (사용자사유)2023-12-31
25022503여성화푸야2023-12-17(일)2023-12-17 10:002023-12-17 13:0080000100% 환불 (천재지변_우천)2023-12-31
25032504여성화성시야구소프트볼협회2023-12-17(일)2023-12-17 13:002023-12-17 16:0056000화성시 체육회 종목단체에 등록된 동호회2023-12-31
25042505주니어1화성시체육회2023-12-23(토)2023-12-23 13:002023-12-23 16:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
25052506주니어3화성시체육회2023-12-23(토)2023-12-23 10:002023-12-23 13:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
25062507주니어3화성시체육회2023-12-23(토)2023-12-23 13:002023-12-23 16:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
25072508주니어1화성시체육회2023-12-24(일)2023-12-24 13:002023-12-24 16:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
25082509주니어3화성시체육회2023-12-30(토)2023-12-30 10:002023-12-30 13:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
25092510주니어3화성시체육회2023-12-30(토)2023-12-30 13:002023-12-30 16:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31
25102511주니어1화성시체육회2023-12-31(일)2023-12-31 13:002023-12-31 16:000화성시,화성시 체육회 주최 또는 주관하는 경기 및 행사2023-12-31