Overview

Dataset statistics

Number of variables4
Number of observations38
Missing cells20
Missing cells (%)13.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 KiB
Average record size in memory36.5 B

Variable types

Text2
Numeric1
DateTime1

Dataset

Description경상남도 사천시 문화관광홈페이지의 사천의길 테이블의 내용(제목,내용,조회수, 등록일)에 대한 등록 자료(영어)입니다.
Author경상남도 사천시
URLhttps://www.data.go.kr/data/15084153/fileData.do

Alerts

내용 has 20 (52.6%) missing valuesMissing
조회수 has 18 (47.4%) zerosZeros

Reproduction

Analysis started2023-12-12 12:42:59.568055
Analysis finished2023-12-12 12:43:00.132652
Duration0.56 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

제목
Text

Distinct35
Distinct (%)92.1%
Missing0
Missing (%)0.0%
Memory size436.0 B
2023-12-12T21:43:00.341367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length29.5
Mean length22.210526
Min length10

Characters and Unicode

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

Unique

Unique32 ?
Unique (%)84.2%

Sample

1st rowSamcheonpo Bridge Yeongnyeon Festival
2nd rowSacheon City Hall
3rd rowDasolsa (Temple)
4th rowMt. Bongmyeongsan
5th rowSacheoneupseong
ValueCountFrequency (%)
sacheon 8
 
7.5%
museum 5
 
4.7%
park 4
 
3.7%
mt 3
 
2.8%
bridge 3
 
2.8%
samcheonpo 3
 
2.8%
soup 3
 
2.8%
aerospace 2
 
1.9%
bakyeonmuk 2
 
1.9%
city 2
 
1.9%
Other values (66) 72
67.3%
2023-12-12T21:43:00.814708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
e 86
 
10.2%
o 73
 
8.6%
69
 
8.2%
a 65
 
7.7%
n 62
 
7.3%
s 41
 
4.9%
i 35
 
4.1%
r 31
 
3.7%
u 31
 
3.7%
c 30
 
3.6%
Other values (40) 321
38.0%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 673
79.7%
Uppercase Letter 84
 
10.0%
Space Separator 69
 
8.2%
Other Punctuation 6
 
0.7%
Open Punctuation 4
 
0.5%
Close Punctuation 4
 
0.5%
Dash Punctuation 4
 
0.5%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 86
12.8%
o 73
 
10.8%
a 65
 
9.7%
n 62
 
9.2%
s 41
 
6.1%
i 35
 
5.2%
r 31
 
4.6%
u 31
 
4.6%
c 30
 
4.5%
h 29
 
4.3%
Other values (14) 190
28.2%
Uppercase Letter
ValueCountFrequency (%)
S 20
23.8%
B 12
14.3%
M 9
10.7%
C 6
 
7.1%
H 5
 
6.0%
E 4
 
4.8%
P 4
 
4.8%
F 3
 
3.6%
J 3
 
3.6%
I 3
 
3.6%
Other values (8) 15
17.9%
Other Punctuation
ValueCountFrequency (%)
. 3
50.0%
· 1
 
16.7%
, 1
 
16.7%
! 1
 
16.7%
Space Separator
ValueCountFrequency (%)
69
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 757
89.7%
Common 87
 
10.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 86
 
11.4%
o 73
 
9.6%
a 65
 
8.6%
n 62
 
8.2%
s 41
 
5.4%
i 35
 
4.6%
r 31
 
4.1%
u 31
 
4.1%
c 30
 
4.0%
h 29
 
3.8%
Other values (32) 274
36.2%
Common
ValueCountFrequency (%)
69
79.3%
( 4
 
4.6%
) 4
 
4.6%
- 4
 
4.6%
. 3
 
3.4%
· 1
 
1.1%
, 1
 
1.1%
! 1
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 843
99.9%
None 1
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
e 86
 
10.2%
o 73
 
8.7%
69
 
8.2%
a 65
 
7.7%
n 62
 
7.4%
s 41
 
4.9%
i 35
 
4.2%
r 31
 
3.7%
u 31
 
3.7%
c 30
 
