Overview

Dataset statistics

Number of variables7
Number of observations122
Missing cells270
Missing cells (%)31.6%
Duplicate rows1
Duplicate rows (%)0.8%
Total size in memory6.9 KiB
Average record size in memory58.1 B

Variable types

Unsupported3
Text3
Categorical1

Dataset

Description문경시 관내 종교시설에 대한 데이터로 사찰, 교회, 성당 등 종교시설의 시설명, 주소, 전화번호 데이터를 공개하고자 함
URLhttps://www.data.go.kr/data/15117497/fileData.do

Alerts

Unnamed: 6 has constant value ""Constant
Dataset has 1 (0.8%) duplicate rowsDuplicates
Unnamed: 2 has 2 (1.6%) missing valuesMissing
Unnamed: 3 has 23 (18.9%) missing valuesMissing
Unnamed: 5 has 122 (100.0%) missing valuesMissing
Unnamed: 6 has 121 (99.2%) missing valuesMissing
종교단체(기독교) is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 01:49:04.497283
Analysis finished2023-12-12 01:49:05.143656
Duration0.65 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

종교단체(기독교)
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.8%
Memory size1.1 KiB

Unnamed: 1
Unsupported

REJECTED  UNSUPPORTED 

Missing1
Missing (%)0.8%
Memory size1.1 KiB

Unnamed: 2
Text

MISSING 

Distinct120
Distinct (%)100.0%
Missing2
Missing (%)1.6%
Memory size1.1 KiB
2023-12-12T10:49:05.494237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length18
Mean length14.05
Min length5

Characters and Unicode

Total characters1686
Distinct characters144
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

Unique120 ?
Unique (%)100.0%

Sample

1st row소 재 지
2nd row문경시 문경읍 문희로 60-4
3rd row문경시 문경읍 주흘1길 31
4th row문경시 문경읍 주흘로 87
5th row문경시 문경읍 요성1길 18
ValueCountFrequency (%)
문경시 119
27.3%
문경읍 13
 
3.0%
산북면 10
 
2.3%
가은읍 9
 
2.1%
동로면 7
 
1.6%
호계면 7
 
1.6%
산양면 7
 
1.6%
마성면 6
 
1.4%
영순면 5
 
1.1%
신흥로 5
 
1.1%
Other values (203) 248
56.9%
2023-12-12T10:49:06.088285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
317
18.8%
문 133
 
7.9%
경 132
 
7.8%
시 122
 
7.2%
길 83
 
4.9%
1 83
 
4.9%
면 47
 
2.8%
2 47
 
2.8%
로 41
 
2.4%
3 39
 
2.3%
Other values (134) 642
38.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 979
58.1%
Decimal Number 346
 
20.5%
Space Separator 317
 
18.8%
Dash Punctuation 38
 
2.3%
Other Punctuation 6
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
문 133
 
13.6%
경 132
 
13.5%
시 122
 
12.5%
길 83
 
8.5%
면 47
 
4.8%
로 41
 
4.2%
읍 22
 
2.2%
산 19
 
1.9%
신 16
 
1.6%
동 14
 
1.4%
Other values (121) 350
35.8%
Decimal Number
ValueCountFrequency (%)
1 83
24.0%
2 47
13.6%
3 39
11.3%
6 34
9.8%
4 31
 
9.0%
9 26
 
7.5%
0 26
 
7.5%
5 25
 
7.2%
7 18
 
5.2%
8 17
 
4.9%
Space Separator
ValueCountFrequency (%)
317
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 38
100.0%
Other Punctuation
ValueCountFrequency (%)
, 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 979
58.1%
Common 707
41.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
문 133
 
13.6%
경 132
 
13.5%
시 122
 
12.5%
길 83
 
8.5%
면 47
 
4.8%
로 41
 
4.2%
읍 22
 
2.2%
산 19
 
1.9%
신 16
 
1.6%
동 14
 
1.4%
Other values (121) 350
35.8%
Common
ValueCountFrequency (%)
317
44.8%
1 83
 
