Overview

Dataset statistics

Number of variables9
Number of observations350
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory25.1 KiB
Average record size in memory73.4 B

Variable types

Categorical4
Text3
Numeric1
DateTime1

Dataset

Description충청남도 공주시 하천(소하천)현황 에 대한 데이터로 (지정고시번호,하천명,구간시작위치,읍면동별,관리기관명) 등의 항목을 제공합니다.
Author충청남도 공주시
URLhttps://www.data.go.kr/data/15041835/fileData.do

Alerts

구분 has constant value ""Constant
지정고시번호 has constant value ""Constant
관리기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
구간시작위치 has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:21:00.028114
Analysis finished2023-12-12 09:21:00.962724
Duration0.93 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
소하천
350 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row소하천
2nd row소하천
3rd row소하천
4th row소하천
5th row소하천

Common Values

ValueCountFrequency (%)
소하천 350
100.0%

Length

2023-12-12T18:21:01.039844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:21:01.177354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
소하천 350
100.0%

지정고시번호
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
공주시 2004-31호
350 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공주시 2004-31호
2nd row공주시 2004-31호
3rd row공주시 2004-31호
4th row공주시 2004-31호
5th row공주시 2004-31호

Common Values

ValueCountFrequency (%)
공주시 2004-31호 350
100.0%

Length

2023-12-12T18:21:01.317774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:21:01.454448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공주시 350
50.0%
2004-31호 350
50.0%

하천명
Text

Distinct341
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2023-12-12T18:21:01.764137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length5
Mean length3.7485714
Min length3

Characters and Unicode

Total characters1312
Distinct characters249
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

Unique333 ?
Unique (%)95.1%

Sample

1st row각홀저천
2nd row갈재천
3rd row고리골천
4th row고비울천
5th row고재천
ValueCountFrequency (%)
터골천 3
 
0.9%
동막천 2
 
0.6%
작은골천 2
 
0.6%
도덕골천 2
 
0.6%
용수골천 2
 
0.6%
오약골천 2
 
0.6%
원당천 2
 
0.6%
안골천 2
 
0.6%
새터1천 1
 
0.3%
작은말천 1
 
0.3%
Other values (331) 331
94.6%
2023-12-12T18:21:02.589276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
천 352
26.8%
골 134
 
10.2%
산 21
 
1.6%
동 20
 
1.5%
1 20
 
1.5%
이 15
 
1.1%
수 15
 
1.1%
말 15
 
1.1%
작 13
 
1.0%
안 12
 
0.9%
Other values (239) 695
53.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1284
97.9%
Decimal Number 28
 
2.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
천 352
27.4%
골 134
 
10.4%
산 21
 
1.6%
동 20
 
1.6%
이 15
 
1.2%
수 15
 
1.2%
말 15
 
1.2%
작 13
 
1.0%
안 12
 
0.9%
은 12
 
0.9%
Other values (236) 675
52.6%
Decimal Number
ValueCountFrequency (%)
1 20
71.4%
2 7
 
25.0%
3 1
 
3.6%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1284
97.9%
Common 28
 
2.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
천 352
27.4%
골 134
 
10.4%
산 21
 
1.6%
동 20
 
1.6%
이 15
 
1.2%
수 15
 
1.2%
말 15
 
1.2%
작 13
 
1.0%
안 12
 
0.9%
은 12
 
0.9%
Other values (236) 675
52.6%
Common
ValueCountFrequency (%)
1 20
71.4%
2 7
 
25.0%
3 1
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1284
97.9%
ASCII 28
 
2.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
천 352
27.4%
골 134
 
10.4%
산 21
 
1.6%
동 20
 
1.6%
이 15
 
1.2%
수 15
 
1.2%
말 15
 
1.2%
작 13
 
1.0%
안 12
 
0.9%
은 12
 
0.9%
Other values (236) 675
52.6%
ASCII
ValueCountFrequency (%)
1 20
71.4%
2 7
 
25.0%
3 1
 
3.6%

길이(km)
Real number (ℝ)

Distinct159
Distinct (%)45.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.3164857
Minimum0.5
Maximum8.02
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.2 KiB
2023-12-12T18:21:02.787775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.5
5-th percentile0.55
Q10.75
median1.12
Q31.53
95-th percentile2.944
Maximum8.02
Range7.52
Interquartile range (IQR)0.78

