Overview

Dataset statistics

Number of variables5
Number of observations42
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory44.1 B

Variable types

Numeric1
Text3
Categorical1

Dataset

Description충청남도 천안시 내 행정기관 정보입니다. 천안시 소속 행정기관(기관명, 소재지도로명주소 등)의 항목을 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=373&beforeMenuCd=DOM_000000201001001000&publicdatapk=15074482

Alerts

데이터기준일자 has constant value ""Constant
연번 has unique valuesUnique
기관명 has unique valuesUnique
전화번호 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:30:45.573572
Analysis finished2024-01-09 22:30:45.969571
Duration0.4 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21.5
Minimum1
Maximum42
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size510.0 B
2024-01-10T07:30:46.029218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile3.05
Q111.25
median21.5
Q331.75
95-th percentile39.95
Maximum42
Range41
Interquartile range (IQR)20.5

Descriptive statistics

Standard deviation12.267844
Coefficient of variation (CV)0.5705974
Kurtosis-1.2
Mean21.5
Median Absolute Deviation (MAD)10.5
Skewness0
Sum903
Variance150.5
MonotonicityStrictly increasing
2024-01-10T07:30:46.148062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=42)
ValueCountFrequency (%)
1 1
 
2.4%
33 1
 
2.4%
25 1
 
2.4%
26 1
 
2.4%
27 1
 
2.4%
28 1
 
2.4%
29 1
 
2.4%
30 1
 
2.4%
31 1
 
2.4%
32 1
 
2.4%
Other values (32) 32
76.2%
ValueCountFrequency (%)
1 1
2.4%
2 1
2.4%
3 1
2.4%
4 1
2.4%
5 1
2.4%
6 1
2.4%
7 1
2.4%
8 1
2.4%
9 1
2.4%
10 1
2.4%
ValueCountFrequency (%)
42 1
2.4%
41 1
2.4%
40 1
2.4%
39 1
2.4%
38 1
2.4%
37 1
2.4%
36 1
2.4%
35 1
2.4%
34 1
2.4%
33 1
2.4%

기관명
Text

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size468.0 B
2024-01-10T07:30:46.342624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length23
Mean length20.97619
Min length9

Characters and Unicode

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

Unique

Unique42 ?
Unique (%)100.0%

Sample

1st row충청남도 천안시청
2nd row충청남도 서북구 보건소
3rd row충청남도 동남구 보건소
4th row충청남도 천안시 농업기술센터
5th row충청남도 천안시 맑은물사업본부
ValueCountFrequency (%)
충청남도 42
22.5%
천안시 39
20.9%
행정복지센터 31
16.6%
동남구 18
9.6%
서북구 15
 
8.0%
보건소 2
 
1.1%
부성1동 1
 
0.5%
일봉동 1
 
0.5%
신방동 1
 
0.5%
청룡동 1
 
0.5%
Other values (36) 36
19.3%
2024-01-10T07:30:46.688236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
145
16.5%
남 62
 
7.0%
청 46
 
5.2%
도 45
 
5.1%
충 42
 
4.8%
천 42
 
4.8%
시 42
 
4.8%
안 41
 
4.7%
동 39
 
4.4%
구 35
 
4.0%
Other values (64) 342
38.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 725
82.3%
Space Separator 145
 
16.5%
Decimal Number 11
 
1.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 62
 
8.6%
청 46
 
6.3%
도 45
 
6.2%
충 42
 
5.8%
천 42
 
5.8%
시 42
 
5.8%
안 41
 
5.7%
동 39
 
5.4%
구 35
 
4.8%
정 33
 
4.6%
Other values (60) 298
41.1%
Decimal Number
ValueCountFrequency (%)
1 5
45.5%
2 5
45.5%
3 1
 
9.1%
Space Separator
ValueCountFrequency (%)
145
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 725
82.3%
Common 156
 
17.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 62
 
8.6%
청 46
 
6.3%
도 45
 
6.2%
충 42
 
5.8%
천 42
 
5.8%
시 42
 
5.8%
안 41
 
5.7%
동 39
 
5.4%
구 35
 
4.8%
정 33
 
4.6%
Other values (60) 298
41.1%
Common
ValueCountFrequency (%)
145
92.9%
1 5
 
3.2%
2 5
 
3.2%
3 1
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 725
82.3%
ASCII 156
 
17.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
145
92.9%
1 5
 
3.2%
2 5
 
3.2%
3 1
 
0.6%
Hangul
ValueCountFrequency (%)
남 62
 
8.6%
청 46
 
6.3%
도 45
 
6.2%
충 42
 
5.8%
천 42
 
