Overview

Dataset statistics

Number of variables4
Number of observations65
Missing cells104
Missing cells (%)40.0%
Duplicate rows1
Duplicate rows (%)1.5%
Total size in memory2.2 KiB
Average record size in memory34.0 B

Variable types

Text4

Dataset

Description연천군시설관리공단이 관리, 운영하는 시설물 현황 설명
Author연천군시설관리공단
URLhttps://www.data.go.kr/data/15004063/fileData.do

Alerts

Dataset has 1 (1.5%) duplicate rowsDuplicates
연천군시설관리공단 이용시설물 현황 has 27 (41.5%) missing valuesMissing
Unnamed: 1 has 40 (61.5%) missing valuesMissing
Unnamed: 2 has 27 (41.5%) missing valuesMissing
Unnamed: 3 has 10 (15.4%) missing valuesMissing

Reproduction

Analysis started2023-12-12 03:35:08.604209
Analysis finished2023-12-12 03:35:09.640506
Duration1.04 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연천군시설관리공단 이용시설물 현황
Text

MISSING 

Distinct38
Distinct (%)100.0%
Missing27
Missing (%)41.5%
Memory size652.0 B
2023-12-12T12:35:09.866275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3.5
Mean length3.4736842
Min length2

Characters and Unicode

Total characters132
Distinct characters16
Distinct categories2 ?
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 (%)100.0%

Sample

1st row연번
2nd row시설1
3rd row시설2
4th row시설3
5th row시설4
ValueCountFrequency (%)
시설9 1
 
2.6%
주차8 1
 
2.6%
주차10 1
 
2.6%
주차11 1
 
2.6%
주차12 1
 
2.6%
주차13 1
 
2.6%
주차14 1
 
2.6%
주차15 1
 
2.6%
주차16 1
 
2.6%
주차9 1
 
2.6%
Other values (28) 28
73.7%
2023-12-12T12:35:10.361025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 26
19.7%
차 26
19.7%
1 17
12.9%
시 11
8.3%
설 11
8.3%
2 11
8.3%
3 4
 
3.0%
4 4
 
3.0%
5 4
 
3.0%
6 4
 
3.0%
Other values (6) 14
10.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 76
57.6%
Decimal Number 56
42.4%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 17
30.4%
2 11
19.6%
3 4
 
7.1%
4 4
 
7.1%
5 4
 
7.1%
6 4
 
7.1%
9 3
 
5.4%
7 3
 
5.4%
0 3
 
5.4%
8 3
 
5.4%
Other Letter
ValueCountFrequency (%)
주 26
34.2%
차 26
34.2%
시 11
14.5%
설 11
14.5%
연 1
 
1.3%
번 1
 
1.3%

Most occurring scripts

ValueCountFrequency (%)
Hangul 76
57.6%
Common 56
42.4%

Most frequent character per script

Common
ValueCountFrequency (%)
1 17
30.4%
2 11
19.6%
3 4
 
7.1%
4 4
 
7.1%
5 4
 
7.1%
6 4
 
7.1%
9 3
 
5.4%
7 3
 
5.4%
0 3
 
5.4%
8 3
 
5.4%
Hangul
ValueCountFrequency (%)
주 26
34.2%
차 26
34.2%
시 11
14.5%
설 11
14.5%
연 1
 
1.3%
번 1
 
1.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 76
57.6%
ASCII 56
42.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 26
34.2%
차 26
34.2%
시 11
14.5%
설 11
14.5%
연 1
 
1.3%
번 1
 
1.3%
ASCII
ValueCountFrequency (%)
1 17
30.4%
2 11
19.6%
3 4
 
7.1%
4 4
 
7.1%
5 4
 
7.1%
6 4
 
7.1%
9 3
 
5.4%
7 3
 
5.4%
0 3
 
5.4%
8 3
 
5.4%

Unnamed: 1
Text

MISSING 

Distinct23
Distinct (%)92.0%
Missing40
Missing (%)61.5%
Memory size652.0 B
2023-12-12T12:35:10.620421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length19
Mean length12.4
Min length3

Characters and Unicode

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

Unique

Unique21 ?
Unique (%)84.0%

Sample

1st row시설명
2nd row(관리)
3rd row연천군 공설운동장
4th row(경영사업1팀 ☎834-9482)
5th row종량제 봉투
ValueCountFrequency (%)
경영사업1팀 7
 
15.9%
경영사업2팀 4
 
9.1%
연천군 2
 
4.5%
☎834-3770 2
 
4.5%
☎834-9482 2
 
