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년8월
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=204368

Alerts

2020년 옥정호 주요하천 수질조사결과 (8월) 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 00:37:28.744569
Analysis finished2024-03-14 00:37:28.876253
Duration0.13 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

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

MISSING 

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

Length

Max length73
Median length21
Mean length14.652174
Min length2

Characters and Unicode

Total characters337
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. 8. 20.
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-14T09:37:29.286994image/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.5%
L 13
 
3.9%
g 12
 
3.6%
, 10
 
3.0%
O 9
 
2.7%
0 7
 
2.1%
Other values (77) 186
55.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 114
33.8%
Uppercase Letter 51
15.1%
Lowercase Letter 35
 
10.4%
Space Separator 33
 
9.8%
Other Punctuation 32
 
9.5%
Decimal Number 21
 
6.2%
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%
P 3
 
5.9%
S 3
 
5.9%
C 3
 
5.9%
T 3
 
5.9%
H 3
 
5.9%
B 2
 
3.9%
Lowercase Letter
ValueCountFrequency (%)
m 16
45.7%
g 12
34.3%
p 2
 
5.7%
a 1
 
2.9%
l 1
 
2.9%
c 1
 
2.9%
h 1
 
2.9%
μ 1
 
2.9%
Decimal Number
ValueCountFrequency (%)
0 7
33.3%
2 4
19.0%
1 3
14.3%
3 3
14.3%
8 2
 
9.5%
4 1
 
4.8%
7 1
 
4.8%
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 137
40.7%
Hangul 114
33.8%
Latin 85
25.2%
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
24.1%
) 18
13.1%
( 18
13.1%
/ 15
10.9%
, 10
 
7.3%
0 7
 
5.1%
- 7
 
5.1%
. 4
 
2.9%
2 4
 
2.9%
□ 4
 
2.9%
Other values (8) 17
12.4%
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%
P 3
 
3.5%
S 3
 
3.5%
C 3
 
3.5%
T 3
 
3.5%
Other values (7) 11
12.9%
Greek
ValueCountFrequency (%)
μ 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 217
64.4%
Hangul 114
33.8%
Geometric Shapes 4
 
1.2%
None 1
 
0.3%
Letterlike Symbols 1
 
0.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
33
15.2%
) 18
 
8.3%
( 18
 
8.3%
m 16
 
7.4%
/ 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) 66
30.4%
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년 옥정호 주요하천 수질조사결과 (8월)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. 8. 20.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수온(℃)29.1<NA><NA><NA>31.7<NA><NA><NA>32.5<NA><NA><NA>30.2<NA><NA><NA>27.2<NA><NA><NA>22.8<NA><NA><NA>22.5<NA><NA><NA>24.6
7pH8.2<NA><NA><NA>8.9<NA><NA><NA>9.3<NA><NA><NA>7<NA><NA><NA>7.9<NA><NA><NA>7.7<NA><NA><NA>7.7<NA><NA><NA>7.8
8DO(mg/L)8.7<NA><NA><NA>9.6<NA><NA><NA>11.5<NA><NA><NA>4.5<NA><NA><NA>8.5<NA><NA><NA>8.7<NA><NA><NA>8.5<NA><NA><NA>8.4
9전기전도도 (μS/cm)225<NA><NA><NA>142<NA><NA><NA>127<NA><NA><NA>109<NA><NA><NA>106<NA><NA><NA>64<NA><NA><NA>67<NA><NA><NA>70
2020년 옥정호 주요하천 수질조사결과 (8월)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.04<NA><NA><NA>0.027<NA><NA><NA>0.019<NA><NA><NA>0.032<NA><NA><NA>0.008<NA><NA><NA>0.01<NA><NA><NA>0.009<NA><NA><NA>0.009
15NO3-N(mg/L)1.047<NA><NA><NA>1.068<NA><NA><NA>0.76<NA><NA><NA>0.399<NA><NA><NA>1.576<NA><NA><NA>0.921<NA><NA><NA>1.076<NA><NA><NA>0.953
16T-N(mg/L)1.878<NA><NA><NA>1.69<NA><NA><NA>1.225<NA><NA><NA>0.956<NA><NA><NA>2.269<NA><NA><NA>1.38<NA><NA><NA>1.595<NA><NA><NA>1.465
17PO4-P(mg/L)0.054<NA><NA><NA>0.007<NA><NA><NA>0.01<NA><NA><NA>0.004<NA><NA><NA>불검츨<NA><NA><NA>0.053<NA><NA><NA>0.052<NA><NA><NA>0.021
18T-P(mg/L)0.166<NA><NA><NA>0.029<NA><NA><NA>0.03<NA><NA><NA>0.042<NA><NA><NA>0.023<NA><NA><NA>0.098<NA><NA><NA>0.082<NA><NA><NA>0.076
19Chl-a(mg/m3)15.7<NA><NA><NA>32<NA><NA><NA>25.9<NA><NA><NA>23.7<NA><NA><NA>8<NA><NA><NA>7.6<NA><NA><NA>8.1<NA><NA><NA>8.6
20SS(mg/L)4<NA><NA><NA>4.4<NA><NA><NA>4.6<NA><NA><NA>5.4<NA><NA><NA>3<NA><NA><NA>26.8<NA><NA><NA>17.6<NA><NA><NA>17.6
21총대장균군 (총대장균군수/100mL)9400<NA><NA><NA>22000<NA><NA><NA>2800<NA><NA><NA>15000<NA><NA><NA>5700<NA><NA><NA>15000<NA><NA><NA>6200<NA><NA><NA>5700
22분원성대장균군 (분원성대장균군수/100mL)420<NA><NA><NA>1500<NA><NA><NA>89<NA><NA><NA>960<NA><NA><NA>1400<NA><NA><NA>3600<NA><NA><NA>2700<NA><NA><NA>640
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