Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory566.4 KiB
Average record size in memory58.0 B

Variable types

Numeric2
Text3
Categorical1

Dataset

Description공공데이터 중장기 개방계획에 따라 공개하는 경상남도 하천관리 시스템의 데이터 입니다. 하천관리시스템의 종단측점 정보를 포함하고있습니다.
Author경상남도
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15093566

Alerts

구분코드 has constant value ""Constant
공간아이디 has unique valuesUnique
공간정보 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:42:58.001027
Analysis finished2023-12-10 23:42:59.120791
Duration1.12 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공간아이디
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23761.718
Minimum7
Maximum47773
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T08:42:59.239899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum7
5-th percentile2402.8
Q111767
median23826
Q335495.75
95-th percentile45255.1
Maximum47773
Range47766
Interquartile range (IQR)23728.75

Descriptive statistics

Standard deviation13731.246
Coefficient of variation (CV)0.57787258
Kurtosis-1.1996575
Mean23761.718
Median Absolute Deviation (MAD)11844
Skewness-0.00079728725
Sum2.3761718 × 108
Variance1.885471 × 108
MonotonicityNot monotonic
2023-12-11T08:42:59.435973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
26703 1
 
< 0.1%
7580 1
 
< 0.1%
7715 1
 
< 0.1%
1239 1
 
< 0.1%
15914 1
 
< 0.1%
12731 1
 
< 0.1%
28763 1
 
< 0.1%
15134 1
 
< 0.1%
24218 1
 
< 0.1%
19329 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
7 1
< 0.1%
11 1
< 0.1%
12 1
< 0.1%
16 1
< 0.1%
19 1
< 0.1%
21 1
< 0.1%
34 1
< 0.1%
37 1
< 0.1%
42 1
< 0.1%
43 1
< 0.1%
ValueCountFrequency (%)
47773 1
< 0.1%
47768 1
< 0.1%
47759 1
< 0.1%
47758 1
< 0.1%
47757 1
< 0.1%
47752 1
< 0.1%
47745 1
< 0.1%
47743 1
< 0.1%
47741 1
< 0.1%
47739 1
< 0.1%

하천관리코드
Text

Distinct722
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T08:42:59.772560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length19
Mean length19
Min length19

Characters and Unicode

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

Unique

Unique8 ?
Unique (%)0.1%

Sample

1st row20272502010F02Q0102
2nd row40227302010F01Q0101
3rd row20237302015F02Q0101
4th row20246402010F01Q0101
5th row27202702012F02Q0101
ValueCountFrequency (%)
20246902020f02q0101 100
 
1.0%
20257502020f02q0101 69
 
0.7%
27209902014f02q0101 69
 
0.7%
20231502019f02q0101 61
 
0.6%
20228802004f01q0101 59
 
0.6%
20249602010f02q0101 53
 
0.5%
20250302004f02q0101 52
 
0.5%
20231502004f02q0101 47
 
0.5%
20268002012f02q0101 47
 
0.5%
20231102004f01q0101 45
 
0.4%
Other values (712) 9398
94.0%
2023-12-11T08:43:00.173128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 64973
34.2%
2 36075
19.0%
1 35935
18.9%
F 10000
 
5.3%
Q 10000
 
5.3%
9 6818
 
3.6%
7 5351
 
2.8%
4 4752
 
2.5%
6 4492
 
2.4%
3 4472
 
2.4%
Other values (2) 7132
 
3.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 170000
89.5%
Uppercase Letter 20000
 
10.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 64973
38.2%
2 36075
21.2%
1 35935
21.1%
9 6818
 
4.0%
7 5351
 
3.1%
4 4752
 
2.8%
6 4492
 
2.6%
3 4472
 
2.6%
5 4071
 
2.4%
8 3061
 
1.8%
Uppercase Letter
ValueCountFrequency (%)
F 10000
50.0%
Q 10000
50.0%

Most occurring scripts

ValueCountFrequency (%)
Common 170000
89.5%
Latin 20000
 
10.5%

Most frequent character per script

Common
ValueCountFrequency (%)
0 64973
38.2%
2 36075
21.2%
1 35935
21.1%
9 6818
 
4.0%
7 5351
 
3.1%
4 4752
 
2.8%
6 4492
 
2.6%
3 4472
 
2.6%
5 4071
 
2.4%
8 3061
 
1.8%
Latin
ValueCountFrequency (%)
F 10000
50.0%
Q 10000
50.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 190000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 64973
34.2%
2 36075
19.0%
1 35935
18.9%
F 10000
 
5.3%
Q 10000
 
5.3%
9 6818
 
3.6%
7 5351
 
2.8%
4 4752
 
2.5%
6 4492
 
2.4%
3 4472
 
2.4%
Other values (2) 7132
 
3.8%

구분코드
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
E07
10000 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowE07
2nd rowE07
3rd rowE07
4th rowE07
5th rowE07

Common Values

ValueCountFrequency (%)
E07 10000
100.0%

Length