4.5%
☎834-3064 1
 
2.3%
공영주차장 1
 
2.3%
☎834-8785 1
 
2.3%
청소년수련관팀 1
 
2.3%
☎835-1155 1
 
2.3%
Other values (22) 22
50.0%
2023-12-12T12:35:11.064545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3 19
 
6.1%
18
 
5.8%
8 18
 
5.8%
( 13
 
4.2%
4 13
 
4.2%
) 13
 
4.2%
팀 12
 
3.9%
☎ 12
 
3.9%
영 12
 
3.9%
- 12
 
3.9%
Other values (73) 168
54.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 146
47.1%
Decimal Number 95
30.6%
Space Separator 18
 
5.8%
Open Punctuation 13
 
4.2%
Close Punctuation 13
 
4.2%
Other Symbol 12
 
3.9%
Dash Punctuation 12
 
3.9%
Control 1
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
팀 12
 
8.2%
영 12
 
8.2%
업 11
 
7.5%
사 11
 
7.5%
경 11
 
7.5%
장 5
 
3.4%
관 4
 
2.7%
수 3
 
2.1%
연 3
 
2.1%
청 3
 
2.1%
Other values (57) 71
48.6%
Decimal Number
ValueCountFrequency (%)
3 19
20.0%
8 18
18.9%
4 13
13.7%
1 10
10.5%
2 10
10.5%
0 9
9.5%
7 7
 
7.4%
5 5
 
5.3%
9 3
 
3.2%
6 1
 
1.1%
Space Separator
ValueCountFrequency (%)
18
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Other Symbol
ValueCountFrequency (%)
☎ 12
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%
Control
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 164
52.9%
Hangul 146
47.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
팀 12
 
8.2%
영 12
 
8.2%
업 11
 
7.5%
사 11
 
7.5%
경 11
 
7.5%
장 5
 
3.4%
관 4
 
2.7%
수 3
 
2.1%
연 3
 
2.1%
청 3
 
2.1%
Other values (57) 71
48.6%
Common
ValueCountFrequency (%)
3 19
11.6%
18
11.0%
8 18
11.0%
( 13
7.9%
4 13
7.9%
) 13
7.9%
☎ 12
7.3%
- 12
7.3%
1 10
 
6.1%
2 10
 
6.1%
Other values (6) 26
15.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 152
49.0%
Hangul 146
47.1%
Misc Symbols 12
 
3.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3 19
12.5%
18
11.8%
8 18
11.8%
( 13
8.6%
4 13
8.6%
) 13
8.6%
- 12
7.9%
1 10
6.6%
2 10
6.6%
0 9
5.9%
Other values (5) 17
11.2%
Hangul
ValueCountFrequency (%)
팀 12
 
8.2%
영 12
 
8.2%
업 11
 
7.5%
사 11
 
7.5%
경 11
 
7.5%
장 5
 
3.4%
관 4
 
2.7%
수 3
 
2.1%
연 3
 
2.1%
청 3
 
2.1%
Other values (57) 71
48.6%
Misc Symbols
ValueCountFrequency (%)
☎ 12
100.0%

Unnamed: 2
Text

MISSING 

Distinct35
Distinct (%)92.1%
Missing27
Missing (%)41.5%
Memory size652.0 B
2023-12-12T12:35:11.328042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length24
Mean length17.947368
Min length5

Characters and Unicode

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

Unique

Unique33 ?
Unique (%)86.8%

Sample

1st row소 재 지
2nd row연천읍 문화로 150
3rd row연천읍 문화로 150
4th row전곡읍 은대성로 95
5th row청산면 전영로 319번길 136
ValueCountFrequency (%)
전곡읍 30
25.4%
전곡리 23
19.5%
은대리 5
 
4.2%
연천읍 4
 
3.4%
문화로 4
 
3.4%
선사로길 3
 
2.5%
150 3
 
2.5%
14-71 2
 
