Overview

Dataset statistics

Number of variables27
Number of observations23
Missing cells457
Missing cells (%)73.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.4 KiB
Average record size in memory240.7 B

Variable types

Text1
Unsupported26

Dataset

Description용담호유입하천수질조사결과2016년03월
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202733

Alerts

Unnamed: 1 has 23 (100.0%) missing valuesMissing
Unnamed: 2 has 2 (8.7%) missing valuesMissing
Unnamed: 3 has 23 (100.0%) missing valuesMissing
Unnamed: 4 has 23 (100.0%) missing valuesMissing
Unnamed: 5 has 23 (100.0%) missing valuesMissing
Unnamed: 6 has 3 (13.0%) missing valuesMissing
Unnamed: 7 has 23 (100.0%) missing valuesMissing
Unnamed: 8 has 23 (100.0%) missing valuesMissing
Unnamed: 9 has 23 (100.0%) missing valuesMissing
Unnamed: 10 has 3 (13.0%) missing valuesMissing
Unnamed: 11 has 23 (100.0%) missing valuesMissing
Unnamed: 12 has 23 (100.0%) missing valuesMissing
Unnamed: 13 has 23 (100.0%) missing valuesMissing
Unnamed: 14 has 3 (13.0%) missing valuesMissing
Unnamed: 15 has 23 (100.0%) missing valuesMissing
Unnamed: 16 has 23 (100.0%) missing valuesMissing
Unnamed: 17 has 23 (100.0%) missing valuesMissing
Unnamed: 18 has 3 (13.0%) missing valuesMissing
Unnamed: 19 has 23 (100.0%) missing valuesMissing
Unnamed: 20 has 23 (100.0%) missing valuesMissing
Unnamed: 21 has 23 (100.0%) missing valuesMissing
Unnamed: 22 has 3 (13.0%) missing valuesMissing
Unnamed: 23 has 23 (100.0%) missing valuesMissing
Unnamed: 24 has 23 (100.0%) missing valuesMissing
Unnamed: 25 has 23 (100.0%) missing valuesMissing
Unnamed: 26 has 3 (13.0%) missing valuesMissing
2016년 3월 has unique valuesUnique
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

Reproduction

Analysis started2024-03-14 01:23:40.908828
Analysis finished2024-03-14 01:23:41.041640
Duration0.13 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

2016년 3월
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size316.0 B
2024-03-14T10:23:41.147298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length17
Mean length10.521739
Min length2

Characters and Unicode

Total characters242
Distinct characters70
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용담호 유입하천 수질조사결과
2nd row□ 조사지점 : 용담호 유입하천
3rd row□ 시험항목 ○ 매월 :
4th row채수지점
5th row채수일시
ValueCountFrequency (%)
용담호 2
 
5.6%
□ 2
 
5.6%
2
 
5.6%
유입하천 2
 
5.6%
총대장균군수/100ml 1
 
2.8%
분원성대장균군 1
 
2.8%
총대장균군 1
 
