Dataset statistics
Number of variables | 16 |
---|---|
Number of observations | 23 |
Missing cells | 179 |
Missing cells (%) | 48.6% |
Duplicate rows | 0 |
Duplicate rows (%) | 0.0% |
Total size in memory | 3.2 KiB |
Average record size in memory | 140.7 B |
Variable types
Unsupported | 14 |
---|---|
Text | 1 |
Categorical | 1 |
Dataset
Description | 2020년옥정호주요하천수질조사결과4월 |
---|---|
Author | 전라북도 |
URL | https://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=204349 |
Unnamed: 12 is highly imbalanced (53.6%) | Imbalance |
Unnamed: 0 has 23 (100.0%) missing values | Missing |
2020년 옥정호 주요하천 수질조사 결과(4월) has 1 (4.3%) missing values | Missing |
Unnamed: 2 has 5 (21.7%) missing values | Missing |
Unnamed: 3 has 5 (21.7%) missing values | Missing |
Unnamed: 4 has 5 (21.7%) missing values | Missing |
Unnamed: 5 has 5 (21.7%) missing values | Missing |
Unnamed: 6 has 5 (21.7%) missing values | Missing |
Unnamed: 7 has 5 (21.7%) missing values | Missing |
Unnamed: 8 has 5 (21.7%) missing values | Missing |
Unnamed: 9 has 5 (21.7%) missing values | Missing |
Unnamed: 10 has 23 (100.0%) missing values | Missing |
Unnamed: 11 has 23 (100.0%) missing values | Missing |
Unnamed: 13 has 23 (100.0%) missing values | Missing |
Unnamed: 14 has 23 (100.0%) missing values | Missing |
Unnamed: 15 has 23 (100.0%) missing values | Missing |
Unnamed: 0 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 2 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 6 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 7 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 8 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 9 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 10 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 11 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 13 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 14 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Unnamed: 15 is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
Analysis started | 2024-03-14 03:10:17.608542 |
---|---|
Analysis finished | 2024-03-14 03:10:18.195777 |
Duration | 0.59 seconds |
Software version | ydata-profiling vv4.5.1 |
Download configuration | config.json |
Unnamed: 0
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 23 |
---|---|
Missing (%) | 100.0% |
Memory size | 339.0 B |
2020년 옥정호 주요하천 수질조사 결과(4월)
Text
MISSING
 
