Overview

Dataset statistics

Number of variables5
Number of observations639
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory25.7 KiB
Average record size in memory41.2 B

Variable types

Categorical4
Numeric1

Dataset

Description현재 운영하고 있는 국가 비점오염물질 측정망의 측정 장비에 대한 데이터로서 상세 모델 명, 제조사 정보 등을 제공합니다.
URLhttps://www.data.go.kr/data/15070151/fileData.do

Alerts

측정소번호 is highly overall correlated with 모델번호 and 1 other fieldsHigh correlation
장비모델명 is highly overall correlated with 장비제조사명High correlation
장비제조사명 is highly overall correlated with 장비모델명High correlation
측정소명 is highly overall correlated with 모델번호 and 1 other fieldsHigh correlation
모델번호 is highly overall correlated with 측정소번호 and 1 other fieldsHigh correlation
모델번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 01:34:14.852487
Analysis finished2023-12-12 01:34:15.523042
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

측정소번호
Categorical

HIGH CORRELATION 

Distinct36
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
1101N10
 
26
1001N10
 
20
20226046
 
18
2003N10
 
18
1101N20
 
18
Other values (31)
539 

Length

Max length10
Median length8
Mean length7.6635368
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1101N10 26
 
4.1%
1001N10 20
 
3.1%
20226046 18
 
2.8%
2003N10 18
 
2.8%
1101N20 18
 
2.8%
2022N10 18
 
2.8%
1012N10 18
 
2.8%
1001N30 18
 
2.8%
330109NM10 18
 
2.8%
330109NS04 18
 
2.8%
Other values (26) 449
70.3%

Length

2023-12-12T10:34:15.602219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
1101n10 26
 
4.1%
1001n10 20
 
3.1%
2022n20 18
 
2.8%
10116048 18
 
2.8%
33026042 18
 
2.8%
3009n20 18
 
2.8%
33026041 18
 
2.8%
20036055 18
 
2.8%
10186057 18
 
2.8%
11016056 18
 
2.8%
Other values (26) 449
70.3%

측정소명
Categorical

HIGH CORRELATION 

Distinct36
Distinct (%)5.6%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
N팽성
 
26
N삼옥
 
20
N화목
 
18
N옥수
 
18
N황계
 
18
Other values (31)
539 

Length

Max length5
Median length3
Mean length3.056338
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowN만년
2nd rowN만년
3rd rowN만년
4th rowN만년
5th rowN만년

Common Values

ValueCountFrequency (%)
N팽성 26
 
4.1%
N삼옥 20
 
3.1%
N화목 18
 
2.8%
N옥수 18
 
2.8%
N황계 18
 
2.8%
N효충 18
 
2.8%
N자운 18
 
2.8%
N혈천 18
 
2.8%
N전주천2 18
 
2.8%
N삼천 18
 
2.8%
Other values (26) 449
70.3%

Length

2023-12-12T10:34:15.769004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
n팽성 26
 
4.1%
n삼옥 20
 
3.1%
n호포 18
 
2.8%
n솔정 18
 
2.8%
n팔왕 18
 
2.8%
n한빛 18
 
2.8%
n동진 18
 
2.8%
n송야 18
 
2.8%
n오리 18
 
2.8%
n하갈 18
 
2.8%
Other values (26) 449
70.3%

모델번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct639
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2813.7574
Minimum2414
Maximum3178
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size5.7 KiB
2023-12-12T10:34:15.939400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2414
5-th percentile2460.8
Q12636.5
median2817
Q32997.5
95-th percentile3146.1
Maximum3178
Range764
Interquartile range (IQR)361

Descriptive statistics

Standard deviation215.73391
Coefficient of variation (CV)0.076671113
Kurtosis-1.1142071
Mean2813.7574
Median Absolute Deviation (MAD)181
Skewness-0.076029674
Sum1797991
Variance46541.121
MonotonicityNot monotonic
2023-12-12T10:34:16.114588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
2555 1
 
0.2%
2556 1
 
0.2%
2597 1
 
0.2%
2599 1
 
0.2%
2600 1
 
0.2%
2601 1
 
0.2%
2602 1
 
0.2%
2603 1
 
0.2%
2605 1
 
0.2%
2606 1
 
0.2%
Other values (629) 629
98.4%
ValueCountFrequency (%)
2414 1
0.2%
2415 1
0.2%
2418 1
0.2%
2419 1
0.2%
2420 1
0.2%
2421 1
0.2%
2423 1
0.2%
2424 1
0.2%
2427 1
0.2%
2428 1
0.2%
ValueCountFrequency (%)
3178 1
0.2%
3177 1
0.2%
3176 1
0.2%
3175 1
0.2%
3174 1
0.2%
3173 1
0.2%
3172 1
0.2%
3171 1
0.2%
3170 1
0.2%
3169 1
0.2%

장비모델명
Categorical

HIGH CORRELATION 

Distinct28
Distinct (%)4.4%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
TW/NEXT-232RS16
51 
HFU-MM-3kVA
51 
LT-200-1CH
49 
ICTs-WTMS
 
37
CN/ERR093BW
 
37
Other values (23)
414 

Length

Max length17
Median length15
Mean length10.280125
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowTW/NEXT-232RS16
2nd rowLT-W232SUE
3rd rowICTs-WTMS
4th rowM-1000U
5th rowCF1-HM0M01