3.6%
Other values (39) 320
38.0%
None
ValueCountFrequency (%)
· 1
100.0%

내용
Text

MISSING 

Distinct15
Distinct (%)83.3%
Missing20
Missing (%)52.6%
Memory size436.0 B
2023-12-12T21:43:01.087724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length1024
Median length654.5
Mean length440.72222
Min length12

Characters and Unicode

Total characters7933
Distinct characters64
Distinct categories8 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique14 ?
Unique (%)77.8%

Sample

1st rowIn the middle of Shilan sunset glow ed as one of nine most beautiful sunsets of Korea by Korea Tourism Organization and clear blue Hallyeosudo stands Samcheonpo Bridge, the winner of grand prize in Koreas 100 Beautiful Roads. Samcheonpo Bridge Yeongnyeon Festival is held every January 1st. Yeongnyeon Festival has the advantage of the most beautiful water way in Korea. It runs a separate event areas to prevent congestion of cars and crowds from Yeongyeon event areas. Many visitors coming from the Seoul metropolitan areas seek this festival.Yeongnyeon festival starts with the performance of Sorinuri (traditional percussion band) and features drum performace Mondeumbuk byt Sacheon Culture Center traditional art team. Fireworks are shot in front of Dongseodong Daebang military port to celebrate the coming of the New Year. Visitors gather to see the beautiful fireworks.
2nd rowWith the winter coldness creeping over, you hanker for that one dish that will keep you warm. Warm dishes include soup, stews, etc. Here we introduce you to cubed snail fish soup that you can only taste in the winter. The refreshing taste of fresh cubed snail fish caught in the front waters of Samcheonpo is the representative food of Sacheon. Here is a picture for your delight!Cubed snail fish soup that is made with the freshest cubed snail fish caught in the morning at Samcheonpo Sea boasts superb taste and texture incomparable to any cubed snail fish of other regions.Cubed snail fish soup is rich in calcium, iron, and Vitamin B easing your stomach and detoxifying after a night of drinking. Its also low in fat and high in protein, an ideal dish for ladies. Rich in nutritious ingredients, it will help prevent colds and also diabetes.
3rd rowIf you are hungover from the previous night of drinking or if you feel bloated from a heavy meal, you will naturally crave this refreshing blowfish soup. As this blowfish soup is boiled using only the freshest blowfish caught in the front shores of Sacheon, it has very unique freshness that you will not taste anywhere else. This representative specialty of Sacheon tastes just as good as it looks!The best season for blowfish is from December to February.The freshness and superb taste of blowfish caught by the fishermen of Samcheonpo is only available here.Blowfish has life-threatening poison, however, when the poison is effectively removed, it is very nutritious. Methionine and taurine help detoxifying action of liver and ideal for post hangover.
4th rowIf you like seafood, you will undoubtedly want to taste little bit of everything thats good. The Sachoen seafood set meal is ideal for you. It contains all the fresh ingredients caught in the seas of Sacheon!Seafood set meal includes season fresh ingredients and you can taste various sea products in this one meal. The sashimi of the season fresh fish will delight your taste buds followed by 20 different types of banchan, four types of vegetables. Except the vegetables, everything on the table is directly from the sea. Just one look of it enough to make your mouth water. The meal is replete with all types of sea products, roasted fish and fish soup, etc.
5th rowMulhwe (water sashimi) is a unique variation of sashimi. Mulhwe (water sashimi) is self-explanatory in that you dip sashimi into water. The fresh fish caught in Sacheon Sea is added to vegetables, spicy red pepper sauce, and ice cubes in this representative dish of Sacheon Mulhwe (water sashimi). Here is a peak look at its freshness!Sacheon Sea has strong currents and deep waters which lends for chewy texture of the fish meat. Mulhwe (water sashimi) is a specialty that develops only in places such as Sacheon where the fish cath is abundant.Especially, in spring and summer, visitors from all over Korea line up to taste the special Sacheon Mulhwe (water sashimi).
ValueCountFrequency (%)
the 78
 
5.9%
of 54
 
4.1%
and 46
 
3.5%
is 35
 
2.7%
in 31
 