11.7%
2 47
 
6.6%
3 39
 
5.5%
- 38
 
5.4%
6 34
 
4.8%
4 31
 
4.4%
9 26
 
3.7%
0 26
 
3.7%
5 25
 
3.5%
Other values (3) 41
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 979
58.1%
ASCII 707
41.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
317
44.8%
1 83
 
11.7%
2 47
 
6.6%
3 39
 
5.5%
- 38
 
5.4%
6 34
 
4.8%
4 31
 
4.4%
9 26
 
3.7%
0 26
 
3.7%
5 25
 
3.5%
Other values (3) 41
 
5.8%
Hangul
ValueCountFrequency (%)
문 133
 
13.6%
경 132
 
13.5%
시 122
 
12.5%
길 83
 
8.5%
면 47
 
4.8%
로 41
 
4.2%
읍 22
 
2.2%
산 19
 
1.9%
신 16
 
1.6%
동 14
 
1.4%
Other values (121) 350
35.8%

Unnamed: 3
Text

MISSING 

Distinct99
Distinct (%)100.0%
Missing23
Missing (%)18.9%
Memory size1.1 KiB
2023-12-12T10:49:06.439764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length8
Mean length8.020202
Min length5

Characters and Unicode

Total characters794
Distinct characters16
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

Unique99 ?
Unique (%)100.0%

Sample

1st row유선 전화
2nd row571-0448
3rd row571-0428
4th row571-7506
5th row571-1830
ValueCountFrequency (%)
571-0133 1
 
1.0%
553-5016 1
 
1.0%
552-6004 1
 
1.0%
552-9021 1
 
1.0%
556-2033 1
 
1.0%
555-2546 1
 
1.0%
553-3133 1
 
1.0%
556-0722 1
 
1.0%
555-4064 1
 
1.0%
554-9182 1
 
1.0%
Other values (90) 90
90.0%
2023-12-12T10:49:07.333140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 211
26.6%
- 99
12.5%
2 82
 
10.3%
1 72
 
9.1%
7 64
 
8.1%
0 57
 
7.2%
3 56
 
7.1%
4 41
 
5.2%
6 38
 
4.8%
9 35
 
4.4%
Other values (6) 39
 
4.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 690
86.9%
Dash Punctuation 99
 
12.5%
Other Letter 4
 
0.5%
Space Separator 1
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 211
30.6%
2 82
 
11.9%
1 72
 
10.4%
7 64
 
9.3%
0 57
 
8.3%
3 56
 
8.1%
4 41
 
5.9%
6 38
 
5.5%
9 35
 
5.1%
8 34
 
4.9%
Other Letter
ValueCountFrequency (%)
유 1
25.0%
선 1
25.0%
전 1
25.0%
화 1
25.0%
Dash Punctuation
ValueCountFrequency (%)
- 99
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 790
99.5%
Hangul 4
 
0.5%

Most frequent character per script

Common
ValueCountFrequency (%)
5 211
26.7%
- 99
12.5%
2 82
 
10.4%
1 72
 
9.1%
7 64
 
8.1%
0 57
 
7.2%
3 56
 
7.1%
4 41
 
5.2%
6 38
 
4.8%
9 35
 
4.4%
Other values (2) 35
 
4.4%
Hangul
ValueCountFrequency (%)
유 1
25.0%
선 1
25.0%
전 1
25.0%
화 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 790
99.5%
Hangul 4
 
0.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 211
26.7%
- 99
12.5%
2 82
 
10.4%
1 72
 
9.1%
7 64
 
8.1%
0 57
 
7.2%
3 56
 
7.1%
4 41
 
5.2%
6 38
 
4.8%
9 35
 
4.4%
Other values (2) 35
 
4.4%
Hangul
ValueCountFrequency (%)
유 1
25.0%
선 1
25.0%
전 1
25.0%
화 1
25.0%

Unnamed: 4
Categorical