2.8%
ss(mg/l 1
 
2.8%
cod(mg/l 1
 
2.8%
t-p(mg/l 1
 
2.8%
Other values (22) 22
61.1%
2024-03-14T10:23:41.415322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
( 16
 
6.6%
) 16
 
6.6%
m 16
 
6.6%
/ 15
 
6.2%
13
 
5.4%
L 13
 
5.4%
g 12
 
5.0%
N 7
 
2.9%
O 7
 
2.9%
- 7
 
2.9%
Other values (60) 120
49.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 75
31.0%
Uppercase Letter 45
18.6%
Lowercase Letter 34
14.0%
Other Punctuation 17
 
7.0%
Open Punctuation 16
 
6.6%
Close Punctuation 16
 
6.6%
Space Separator 13
 
5.4%
Decimal Number 11
 
4.5%
Dash Punctuation 7
 
2.9%
Control 4
 
1.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
수 6
 
8.0%
대 4
 
5.3%
균 4
 
5.3%
장 4
 
5.3%
군 4
 
5.3%
사 3
 
4.0%
도 2
 
2.7%
전 2
 
2.7%
총 2
 
2.7%
분 2
 
2.7%
Other values (27) 42
56.0%
Uppercase Letter
ValueCountFrequency (%)
L 13
28.9%
N 7
15.6%
O 7
15.6%
S 3
 
6.7%
D 3
 
6.7%
C 3
 
6.7%
T 3
 
6.7%
P 3
 
6.7%
H 2
 
4.4%
B 1
 
2.2%
Lowercase Letter
ValueCountFrequency (%)
m 16
47.1%
g 12
35.3%
a 1
 
2.9%
l 1
 
2.9%
h 1
 
2.9%
c 1
 
2.9%
μ 1
 
2.9%
p 1
 
2.9%
Decimal Number
ValueCountFrequency (%)
0 4
36.4%
3 3
27.3%
1 2
18.2%
4 1
 
9.1%
2 1
 
9.1%
Other Symbol
ValueCountFrequency (%)
□ 2
50.0%
℃ 1
25.0%
○ 1
25.0%
Other Punctuation
ValueCountFrequency (%)
/ 15
88.2%
: 2
 
11.8%
Open Punctuation
ValueCountFrequency (%)
( 16
100.0%
Close Punctuation
ValueCountFrequency (%)
) 16
100.0%
Space Separator
ValueCountFrequency (%)
13
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 7
100.0%
Control
ValueCountFrequency (%)
4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 88
36.4%
Latin 78
32.2%
Hangul 75
31.0%
Greek 1
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
수 6
 
8.0%
대 4
 
5.3%
균 4
 
5.3%
장 4
 
5.3%
군 4
 
5.3%
사 3
 
4.0%
도 2
 
2.7%
전 2
 
2.7%
총 2
 
2.7%
분 2
 
2.7%
Other values (27) 42
56.0%
Latin
ValueCountFrequency (%)
m 16
20.5%
L 13
16.7%
g 12
15.4%
N 7
9.0%
O 7
9.0%
S 3
 
3.8%
D 3
 
3.8%
C 3
 
3.8%
T 3
 
3.8%
P 3
 
3.8%
Other values (7) 8
10.3%
Common
ValueCountFrequency (%)
( 16
18.2%
) 16
18.2%
/ 15
17.0%
13
14.8%
- 7
8.0%
0 4
 
4.5%
4
 
4.5%
3 3
 
3.4%
1 2
 
2.3%
: 2
 
2.3%
Other values (5) 6
 
6.8%
Greek
ValueCountFrequency (%)
μ 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 162
66.9%
Hangul 75
31.0%
Geometric Shapes 3
 
1.2%
Letterlike Symbols 1
 
0.4%
None 1
 
0.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
( 16
 
9.9%
) 16
 
9.9%
m 16
 
9.9%
/ 15
 
9.3%
13
 
8.0%
L 13
 
8.0%
g 12
 
7.4%
N 7
 
4.3%
O 7
 
4.3%
- 7
 
4.3%
Other values (19) 40
24.7%
Hangul
ValueCountFrequency (%)
수 6
 
8.0%
대 4
 
5.3%
균 4
 
5.3%
장 4
 
5.3%
군 4
 
5.3%
사 3
 
4.0%
도 2
 
2.7%
전 2
 
2.7%
총 2
 
2.7%
분 2
 
2.7%
Other values (27) 42
56.0%
Geometric Shapes
ValueCountFrequency (%)
□ 2
66.7%
○ 1
33.3%
Letterlike Symbols
ValueCountFrequency (%)
℃ 1
100.0%
None
ValueCountFrequency (%)
μ 1
100.0%

Unnamed: 1
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 2
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)8.7%
Memory size316.0 B

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 6
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)13.0%
Memory size316.0 B

Unnamed: 7
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 8
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 9
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 10
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)13.0%
Memory size316.0 B

Unnamed: 11
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 12
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 13
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 14
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)13.0%
Memory size316.0 B

Unnamed: 15
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 16
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 17
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 18
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)13.0%
Memory size316.0 B

Unnamed: 19
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 20
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 21
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 22
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)13.0%
Memory size316.0 B

Unnamed: 23
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 24
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 25
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing23
Missing (%)100.0%
Memory size339.0 B

Unnamed: 26
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing3
Missing (%)13.0%
Memory size316.0 B

Sample

