Overview

Dataset statistics

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

Variable types

Text4
DateTime1

Dataset

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

Alerts

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

Reproduction

Analysis started2023-12-10 23:22:22.485070
Analysis finished2023-12-10 23:22:22.827600
Duration0.34 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:22.972765image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length9
Mean length7.96
Min length4

Characters and Unicode

Total characters199
Distinct characters53
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:23.368381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
20
 
10.1%
17
 
8.5%
13
 
6.5%
13
 
6.5%
13
 
6.5%
13
 
6.5%
10
 
5.0%
7
 
3.5%
5
 
2.5%
5
 
2.5%
Other values (43) 83
41.7%

Most occurring categories

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

Most frequent character per category

Other Letter
ValueCountFrequency (%)
20
 
10.5%
17
 
8.9%
13
 
6.8%
13
 
6.8%
13
 
6.8%
13
 
6.8%
10
 
5.2%
7
 
3.7%
5
 
2.6%
5
 
2.6%
Other values (41) 75
39.3%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%

Most occurring scripts

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

Most frequent character per script

Hangul
ValueCountFrequency (%)
20
 
10.5%
17
 
8.9%
13
 
6.8%
13
 
6.8%
13
 
6.8%
13
 
6.8%
10
 
5.2%
7
 
3.7%
5
 
2.6%
5
 