Distinct16
Distinct (%)13.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
문경읍
13 
점촌3동
13 
점촌2동
12 
산북면
10 
점촌5동
10 
Other values (11)
64 

Length

Max length4
Median length3
Mean length3.4262295
Min length3

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row<NA>
2nd row읍면동
3rd row<NA>
4th row문경읍
5th row문경읍

Common Values

ValueCountFrequency (%)
문경읍 13
10.7%
점촌3동 13
10.7%
점촌2동 12
9.8%
산북면 10
 
8.2%
점촌5동 10
 
8.2%
가은읍 9
 
7.4%
점촌1동 9
 
7.4%
산양면 7
 
5.7%
호계면 7
 
5.7%
동로면 7
 
5.7%
Other values (6) 25
20.5%

Length

2023-12-12T10:49:07.537159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
문경읍 13
10.7%
점촌3동 13
10.7%
점촌2동 12
9.8%
산북면 10
 
8.2%
점촌5동 10
 
8.2%
가은읍 9
 
7.4%
점촌1동 9
 
7.4%
산양면 7
 
5.7%
호계면 7
 
5.7%
동로면 7
 
5.7%
Other values (6) 25
20.5%

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing122
Missing (%)100.0%
Memory size1.2 KiB

Unnamed: 6
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)100.0%
Missing121
Missing (%)99.2%
Memory size1.1 KiB
2023-12-12T10:49:07.644115image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

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

Unique

Unique1 ?
Unique (%)100.0%

Sample

1st row`
ValueCountFrequency (%)
1
100.0%
2023-12-12T10:49:07.866546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
` 1
100.0%

Most occurring categories

ValueCountFrequency (%)
Modifier Symbol 1
100.0%

Most frequent character per category

Modifier Symbol
ValueCountFrequency (%)
` 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
` 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
` 1
100.0%

Correlations

2023-12-12T10:49:07.978519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Unnamed: 3Unnamed: 4
Unnamed: 31.0001.000
Unnamed: 41.0001.000

Missing values

2023-12-12T10:49:04.750855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T10:49:04.909227image/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-12T10:49:05.060405image/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: 3Unnamed: 4Unnamed: 5Unnamed: 6
0NaNNaN<NA><NA><NA><NA><NA>
1번호교회소 재 지유선 전화읍면동<NA><NA>
2총계119<NA><NA><NA><NA><NA>
31문경교회문경시 문경읍 문희로 60-4571-0448문경읍<NA><NA>
42문경시민교회문경시 문경읍 주흘1길 31571-0428문경읍<NA><NA>
53주행전교회문경시 문경읍 주흘로 87571-7506문경읍<NA><NA>
64요성교회문경시 문경읍 요성1길 18571-1830문경읍<NA><NA>
75문경새재교회문경시 문경읍 하푸실길 60-6571-2489문경읍<NA><NA>
86당포교회문경시 문경읍 당포안길 12572-2799문경읍<NA><NA>
97용연교회문경시 문경읍 용연길 116-2571-8090문경읍<NA><NA>
종교단체(기독교)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6
112110문경순복음교회문경시 모전로 60555-9192점촌5동<NA><NA>
113111영강침례교회문경시 돈달로 8552-5652점촌5동<NA><NA>
114112무지개교회문경시 매봉로 56555-7740점촌5동<NA><NA>
115113점촌남부교회문경시 모전1길 9554-2025점촌5동<NA><NA>
116114점촌서부교회문경시 모전3길 32555-3942점촌5동<NA><NA>
117115모전광림교회문경시 당교9길 8-1555-3281점촌5동<NA><NA>
118116문경교회문경시 매봉6길 14556-9731점촌5동<NA><NA>
119117시냇가에심은나무교회문경시 여중1길 28554-2903점촌5동<NA><NA>
120118점촌문희교회문경시 당교3길 3<NA>점촌5동<NA><NA>
121119예스교회문경시 매봉5길 4<NA>점촌5동<NA><NA>

Duplicate rows

Most frequently occurring

Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 6# duplicates
0<NA><NA><NA><NA>2