Descriptive statistics

Standard deviation0.8635586
Coefficient of variation (CV)0.65595744
Kurtosis14.099161
Mean1.3164857
Median Absolute Deviation (MAD)0.385
Skewness2.9408737
Sum460.77
Variance0.74573346
MonotonicityNot monotonic
2023-12-12T18:21:03.011831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.58 8
 
2.3%
1.03 7
 
2.0%
0.53 6
 
1.7%
0.7 6
 
1.7%
1.47 5
 
1.4%
1.17 5
 
1.4%
0.68 5
 
1.4%
1.29 5
 
1.4%
1.2 5
 
1.4%
0.59 5
 
1.4%
Other values (149) 293
83.7%
ValueCountFrequency (%)
0.5 4
1.1%
0.51 4
1.1%
0.52 1
 
0.3%
0.53 6
1.7%
0.54 2
 
0.6%
0.55 2
 
0.6%
0.56 4
1.1%
0.57 2
 
0.6%
0.58 8
2.3%
0.59 5
1.4%
ValueCountFrequency (%)
8.02 1
0.3%
5.63 1
0.3%
5.42 1
0.3%
5.03 1
0.3%
4.49 1
0.3%
3.84 1
0.3%
3.78 1
0.3%
3.77 1
0.3%
3.44 1
0.3%
3.41 1
0.3%

구간시작위치
Text

UNIQUE 

Distinct350
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2023-12-12T18:21:03.543918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length9.6057143
Min length7

Characters and Unicode

Total characters3362
Distinct characters125
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

Unique350 ?
Unique (%)100.0%

Sample

1st row유구 문금 729
2nd row유구 문금 108
3rd row유구 탑곡 237
4th row유구 동해 463
5th row유구 녹천 674
ValueCountFrequency (%)
유구 53
 
5.0%
계룡 41
 
3.9%
신풍 37
 
3.5%
이인 34
 
3.2%
우성 34
 
3.2%
정안 33
 
3.1%
탄천 31
 
3.0%
사곡 29
 
2.8%
반포 18
 
1.7%
금학 15
 
1.4%
Other values (466) 725
69.0%
2023-12-12T18:21:04.248090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
701
20.9%
1 207
 
6.2%
2 164
 
4.9%
3 146
 
4.3%
- 143
 
4.3%
6 111
 
3.3%
5 99
 
2.9%
4 95
 
2.8%
7 77
 
2.3%
8 66
 
2.0%
Other values (115) 1553
46.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1440
42.8%
Decimal Number 1078
32.1%
Space Separator 701
20.9%
Dash Punctuation 143
 
4.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 64
 
4.4%
산 63
 
4.4%
구 62
 
4.3%
룡 61
 
4.2%
곡 56
 
3.9%
신 53
 
3.7%
계 51
 
3.5%
천 50
 
3.5%
정 46
 
3.2%
성 43
 
3.0%
Other values (103) 891
61.9%
Decimal Number
ValueCountFrequency (%)
1 207
19.2%
2 164
15.2%
3 146
13.5%
6 111
10.3%
5 99
9.2%
4 95
8.8%
7 77
 
7.1%
8 66
 
6.1%
9 60
 
5.6%
0 53
 
4.9%
Space Separator
ValueCountFrequency (%)
701
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 143
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1922
57.2%
Hangul 1440
42.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
유 64
 
4.4%
산 63
 
4.4%
구 62
 
4.3%
룡 61
 
4.2%
곡 56
 
3.9%
신 53
 
3.7%
계 51
 
3.5%
천 50
 
3.5%
정 46
 
3.2%
성 43
 
3.0%
Other values (103) 891
61.9%
Common
ValueCountFrequency (%)
701
36.5%
1 207
 
10.8%
2 164
 
8.5%
3 146
 
7.6%
- 143
 
7.4%
6 111
 
5.8%
5 99
 
5.2%
4 95
 
4.9%
7 77
 
4.0%
8 66
 
3.4%
Other values (2) 113
 
5.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1922
57.2%
Hangul 1440
42.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
701
36.5%
1 207
 
10.8%
2 164
 
8.5%
3 146
 