1.7%
295-71(5일장거리 1
 
0.8%
336-65(전곡정형외과 1
 
0.8%
Other values (42) 42
35.6%
2023-12-12T12:35:11.826067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
80
 
11.7%
전 60
 
8.8%
곡 57
 
8.4%
읍 37
 
5.4%
리 30
 
4.4%
- 27
 
4.0%
) 26
 
3.8%
( 26
 
3.8%
5 25
 
3.7%
3 25
 
3.7%
Other values (104) 289
42.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 369
54.1%
Decimal Number 152
22.3%
Space Separator 80
 
11.7%
Dash Punctuation 27
 
4.0%
Close Punctuation 26
 
3.8%
Open Punctuation 26
 
3.8%
Lowercase Letter 2
 
0.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 60
16.3%
곡 57
 
15.4%
읍 37
 
10.0%
리 30
 
8.1%
로 10
 
2.7%
은 8
 
2.2%
대 8
 
2.2%
일 6
 
1.6%
연 5
 
1.4%
천 5
 
1.4%
Other values (88) 143
38.8%
Decimal Number
ValueCountFrequency (%)
5 25
16.4%
3 25
16.4%
6 23
15.1%
1 20
13.2%
4 16
10.5%
8 10
 
6.6%
0 9
 
5.9%
9 9
 
5.9%
2 8
 
5.3%
7 7
 
4.6%
Lowercase Letter
ValueCountFrequency (%)
l 1
50.0%
g 1
50.0%
Space Separator
ValueCountFrequency (%)
80
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 27
100.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 369
54.1%
Common 311
45.6%
Latin 2
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 60
16.3%
곡 57
 
15.4%
읍 37
 
10.0%
리 30
 
8.1%
로 10
 
2.7%
은 8
 
2.2%
대 8
 
2.2%
일 6
 
1.6%
연 5
 
1.4%
천 5
 
1.4%
Other values (88) 143
38.8%
Common
ValueCountFrequency (%)
80
25.7%
- 27
 
8.7%
) 26
 
8.4%
( 26
 
8.4%
5 25
 
8.0%
3 25
 
8.0%
6 23
 
7.4%
1 20
 
6.4%
4 16
 
5.1%
8 10
 
3.2%
Other values (4) 33
10.6%
Latin
ValueCountFrequency (%)
l 1
50.0%
g 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 369
54.1%
ASCII 313
45.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
80
25.6%
- 27
 
8.6%
) 26
 
8.3%
( 26
 
8.3%
5 25
 
8.0%
3 25
 
8.0%
6 23
 
7.3%
1 20
 
6.4%
4 16
 
5.1%
8 10
 
3.2%
Other values (6) 35
11.2%
Hangul
ValueCountFrequency (%)
전 60
16.3%
곡 57
 
15.4%
읍 37
 
10.0%
리 30
 
8.1%
로 10
 
2.7%
은 8
 
2.2%
대 8
 
2.2%
일 6
 
1.6%
연 5
 
1.4%
천 5
 
1.4%
Other values (88) 143
38.8%

Unnamed: 3
Text

MISSING 

Distinct49
Distinct (%)89.1%
Missing10
Missing (%)15.4%
Memory size652.0 B
2023-12-12T12:35:12.089915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length66
Median length43
Mean length11.363636
Min length3

Characters and Unicode

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

Unique

Unique43 ?
Unique (%)78.2%

Sample

1st row주요시설내역
2nd row육상트랙(400m 8레인)
3rd row축구경기장2면(천연잔디1, 인조잔디 1)
4th row농구경기장2면
5th row족구장2면
ValueCountFrequency (%)
주차 26
 
22.6%
1 4
 
3.5%
1면(인조잔디 3
 
2.6%
화장실 2
 
1.7%
7면(유료 2
 
1.7%
1동 2
 
1.7%
13면(유료 2
 
1.7%
20면(유료 2
 
1.7%
15면(유료 2
 
1.7%
풋살경기장 2
 
1.7%
Other values (68) 68
59.1%
2023-12-12T12:35:12.637936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
66
 
10.6%
( 35
 
5.6%
) 35
 
5.6%
1 34
 
5.4%
면 34
 
5.4%
차 30
 
4.8%
주 29
 
4.6%
료 26
 
4.2%
장 21
 
3.4%
, 17
 
2.7%
Other values (101) 298
47.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 370
59.2%
Decimal Number 101
 
16.2%
Space Separator 66
 
10.6%
Open Punctuation 35
 
5.6%
Close Punctuation 35
 
5.6%
Other Punctuation 17
 
2.7%
Lowercase Letter 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
면 34
 
9.2%
차 30
 
8.1%
주 29
 
7.8%
료 26
 
7.0%
장 21
 
5.7%
유 15
 
4.1%
무 11
 
3.0%
실 9
 
2.4%
석 9
 
2.4%
기 7
 
1.9%
Other values (86) 179
48.4%
Decimal Number
ValueCountFrequency (%)
1 34
33.7%
2 17
16.8%
5 12
 
11.9%
0 11
 
10.9%
4 7
 
6.9%
9 5
 
5.0%
6 5
 
5.0%
8 5
 
5.0%
3 3
 
3.0%
7 2
 
2.0%
Space Separator
ValueCountFrequency (%)
66
100.0%
Open Punctuation
ValueCountFrequency (%)
( 35
100.0%
Close Punctuation
ValueCountFrequency (%)
) 35
100.0%
Other Punctuation
ValueCountFrequency (%)
, 17
100.0%
Lowercase Letter
ValueCountFrequency (%)
m 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 370
59.2%
Common 254
40.6%
Latin 1
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
면 34
 
9.2%
차 30
 
8.1%
주 29
 
7.8%
료 26
 
7.0%
장 21
 
5.7%
유 15
 
4.1%
무 11
 
3.0%
실 9
 
2.4%
석 9
 
2.4%
기 7
 
1.9%
Other values (86) 179
48.4%
Common
ValueCountFrequency (%)
66
26.0%
( 35
13.8%
) 35
13.8%
1 34
13.4%
, 17
 
6.7%
2 17
 
6.7%
5 12
 
4.7%
0 11
 
4.3%
4 7
 
2.8%
9 5
 
2.0%
Other values (4) 15
 
5.9%
Latin
ValueCountFrequency (%)
m 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 370
59.2%
ASCII 255
40.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
66
25.9%
( 35
13.7%
) 35
13.7%
1 34
13.3%
, 17
 
6.7%
2 17
 
6.7%
5 12
 
4.7%
0 11
 
4.3%
4 7
 
2.7%
9 5
 
2.0%
Other values (5) 16
 
6.3%
Hangul
ValueCountFrequency (%)
면 34
 
9.2%
차 30
 
8.1%
주 29
 
7.8%
료 26
 
7.0%
장 21
 
5.7%
유 15
 
4.1%
무 11
 
3.0%
실 9
 
2.4%
석 9
 
2.4%
기 7
 
1.9%
Other values (86) 179
48.4%

Correlations

2023-12-12T12:35:12.784332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연천군시설관리공단 이용시설물 현황Unnamed: 1Unnamed: 2Unnamed: 3
연천군시설관리공단 이용시설물 현황1.0001.0001.0001.000
Unnamed: 11.0001.0001.0000.991
Unnamed: 21.0001.0001.0000.933
Unnamed: 31.0000.9910.9331.000

Missing values

2023-12-12T12:35:08.986308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T12:35:09.102366image/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.
2023-12-12T12:35:09.567985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

연천군시설관리공단 이용시설물 현황Unnamed: 1Unnamed: 2Unnamed: 3
0<NA><NA><NA><NA>
1연번시설명소 재 지주요시설내역
2<NA>(관리)<NA><NA>
3시설1연천군 공설운동장연천읍 문화로 150육상트랙(400m 8레인)
4<NA>(경영사업1팀 ☎834-9482)<NA>축구경기장2면(천연잔디1, 인조잔디 1)
5<NA><NA><NA>농구경기장2면
6<NA><NA><NA>족구장2면
7시설2종량제 봉투연천읍 문화로 150<NA>
8<NA>(경영사업1팀 ☎834-9482)<NA><NA>
9<NA><NA><NA><NA>
연천군시설관리공단 이용시설물 현황Unnamed: 1Unnamed: 2Unnamed: 3
55주차17<NA>전곡읍 전곡리 253-5(대원모터)주차 16면(무료)
56주차18<NA>전곡읍 전곡리 458-6(한진주유소)주차 20면(무료)
57주차19<NA>전곡읍 은대리 542-6(만물공구뒤)주차 8면(무료)
58주차20<NA>전곡읍 은대리 859-26(구한일은행 앞)주차 4면(무료)
59주차21<NA>전곡읍 은대리 566-2(제일부페뒤)주차 6면(무료)
60주차22<NA>전곡읍 전곡리 333-40(읍민회관뒤)주차 22면(무료)
61주차23<NA>전곡읍 전곡리 333-608(전곡역우측)주차 15면(무료)
62주차24<NA>전곡읍 전곡리 333-608(전곡역좌측)주차 69면(무료)
63주차25<NA>전곡읍 전곡리 은대리 517-11(구읍사무소뒤)주차 58면(무료)
64주차26<NA>전곡읍 전곡리 은대리 572-5(문화체육센터앞)주차 145면(무료)

Duplicate rows

Most frequently occurring

연천군시설관리공단 이용시설물 현황Unnamed: 1Unnamed: 2Unnamed: 3# duplicates
0<NA><NA><NA><NA>5