2.6%
Other values (41) 75
39.3%
Common
ValueCountFrequency (%)
) 4
50.0%
( 4
50.0%

Most occurring blocks

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

Most frequent character per block

Hangul
ValueCountFrequency (%)
20
 
10.5%
17
 
8.9%
13
 
6.8%
13
 
6.8%
13
 
6.8%
13
 
6.8%
10
 
5.2%
7
 
3.7%
5
 
2.6%
5
 
2.6%
Other values (41) 75
39.3%
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:23.592196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length22
Mean length20.04
Min length15

Characters and Unicode

Total characters501
Distinct characters57
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경상남도 거제시 하청면 하청로 34
3rd row경상남도 거제시 일운면 지세포로 101
4th row경상남도 거제시 동부면 동부로 4
5th row경상남도 거제시 거제면 기성로 33
ValueCountFrequency (%)
경상남도 25
20.5%
거제시 25
20.5%
고현로 4
 
3.3%
거제면 4
 
3.3%
하청면 3
 
2.5%
거제남서로 2
 
1.6%
장목면 2
 
1.6%
읍내로2길 2
 
1.6%
기성로 2
 
1.6%
동부면 2
 
1.6%
Other values (46) 51
41.8%
2023-12-11T08:22:23.999474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
97
19.4%
34
 
6.8%
34
 
6.8%
28
 
5.6%
26
 
5.2%
25
 
5.0%
25
 
5.0%
25
 
5.0%
21
 
4.2%
18
 
3.6%
Other values (47) 168
33.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 328
65.5%
Space Separator 97
 
19.4%
Decimal Number 73
 
14.6%
Dash Punctuation 3
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
34
10.4%
34
10.4%
28
 
8.5%
26
 
7.9%
25
 
7.6%
25
 
7.6%
25
 
7.6%
21
 
6.4%
18
 
5.5%
9
 
2.7%
Other values (35) 83
25.3%
Decimal Number
ValueCountFrequency (%)
1 18
24.7%
3 14
19.2%
2 12
16.4%
4 7
 
9.6%
0 7
 
9.6%
8 5
 
6.8%
6 4
 
5.5%
5 3
 
4.1%
9 2
 
2.7%
7 1
 
1.4%
Space Separator
ValueCountFrequency (%)
97
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 328
65.5%
Common 173
34.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
34
10.4%
34
10.4%
28
 
8.5%
26
 
7.9%
25
 
7.6%
25
 
7.6%
25
 
7.6%
21
 
6.4%
18
 
5.5%
9
 
2.7%
Other values (35) 83
25.3%
Common
ValueCountFrequency (%)
97
56.1%
1 18
 
10.4%
3 14
 
8.1%
2 12
 
6.9%
4 7
 
4.0%
0 7
 
4.0%
8 5
 
2.9%
6 4
 
2.3%
- 3
 
1.7%
5 3
 
1.7%
Other values (2) 3
 
1.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 328
65.5%
ASCII 173
34.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
97
56.1%
1 18
 
10.4%
3 14
 
8.1%
2 12
 
6.9%
4 7
 
4.0%
0 7
 
4.0%
8 5
 
2.9%
6 4
 
2.3%
- 3
 
1.7%
5 3
 
1.7%
Other values (2) 3
 
1.7%
Hangul
ValueCountFrequency (%)
34
10.4%
34
10.4%
28
 
8.5%
26
 
7.9%
25
 
7.6%
25
 
7.6%
25
 
7.6%
21
 
6.4%
18
 
5.5%
9
 
2.7%
Other values (35) 83
25.3%

전화번호
Text

MISSING 

Distinct24
Distinct (%)100.0%
Missing1
Missing (%)4.0%
Memory size332.0 B
2023-12-11T08:22:24.221158image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

Total characters288
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

Unique24 ?
Unique (%)100.0%

Sample

1st row055-635-7302
2nd row055-636-5805
3rd row055-681-0386
4th row055-634-4566
5th row055-632-3654
ValueCountFrequency (%)
055-635-7302 1
 
4.2%
055-636-5805 1
 
4.2%
055-636-0533 1
 
4.2%
055-636-6044 1
 
4.2%
055-633-9077 1
 
4.2%
055-632-8570 1
 
4.2%
055-633-2005 1
 
4.2%
055-688-5798 1
 
4.2%
055-635-0109 1
 
4.2%
055-634-1382 1
 
4.2%
Other values (14) 14
58.3%
2023-12-11T08:22:24.569981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5 65
22.6%
- 48
16.7%
0 43
14.9%
6 35
12.2%
3 33
11.5%
8 16
 
5.6%
2 12
 
4.2%
1 11
 
3.8%
4 10
 
3.5%
7 9
 
3.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 240
83.3%
Dash Punctuation 48
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
5 65
27.1%
0 43
17.9%
6 35
14.6%
3 33
13.8%
8 16
 
6.7%
2 12
 
5.0%
1 11
 
4.6%
4 10
 
4.2%
7 9
 
3.8%
9 6
 
2.5%
Dash Punctuation
ValueCountFrequency (%)
- 48
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 288
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
5 65
22.6%
- 48
16.7%
0 43
14.9%
6 35
12.2%
3 33
11.5%
8 16
 
5.6%
2 12
 
4.2%
1 11
 
3.8%
4 10
 
3.5%
7 9
 
3.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 288
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5 65
22.6%
- 48
16.7%
0 43
14.9%
6 35
12.2%
3 33
11.5%
8 16
 
5.6%
2 12
 
4.2%
1 11
 
3.8%
4 10
 
3.5%
7 9
 
3.1%
Distinct22
Distinct (%)88.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
2023-12-11T08:22:24.793463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length7
Median length3
Mean length3.12
Min length2

Characters and Unicode

Total characters78
Distinct characters46
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

Unique19 ?
Unique (%)76.0%

Sample

1st row이철주
2nd row정흥섭
3rd row윤대산
4th row심광
5th row김재환
ValueCountFrequency (%)
신종배 2
 
7.7%
원희철 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%
Other values (13) 13
50.0%
2023-12-11T08:22:25.482432image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5
 
6.4%
5
 
6.4%
4
 
5.1%
3
 
3.8%
3
 
3.8%
3
 
3.8%
3
 
3.8%
3
 
3.8%
3
 
3.8%
3
 
3.8%
Other values (36) 43
55.1%

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%
4
 
5.2%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
Other values (35) 42
54.5%
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%
4
 
5.2%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
Other values (35) 42
54.5%
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%
4
 
5.2%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
3
 
3.9%
Other values (35) 42
54.5%
ASCII
ValueCountFrequency (%)
1
100.0%

기준일
Date

CONSTANT 

Distinct1
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size332.0 B
Minimum2018-08-03 00:00:00
Maximum2018-08-03 00:00:00
2023-12-11T08:22:25.620900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:22:25.758469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-11T08:22:25.870756image/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:22.695288image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:22:22.792465image/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이철주2018-08-03
1하청농업협동조합경상남도 거제시 하청면 하청로 34055-636-5805정흥섭2018-08-03
2일운농약사경상남도 거제시 일운면 지세포로 101055-681-0386윤대산2018-08-03
3심원농약사경상남도 거제시 동부면 동부로 4055-634-4566심광2018-08-03
4중앙종묘농약사경상남도 거제시 거제면 기성로 33055-632-3654김재환2018-08-03
5성내원예자재사경상남도 거제시 거제면 읍내로2길 27055-632-8979정완규2018-08-03
6신흥농약사경상남도 거제시 하청면 하청로 10055-636-2036이행선2018-08-03
7황씨상회경상남도 거제시 장승포로 49 신부시장055-681-5808김순자2018-08-03
8일운농업협동조합경상남도 거제시 일운면 지세포로 131055-681-0072서영재2018-08-03
9신현농업협동조합경상남도 거제시 고현로11길 23055-632-0040지영배2018-08-03
상호주소전화번호대표자명기준일
15대교상사경상남도 거제시 사등면 덕호신촌2길 2055-634-1382정명자2018-08-03
16장목농업협동조합경상남도 거제시 장목면 거제북로 1206055-635-0109신종배2018-08-03
17장승포농업협동조합경상남도 거제시 아주동 거제대로 3513055-688-5798권순옥2018-08-03
18동남부농업협동조합(동부지점)경상남도 거제시 동부면 거제남서로 3086055-633-2005원희철2018-08-03
19거제원예농약종묘사경상남도 거제시 고현로 12길 19055-632-8570유동선2018-08-03
20하청농업협동조합(칠천지점)경상남도 거제시 하청면 연구2길 3-12055-633-9077정흥섭2018-08-03
21장목농업협동조합(외포지점)경상남도 거제시 장목면 외포4길 3055-636-6044신종배2018-08-03
22동신농약사경상남도 거제시 고현로 84055-636-0533박일자2018-08-03
23고현원예종묘경상남도 거제시 고현로 10길 14055-638-5789제서영 김노열2018-08-03
24대성종묘경상남도 거제시 거제면 기성로 38-1<NA>이희용2018-08-03