2023-12-11T08:43:00.290143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:43:00.359628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
e07 10000
100.0%

일련번호
Real number (ℝ)

Distinct650
Distinct (%)6.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean99.0135
Minimum0
Maximum3142
Zeros11
Zeros (%)0.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-11T08:43:00.439341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile4
Q119
median41
Q374
95-th percentile230.05
Maximum3142
Range3142
Interquartile range (IQR)55

Descriptive statistics

Standard deviation292.56165
Coefficient of variation (CV)2.9547653
Kurtosis51.750057
Mean99.0135
Median Absolute Deviation (MAD)25
Skewness6.8469569
Sum990135
Variance85592.321
MonotonicityNot monotonic
2023-12-11T08:43:00.545228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 158
 
1.6%
10 152
 
1.5%
8 144
 
1.4%
12 142
 
1.4%
6 142
 
1.4%
5 139
 
1.4%
7 137
 
1.4%
14 136
 
1.4%
4 136
 
1.4%
20 135
 
1.4%
Other values (640) 8579
85.8%
ValueCountFrequency (%)
0 11
 
0.1%
1 158
1.6%
2 123
1.2%
3 127
1.3%
4 136
1.4%
5 139
1.4%
6 142
1.4%
7 137
1.4%
8 144
1.4%
9 132
1.3%
ValueCountFrequency (%)
3142 1
< 0.1%
3140 1
< 0.1%
3130 1
< 0.1%
3128 1
< 0.1%
3121 1
< 0.1%
3116 1
< 0.1%
3110 1
< 0.1%
3108 1
< 0.1%
3086 1
< 0.1%
3081 1
< 0.1%

측점번호
Text

Distinct3311
Distinct (%)33.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T08:43:00.784348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length9
Mean length9.031
Min length9

Characters and Unicode

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

Unique

Unique2557 ?
Unique (%)25.6%

Sample

1st row0045+0000
2nd row0064+0072
3rd row0007+0050
4th row0046+0000
5th row0016+0041
ValueCountFrequency (%)
0000+0000 145
 
1.5%
0003+0000 138
 
1.4%
0002+0000 135
 
1.4%
0001+0000 131
 
1.3%
0005+0000 118
 
1.2%
0011+0000 117
 
1.2%
0012+0000 116
 
1.2%
0006+0000 116
 
1.2%
0007+0000 111
 
1.1%
0004+0000 110
 
1.1%
Other values (3296) 8763
87.6%
2023-12-11T08:43:01.140532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 56095
62.1%
+ 9996
 
11.1%
1 4971
 
5.5%
2 3526
 
3.9%
5 3135
 
3.5%
3 2805
 
3.1%
4 2401
 
2.7%
6 1989
 
2.2%
8 1821
 
2.0%
7 1818
 
2.0%
Other values (4) 1753
 
1.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 80151
88.8%
Math Symbol 9996
 
11.1%
Other Punctuation 147
 
0.2%
Dash Punctuation 15
 
< 0.1%
Connector Punctuation 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 56095
70.0%
1 4971
 
6.2%
2 3526
 
4.4%
5 3135
 
3.9%
3 2805
 
3.5%
4 2401
 
3.0%
6 1989
 
2.5%
8 1821
 
2.3%
7 1818
 
2.3%
9 1590
 
2.0%
Math Symbol
ValueCountFrequency (%)
+ 9996
100.0%
Other Punctuation
ValueCountFrequency (%)
. 147
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 15
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 90310
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 56095
62.1%
+ 9996
 
11.1%
1 4971
 
5.5%
2 3526
 
3.9%
5 3135
 
3.5%
3 2805
 
3.1%
4 2401
 
2.7%
6 1989
 
2.2%
8 1821
 
2.0%
7 1818
 
2.0%
Other values (4) 1753
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
ASCII 90310
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 56095
62.1%
+ 9996
 
11.1%
1 4971
 
5.5%
2 3526
 
3.9%
5 3135
 
3.5%
3 2805
 
3.1%
4 2401
 
2.7%
6 1989
 
2.2%
8 1821
 
2.0%
7 1818
 
2.0%
Other values (4) 1753
 
1.9%

공간정보
Text

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T08:43:01.331718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length45
Median length45
Mean length44.5202
Min length39

Characters and Unicode

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

Unique

Unique10000 ?
Unique (%)100.0%

Sample

1st rowPOINT (1137235.2358923783 1735043.7547523598)
2nd rowPOINT (1023590.727327839 1681768.1541684214)
3rd rowPOINT (1076342.3327878918 1720180.3355910126)
4th rowPOINT (1038119.8148847272 1711691.2228992719)
5th rowPOINT (1096787.0350708447 1691169.5437466274)
ValueCountFrequency (%)
point 10000
33.3%
1084451.8784521197 1
 
< 0.1%
1715925.0458078277 1
 
< 0.1%
1048597.2332661285 1
 
< 0.1%
1680570.3162924557 1
 
< 0.1%
1067868.61010718 1
 
< 0.1%
1739146.3837482594 1
 
