Overview

Dataset statistics

Number of variables12
Number of observations27
Missing cells135
Missing cells (%)41.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory106.9 B

Variable types

Numeric1
Text3
Categorical3
Unsupported5

Dataset

Description전북해양수상레저사업장현황_201807
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=201921

Alerts

자료출처 has constant value ""Constant
Unnamed: 7 has 27 (100.0%) missing valuesMissing
Unnamed: 8 has 27 (100.0%) missing valuesMissing
Unnamed: 9 has 27 (100.0%) missing valuesMissing
Unnamed: 10 has 27 (100.0%) missing valuesMissing
Unnamed: 11 has 27 (100.0%) missing valuesMissing
연번 has unique valuesUnique
상호명 has unique valuesUnique
연락처 has unique valuesUnique
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 00:10:34.631286
Analysis finished2024-03-14 00:10:35.156317
Duration0.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14
Minimum1
Maximum27
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size375.0 B
2024-03-14T09:10:35.207909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.3
Q17.5
median14
Q320.5
95-th percentile25.7
Maximum27
Range26
Interquartile range (IQR)13

Descriptive statistics

Standard deviation7.9372539
Coefficient of variation (CV)0.56694671
Kurtosis-1.2
Mean14
Median Absolute Deviation (MAD)7
Skewness0
Sum378
Variance63
MonotonicityStrictly increasing
2024-03-14T09:10:35.338459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
1 1
 
3.7%
2 1
 
3.7%
27 1
 
3.7%
26 1
 
3.7%
25 1
 
3.7%
24 1
 
3.7%
23 1
 
3.7%
22 1
 
3.7%
21 1
 
3.7%
20 1
 
3.7%
Other values (17) 17
63.0%
ValueCountFrequency (%)
1 1
3.7%
2 1
3.7%
3 1
3.7%
4 1
3.7%
5 1
3.7%
6 1
3.7%
7 1
3.7%
8 1
3.7%
9 1
3.7%
10 1
3.7%
ValueCountFrequency (%)
27 1
3.7%
26 1
3.7%
25 1
3.7%
24 1
3.7%
23 1
3.7%
22 1
3.7%
21 1
3.7%
20 1
3.7%
19 1
3.7%
18 1
3.7%

주소
Text

Distinct26
Distinct (%)96.3%
Missing0
Missing (%)0.0%
Memory size348.0 B
2024-03-14T09:10:35.530633image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length18
Mean length16.444444
Min length13

Characters and Unicode

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

Unique

Unique25 ?
Unique (%)92.6%

Sample

1st row부안군 변산면 격포리 288-1
2nd row부안군 변산면 운산리 441-13
3rd row부안군 변산면 도청리 203-110
4th row고창군 상하면 자룡리 529-20
5th row군산시 옥도면 대장도리 18
ValueCountFrequency (%)
무주군 14
 
12.8%
부남면 11
 
10.1%
부안군 4
 
3.7%
무금로 4
 
3.7%
옥도면 3
 
2.8%
변산면 3
 
2.8%
군산시 3
 
2.8%
하굴암길 2
 
1.8%
85 2
 
1.8%
무주읍 2
 
1.8%
Other values (59) 61
56.0%
2024-03-14T09:10:35.829155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
82
18.5%
24
 
5.4%
24
 
5.4%
1 22
 
5.0%
20
 
4.5%
18
 
4.1%
16
 
3.6%
2 16
 
3.6%
14
 
3.2%
11
 
2.5%
Other values (62) 197
44.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 262
59.0%
Decimal Number 90
 
20.3%
Space Separator 82
 
18.5%
Dash Punctuation 10
 
2.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
24
 
9.2%
24
 
9.2%
20
 
7.6%
18
 
6.9%
16
 
6.1%
14
 
5.3%
11
 
4.2%
9
 
3.4%
8
 
3.1%
8
 
3.1%
Other values (50) 110
42.0%
Decimal Number
ValueCountFrequency (%)
1 22
24.4%
2 16
17.8%
5 10
11.1%
3 10
11.1%
8 10
11.1%
0 6
 
6.7%
4 5
 
5.6%
6 5
 
5.6%
9 4
 
4.4%
7 2
 
