Overview

Dataset statistics

Number of variables5
Number of observations25
Missing cells2
Missing cells (%)1.6%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.1 KiB
Average record size in memory45.3 B

Variable types

Text4
Categorical1

Dataset

Description경상남도 거제시 농약판매업등록현황에 대한 자료입니다. 상호, 주소, 전화번호, 대표자명, 기준일에 대한 정보를 제공합니다.
Author경상남도 거제시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=3079239

Alerts

기준일 has constant value ""Constant
전화번호 has 2 (8.0%) missing valuesMissing
상호 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:22:04.682983
Analysis finished2023-12-10 23:22:04.995521
Duration0.31 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호
Text

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-11T08:22:05.122841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length14
Mean length7.92
Min length4

Characters and Unicode

Total characters198
Distinct characters51
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique25 ?
Unique (%)100.0%

Sample

1st row제일농약종묘사
2nd row일운농약사
3rd row심원농약사
4th row중앙종묘농약사
5th row성내원예자재사
ValueCountFrequency (%)
제일농약종묘사 1
 
4.0%
일운농업협동조합 1
 
4.0%
하청농업협동조합(칠천지점 1
 
4.0%
동남부농업협동조합(동부지점 1
 
4.0%
장승포농업협동조합 1
 
4.0%
장목농업협동조합 1
 
4.0%
연초농업협동조합 1
 
4.0%
사등농업협동조합 1
 
4.0%
둔덕농업협동조합 1
 
4.0%
거제농업협동조합 1
 
4.0%
Other values (15) 15
60.0%
2023-12-11T08:22:05.413845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
농 19
 
9.6%
동 17
 
8.6%
업 13
 
6.6%
협 13
 
6.6%
조 13
 
6.6%
합 13
 
6.6%
사 11
 
5.6%
약 6
 
3.0%
종 6
 
3.0%
묘 6
 
3.0%
Other values (41) 81
40.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 190
96.0%
Close Punctuation 4
 
2.0%
Open Punctuation 4
 
2.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
농 19
 
10.0%
동 17
 
8.9%
업 13
 
6.8%
협 13
 
6.8%
조 13
 
6.8%
합 13
 
6.8%
사 11
 
5.8%
약 6
 
3.2%
종 6
 
3.2%
묘 6
 
3.2%
Other values (39) 73
38.4%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 190
96.0%
Common 8
 
4.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
농 19
 
10.0%
동 17
 
8.9%
업 13
 
6.8%
협 13
 
6.8%
조 13
 
6.8%
합 13
 
6.8%
사 11
 
5.8%
약 6
 
3.2%
종 6
 
3.2%
묘 6
 
3.2%
Other values (39) 73
38.4%
Common
ValueCountFrequency (%)
) 4
50.0%
( 4
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 190
96.0%
ASCII 8
 
4.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
농 19
 
10.0%
동 17
 
8.9%
업 13
 
6.8%
협 13
 
6.8%
조 13
 
6.8%
합 13
 
6.8%
사 11
 
5.8%
약 6
 
3.2%
종 6
 
3.2%
묘 6
 
3.2%
Other values (39) 73
38.4%
ASCII
ValueCountFrequency (%)
) 4
50.0%
( 4
50.0%

주소
Text

UNIQUE 

Distinct25
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-11T08:22:05.628694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length20
Mean length19.04
Min length15

Characters and Unicode

Total characters476
Distinct characters59
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique25 ?
Unique (%)100.0%

Sample

1st row경남 거제시 고현동 고현로 85
2nd row경남 거제시 일운면 지세포로 101
3rd row경남 거제시동부면 동부로 6
4th row경남 거제시 거제면 기성로 33
5th row경남 거제시 거제면 읍내로 2길 27
ValueCountFrequency (%)
경남 25
19.5%
거제시 24
18.8%
고현로 5
 
3.9%
거제면 4
 
3.1%
고현동 4
 
3.1%
거제북로 2
 
1.6%
연초면 2
 
1.6%
지세포로 2
 
1.6%
하청면 2
 
1.6%
사등면 2
 
1.6%
Other values (50) 56
43.8%
2023-12-11T08:22:05.966274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
104
21.8%
거 34
 
7.1%
제 34
 
7.1%
남 28
 
5.9%
경 25
 
5.3%
시 25
 
5.3%
로 21
 
4.4%
1 18
 
3.8%
면 18
 
3.8%
3 14
 
2.9%
Other values (49) 155
32.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 293
61.6%
Space Separator 104
 
21.8%
Decimal Number 75
 
15.8%
Dash Punctuation 4
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
거 34
11.6%
제 34
11.6%
남 28
 
9.6%
경 25
 
8.5%
시 25
 
8.5%
로 21
 
7.2%
면 18
 
6.1%
동 10
 
3.4%
현 9
 
3.1%
고 9
 
3.1%
Other values (37) 80
27.3%
Decimal Number
ValueCountFrequency (%)
1 18
24.0%
3 14
18.7%
2 13
17.3%
8 7
 
9.3%
6 6
 
8.0%
0 6
 
8.0%
4 5
 
6.7%
5 3
 
4.0%
9 2
 
2.7%
7 1
 
1.3%
Space Separator
ValueCountFrequency (%)
104
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 293
61.6%
Common 183
38.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
거 34
11.6%
제 34
11.6%
남 28
 
9.6%
경 25
 
8.5%
시 25
 
8.5%
로 21
 
7.2%
면 18
 
6.1%
동 10
 
3.4%
현 9
 
3.1%
고 9
 
3.1%
Other values (37) 80
27.3%
Common
ValueCountFrequency (%)
104
56.8%
1 18
 
9.8%
3 14
 
7.7%
2 13
 
7.1%
8 7
 
3.8%
6 6
 
3.3%
0 6
 
3.3%
4 5
 
2.7%
- 4
 
2.2%
5 3
 
1.6%
Other values (2) 3
 
1.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 293
61.6%
ASCII 183
38.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
104
56.8%
1 18
 
9.8%
3 14
 
7.7%
2 13
 
7.1%
8 7
 
3.8%
6 6
 
3.3%
0 6
 
3.3%
4 5
 
2.7%
- 4
 
2.2%
5 3
 
1.6%
Other values (2) 3
 
1.6%
Hangul
ValueCountFrequency (%)
거 34
11.6%
제 34
11.6%
남 28
 
9.6%
경 25
 
8.5%
시 25
 
8.5%
로 21
 
7.2%
면 18
 
6.1%
동 10
 
3.4%
현 9
 
3.1%
고 9
 
3.1%
Other values (37) 80
27.3%

전화번호
Text

MISSING 

Distinct23
Distinct (%)100.0%
Missing2
Missing (%)8.0%
Memory size332.0 B
2023-12-11T08:22:06.134367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters276
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
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 row055-635-7302
2nd row055-681-0386
3rd row055-634-4566
4th row055-632-3654
5th row055-632-8979
ValueCountFrequency (%)
055-635-7302 1
 
4.3%
055-639-1625 1
 
4.3%
055-680-7615 1
 
4.3%
055-633-9077 1
 
4.3%
055-639-1608 1
 
4.3%
055-688-5798 1
 
4.3%
055-635-1930 1
 
4.3%
055-636-3128 1
 
4.3%
055-680-6108 1
 
4.3%
055-634-5289 1
 
4.3%
Other values (13) 13
56.5%
2023-12-11T08:22:06.447015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 59
21.4%
- 46
16.7%
0 38
13.8%
6 37
13.4%
3 27
9.8%
8 20
 
7.2%
1 13
 
4.7%
7 10
 
3.6%
2 10
 
3.6%
9 10
 
3.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 230
83.3%
Dash Punctuation 46
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 59
25.7%
0 38
16.5%
6 37
16.1%
3 27
11.7%
8 20
 
8.7%
1 13
 
5.7%
7 10
 
4.3%
2 10
 
4.3%
9 10
 
4.3%
4 6
 
2.6%
Dash Punctuation
ValueCountFrequency (%)
- 46
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 276
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 59
21.4%
- 46
16.7%
0 38
13.8%
6 37
13.4%
3 27
9.8%
8 20
 
7.2%
1 13
 
4.7%
7 10
 
3.6%
2 10
 
3.6%
9 10
 
3.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 276
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 59
21.4%
- 46
16.7%
0 38
13.8%
6 37
13.4%
3 27
9.8%
8 20
 
7.2%
1 13
 
4.7%
7 10
 
3.6%
2 10
 
3.6%
9 10
 
3.6%

대표자명
Text

Distinct23
Distinct (%)92.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-11T08:22:06.636856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length3
Mean length3.12
Min length2

Characters and Unicode

Total characters78
Distinct characters49
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique21 ?
Unique (%)84.0%

Sample

1st row이철주
2nd row윤대산
3rd row심광
4th row김재환
5th row정완규
ValueCountFrequency (%)
주영포 2
 
7.7%
원희철 2
 
7.7%
이철주 1
 
3.8%
권순옥 1
 
3.8%
김현준 1
 
3.8%
손정신 1
 
3.8%
김종삼 1
 
3.8%
김임준 1
 
3.8%
이범석 1
 
3.8%
지영배 1
 
3.8%
Other values (14) 14
53.8%
2023-12-11T08:22:06.917074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
이 5
 
6.4%
김 5
 
6.4%
주 3
 
3.8%
영 3
 
3.8%
희 3
 
3.8%
철 3
 
3.8%
정 3
 
3.8%
환 2
 
2.6%
배 2
 
2.6%
지 2
 
2.6%
Other values (39) 47
60.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 77
98.7%
Space Separator 1
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
이 5
 
6.5%
김 5
 
6.5%
주 3
 
3.9%
영 3
 
3.9%
희 3
 
3.9%
철 3
 
3.9%
정 3
 
3.9%
환 2
 
2.6%
배 2
 
2.6%
지 2
 
2.6%
Other values (38) 46
59.7%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 77
98.7%
Common 1
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
이 5
 
6.5%
김 5
 
6.5%
주 3
 
3.9%
영 3
 
3.9%
희 3
 
3.9%
철 3
 
3.9%
정 3
 
3.9%
환 2
 
2.6%
배 2
 
2.6%
지 2
 
2.6%
Other values (38) 46
59.7%
Common
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 77
98.7%
ASCII 1
 
1.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
이 5
 
6.5%
김 5
 
6.5%
주 3
 
3.9%
영 3
 
3.9%
희 3
 
3.9%
철 3
 
3.9%
정 3
 
3.9%
환 2
 
2.6%
배 2
 
2.6%
지 2
 
2.6%
Other values (38) 46
59.7%
ASCII
ValueCountFrequency (%)
1
100.0%

기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2019-07-11
25 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2019-07-11
2nd row2019-07-11
3rd row2019-07-11
4th row2019-07-11
5th row2019-07-11

Common Values

ValueCountFrequency (%)
2019-07-11 25
100.0%

Length

2023-12-11T08:22:07.037006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:22:07.162290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019-07-11 25
100.0%

Correlations

2023-12-11T08:22:07.221903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
상호주소전화번호대표자명
상호1.0001.0001.0001.000
주소1.0001.0001.0001.000
전화번호1.0001.0001.0001.000
대표자명1.0001.0001.0001.000

Missing values

2023-12-11T08:22:04.885391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:22:04.965042image/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

상호주소전화번호대표자명기준일
0제일농약종묘사경남 거제시 고현동 고현로 85055-635-7302이철주2019-07-11
1일운농약사경남 거제시 일운면 지세포로 101055-681-0386윤대산2019-07-11
2심원농약사경남 거제시동부면 동부로 6055-634-4566심광2019-07-11
3중앙종묘농약사경남 거제시 거제면 기성로 33055-632-3654김재환2019-07-11
4성내원예자재사경남 거제시 거제면 읍내로 2길 27055-632-8979정완규2019-07-11
5황씨상회경남 거제시 장승포동 장승포로 49055-681-5808김순자2019-07-11
6대교상사경남 거제시 사등면 덕호신촌2길 2055-634-1382황지환2019-07-11
7거제원예농약종묘사경남 거제시 고현동 고현로 12길 19055-632-8570유동선2019-07-11
8동신농약사경남 거제시 고현동 고현로 84055-636-0533박일자 이정민2019-07-11
9대성종묘경남 거제시 거제면 기성로 38-1<NA>이희용2019-07-11
상호주소전화번호대표자명기준일
15동남부농업협동조합(남부지점)경남 거제시 남부면 저구1길 60-1055-639-1625원희철2019-07-11
16거제농업협동조합경남 거제시 거제면 읍내로 2길 32055-634-3275이범석2019-07-11
17둔덕농업협동조합경남 거제시 둔덕면 거제남서로 4580055-634-5289김임준2019-07-11
18사등농업협동조합경남 거제시 사등면 성포로 133055-680-6108김종삼2019-07-11
19연초농업협동조합경남 거제시 연초면 거제북로 26055-636-3128손정신2019-07-11
20장목농업협동조합경남 거제시 장목면 거제북로 1206055-635-1930김현준2019-07-11
21장승포농업협동조합경남 거제시 아주동 거제대로 3513055-688-5798권순옥2019-07-11
22동남부농업협동조합(동부지점)경남 거제시 동부면 거제남서로 3086055-639-1608원희철2019-07-11
23하청농업협동조합(칠천지점)경남 거제시 하청면 연구2길 3-12055-633-9077주영포2019-07-11
24장목농업협동조합(외포지점)경남 거제시 장목면 외포4길 3055-650-8331신종배2019-07-11