5.8%
시 42
 
5.8%
안 41
 
5.7%
동 39
 
5.4%
구 35
 
4.8%
정 33
 
4.6%
Other values (60) 298
41.1%

소재지도로명주소
Text

Distinct40
Distinct (%)95.2%
Missing0
Missing (%)0.0%
Memory size468.0 B
2024-01-10T07:30:46.941818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length21.880952
Min length19

Characters and Unicode

Total characters919
Distinct characters78
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

Unique38 ?
Unique (%)90.5%

Sample

1st row충청남도 천안시 서북구 번영로 156
2nd row충청남도 천안시 서북구 번영로 156
3rd row충청남도 천안시 동남구 버들로 34
4th row충청남도 천안시 동남구 목천읍 목천안터1길 15
5th row충청남도 천안시 동남구 용곡2길 141
ValueCountFrequency (%)
충청남도 42
18.8%
천안시 42
18.8%
동남구 24
 
10.7%
서북구 18
 
8.0%
15 4
 
1.8%
번영로 3
 
1.3%
천안대로 3
 
1.3%
목천읍 2
 
0.9%
봉주로 2
 
0.9%
39 2
 
0.9%
Other values (79) 82
36.6%
2024-01-10T07:30:47.319471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
182
19.8%
남 67
 
7.3%
천 53
 
5.8%
안 47
 
5.1%
청 45
 
4.9%
시 43
 
4.7%
충 42
 
4.6%
구 42
 
4.6%
도 42
 
4.6%
1 34
 
3.7%
Other values (68) 322
35.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 602
65.5%
Space Separator 182
 
19.8%
Decimal Number 130
 
14.1%
Dash Punctuation 5
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 67
 
11.1%
천 53
 
8.8%
안 47
 
7.8%
청 45
 
7.5%
시 43
 
7.1%
충 42
 
7.0%
구 42
 
7.0%
도 42
 
7.0%
동 26
 
4.3%
로 23
 
3.8%
Other values (56) 172
28.6%
Decimal Number
ValueCountFrequency (%)
1 34
26.2%
4 16
12.3%
5 15
11.5%
3 13
 
10.0%
2 12
 
9.2%
9 10
 
7.7%
7 9
 
6.9%
0 8
 
6.2%
6 7
 
5.4%
8 6
 
4.6%
Space Separator
ValueCountFrequency (%)
182
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 602
65.5%
Common 317
34.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 67
 
11.1%
천 53
 
8.8%
안 47
 
7.8%
청 45
 
7.5%
시 43
 
7.1%
충 42
 
7.0%
구 42
 
7.0%
도 42
 
7.0%
동 26
 
4.3%
로 23
 
3.8%
Other values (56) 172
28.6%
Common
ValueCountFrequency (%)
182
57.4%
1 34
 
10.7%
4 16
 
5.0%
5 15
 
4.7%
3 13
 
4.1%
2 12
 
3.8%
9 10
 
3.2%
7 9
 
2.8%
0 8
 
2.5%
6 7
 
2.2%
Other values (2) 11
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 602
65.5%
ASCII 317
34.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
182
57.4%
1 34
 
10.7%
4 16
 
5.0%
5 15
 
4.7%
3 13
 
4.1%
2 12
 
3.8%
9 10
 
3.2%
7 9
 
2.8%
0 8
 
2.5%
6 7
 
2.2%
Other values (2) 11
 
3.5%
Hangul
ValueCountFrequency (%)
남 67
 
11.1%
천 53
 
8.8%
안 47
 
7.8%
청 45
 
7.5%
시 43
 
7.1%
충 42
 
7.0%
구 42
 
7.0%
도 42
 
7.0%
동 26
 
4.3%
로 23
 
3.8%
Other values (56) 172
28.6%

전화번호
Text

UNIQUE 

Distinct42
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size468.0 B
2024-01-10T07:30:47.521223image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length11.880952
Min length7

Characters and Unicode

Total characters499
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

Unique42 ?
Unique (%)100.0%

Sample

1st row1422-36
2nd row041-521-2552
3rd row041-521-2651
4th row041-521-2962
5th row041-521-3111
ValueCountFrequency (%)
1422-36 1
 
2.4%
041-521-6811 1
 
2.4%
041-521-6981 1
 
2.4%
041-521-4921 1
 
2.4%
041-521-4941 1
 
2.4%
041-521-4961 1
 
2.4%
041-521-4981 1
 
2.4%
041-521-6020 1
 
2.4%
041-521-6751 1
 
2.4%
041-521-6781 1
 