Common Values

ValueCountFrequency (%)
TW/NEXT-232RS16 51
 
8.0%
HFU-MM-3kVA 51
 
8.0%
LT-200-1CH 49
 
7.7%
ICTs-WTMS 37
 
5.8%
CN/ERR093BW 37
 
5.8%
M-1000U 36
 
5.6%
CF1-HM0M01 36
 
5.6%
LTEM-1233E57-40SE 36
 
5.6%
NFCT21-CP4 36
 
5.6%
WDSD-205 36
 
5.6%
Other values (18) 234
36.6%

Length

2023-12-12T10:34:16.355328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
tw/next-232rs16 51
 
7.4%
hfu-mm-3kva 51
 
7.4%
lt-200-1ch 49
 
7.1%
axgate 48
 
7.0%
icts-wtms 37
 
5.4%
cn/err093bw 37
 
5.4%
m-1000u 36
 
5.2%
cf1-hm0m01 36
 
5.2%
ltem-1233e57-40se 36
 
5.2%
nfct21-cp4 36
 
5.2%
Other values (20) 272
39.5%

장비제조사명
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size5.1 KiB
에이치코비
93 
대한전력전자
51 
이지넷유비쿼터스
51 
우리기술
49 
엑스게이트
48 
Other values (12)
347 

Length

Max length14
Median length8
Mean length5.6338028
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row이지넷유비쿼터스
2nd row엘지전자
3rd row아이씨티솔루션스
4th row기술과환경
5th row한국청각장애인복지회청음공방

Common Values

ValueCountFrequency (%)
에이치코비 93
14.6%
대한전력전자 51
 
8.0%
이지넷유비쿼터스 51
 
8.0%
우리기술 49
 
7.7%
엑스게이트 48
 
7.5%
엘지전자 38
 
5.9%
아이씨티솔루션스 37
 
5.8%
위니아딤채 37
 
5.8%
위댄기업 36
 
5.6%
쏠라페 36
 
5.6%
Other values (7) 163
25.5%

Length

2023-12-12T10:34:16.529190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
에이치코비 93
14.6%
이지넷유비쿼터스 51
 
8.0%
대한전력전자 51
 
8.0%
우리기술 49
 
7.7%
엑스게이트 48
 
7.5%
엘지전자 38
 
5.9%
아이씨티솔루션스 37
 
5.8%
위니아딤채 37
 
5.8%
고려화공 36
 
5.6%
한국청각장애인복지회청음공방 36
 
5.6%
Other values (7) 163
25.5%

Interactions

2023-12-12T10:34:15.189660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T10:34:16.629618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
측정소번호측정소명모델번호장비모델명장비제조사명
측정소번호1.0001.0000.8790.0000.000
측정소명1.0001.0000.8790.0000.000
모델번호0.8790.8791.0000.5530.422
장비모델명0.0000.0000.5531.0001.000
장비제조사명0.0000.0000.4221.0001.000
2023-12-12T10:34:16.763945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
측정소번호장비모델명장비제조사명측정소명
측정소번호1.0000.0000.0001.000
장비모델명0.0001.0000.9910.000
장비제조사명0.0000.9911.0000.000
측정소명1.0000.0000.0001.000
2023-12-12T10:34:16.895069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
모델번호측정소번호측정소명장비모델명장비제조사명
모델번호1.0000.5400.5400.2290.177
측정소번호0.5401.0001.0000.0000.000
측정소명0.5401.0001.0000.0000.000
장비모델명0.2290.0000.0001.0000.991
장비제조사명0.1770.0000.0000.9911.000

Missing values

2023-12-12T10:34:15.333286image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T10:34:15.477119image/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

측정소번호측정소명모델번호장비모델명장비제조사명
03009N30N만년2555TW/NEXT-232RS16이지넷유비쿼터스
13009N30N만년2556LT-W232SUE엘지전자
23009N30N만년2559ICTs-WTMS아이씨티솔루션스
33009N30N만년2560M-1000U기술과환경
43009N30N만년2561CF1-HM0M01한국청각장애인복지회청음공방
53009N30N만년2562KF-2300A고려화공
63009N20N한빛2564TW/NEXT-232RS16이지넷유비쿼터스
73009N20N한빛2565LT-W232SUE엘지전자
83009N20N한빛2568ICTs-WTMS아이씨티솔루션스
93009N20N한빛2569M-1000U기술과환경
측정소번호측정소명모델번호장비모델명장비제조사명
629330109NS04N삼천3169TW/NEXT-232RS16이지넷유비쿼터스
6301001N30N혈천3170TW/NEXT-232RS16이지넷유비쿼터스
6311012N10N자운3171TW/NEXT-232RS16이지넷유비쿼터스
6321101N20N황계3172TW/NEXT-232RS16이지넷유비쿼터스
6332022N10N효충3173TW/NEXT-232RS16이지넷유비쿼터스
6342022N30N장유3174TW/NEXT-232RS16이지넷유비쿼터스
6353009N20N한빛3175TW/NEXT-232RS16이지넷유비쿼터스
6365001N10N상무3176TW/NEXT-232RS16이지넷유비쿼터스
6371101N10N팽성3177JP/TOC-4200Shimadzu
6381101N10N팽성3178US/KMPi (유사품)Repligen