2.4%
to 24
 
1.8%
for 20
 
1.5%
a 19
 
1.4%
you 15
 
1.1%
this 14
 
1.1%
Other values (546) 981
74.5%
2023-12-12T21:43:01.499632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1300
16.4%
e 779
 
9.8%
a 545
 
6.9%
o 510
 
6.4%
t 497
 
6.3%
s 465
 
5.9%
n 461
 
5.8%
i 447
 
5.6%
r 375
 
4.7%
h 332
 
4.2%
Other values (54) 2222
28.0%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 6243
78.7%
Space Separator 1300
 
16.4%
Uppercase Letter 202
 
2.5%
Other Punctuation 125
 
1.6%
Decimal Number 31
 
0.4%
Open Punctuation 11
 
0.1%
Close Punctuation 11
 
0.1%
Dash Punctuation 10
 
0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 779
12.5%
a 545
 
8.7%
o 510
 
8.2%
t 497
 
8.0%
s 465
 
7.4%
n 461
 
7.4%
i 447
 
7.2%
r 375
 
6.0%
h 332
 
5.3%
l 249
 
4.0%
Other values (16) 1583
25.4%
Uppercase Letter
ValueCountFrequency (%)
S 49
24.3%
T 21
10.4%
B 14
 
6.9%
I 14
 
6.9%
F 12
 
5.9%
K 10
 
5.0%
J 9
 
4.5%
M 9
 
4.5%
C 8
 
4.0%
H 7
 
3.5%
Other values (12) 49
24.3%
Decimal Number
ValueCountFrequency (%)
0 13
41.9%
1 6
19.4%
2 4
 
12.9%
3 2
 
6.5%
4 2
 
6.5%
6 1
 
3.2%
7 1
 
3.2%
5 1
 
3.2%
9 1
 
3.2%
Other Punctuation
ValueCountFrequency (%)
. 71
56.8%
, 48
38.4%
! 6
 
4.8%
Space Separator
ValueCountFrequency (%)
1300
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 10
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 6445
81.2%
Common 1488
 
18.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 779
12.1%
a 545
 
8.5%
o 510
 
7.9%
t 497
 
7.7%
s 465
 
7.2%
n 461
 
7.2%
i 447
 
6.9%
r 375
 
5.8%
h 332
 
5.2%
l 249
 
3.9%
Other values (38) 1785
27.7%
Common
ValueCountFrequency (%)
1300
87.4%
. 71
 
4.8%
, 48
 
3.2%
0 13
 
0.9%
( 11
 
0.7%
) 11
 
0.7%
- 10
 
0.7%
1 6
 
0.4%
! 6
 
0.4%
2 4
 
0.3%
Other values (6) 8
 
0.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 7933
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1300
16.4%
e 779
 
9.8%
a 545
 
6.9%
o 510
 
6.4%
t 497
 
6.3%
s 465
 
5.9%
n 461
 
5.8%
i 447
 
5.6%
r 375
 
4.7%
h 332
 
4.2%
Other values (54) 2222
28.0%

조회수
Real number (ℝ)

ZEROS 

Distinct19
Distinct (%)50.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean79.105263
Minimum0
Maximum198
Zeros18
Zeros (%)47.4%
Negative0
Negative (%)0.0%
Memory size474.0 B
2023-12-12T21:43:01.662729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median8
Q3174.25
95-th percentile187.65
Maximum198
Range198
Interquartile range (IQR)174.25

Descriptive statistics

Standard deviation88.027265
Coefficient of variation (CV)1.1127865
Kurtosis-2.0122581
Mean79.105263
Median Absolute Deviation (MAD)8
Skewness0.2427195
Sum3006
Variance7748.7994
MonotonicityNot monotonic
2023-12-12T21:43:01.812569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=19)
ValueCountFrequency (%)
0 18
47.4%
172 2
 
5.3%
177 2
 
5.3%
180 1
 
2.6%
198 1
 
2.6%
11 1
 
2.6%
7 1
 
2.6%
197 1
 
2.6%
181 1
 
2.6%
9 1
 