2016년 3월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: 26
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
1□ 조사지점 : 용담호 유입하천<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□ 시험항목 ○ 매월 :<NA>수온, pH, DO, 전기전도도, BOD, COD, TOC, SS, T-N, T-P, 분원성대장균군수, 총대장균군수, NO2-N, NO3-N, NH3-N, PO4-P, 클로로필-a<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채수지점<NA>통학교<NA><NA><NA>동정교<NA><NA><NA>천천1교<NA><NA><NA>오봉교<NA><NA><NA>섬티교<NA><NA><NA>구암교<NA><NA><NA>금성교
4채수일시<NA>2016.03.16\n10:10<NA><NA><NA>2016.03.16\n11:00<NA><NA><NA>2016.03.16\n11:13<NA><NA><NA>2016.03.16\n13:40<NA><NA><NA>2016.03.15\n10:46<NA><NA><NA>2016.03.15\n14:38<NA><NA><NA>2016.03.15\n13:39
5검사기간<NA>2016.03.16-\n03.31<NA><NA><NA>2016.03.16-\n03.31<NA><NA><NA>2016.03.16-\n03.31<NA><NA><NA>2016.03.16-\n03.31<NA><NA><NA>2016.03.15-\n03.31<NA><NA><NA>2016.03.15-\n03.31<NA><NA><NA>2016.03.15-\n03.31
6수온(℃)<NA>6.4<NA><NA><NA>8.1<NA><NA><NA>7.5<NA><NA><NA>9.3<NA><NA><NA>3.8<NA><NA><NA>8.5<NA><NA><NA>7.2
7pH<NA>8.4<NA><NA><NA>8.4<NA><NA><NA>8.4<NA><NA><NA>9<NA><NA><NA>8.4<NA><NA><NA>7.9<NA><NA><NA>8.1
8DO(mg/L)<NA>12.4<NA><NA><NA>13.7<NA><NA><NA>12.1<NA><NA><NA>12.2<NA><NA><NA>13.2<NA><NA><NA>12.7<NA><NA><NA>12.6
9전기전도도 (μS/cm)<NA>155<NA><NA><NA>201<NA><NA><NA>174<NA><NA><NA>215<NA><NA><NA>136<NA><NA><NA>89<NA><NA><NA>81
2016년 3월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: 26
13NH3-N(mg/L)<NA>0.01<NA><NA><NA>0.154<NA><NA><NA>0.044<NA><NA><NA>0.049<NA><NA><NA>0.351<NA><NA><NA>0.11<NA><NA><NA>0.004
14NO2-N(mg/L)<NA>0.012<NA><NA><NA>0.034<NA><NA><NA>0.02<NA><NA><NA>0.02<NA><NA><NA>0.033<NA><NA><NA>0.005<NA><NA><NA>0.005
15NO3-N(mg/L)<NA>4.148<NA><NA><NA>3.791<NA><NA><NA>3.76<NA><NA><NA>3.785<NA><NA><NA>3.522<NA><NA><NA>1.98<NA><NA><NA>2.295
16T-N(mg/L)<NA>4.893<NA><NA><NA>4.517<NA><NA><NA>4.317<NA><NA><NA>3.325<NA><NA><NA>2.794<NA><NA><NA>2.5<NA><NA><NA>2.643
17PO4-P(mg/L)<NA>0.015<NA><NA><NA>0.011<NA><NA><NA>0.012<NA><NA><NA>0.012<NA><NA><NA>0.011<NA><NA><NA>0.008<NA><NA><NA>0.007
18T-P(mg/L)<NA>0.027<NA><NA><NA>0.017<NA><NA><NA>0.018<NA><NA><NA>0.014<NA><NA><NA>0.011<NA><NA><NA>0.015<NA><NA><NA>0.009
19Chl-a(mg/m3)<NA>3<NA><NA><NA>4<NA><NA><NA>5<NA><NA><NA>2.7<NA><NA><NA>0.8<NA><NA><NA>2.7<NA><NA><NA>0.7
20SS(mg/L)<NA>3<NA><NA><NA>2.7<NA><NA><NA>4.8<NA><NA><NA>1.1<NA><NA><NA>1<NA><NA><NA>1.3<NA><NA><NA>1
21총대장균군 (총대장균군수/100mL)<NA>1169<NA><NA><NA>935<NA><NA><NA>675<NA><NA><NA>959<NA><NA><NA>657<NA><NA><NA>107<NA><NA><NA>52
22분원성대장균군 (분원성대장균군수/100mL)<NA>1119.9<NA><NA><NA>344.1<NA><NA><NA>290.9<NA><NA><NA>866.4<NA><NA><NA>10<NA><NA><NA><1<NA><NA><NA><1