< 0.1%
1053671.4857049873 1
 
< 0.1%
1716663.4545984785 1
 
< 0.1%
1698758.9032412802 1
 
< 0.1%
Other values (19991) 19991
66.6%
2023-12-11T08:43:01.855350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 50468
11.3%
7 35916
 
8.1%
0 35781
 
8.0%
6 33778
 
7.6%
2 30397
 
6.8%
3 30315
 
6.8%
5 30154
 
6.8%
8 29956
 
6.7%
4 29595
 
6.6%
9 28842
 
6.5%
Other values (9) 110000
24.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 335202
75.3%
Uppercase Letter 50000
 
11.2%
Space Separator 20000
 
4.5%
Other Punctuation 20000
 
4.5%
Open Punctuation 10000
 
2.2%
Close Punctuation 10000
 
2.2%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 50468
15.1%
7 35916
10.7%
0 35781
10.7%
6 33778
10.1%
2 30397
9.1%
3 30315
9.0%
5 30154
9.0%
8 29956
8.9%
4 29595
8.8%
9 28842
8.6%
Uppercase Letter
ValueCountFrequency (%)
T 10000
20.0%
N 10000
20.0%
O 10000
20.0%
I 10000
20.0%
P 10000
20.0%
Space Separator
ValueCountFrequency (%)
20000
100.0%
Other Punctuation
ValueCountFrequency (%)
. 20000
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10000
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 395202
88.8%
Latin 50000
 
11.2%

Most frequent character per script

Common
ValueCountFrequency (%)
1 50468
12.8%
7 35916
9.1%
0 35781
9.1%
6 33778
8.5%
2 30397
7.7%
3 30315
7.7%
5 30154
7.6%
8 29956
7.6%
4 29595
7.5%
9 28842
7.3%
Other values (4) 60000
15.2%
Latin
ValueCountFrequency (%)
T 10000
20.0%
N 10000
20.0%
O 10000
20.0%
I 10000
20.0%
P 10000
20.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 445202
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 50468
11.3%
7 35916
 
8.1%
0 35781
 
8.0%
6 33778
 
7.6%
2 30397
 
6.8%
3 30315
 
6.8%
5 30154
 
6.8%
8 29956
 
6.7%
4 29595
 
6.6%
9 28842
 
6.5%
Other values (9) 110000
24.7%

Interactions

2023-12-11T08:42:58.638730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:42:58.421766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:42:58.778607image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:42:58.526807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T08:43:01.936198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공간아이디일련번호
공간아이디1.0000.478
일련번호0.4781.000
2023-12-11T08:43:02.009902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공간아이디일련번호
공간아이디1.0000.075
일련번호0.0751.000

Missing values

2023-12-11T08:42:58.934883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:42:59.059577image/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

공간아이디하천관리코드구분코드일련번호측점번호공간정보
267022670320272502010F02Q0102E07530045+0000POINT (1137235.2358923783 1735043.7547523598)
407034070440227302010F01Q0101E071710064+0072POINT (1023590.727327839 1681768.1541684214)
5504550520237302015F02Q0101E07180007+0050POINT (1076342.3327878918 1720180.3355910126)
105641056520246402010F01Q0101E07930046+0000POINT (1038119.8148847272 1711691.2228992719)
314753147627202702012F02Q0101E07750016+0041POINT (1096787.0350708447 1691169.5437466274)
279742797520275402011F02Q0101E07550037+0000POINT (1137111.1657013858 1719441.033565823)
5832583320237601988F01Q0101E07630042+0000POINT (1074355.1740527353 1715754.9983558916)
363713637227209902014F02Q0101E071850008+0200POINT (1056279.858838636 1671596.5087345396)
213112131220263601997F01Q0101E0770003+0060POINT (1093644.645097502 1697153.5096600384)
440234402420234302019F02Q0101E071090008+0292POINT (1060070.258799359 1722904.9144135155)
공간아이디하천관리코드구분코드일련번호측점번호공간정보
469174691820238002020F01Q0101E07770001+0850POINT (1067148.4738736334 1717243.0899904054)
201442014520262001998F01Q0101E07150004+0170POINT (1083785.58735942 1706367.0635778771)
395413954240225902013F01Q0101E07200016+0000POINT (1011198.5849096635 1697026.7977234288)
130221302320249902012F02Q0101E07140005+0000POINT (1046210.857171916 1719980.158733824)
317753177627203102010F01Q0101E07240010+0050POINT (1098149.829243899 1680473.4995832534)
445214452220234802019F02Q0101E071500010+0672POINT (1054851.1844726175 1734605.9913785944)
262972629820272102010F01Q0101E07770028+0050POINT (1128661.171900444 1728880.1431079237)
252652526620268702008F02Q0101E07410039+0000POINT (1121069.2879462875 1703555.0877001423)
236742367520266602013F02Q0101E07130042+0000POINT (1102286.577640305 1724164.995765819)
158361583720255602014F02Q0101E071570114+0098POINT (1071373.2397181832 1675552.9956514481)