7.6%
- 143
 
7.4%
6 111
 
5.8%
5 99
 
5.2%
4 95
 
4.9%
7 77
 
4.0%
8 66
 
3.4%
Other values (2) 113
 
5.9%
Hangul
ValueCountFrequency (%)
유 64
 
4.4%
산 63
 
4.4%
구 62
 
4.3%
룡 61
 
4.2%
곡 56
 
3.9%
신 53
 
3.7%
계 51
 
3.5%
천 50
 
3.5%
정 46
 
3.2%
성 43
 
3.0%
Other values (103) 891
61.9%

구간종료위치
Text

Distinct343
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2023-12-12T18:21:04.772011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length10.302857
Min length8

Characters and Unicode

Total characters3606
Distinct characters124
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

Unique336 ?
Unique (%)96.0%

Sample

1st row유구 문금 779-4
2nd row유구 문금 510-2
3rd row유구 탑곡 60
4th row유구 동해 379-1
5th row유구 녹천 210-1
ValueCountFrequency (%)
유구 53
 
5.0%
계룡 41
 
3.9%
신풍 36
 
3.4%
우성 34
 
3.2%
이인 34
 
3.2%
정안 33
 
3.1%
탄천 31
 
3.0%
사곡 30
 
2.9%
반포 18
 
1.7%
금학 15
 
1.4%
Other values (475) 725
69.0%
2023-12-12T18:21:05.424614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
702
19.5%
- 232
 
6.4%
1 222
 
6.2%
2 191
 
5.3%
3 162
 
4.5%
4 158
 
4.4%
5 134
 
3.7%
7 89
 
2.5%
6 88
 
2.4%
9 77
 
2.1%
Other values (114) 1551
43.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1405
39.0%
Decimal Number 1267
35.1%
Space Separator 702
19.5%
Dash Punctuation 232
 
6.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
유 65
 
4.6%
구 62
 
4.4%
룡 62
 
4.4%
곡 57
 
4.1%
신 52
 
3.7%
계 52
 
3.7%
천 50
 
3.6%
정 47
 
3.3%
성 44
 
3.1%
안 39
 
2.8%
Other values (102) 875
62.3%
Decimal Number
ValueCountFrequency (%)
1 222
17.5%
2 191
15.1%
3 162
12.8%
4 158
12.5%
5 134
10.6%
7 89
7.0%
6 88
 
6.9%
9 77
 
6.1%
8 73
 
5.8%
0 73
 
5.8%
Space Separator
ValueCountFrequency (%)
702
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 232
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 2201
61.0%
Hangul 1405
39.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
유 65
 
4.6%
구 62
 
4.4%
룡 62
 
4.4%
곡 57
 
4.1%
신 52
 
3.7%
계 52
 
3.7%
천 50
 
3.6%
정 47
 
3.3%
성 44
 
3.1%
안 39
 
2.8%
Other values (102) 875
62.3%
Common
ValueCountFrequency (%)
702
31.9%
- 232
 
10.5%
1 222
 
10.1%
2 191
 
8.7%
3 162
 
7.4%
4 158
 
7.2%
5 134
 
6.1%
7 89
 
4.0%
6 88
 
4.0%
9 77
 
3.5%
Other values (2) 146
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2201
61.0%
Hangul 1405
39.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
702
31.9%
- 232
 
10.5%
1 222
 
10.1%
2 191
 
8.7%
3 162
 
7.4%
4 158
 
7.2%
5 134
 
6.1%
7 89
 
4.0%
6 88
 
4.0%
9 77
 
3.5%
Other values (2) 146
 
6.6%
Hangul
ValueCountFrequency (%)
유 65
 
4.6%
구 62
 
4.4%
룡 62
 
4.4%
곡 57
 
4.1%
신 52
 
3.7%
계 52
 
3.7%
천 50
 
3.6%
정 47
 
3.3%
성 44
 
3.1%
안 39
 
2.8%
Other values (102) 875
62.3%

읍면동별
Categorical

Distinct14
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
유구
49 
계룡
41 
신풍
37 
우성
34 
정안
33 
Other values (9)
156 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)0.3%

Sample

1st row유구
2nd row유구
3rd row유구
4th row유구
5th row유구

Common Values