2.4%
Other values (32) 32
76.2%
2024-01-10T07:30:47.857707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 124
24.8%
- 83
16.6%
4 67
13.4%
2 57
11.4%
0 50
10.0%
5 46
 
9.2%
6 28
 
5.6%
8 17
 
3.4%
9 13
 
2.6%
7 10
 
2.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 416
83.4%
Dash Punctuation 83
 
16.6%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 124
29.8%
4 67
16.1%
2 57
13.7%
0 50
12.0%
5 46
 
11.1%
6 28
 
6.7%
8 17
 
4.1%
9 13
 
3.1%
7 10
 
2.4%
3 4
 
1.0%
Dash Punctuation
ValueCountFrequency (%)
- 83
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 499
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 124
24.8%
- 83
16.6%
4 67
13.4%
2 57
11.4%
0 50
10.0%
5 46
 
9.2%
6 28
 
5.6%
8 17
 
3.4%
9 13
 
2.6%
7 10
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 499
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 124
24.8%
- 83
16.6%
4 67
13.4%
2 57
11.4%
0 50
10.0%
5 46
 
9.2%
6 28
 
5.6%
8 17
 
3.4%
9 13
 
2.6%
7 10
 
2.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size468.0 B
2023-08-18
42 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-18
2nd row2023-08-18
3rd row2023-08-18
4th row2023-08-18
5th row2023-08-18

Common Values

ValueCountFrequency (%)
2023-08-18 42
100.0%

Length

2024-01-10T07:30:47.990416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:30:48.078731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-18 42
100.0%

Interactions

2024-01-10T07:30:45.736866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:30:48.140550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번기관명소재지도로명주소전화번호
연번1.0001.0001.0001.000
기관명1.0001.0001.0001.000
소재지도로명주소1.0001.0001.0001.000
전화번호1.0001.0001.0001.000

Missing values

2024-01-10T07:30:45.839901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:30:45.932763image/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

연번기관명소재지도로명주소전화번호데이터기준일자
01충청남도 천안시청충청남도 천안시 서북구 번영로 1561422-362023-08-18
12충청남도 서북구 보건소충청남도 천안시 서북구 번영로 156041-521-25522023-08-18
23충청남도 동남구 보건소충청남도 천안시 동남구 버들로 34041-521-26512023-08-18
34충청남도 천안시 농업기술센터충청남도 천안시 동남구 목천읍 목천안터1길 15041-521-29622023-08-18
45충청남도 천안시 맑은물사업본부충청남도 천안시 동남구 용곡2길 141041-521-31112023-08-18
56충청남도 천안시 도시건설사업본부충청남도 천안시 동남구 천안대로 400041-521-27112023-08-18
67충청남도 천안시 도서관본부충청남도 천안시 동남구 청수16로 5-10041-521-37112023-08-18
78충청남도 천안시 농수산물도매시장관리사업소충청남도 천안시 서북구 천안대로 1347041-521-28412023-08-18
89충청남도 천안시 차량등록사업소충청남도 천안시 동남구 천안대로 400041-521-36402023-08-18
910충청남도 천안시 동남구청충청남도 천안시 동남구 옛시청길 39041-521-40202023-08-18
연번기관명소재지도로명주소전화번호데이터기준일자
3233충청남도 천안시 서북구 성정1동 행정복지센터충청남도 천안시 서북구 성정8길 5041-521-68612023-08-18
3334충청남도 천안시 서북구 성정2동 행정복지센터충청남도 천안시 서북구 서부8길 29041-521-68812023-08-18
3435충청남도 천안시 서북구 쌍용1동 행정복지센터충청남도 천안시 서북구 미라10길 21041-521-69012023-08-18
3536충청남도 천안시 서북구 쌍용2동 행정복지센터충청남도 천안시 서북구 쌍용14길 70041-521-69212023-08-18
3637충청남도 천안시 서북구 쌍용3동 행정복지센터충청남도 천안시 서북구 월봉로 138041-521-69412023-08-18
3738충청남도 천안시 서북구 백석동 행정복지센터충청남도 천안시 서북구 번영로 208041-521-69612023-08-18
3839충청남도 천안시 서북구 불당1동 행정복지센터충청남도 천안시 서북구 봉서산로 64041-521-66712023-08-18
3940충청남도 천안시 서북구 불당2동 행정복지센터충청남도 천안시 서북구 불당25로 182041-521-62912023-08-18
4041충청남도 천안시 서북구 부성1동 행정복지센터충청남도 천안시 서북구 부대중앙길 51041-521-69812023-08-18
4142충청남도 천안시 서북구 부성2동 행정복지센터충청남도 천안시 서북구 부성7길 39-5041-521-66912023-08-18