Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows21
Duplicate rows (%)0.2%
Total size in memory625.0 KiB
Average record size in memory64.0 B

Variable types

Categorical3
Text1
DateTime3

Dataset

Description경기도 화성시의 야외 체육시설 이용현황 입니다. 사용시설, 신청일자, 예약일시, 예약 종료일시, 이용요금을 확인할 수 있습니다.
Author화성도시공사
URLhttps://www.data.go.kr/data/15126951/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 21 (0.2%) duplicate rowsDuplicates

Reproduction

Analysis started2024-03-14 19:54:10.761929
Analysis finished2024-03-14 19:54:11.914713
Duration1.15 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

Distinct34
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
돌모루(동학산14호)축구장
967 
봉담2생태체육공원 축구장
813 
동학산(11호) 축구장
765 
반월체육센터 축구장
658 
동탄여울공원 축구장
 
531
Other values (29)
6266 

Length

Max length19
Median length16
Mean length11.6292
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row반월체육센터 축구장
2nd row치동천체육공원 축구장
3rd row봉담2생태체육공원 축구장
4th row동탄 소라공원 야구장
5th row동탄여울공원 축구장

Common Values

ValueCountFrequency (%)
돌모루(동학산14호)축구장 967
 
9.7%
봉담2생태체육공원 축구장 813
 
8.1%
동학산(11호) 축구장 765
 
7.6%
반월체육센터 축구장 658
 
6.6%
동탄여울공원 축구장 531
 
5.3%
비봉 축구장(1호) 484
 
4.8%
왕배산(신리천) 체육공원 축구장 469
 
4.7%
향남2지구 축구장 437
 
4.4%
다원이음터 축구장(다원중학교) 389
 
3.9%
쌍봉산근린공원 축구장 371
 
3.7%
Other values (24) 4116
41.2%

Length

2024-03-15T04:54:12.155947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
축구장 6725
34.2%
돌모루(동학산14호)축구장 967
 
4.9%
봉담2생태체육공원 813
 