2.6%
Other values (9) 9
23.7%
ValueCountFrequency (%)
0 18
47.4%
7 1
 
2.6%
9 1
 
2.6%
11 1
 
2.6%
156 1
 
2.6%
158 1
 
2.6%
161 1
 
2.6%
165 1
 
2.6%
169 1
 
2.6%
172 2
 
5.3%
ValueCountFrequency (%)
198 1
2.6%
197 1
2.6%
186 1
2.6%
181 1
2.6%
180 1
2.6%
179 1
2.6%
177 2
5.3%
176 1
2.6%
175 1
2.6%
172 2
5.3%

등록일
Date

Distinct4
Distinct (%)10.5%
Missing0
Missing (%)0.0%
Memory size436.0 B
Minimum2013-06-17 00:00:00
Maximum2013-07-03 00:00:00
2023-12-12T21:43:01.936045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:43:02.029267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=4)

Interactions

2023-12-12T21:42:59.793151image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T21:43:02.122261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
제목내용조회수등록일
제목1.0001.0000.0000.758
내용1.0001.000NaN1.000
조회수0.000NaN1.0000.827
등록일0.7581.0000.8271.000

Missing values

2023-12-12T21:42:59.971892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:43:00.091383image/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

제목내용조회수등록일
0Samcheonpo Bridge Yeongnyeon FestivalIn the middle of Shilan sunset glow ed as one of nine most beautiful sunsets of Korea by Korea Tourism Organization and clear blue Hallyeosudo stands Samcheonpo Bridge, the winner of grand prize in Koreas 100 Beautiful Roads. Samcheonpo Bridge Yeongnyeon Festival is held every January 1st. Yeongnyeon Festival has the advantage of the most beautiful water way in Korea. It runs a separate event areas to prevent congestion of cars and crowds from Yeongyeon event areas. Many visitors coming from the Seoul metropolitan areas seek this festival.Yeongnyeon festival starts with the performance of Sorinuri (traditional percussion band) and features drum performace Mondeumbuk byt Sacheon Culture Center traditional art team. Fireworks are shot in front of Dongseodong Daebang military port to celebrate the coming of the New Year. Visitors gather to see the beautiful fireworks.02013-06-17
1Sacheon City Hall<NA>1792013-06-24
2Dasolsa (Temple)<NA>1612013-06-24
3Mt. Bongmyeongsan<NA>1802013-06-24
4Sacheoneupseong<NA>1582013-06-24
5Changseon·Samcheonpo Bridge<NA>1762013-06-24
6Samcheonpo Bridge Park<NA>1652013-06-24
7Sacheon Seonjinri-seong (fort)<NA>1562013-06-24
8ilannakjo coastal road (Sunset)<NA>1692013-06-24
9Mt. Waryongsan<NA>1722013-06-24
제목내용조회수등록일
28City of Aerospace Industries, Sacheon!on the anvil02013-07-01
29Shinsu IslandSed as 10 best islands of Korea BeSacheont (by Ministry of Public Administration and Security in June 2010), this islands is the largest of the six man-inhabiting islands of Sacheon. After the Japanese takeover of Korea, the fishermen learned to use the tendons of a whale for fishing line. This led to advances of fishing technique in the island and to this day, this island serves as an important fishing ground for the whole country.02013-07-01
30Park Jaesam literature museumPark Jaesams profound world of poetry!Park Jaesam wrote poetry that truly shows the beauty of the Korean language more than any other poet. He created unique rhythm that combined the sound and meaning of the language to a beautiful mood in his poetry. He suffered the dire povery that followed the Liberation and Korean War and used this experience as a fodder for his inspiring yet very accessible poetry.02013-07-01
31Daegok Forest<NA>1752013-07-03
32Daebangjin military port<NA>1722013-07-03
33Bakyeonmuk Education Museum<NA>92013-07-03
34Byeoljubu-jeon Theme Park<NA>1812013-07-03
35Sacheon Bay Mudflat Ecology Experience Center<NA>1972013-07-03
36Sacheon High-Tech Aerospace Science Museum<NA>72013-07-03
37Sacheon Local History Museum<NA>112013-07-03