Overview

Dataset statistics

Number of variables30
Number of observations24
Missing cells553
Missing cells (%)76.8%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.2 KiB
Average record size in memory266.5 B

Variable types

Text1
Unsupported29

Dataset

Description옥정호주요하천항목별수질조사결과_2020년10월
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=204370

Alerts

2020년 옥정호 주요하천 수질조사결과 (10월) has 1 (4.2%) missing valuesMissing
Unnamed: 1 has 6 (25.0%) missing valuesMissing
Unnamed: 2 has 24 (100.0%) missing valuesMissing
Unnamed: 3 has 24 (100.0%) missing valuesMissing
Unnamed: 4 has 24 (100.0%) missing valuesMissing
Unnamed: 5 has 6 (25.0%) missing valuesMissing
Unnamed: 6 has 24 (100.0%) missing valuesMissing
Unnamed: 7 has 24 (100.0%) missing valuesMissing
Unnamed: 8 has 24 (100.0%) missing valuesMissing
Unnamed: 9 has 6 (25.0%) missing valuesMissing
Unnamed: 10 has 24 (100.0%) missing valuesMissing
Unnamed: 11 has 24 (100.0%) missing valuesMissing
Unnamed: 12 has 24 (100.0%) missing valuesMissing
Unnamed: 13 has 6 (25.0%) missing valuesMissing
Unnamed: 14 has 24 (100.0%) missing valuesMissing
Unnamed: 15 has 24 (100.0%) missing valuesMissing
Unnamed: 16 has 24 (100.0%) missing valuesMissing
Unnamed: 17 has 6 (25.0%) missing valuesMissing
Unnamed: 18 has 24 (100.0%) missing valuesMissing
Unnamed: 19 has 24 (100.0%) missing valuesMissing
Unnamed: 20 has 24 (100.0%) missing valuesMissing
Unnamed: 21 has 6 (25.0%) missing valuesMissing
Unnamed: 22 has 24 (100.0%) missing valuesMissing
Unnamed: 23 has 24 (100.0%) missing valuesMissing
Unnamed: 24 has 24 (100.0%) missing valuesMissing
Unnamed: 25 has 6 (25.0%) missing valuesMissing
Unnamed: 26 has 24 (100.0%) missing valuesMissing
Unnamed: 27 has 24 (100.0%) missing valuesMissing
Unnamed: 28 has 24 (100.0%) missing valuesMissing
Unnamed: 29 has 6 (25.0%) missing valuesMissing
Unnamed: 1 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 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
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 12 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 16 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 17 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 18 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 19 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 20 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 21 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 22 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 23 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 24 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 25 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 26 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 27 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 28 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 29 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 01:16:39.985686
Analysis finished2024-03-14 01:16:40.123594
Duration0.14 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2020년 옥정호 주요하천 수질조사결과 (10월)
Text

MISSING 

Distinct23
Distinct (%)100.0%
Missing1
Missing (%)4.2%
Memory size324.0 B
2024-03-14T10:16:40.245013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length73
Median length22
Mean length14.695652
Min length2

Characters and Unicode

Total characters338
Distinct characters87
Distinct categories11 ?
Distinct scripts4 ?
Distinct blocks5 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique23 ?
Unique (%)100.0%

Sample

1st row□ 조사지점 : 옥정호 주요하천 8개 지점(임실천, 오원천, 섬진강본류, 옥녀동천, 추령천, 도원천하류, 동진강상류, 섬진강댐하류)
2nd row□ 조사일자 : 2020. 10. 12.
3rd row□ 조사항목 : 현장측정(수온, pH, DO, 전기전도도) 및 BOD 등 17개 항목
4th row□ 조사결과
5th row채수지점
ValueCountFrequency (%)
□ 4
 
7.1%
3
 
5.4%
전기전도도 2
 
3.6%
ph 2
 