4.1%
동학산(11호 765
 
3.9%
반월체육센터 658
 
3.3%
비봉 599
 
3.0%
동탄여울공원 531
 
2.7%
야구장 511
 
2.6%
축구장(1호 484
 
2.5%
왕배산(신리천 469
 
2.4%
Other values (32) 7127
36.3%

단체명
Text

Distinct380
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-15T04:54:13.352782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length3
Mean length4.5577
Min length2

Characters and Unicode

Total characters45577
Distinct characters332
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique83 ?
Unique (%)0.8%

Sample

1st row김**
2nd row허**
3rd rowf.c호랑이
4th row신**
5th row김**
ValueCountFrequency (%)
김 1260
 
11.1%
이 610
 
5.4%
화성시 585
 
5.1%
허 566
 
5.0%
화성시체육회 550
 
4.8%
체육회 539
 
4.7%
서부축구협회 378
 
3.3%
권 351
 
3.1%
화성fc 302
 
2.7%
관 244
 
2.1%
Other values (396) 5984
52.6%
2024-03-15T04:54:15.100559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
* 11226
24.6%
회 2059
 
4.5%
성 1803
 
4.0%
화 1784
 
3.9%
시 1476
 
3.2%
C 1436
 
3.2%
육 1425
 
3.1%
체 1424
 
3.1%
F 1400
 
3.1%
1378
 
3.0%
Other values (322) 20166
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 26616
58.4%
Other Punctuation 11289
24.8%
Uppercase Letter 4052
 
8.9%
Space Separator 1378
 
3.0%
Lowercase Letter 732
 
1.6%
Open Punctuation 599
 
1.3%
Close Punctuation 597
 
1.3%
Decimal Number 251
 
0.6%
Dash Punctuation 62
 
0.1%
Connector Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
회 2059
 
7.7%
성 1803
 
6.8%
화 1784
 
6.7%
시 1476
 
5.5%
육 1425
 
5.4%
체 1424
 
5.4%
구 1348
 
5.1%
김 1260
 
4.7%
부 925
 
3.5%
축 864
 
3.2%
Other values (260) 12248
46.0%
Uppercase Letter
ValueCountFrequency (%)
C 1436
35.4%
F 1400
34.6%
M 184
 
4.5%
G 164
 
4.0%
T 155
 
3.8%
N 94
 
2.3%
A 86
 
2.1%
J 73
 
1.8%
H 72
 
1.8%
S 71
 
1.8%
Other values (13) 317
 
7.8%
Lowercase Letter
ValueCountFrequency (%)
f 98
13.4%
c 94
12.8%
r 60
8.2%
a 55
7.5%
t 52
 
7.1%
n 52
 
7.1%
e 50
 
6.8%
i 48
 
6.6%
o 47
 
6.4%
s 42
 
5.7%
Other values (12) 134
18.3%
Decimal Number
ValueCountFrequency (%)
5 90
35.9%
1 69
27.5%
3 36
 
14.3%
0 33
 
13.1%
2 13
 
5.2%
8 3
 
1.2%
9 3
 
1.2%
4 2
 
0.8%
6 2
 
0.8%
Other Punctuation
ValueCountFrequency (%)
* 11226
99.4%
. 57
 
0.5%
# 6
 
0.1%
Space Separator
ValueCountFrequency (%)
1378
100.0%
Open Punctuation
ValueCountFrequency (%)
( 599
100.0%
Close Punctuation
ValueCountFrequency (%)
) 597
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 62
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 26616
58.4%
Common 14177
31.1%
Latin 4784
 
10.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
회 2059
 
7.7%
성 1803
 
6.8%
화 1784
 
6.7%
시 1476
 
5.5%
육 1425
 
5.4%
체 1424
 
5.4%
구 1348
 
5.1%
김 1260
 
4.7%
부 925
 
3.5%
축 864
 
3.2%
Other values (260) 12248
46.0%
Latin
ValueCountFrequency (%)
C 1436
30.0%
F 1400
29.3%
M 184
 
3.8%
G 164
 
3.4%
T 155
 
3.2%
f 98
 
2.0%
N 94
 
2.0%
c 94
 
2.0%
A 86
 
1.8%
J 73
 
1.5%
Other values (35) 1000
20.9%
Common
ValueCountFrequency (%)
* 11226
79.2%
1378
 
9.7%
( 599
 
4.2%
) 597
 
4.2%
5 90
 
0.6%
1 69
 
0.5%
- 62
 
0.4%
. 57
 
0.4%
3 36
 
0.3%
0 33
 
0.2%
Other values (7) 30
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 26616
58.4%
ASCII 18961
41.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
* 11226
59.2%
C 1436
 
7.6%
F 1400
 
7.4%
1378
 
7.3%
( 599
 
3.2%
) 597
 
3.1%
M 184
 
1.0%
G 164
 
0.9%
T 155
 
0.8%
f 98
 
0.5%
Other values (52) 1724
 
9.1%
Hangul
ValueCountFrequency (%)
회 2059
 
7.7%
성 1803
 
6.8%
화 1784
 
6.7%
시 1476
 
5.5%
육 1425
 
5.4%
체 1424
 
5.4%
구 1348
 
5.1%
김 1260
 
4.7%
부 925
 
3.5%
축 864
 
3.2%
Other values (260) 12248
46.0%

신청일자
Date

Distinct370
Distinct (%)3.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-12-17 00:00:00
Maximum2023-12-31 00:00:00
2024-03-15T04:54:15.504498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T04:54:15.985995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

예약시작일시
Date

Distinct2542
Distinct (%)25.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 06:00:00
Maximum2023-12-31 20:00:00
2024-03-15T04:54:16.393457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T04:54:16.830173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

예약종료일시
Date

Distinct2364
Distinct (%)23.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 08:00:00
Maximum2023-12-31 22:00:00
2024-03-15T04:54:17.201632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T04:54:17.633187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

이용요금
Categorical

Distinct45
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0
3650 
60000
970 
60,000
650 
42000
557 
50,000
539 
Other values (40)
3634 

Length

Max length7
Median length6
Mean length3.8745
Min length1

Unique

Unique7 ?
Unique (%)0.1%

Sample

1st row60,000
2nd row42,000
3rd row80000
4th row0
5th row0

Common Values

ValueCountFrequency (%)
0 3650
36.5%
60000 970
 
9.7%
60,000 650
 
6.5%
42000 557
 
5.6%
50,000 539
 
5.4%
40000 372
 
3.7%
42,000 368
 
3.7%
35,000 331
 
3.3%
30,000 322
 
3.2%
40,000 283
 
2.8%
Other values (35) 1958
19.6%

Length

2024-03-15T04:54:18.089996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
0 3650
36.5%
60000 970
 
9.7%
60,000 650
 
6.5%
42000 557
 
5.6%
50,000 539
 
5.4%
40000 372
 
3.7%
42,000 368
 
3.7%
35,000 331
 
3.3%
30,000 322
 
3.2%
40,000 283
 
2.8%
Other values (35) 1958
19.6%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-31
10000 

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 10000
100.0%

Length

2024-03-15T04:54:18.484549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T04:54:18.786157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-31 10000
100.0%

Correlations

2024-03-15T04:54:18.957022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분이용요금
구분1.0000.872
이용요금0.8721.000
2024-03-15T04:54:19.254526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분이용요금
구분1.0000.340
이용요금0.3401.000
2024-03-15T04:54:19.484985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분이용요금
구분1.0000.340
이용요금0.3401.000

Missing values

2024-03-15T04:54:11.508586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T04:54:11.732981image/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

구분단체명신청일자예약시작일시예약종료일시이용요금데이터기준일자
4281반월체육센터 축구장김**2023-08-172023-08-17 20:002023-08-17 22:0060,0002023-12-31
790치동천체육공원 축구장허**2023-03-012023-03-01 08:002023-03-01 10:0042,0002023-12-31
12251봉담2생태체육공원 축구장f.c호랑이2023-09-252023-10-06 06:002023-10-06 16:00800002023-12-31
2632동탄 소라공원 야구장신**2023-05-252023-05-25 19:002023-05-25 22:0002023-12-31
6761동탄여울공원 축구장김**2023-12-142023-12-14 18:002023-12-14 20:0002023-12-31
1819왕배산(신리천) 체육공원 축구장라**2023-04-202023-04-20 20:002023-04-20 22:0050,0002023-12-31
444동탄여울공원 축구장김**2023-02-102023-02-10 20:002023-02-10 22:00600002023-12-31
7733쌍봉산근린공원 축구장백**2023-02-082023-02-12 14:002023-02-12 16:00600002023-12-31
4484다원이음터 축구장(다원중학교)박**2023-08-272023-08-27 18:002023-08-27 20:0070,0002023-12-31
10785송산 축구장송**2023-07-042023-07-08 20:002023-07-08 22:00600002023-12-31
구분단체명신청일자예약시작일시예약종료일시이용요금데이터기준일자
10249봉선체육공원(송린중학교) 축구장체육시설2023-05-112023-06-05 16:002023-06-05 20:0002023-12-31
5449돌모루(동학산14호)축구장권**2023-10-152023-10-15 08:002023-10-15 10:0035,0002023-12-31
7942장안2첨단산업단지 축구장ABIMAN FC2023-02-282023-03-07 18:002023-03-07 20:00300002023-12-31
12596매송체육공원 축구장체육시설2023-09-142023-10-22 08:002023-10-22 10:0002023-12-31
3439동학산(11호) 축구장권**2023-07-012023-07-01 10:002023-07-01 12:0042,0002023-12-31
1130송방천 축구장김**2023-03-182023-03-18 20:002023-03-18 22:0060,0002023-12-31
336돌모루(동학산14호)축구장곽**2023-02-042023-02-04 06:002023-02-04 08:00490002023-12-31
11225비봉 축구장(1호)화성FC2023-07-182023-08-06 08:002023-08-06 12:0002023-12-31
6750송방천 축구장정**2023-12-132023-12-13 18:002023-12-13 20:0030,0002023-12-31
12071남양체육공원 축구장체육시설2023-08-182023-09-23 13:002023-09-23 16:0002023-12-31

Duplicate rows

Most frequently occurring

구분단체명신청일자예약시작일시예약종료일시이용요금데이터기준일자# duplicates
7동학산(11호) 축구장김**2023-10-152023-10-15 16:002023-10-15 18:0002023-12-313
0남양체육공원 축구장서부축구협회2023-04-242023-05-03 18:002023-05-03 20:00420002023-12-312
1남양체육공원 축구장서부축구협회2023-06-232023-07-19 18:002023-07-19 20:00420002023-12-312
2남양체육공원 축구장서부축구협회2023-09-232023-10-25 18:002023-10-25 20:00420002023-12-312
3남양체육공원 축구장서부축구협회2023-11-232023-12-06 18:002023-12-06 20:00420002023-12-312
4다람산 축구장민**2023-08-292023-08-29 10:002023-08-29 12:0020,0002023-12-312
5도원체육공원 축구장화랑FC2023-04-252023-05-02 20:002023-05-02 22:00600002023-12-312
6돌모루(동학산14호)축구장임**2023-07-032023-07-03 08:002023-07-03 10:0030,0002023-12-312
8매송체육공원 축구장매**2023-09-282023-10-23 16:002023-10-23 18:00300002023-12-312
9봉담2생태체육공원 축구장화성시 체육회2023-04-242023-05-17 18:002023-05-17 20:0002023-12-312