2.2%
Space Separator
ValueCountFrequency (%)
82
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 262
59.0%
Common 182
41.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
24
 
9.2%
24
 
9.2%
20
 
7.6%
18
 
6.9%
16
 
6.1%
14
 
5.3%
11
 
4.2%
9
 
3.4%
8
 
3.1%
8
 
3.1%
Other values (50) 110
42.0%
Common
ValueCountFrequency (%)
82
45.1%
1 22
 
12.1%
2 16
 
8.8%
5 10
 
5.5%
- 10
 
5.5%
3 10
 
5.5%
8 10
 
5.5%
0 6
 
3.3%
4 5
 
2.7%
6 5
 
2.7%
Other values (2) 6
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 262
59.0%
ASCII 182
41.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
82
45.1%
1 22
 
12.1%
2 16
 
8.8%
5 10
 
5.5%
- 10
 
5.5%
3 10
 
5.5%
8 10
 
5.5%
0 6
 
3.3%
4 5
 
2.7%
6 5
 
2.7%
Other values (2) 6
 
3.3%
Hangul
ValueCountFrequency (%)
24
 
9.2%
24
 
9.2%
20
 
7.6%
18
 
6.9%
16
 
6.1%
14
 
5.3%
11
 
4.2%
9
 
3.4%
8
 
3.1%
8
 
3.1%
Other values (50) 110
42.0%

상호명
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2024-03-14T09:10:36.006042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length10
Mean length6.8888889
Min length4

Characters and Unicode

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

Unique

Unique27 ?
Unique (%)100.0%

Sample

1st row채석강수상레저
2nd row고사포수상레저
3rd row모항 수상레저
4th row구시포 레저
5th rowgo군산마린
ValueCountFrequency (%)
채석강수상레저 1
 
2.9%
금강파워레저 1
 
2.9%
줄포만갯벌생태공원 1
 
2.9%
금강래프팅 1
 
2.9%
무주스피드레저 1
 
2.9%
금강레저클럽 1
 
2.9%
무주래프팅 1
 
2.9%
무주레저클럽 1
 
2.9%
반딧불레저 1
 
2.9%
고사포수상레저 1
 
2.9%
Other values (24) 24
70.6%
2024-03-14T09:10:36.335629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
18
 
9.7%
14
 
7.5%
7
 
3.8%
7
 
3.8%
7
 
3.8%
6
 
3.2%
5
 
2.7%
5
 
2.7%
5
 
2.7%
5
 
2.7%
Other values (75) 107
57.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 175
94.1%
Space Separator 7
 
3.8%
Lowercase Letter 2
 
1.1%
Close Punctuation 1
 
0.5%
Open Punctuation 1
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
18
 
10.3%
14
 
8.0%
7
 
4.0%
7
 
4.0%
6
 
3.4%
5
 
2.9%
5
 
2.9%
5
 
2.9%
5
 
2.9%
4
 
2.3%
Other values (70) 99
56.6%
Lowercase Letter
ValueCountFrequency (%)
g 1
50.0%
o 1
50.0%
Space Separator
ValueCountFrequency (%)
7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 175
94.1%
Common 9
 
4.8%
Latin 2
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
18
 
10.3%
14
 
8.0%
7
 
4.0%
7
 
4.0%
6
 
3.4%
5
 
2.9%
5
 
2.9%
5
 
2.9%
5
 
2.9%
4
 
2.3%
Other values (70) 99
56.6%
Common
ValueCountFrequency (%)
7
77.8%
) 1
 
11.1%
( 1
 
11.1%
Latin
ValueCountFrequency (%)
g 1
50.0%
o 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 175
94.1%
ASCII 11
 
5.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
18
 
10.3%
14
 
8.0%
7
 
4.0%
7
 
4.0%
6
 
3.4%
5
 
2.9%
5
 
2.9%
5
 
2.9%
5
 
2.9%
4
 
2.3%
Other values (70) 99
56.6%
ASCII
ValueCountFrequency (%)
7
63.6%
) 1
 
9.1%
g 1
 
9.1%
o 1
 