3.6%
nh3-n(mg/l 1
 
1.8%
조사결과 1
 
1.8%
채수지점 1
 
1.8%
수온(℃ 1
 
1.8%
do(mg/l 1
 
1.8%
μs/cm 1
 
1.8%
Other values (39) 39
69.6%
2024-03-14T10:16:40.525460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
33
 
9.8%
) 18
 
5.3%
( 18
 
5.3%
m 16
 
4.7%
/ 15
 
4.4%
L 13
 
3.8%
g 12
 
3.6%
, 10
 
3.0%
O 9
 
2.7%
0 7
 
2.1%
Other values (77) 187
55.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 114
33.7%
Uppercase Letter 51
15.1%
Lowercase Letter 35
 
10.4%
Space Separator 33
 
9.8%
Other Punctuation 32
 
9.5%
Decimal Number 22
 
6.5%
Close Punctuation 18
 
5.3%
Open Punctuation 18
 
5.3%
Dash Punctuation 7
 
2.1%
Other Symbol 5
 
1.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
천 6
 
5.3%
수 5
 
4.4%
장 5
 
4.4%
도 5
 
4.4%
류 4
 
3.5%
대 4
 
3.5%
군 4
 
3.5%
전 4
 
3.5%
균 4
 
3.5%
조 4
 
3.5%
Other values (41) 69
60.5%
Uppercase Letter
ValueCountFrequency (%)
L 13
25.5%
O 9
17.6%
N 7
13.7%
D 5
 
9.8%
H 3
 
5.9%
S 3
 
5.9%
T 3
 
5.9%
P 3
 
5.9%
C 3
 
5.9%
B 2
 
3.9%
Lowercase Letter
ValueCountFrequency (%)
m 16
45.7%
g 12
34.3%
p 2
 
5.7%
c 1
 
2.9%
h 1
 
2.9%
μ 1
 
2.9%
l 1
 
2.9%
a 1
 
2.9%
Decimal Number
ValueCountFrequency (%)
0 7
31.8%
1 5
22.7%
2 4
18.2%
3 3
13.6%
4 1
 
4.5%
8 1
 
4.5%
7 1
 
4.5%
Other Punctuation
ValueCountFrequency (%)
/ 15
46.9%
, 10
31.2%
. 4
 
12.5%
: 3
 
9.4%
Other Symbol
ValueCountFrequency (%)
□ 4
80.0%
℃ 1
 
20.0%
Space Separator
ValueCountFrequency (%)
33
100.0%
Close Punctuation
ValueCountFrequency (%)
) 18
100.0%
Open Punctuation
ValueCountFrequency (%)
( 18
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Control
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 138
40.8%
Hangul 114
33.7%
Latin 85
25.1%
Greek 1
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
천 6
 
5.3%
수 5
 
4.4%
장 5
 
4.4%
도 5
 
4.4%
류 4
 
3.5%
대 4
 
3.5%
군 4
 
3.5%
전 4
 
3.5%
균 4
 
3.5%
조 4
 
3.5%
Other values (41) 69
60.5%
Common
ValueCountFrequency (%)
33
23.9%
) 18
13.0%
( 18
13.0%
/ 15
10.9%
, 10
 
7.2%
0 7
 
5.1%
- 7
 
5.1%
1 5
 
3.6%
□ 4
 
2.9%
. 4
 
2.9%
Other values (8) 17
12.3%
Latin
ValueCountFrequency (%)
m 16
18.8%
L 13
15.3%
g 12
14.1%
O 9
10.6%
N 7
8.2%
D 5
 
5.9%
H 3
 
3.5%
S 3
 
3.5%
T 3
 
3.5%
P 3
 
3.5%
Other values (7) 11
12.9%
Greek
ValueCountFrequency (%)
μ 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 218
64.5%
Hangul 114
33.7%
Geometric Shapes 4
 
1.2%
None 1
 
0.3%
Letterlike Symbols 1
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
33
15.1%
) 18
 
8.3%
( 18
 
8.3%
m 16
 
7.3%
/ 15
 
6.9%
L 13
 
6.0%
g 12
 
5.5%
, 10
 
4.6%
O 9
 
4.1%
0 7
 
3.2%
Other values (23) 67
30.7%
Hangul
ValueCountFrequency (%)
천 6
 
5.3%
수 5
 
4.4%
장 5
 
4.4%
도 5
 
4.4%
류 4
 
3.5%
대 4
 
3.5%
군 4
 
3.5%
전 4
 
3.5%
균 4
 
3.5%
조 4
 
3.5%
Other values (41) 69
60.5%
Geometric Shapes
ValueCountFrequency (%)
□ 4
100.0%
None
ValueCountFrequency (%)
μ 1
100.0%
Letterlike Symbols
ValueCountFrequency (%)
℃ 1
100.0%

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)25.0%
Memory size324.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)25.0%
Memory size324.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)25.0%
Memory size324.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)25.0%
Memory size324.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)25.0%
Memory size324.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)25.0%
Memory size324.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)25.0%
Memory size324.0 B

Unnamed: 26
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 27
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 28
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing24
Missing (%)100.0%
Memory size348.0 B

Unnamed: 29
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing6
Missing (%)25.0%
Memory size324.0 B

Sample