Distinct | 22 |
---|---|
Distinct (%) | 100.0% |
Missing | 1 |
Missing (%) | 4.3% |
Memory size | 316.0 B |
Length
Max length | 58 |
---|---|
Median length | 24 |
Mean length | 15 |
Min length | 2 |
Characters and Unicode
Total characters | 330 |
---|---|
Distinct characters | 86 |
Distinct categories | 12 ? |
Distinct scripts | 4 ? |
Distinct blocks | 5 ? |
Unique
Unique | 22 ? |
---|---|
Unique (%) | 100.0% |
Sample
1st row | 1. 조사지점 : 임실천, 오원천, 섬진강본류, 옥녀동천, 추령천, 도원천하류, 동진강상류, 섬진강댐하류 |
---|---|
2nd row | 2. 조사일자 : 2020년 4월 8일 |
3rd row | 3. 조사항목 : 총 17항목(현장 측정: 수온, pH, DO, EC 와 BOD 등 13개) |
4th row | 4. 조사결과 |
5th row | 지점명 |
Value | Count | Frequency (%) |
mg/l | 11 | 16.4% |
3 | 4.5% | |
bod | 2 | 3.0% |
ec | 2 | 3.0% |
do | 2 | 3.0% |
ph | 2 | 3.0% |
수온 | 2 | 3.0% |
1 | 1 | 1.5% |
ss | 1 | 1.5% |
조사결과 | 1 | 1.5% |
Other values (40) | 40 |
Most occurring characters
Value | Count | Frequency (%) |
29 | 8.8% | |
) | 17 | 5.2% |
( | 17 | 5.2% |
16 | 4.8% | |
/ | 15 | 4.5% |
m | 15 | 4.5% |
L | 13 | 3.9% |
g | 12 | 3.6% |
, | 10 | 3.0% |
O | 9 | 2.7% |
Other values (76) | 177 |
Most occurring categories
Value | Count | Frequency (%) |
Other Letter | 95 | |
Uppercase Letter | 55 | |
Lowercase Letter | 34 | 10.3% |
Other Punctuation | 33 | 10.0% |
Space Separator | 29 | 8.8% |
Decimal Number | 23 | 7.0% |
Close Punctuation | 17 | 5.2% |
Open Punctuation | 17 | 5.2% |
Control | 16 | 4.8% |
Dash Punctuation | 7 | 2.1% |
Other values (2) | 4 | 1.2% |
Most frequent character per category
Other Letter
Value | Count | Frequency (%) |
장 | 5 | 5.3% |
천 | 5 | 5.3% |
원 | 4 | 4.2% |
군 | 4 | 4.2% |
균 | 4 | 4.2% |
대 | 4 | 4.2% |
조 | 4 | 4.2% |
사 | 4 | 4.2% |
류 | 4 | 4.2% |
진 | 3 | 3.2% |
Other values (37) | 54 |
Uppercase Letter
Value | Count | Frequency (%) |
L | 13 | |
O | 9 | |
N | 7 | |
C | 5 | 9.1% |
D | 5 | 9.1% |
H | 3 | 5.5% |
S | 3 | 5.5% |
T | 3 | 5.5% |
P | 3 | 5.5% |
B | 2 | 3.6% |
Lowercase Letter
Value | Count | Frequency (%) |
m | 15 | |
g | 12 | |
p | 2 | 5.9% |
c | 1 | 2.9% |
μ | 1 | 2.9% |
l | 1 | 2.9% |
a | 1 | 2.9% |
h | 1 | 2.9% |
Decimal Number
Value | Count | Frequency (%) |
0 | 6 | |
1 | 5 | |
2 | 4 | |
3 | 4 | |
4 | 2 | 8.7% |
7 | 1 | 4.3% |
8 | 1 | 4.3% |
Other Punctuation
Value | Count | Frequency (%) |
/ | 15 | |
, | 10 | |
: | 4 | 12.1% |
. | 4 | 12.1% |
Other Number
Value | Count | Frequency (%) |
₄ | 1 | |
² | 1 |
Other Symbol
Value | Count | Frequency (%) |
㎥ | 1 | |
℃ | 1 |
Space Separator
Value | Count | Frequency (%) |
29 |
Close Punctuation
Value | Count | Frequency (%) |
) | 17 |
Open Punctuation
Value | Count | Frequency (%) |
( | 17 |
Control
Value | Count | Frequency (%) |
16 |
Dash Punctuation
Value | Count | Frequency (%) |
- | 7 |
Most occurring scripts
Value | Count | Frequency (%) |
Common | 146 | |
Hangul | 95 | |
Latin | 88 | |
Greek | 1 | 0.3% |
Most frequent character per script
Hangul
Value | Count | Frequency (%) |
장 | 5 | 5.3% |
천 | 5 | 5.3% |
원 | 4 | 4.2% |
군 | 4 | 4.2% |
균 | 4 | 4.2% |
대 | 4 | 4.2% |
조 | 4 | 4.2% |
사 | 4 | 4.2% |
류 | 4 | 4.2% |
진 | 3 | 3.2% |
Other values (37) | 54 |
Common
Value | Count | Frequency (%) |
29 | ||
) | 17 | |
( | 17 | |
16 | ||
/ | 15 | |
, | 10 | 6.8% |
- | 7 | 4.8% |
0 | 6 | 4.1% |
1 | 5 | 3.4% |
: | 4 | 2.7% |
Other values (10) | 20 |
Latin
Value | Count | Frequency (%) |
m | 15 | |
L | 13 | |
g | 12 | |
O | 9 | |
N | 7 | |
C | 5 | 5.7% |
D | 5 | 5.7% |
H | 3 | 3.4% |
S | 3 | 3.4% |
T | 3 | 3.4% |
Other values (8) | 13 |
Greek
Value | Count | Frequency (%) |
μ | 1 |
Most occurring blocks
Value | Count | Frequency (%) |
ASCII | 230 | |
Hangul | 95 | |
None | 3 | 0.9% |
CJK Compat | 1 | 0.3% |
Letterlike Symbols | 1 | 0.3% |
Most frequent character per block
ASCII
Value | Count | Frequency (%) |
29 | 12.6% | |
) | 17 | 7.4% |
( | 17 | 7.4% |
16 | 7.0% | |
/ | 15 | 6.5% |
m | 15 | 6.5% |
L | 13 | 5.7% |
g | 12 | 5.2% |
, | 10 | 4.3% |
O | 9 | 3.9% |
Other values (24) | 77 |
Hangul
Value | Count | Frequency (%) |
장 | 5 | 5.3% |
천 | 5 | 5.3% |
원 | 4 | 4.2% |
군 | 4 | 4.2% |
균 | 4 | 4.2% |
대 | 4 | 4.2% |
조 | 4 | 4.2% |
사 | 4 | 4.2% |
류 | 4 | 4.2% |
진 | 3 | 3.2% |
Other values (37) | 54 |
None
Value | Count | Frequency (%) |
₄ | 1 | |
² | 1 | |
μ | 1 |
CJK Compat
Value | Count | Frequency (%) |
㎥ | 1 |
Letterlike Symbols
Value | Count | Frequency (%) |
℃ | 1 |
Unnamed: 2
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 5 |
---|---|
Missing (%) | 21.7% |
Memory size | 316.0 B |
Unnamed: 3
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 5 |
---|---|
Missing (%) | 21.7% |
Memory size | 316.0 B |
Unnamed: 4
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 5 |
---|---|
Missing (%) | 21.7% |
Memory size | 316.0 B |
Unnamed: 5
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 5 |
---|---|
Missing (%) | 21.7% |
Memory size | 316.0 B |
Unnamed: 6
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 5 |
---|---|
Missing (%) | 21.7% |
Memory size | 316.0 B |
Unnamed: 7
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 5 |
---|---|
Missing (%) | 21.7% |
Memory size | 316.0 B |
Unnamed: 8
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 5 |
---|---|
Missing (%) | 21.7% |
Memory size | 316.0 B |
Unnamed: 9
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 5 |
---|---|
Missing (%) | 21.7% |
Memory size | 316.0 B |
Unnamed: 10
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 23 |
---|---|
Missing (%) | 100.0% |
Memory size | 339.0 B |
Unnamed: 11
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 23 |
---|---|
Missing (%) | 100.0% |
Memory size | 339.0 B |
Unnamed: 12
Categorical
IMBALANCE
 
Distinct | 4 |
---|---|
Distinct (%) | 17.4% |
Missing | 0 |
Missing (%) | 0.0% |
Memory size | 316.0 B |
<NA> | |
---|---|
8.3 | |
8.5 | 1 |
8.366666666666667 | 1 |
Length
Max length | 17 |
---|---|
Median length | 4 |
Mean length | 4.4347826 |
Min length | 3 |
Unique
Unique | 2 ? |
---|---|
Unique (%) | 8.7% |
Sample
1st row | <NA> |
---|---|
2nd row | <NA> |
3rd row | <NA> |
4th row | <NA> |
5th row | <NA> |
Common Values
Value | Count | Frequency (%) |
<NA> | 19 | |
8.3 | 2 | 8.7% |
8.5 | 1 | 4.3% |
8.366666666666667 | 1 | 4.3% |
Length
Common Values (Plot)
Value | Count | Frequency (%) |
na | 19 | |
8.3 | 2 | 8.7% |
8.5 | 1 | 4.3% |
8.366666666666667 | 1 | 4.3% |
Unnamed: 13
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 23 |
---|---|
Missing (%) | 100.0% |
Memory size | 339.0 B |
Unnamed: 14
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 23 |
---|---|
Missing (%) | 100.0% |
Memory size | 339.0 B |
Unnamed: 15
Unsupported
MISSING
  REJECTED
  UNSUPPORTED
 
Missing | 23 |
---|---|
Missing (%) | 100.0% |
Memory size | 339.0 B |
2020년 옥정호 주요하천 수질조사 결과(4월) | Unnamed: 12 | |
---|---|---|
2020년 옥정호 주요하천 수질조사 결과(4월) | 1.000 | 1.000 |
Unnamed: 12 | 1.000 | 1.000 |
Unnamed: 0 | 2020년 옥정호 주요하천 수질조사 결과(4월) | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | <NA> | <NA> | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
1 | <NA> | 1. 조사지점 : 임실천, 오원천, 섬진강본류, 옥녀동천, 추령천, 도원천하류, 동진강상류, 섬진강댐하류 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
2 | <NA> | 2. 조사일자 : 2020년 4월 8일 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
3 | <NA> | 3. 조사항목 : 총 17항목(현장 측정: 수온, pH, DO, EC 와 BOD 등 13개) | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
4 | <NA> | 4. 조사결과 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
5 | <NA> | 지점명 | 임실천 | 오원천 | 섬진강본류 | 옥녀동천 | 추령천 | 도원천하류 | 동진강상류 | 섬진강댐하류 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
6 | <NA> | 수온 (℃) | 14.7 | 15.1 | 13.7 | 11.5 | 11.9 | 10.7 | 9.1 | 11.7 | <NA> | <NA> | 8.3 | <NA> | <NA> | <NA> |
7 | <NA> | pH | 7.6 | 8 | 7.9 | 8 | 8.4 | 8.1 | 8.2 | 8.6 | <NA> | <NA> | 8.5 | <NA> | <NA> | <NA> |
8 | <NA> | DO (mg/L) | 11.2 | 11.4 | 11.5 | 12.3 | 11.2 | 11.6 | 11.9 | 10.7 | <NA> | <NA> | 8.3 | <NA> | <NA> | <NA> |
9 | <NA> | EC (μS/cm²) | 283 | 169 | 170 | 144 | 126 | 122 | 123 | 119 | <NA> | <NA> | 8.366667 | <NA> | <NA> | <NA> |
Unnamed: 0 | 2020년 옥정호 주요하천 수질조사 결과(4월) | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13 | <NA> | T-N (mg/L) | 2.354 | 1.512 | 1.598 | 2.387 | 2.664 | 1.576 | 1.659 | 1.714 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
14 | <NA> | T-P (mg/L) | 0.045 | 0.022 | 0.031 | 0.011 | 0.012 | 0.009 | 0.011 | 0.013 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
15 | <NA> | NH3-N (mg/L) | 0.353 | 0.039 | 0.018 | 0.012 | 0.041 | 0.014 | 0.014 | 0.017 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
16 | <NA> | NO2-N (mg/L) | 0.081 | 0.015 | 0.02 | 0.009 | 0.042 | 0.004 | 0.004 | 0.003 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
17 | <NA> | NO3-N (mg/L) | 1.08 | 1.454 | 0.913 | 1.688 | 2.007 | 0.827 | 0.898 | 1.674 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
18 | <NA> | PO₄-P (mg/L) | 0.014 | 0.007 | 불검출 | 불검출 | 불검출 | 불검출 | 불검출 | 불검출 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
19 | <NA> | Chl-a (mg/㎥) | 10 | 5.4 | 28.8 | 7.4 | 2.8 | 5.1 | 7.9 | 4.1 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
20 | <NA> | TOC (mg/L) | 2.5 | 2 | 2.7 | 1 | 1.4 | 2.1 | 2.1 | 2.2 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
21 | <NA> | 총대장균군 (총대장균군/100mL) | 1400 | 7100 | 170 | 310 | 1400 | 1200 | 870 | 1400 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |
22 | <NA> | 분원성대장균군 (분원성대장균군수/100mL) | 96 | 590 | 64 | 17 | 11 | 15 | 4 | 2 | <NA> | <NA> | <NA> | <NA> | <NA> | <NA> |