9.1%
( 1
 
9.1%

연락처
Text

UNIQUE 

Distinct27
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size348.0 B
2024-03-14T09:10:36.534019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length12
Mean length12.37037
Min length12

Characters and Unicode

Total characters334
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique27 ?
Unique (%)100.0%

Sample

1st row010-4583-7229
2nd row010-7108-0012
3rd row010-3673-5706
4th row010-4654-0862
5th row010-6880-9944
ValueCountFrequency (%)
010-4583-7229 1
 
3.7%
063-322-2762 1
 
3.7%
063-322-3388 1
 
3.7%
010-9640-5400 1
 
3.7%
063-323-5882 1
 
3.7%
010-9555-1992 1
 
3.7%
063-323-8000 1
 
3.7%
063-322-6522 1
 
3.7%
063-322-6607 1
 
3.7%
063-322-2076 1
 
3.7%
Other values (17) 17
63.0%
2024-03-14T09:10:36.831206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 56
16.8%
- 54
16.2%
3 42
12.6%
2 35
10.5%
6 34
10.2%
1 26
7.8%
4 21
 
6.3%
7 19
 
5.7%
8 18
 
5.4%
5 17
 
5.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 280
83.8%
Dash Punctuation 54
 
16.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 56
20.0%
3 42
15.0%
2 35
12.5%
6 34
12.1%
1 26
9.3%
4 21
 
7.5%
7 19
 
6.8%
8 18
 
6.4%
5 17
 
6.1%
9 12
 
4.3%
Dash Punctuation
ValueCountFrequency (%)
- 54
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 334
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 56
16.8%
- 54
16.2%
3 42
12.6%
2 35
10.5%
6 34
10.2%
1 26
7.8%
4 21
 
6.3%
7 19
 
5.7%
8 18
 
5.4%
5 17
 
5.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 334
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 56
16.8%
- 54
16.2%
3 42
12.6%
2 35
10.5%
6 34
10.2%
1 26
7.8%
4 21
 
6.3%
7 19
 
5.7%
8 18
 
5.4%
5 17
 
5.1%

운영기간
Categorical

Distinct9
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Memory size348.0 B
연중
16 
임시휴업
‘16. 5. 3~’26. 5. 2
 
1
‘18. 5. 8~’18. 8.31
 
1
‘18. 7.20~’18. 8.19
 
1
Other values (4)

Length

Max length20
Median length2
Mean length6.7407407
Min length2

Unique

Unique7 ?
Unique (%)25.9%

Sample

1st row‘16. 5. 3~’26. 5. 2
2nd row‘18. 5. 8~’18. 8.31
3rd row‘18. 7.20~’18. 8.19
4th row‘18. 7.20.~’18. 8.20
5th row’18. 5.30~’23. 5.29

Common Values

ValueCountFrequency (%)
연중 16
59.3%
임시휴업 4
 
14.8%
‘16. 5. 3~’26. 5. 2 1
 
3.7%
‘18. 5. 8~’18. 8.31 1
 
3.7%
‘18. 7.20~’18. 8.19 1
 
3.7%
‘18. 7.20.~’18. 8.20 1
 
3.7%
’18. 5.30~’23. 5.29 1
 
3.7%
’18. 7.20~’19. 7.19 1
 
3.7%
’18. 7.20~’20. 5.31 1
 
3.7%

Length

2024-03-14T09:10:36.962019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T09:10:37.064788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
연중 16
36.4%
임시휴업 4
 
9.1%
5 3
 
6.8%
‘18 3
 
6.8%
’18 3
 
6.8%
8.20 1
 
2.3%
7.20~’20 1
 
2.3%
7.19 1
 
2.3%
7.20~’19 1
 
2.3%
5.29 1
 
2.3%
Other values (10) 10
22.7%

비고
Categorical

Distinct4
Distinct (%)14.8%
Missing0
Missing (%)0.0%
Memory size348.0 B
<NA>
12 
연중
10 
한시
임시휴업
 
1

Length

Max length4
Median length2
Mean length2.962963
Min length2

Unique

Unique1 ?
Unique (%)3.7%

Sample

1st row연중
2nd row한시
3rd row한시
4th row한시
5th row한시

Common Values

ValueCountFrequency (%)
<NA> 12
44.4%
연중 10
37.0%
한시 4
 
14.8%
임시휴업 1
 
3.7%

Length

2024-03-14T09:10:37.174969image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/