2020년 옥정호 주요하천 수질조사결과 (10월)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29
0<NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN
1□ 조사지점 : 옥정호 주요하천 8개 지점(임실천, 오원천, 섬진강본류, 옥녀동천, 추령천, 도원천하류, 동진강상류, 섬진강댐하류)NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN
2□ 조사일자 : 2020. 10. 12.NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN
3□ 조사항목 : 현장측정(수온, pH, DO, 전기전도도) 및 BOD 등 17개 항목NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN
4□ 조사결과NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN
5채수지점임실천<NA><NA><NA>오원천<NA><NA><NA>섬진강\n본류<NA><NA><NA>옥녀동천<NA><NA><NA>추령천<NA><NA><NA>도원천\n하류<NA><NA><NA>동진강\n상류<NA><NA><NA>섬진강댐\n하류
6수온(℃)19.9<NA><NA><NA>20.8<NA><NA><NA>20.8<NA><NA><NA>20.6<NA><NA><NA>18.7<NA><NA><NA>20.6<NA><NA><NA>18.9<NA><NA><NA>20.2
7pH8.1<NA><NA><NA>8.4<NA><NA><NA>8.4<NA><NA><NA>7.8<NA><NA><NA>8.1<NA><NA><NA>8.1<NA><NA><NA>8.1<NA><NA><NA>7.6
8DO(mg/L)10.1<NA><NA><NA>11.3<NA><NA><NA>11.1<NA><NA><NA>9.7<NA><NA><NA>9.4<NA><NA><NA>9.5<NA><NA><NA>9.4<NA><NA><NA>8.8
9전기전도도 (μS/cm)282<NA><NA><NA>177<NA><NA><NA>118<NA><NA><NA>137<NA><NA><NA>108<NA><NA><NA>75<NA><NA><NA>88<NA><NA><NA>80
2020년 옥정호 주요하천 수질조사결과 (10월)Unnamed: 1Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5Unnamed: 6Unnamed: 7Unnamed: 8Unnamed: 9Unnamed: 10Unnamed: 11Unnamed: 12Unnamed: 13Unnamed: 14Unnamed: 15Unnamed: 16Unnamed: 17Unnamed: 18Unnamed: 19Unnamed: 20Unnamed: 21Unnamed: 22Unnamed: 23Unnamed: 24Unnamed: 25Unnamed: 26Unnamed: 27Unnamed: 28Unnamed: 29
14NO2-N(mg/L)0.114<NA><NA><NA>0.013<NA><NA><NA>0.018<NA><NA><NA>0.004<NA><NA><NA>0.01<NA><NA><NA>0.004<NA><NA><NA>0.004<NA><NA><NA>0.004
15NO3-N(mg/L)0.686<NA><NA><NA>0.537<NA><NA><NA>0.284<NA><NA><NA>0.542<NA><NA><NA>1.292<NA><NA><NA>1.102<NA><NA><NA>1.304<NA><NA><NA>0.967
16T-N(mg/L)2.2<NA><NA><NA>0.906<NA><NA><NA>0.845<NA><NA><NA>1.297<NA><NA><NA>1.425<NA><NA><NA>1.271<NA><NA><NA>1.454<NA><NA><NA>1.132
17PO4-P(mg/L)0.024<NA><NA><NA>0.013<NA><NA><NA>0.004<NA><NA><NA>0.006<NA><NA><NA>0.006<NA><NA><NA>0.011<NA><NA><NA>0.014<NA><NA><NA>0.007
18T-P(mg/L)0.054<NA><NA><NA>0.034<NA><NA><NA>0.04<NA><NA><NA>0.02<NA><NA><NA>0.019<NA><NA><NA>0.029<NA><NA><NA>0.022<NA><NA><NA>0.021
19Chl-a(mg/m3)8.7<NA><NA><NA>8<NA><NA><NA>47.6<NA><NA><NA>7.7<NA><NA><NA>2.6<NA><NA><NA>7.1<NA><NA><NA>5.4<NA><NA><NA>11.7
20SS(mg/L)4.4<NA><NA><NA>3.1<NA><NA><NA>15.21<NA><NA><NA>4.3<NA><NA><NA>2.2<NA><NA><NA>5<NA><NA><NA>3.9<NA><NA><NA>3.4
21총대장균군 (총대장균군수/100mL)9700<NA><NA><NA>2800<NA><NA><NA>1100<NA><NA><NA>8700<NA><NA><NA>1700<NA><NA><NA>7100<NA><NA><NA>8700<NA><NA><NA>5600
22분원성대장균군 (분원성대장균군수/100mL)130<NA><NA><NA>100<NA><NA><NA>60<NA><NA><NA>27<NA><NA><NA>26<NA><NA><NA>420<NA><NA><NA>230<NA><NA><NA>82
23끝.NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN<NA><NA><NA>NaN