ValueCountFrequency (%)
유구 49
14.0%
계룡 41
11.7%
신풍 37
10.6%
우성 34
9.7%
정안 33
9.4%
이인 33
9.4%
탄천 31
8.9%
사곡 29
8.3%
반포 18
 
5.1%
월송 13
 
3.7%
Other values (4) 32
9.1%

Length

2023-12-12T18:21:05.610938image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
유구 49
14.0%
계룡 41
11.7%
신풍 37
10.6%
우성 34
9.7%
정안 33
9.4%
이인 33
9.4%
탄천 31
8.9%
사곡 29
8.3%
반포 18
 
5.1%
월송 13
 
3.7%
Other values (4) 32
9.1%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
공주시
350 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row공주시
2nd row공주시
3rd row공주시
4th row공주시
5th row공주시

Common Values

ValueCountFrequency (%)
공주시 350
100.0%

Length

2023-12-12T18:21:05.757809image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T18:21:05.884680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
공주시 350
100.0%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
Minimum2019-12-16 00:00:00
Maximum2019-12-16 00:00:00
2023-12-12T18:21:06.001586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:21:06.133723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T18:21:00.522625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:21:06.233192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
길이(km)읍면동별
길이(km)1.0000.000
읍면동별0.0001.000
2023-12-12T18:21:06.358020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
길이(km)읍면동별
길이(km)1.0000.000
읍면동별0.0001.000

Missing values

2023-12-12T18:21:00.705201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:21:00.878486image/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

구분지정고시번호하천명길이(km)구간시작위치구간종료위치읍면동별관리기관명데이터기준일자
0소하천공주시 2004-31호각홀저천1.72유구 문금 729유구 문금 779-4유구공주시2019-12-16
1소하천공주시 2004-31호갈재천1.35유구 문금 108유구 문금 510-2유구공주시2019-12-16
2소하천공주시 2004-31호고리골천0.72유구 탑곡 237유구 탑곡 60유구공주시2019-12-16
3소하천공주시 2004-31호고비울천0.9유구 동해 463유구 동해 379-1유구공주시2019-12-16
4소하천공주시 2004-31호고재천2.0유구 녹천 674유구 녹천 210-1유구공주시2019-12-16
5소하천공주시 2004-31호광산골천0.82유구 덕곡 244유구 덕곡 164-1유구공주시2019-12-16
6소하천공주시 2004-31호구당골천0.52유구 덕곡 64유구 덕곡 99-1유구공주시2019-12-16
7소하천공주시 2004-31호노동천3.84유구 노동 182유구 백교 446-1유구공주시2019-12-16
8소하천공주시 2004-31호농기천3.32유구 유구 12유구 유구 497-22유구공주시2019-12-16
9소하천공주시 2004-31호다리골천0.65유구 덕곡 135-2유구 덕곡 115-2유구공주시2019-12-16
구분지정고시번호하천명길이(km)구간시작위치구간종료위치읍면동별관리기관명데이터기준일자
340소하천공주시 2004-31호방고개천0.72반포 봉곡 522-4반포 봉곡 424반포공주시2019-12-16
341소하천공주시 2004-31호봉곡1천1.03반포 봉곡 산56-16반포 봉곡 424-5반포공주시2019-12-16
342소하천공주시 2004-31호새뜸천0.77반포 봉곡 563-5반포 봉곡 413-1반포공주시2019-12-16
343소하천공주시 2004-31호성재천0.51반포 송곡 22-1반포 송곡 2-2반포공주시2019-12-16
344소하천공주시 2004-31호수물도천0.7반포 하신 143반포 하신 230반포공주시2019-12-16
345소하천공주시 2004-31호승적골천1.02반포 송곡 47-8반포 송곡 459-20반포공주시2019-12-16
346소하천공주시 2004-31호원당천1.82반포 봉곡 150반포 봉곡 41반포공주시2019-12-16
347소하천공주시 2004-31호정광터천1.13반포 봉곡 169반포 봉곡 14반포공주시2019-12-16
348소하천공주시 2004-31호지석골천1.13반포 학봉 506반포 학봉 326-1반포공주시2019-12-16
349소하천공주시 2004-31호파산박골천0.53반포 온천 412-1반포 온천 384-2반포공주시2019-12-16