Overview

Dataset statistics

Number of variables6
Number of observations67
Missing cells5
Missing cells (%)1.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.3 KiB
Average record size in memory51.0 B

Variable types

Numeric1
Text4
DateTime1

Dataset

Description익산시 관내 읍면동의 비료 생산업 및 농약 판매업소의 상호명, 사업장 도로명 주소, 등록일, 대표자, 전화번호 등의 데이터를 제공합니다.
Author전라북도 익산시
URLhttps://www.data.go.kr/data/3079123/fileData.do

Alerts

전화번호 has 5 (7.5%) missing valuesMissing
연번 has unique valuesUnique
상호명 has unique valuesUnique
사업장 소재지 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:57:57.870756
Analysis finished2023-12-12 19:57:58.799449
Duration0.93 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct67
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34
Minimum1
Maximum67
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size735.0 B
2023-12-13T04:57:58.884193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.3
Q117.5
median34
Q350.5
95-th percentile63.7
Maximum67
Range66
Interquartile range (IQR)33

Descriptive statistics

Standard deviation19.485037
Coefficient of variation (CV)0.57308932
Kurtosis-1.2
Mean34
Median Absolute Deviation (MAD)17
Skewness0
Sum2278
Variance379.66667
MonotonicityStrictly increasing
2023-12-13T04:57:59.077652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.5%
44 1
 
1.5%
50 1
 
1.5%
49 1
 
1.5%
48 1
 
1.5%
47 1
 
1.5%
46 1
 
1.5%
45 1
 
1.5%
43 1
 
1.5%
2 1
 
1.5%
Other values (57) 57
85.1%
ValueCountFrequency (%)
1 1
1.5%
2 1
1.5%
3 1
1.5%
4 1
1.5%
5 1
1.5%
6 1
1.5%
7 1
1.5%
8 1
1.5%
9 1
1.5%
10 1
1.5%
ValueCountFrequency (%)
67 1
1.5%
66 1
1.5%
65 1
1.5%
64 1
1.5%
63 1
1.5%
62 1
1.5%
61 1
1.5%
60 1
1.5%
59 1
1.5%
58 1
1.5%

상호명
Text

UNIQUE 

Distinct67
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
2023-12-13T04:57:59.382638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length13
Mean length6.4029851
Min length3

Characters and Unicode

Total characters429
Distinct characters109
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique67 ?
Unique (%)100.0%

Sample

1st row신흥농약사
2nd row한림종묘농약사
3rd row대풍농약사
4th row새호남농약사
5th row금마농협
ValueCountFrequency (%)
그린팜 2
 
2.9%
신흥농약사 1
 
1.4%
중앙농약사 1
 
1.4%
익산산림조합 1
 
1.4%
터미널농약사 1
 
1.4%
우주원영농조합법인 1
 
1.4%
한국농약씨앗 1
 
1.4%
익산농협오성지점 1
 
1.4%
은성농약사 1
 
1.4%
함열일수농약사 1
 
1.4%
Other values (58) 58
84.1%
2023-12-13T04:57:59.814366image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
농 58
 
13.5%
약 30
 
7.0%
사 30
 
7.0%
협 22
 
5.1%
산 18
 
4.2%
익 13
 
3.0%
묘 10
 
2.3%
종 10
 
2.3%
지 9
 
2.1%
그 8
 
1.9%
Other values (99) 221
51.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 419
97.7%
Other Symbol 3
 
0.7%
Uppercase Letter 3
 
0.7%
Space Separator 2
 
0.5%
Open Punctuation 1
 
0.2%
Close Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
농 58
 
13.8%
약 30
 
7.2%
사 30
 
7.2%
협 22
 
5.3%
산 18
 
4.3%
익 13
 
3.1%
묘 10
 
2.4%
종 10
 
2.4%
지 9
 
2.1%
그 8
 
1.9%
Other values (92) 211
50.4%
Uppercase Letter
ValueCountFrequency (%)
P 1
33.3%
R 1
33.3%
C 1
33.3%
Other Symbol
ValueCountFrequency (%)
㈜ 3
100.0%
Space Separator
ValueCountFrequency (%)
2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 422
98.4%
Common 4
 
0.9%
Latin 3
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
농 58
 
13.7%
약 30
 
7.1%
사 30
 
7.1%
협 22
 
5.2%
산 18
 
4.3%
익 13
 
3.1%
묘 10
 
2.4%
종 10
 
2.4%
지 9
 
2.1%
그 8
 
1.9%
Other values (93) 214
50.7%
Common
ValueCountFrequency (%)
2
50.0%
( 1
25.0%
) 1
25.0%
Latin
ValueCountFrequency (%)
P 1
33.3%
R 1
33.3%
C 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 419
97.7%
ASCII 7
 
1.6%
None 3
 
0.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
농 58
 
13.8%
약 30
 
7.2%
사 30
 
7.2%
협 22
 
5.3%
산 18
 
4.3%
익 13
 
3.1%
묘 10
 
2.4%
종 10
 
2.4%
지 9
 
2.1%
그 8
 
1.9%
Other values (92) 211
50.4%
None
ValueCountFrequency (%)
㈜ 3
100.0%
ASCII
ValueCountFrequency (%)
2
28.6%
P 1
14.3%
( 1
14.3%
) 1
14.3%
R 1
14.3%
C 1
14.3%

사업장 소재지
Text

UNIQUE 

Distinct67
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size668.0 B
2023-12-13T04:58:00.245789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length22
Mean length19.641791
Min length15

Characters and Unicode

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

Unique

Unique67 ?
Unique (%)100.0%

Sample

1st row전라북도 익산시 익산대로20길 16
2nd row전라북도 익산시 금마면 금마길 45-1
3rd row전라북도 익산시 인북로8길 12-1
4th row전라북도 익산시 황등면 황등로 168
5th row전라북도 익산시 금마면 동고도리 761-1
ValueCountFrequency (%)
전라북도 67
21.4%
익산시 67
21.4%
황등면 7
 
2.2%
인북로 6
 
1.9%
함열읍 5
 
1.6%
오산면 5
 
1.6%
황등로 5
 
1.6%
금마면 5
 
1.6%
익산대로 4
 
1.3%
삼기면 4
 
1.3%
Other values (114) 138
44.1%
2023-12-13T04:58:00.817075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
247
18.8%
산 86
 
6.5%
북 76
 
5.8%
익 73
 
5.5%
라 69
 
5.2%
도 68
 
5.2%
시 68
 
5.2%
전 67
 
5.1%
로 50
 
3.8%
1 44
 
3.3%
Other values (75) 468
35.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 841
63.9%
Space Separator 247
 
18.8%
Decimal Number 205
 
15.6%
Dash Punctuation 17
 
1.3%
Open Punctuation 3
 
0.2%
Close Punctuation 3
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 86
 
10.2%
북 76
 
9.0%
익 73
 
8.7%
라 69
 
8.2%
도 68
 
8.1%
시 68
 
8.1%
전 67
 
8.0%
로 50
 
5.9%
면 38
 
4.5%
길 22
 
2.6%
Other values (61) 224
26.6%
Decimal Number
ValueCountFrequency (%)
1 44
21.5%
2 28
13.7%
8 20
9.8%
4 20
9.8%
7 18
8.8%
6 17
 
8.3%
0 15
 
7.3%
3 15
 
7.3%
9 14
 
6.8%
5 14
 
6.8%
Space Separator
ValueCountFrequency (%)
247
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 841
63.9%
Common 475
36.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 86
 
10.2%
북 76
 
9.0%
익 73
 
8.7%
라 69
 
8.2%
도 68
 
8.1%
시 68
 
8.1%
전 67
 
8.0%
로 50
 
5.9%
면 38
 
4.5%
길 22
 
2.6%
Other values (61) 224
26.6%
Common
ValueCountFrequency (%)
247
52.0%
1 44
 
9.3%
2 28
 
5.9%
8 20
 
4.2%
4 20
 
4.2%
7 18
 
3.8%
6 17
 
3.6%
- 17
 
3.6%
0 15
 
3.2%
3 15
 
3.2%
Other values (4) 34
 
7.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 841
63.9%
ASCII 475
36.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
247
52.0%
1 44
 
9.3%
2 28
 
5.9%
8 20
 
4.2%
4 20
 
4.2%
7 18
 
3.8%
6 17
 
3.6%
- 17
 
3.6%
0 15
 
3.2%
3 15
 
3.2%
Other values (4) 34
 
7.2%
Hangul
ValueCountFrequency (%)
산 86
 
10.2%
북 76
 
9.0%
익 73
 
8.7%
라 69
 
8.2%
도 68
 
8.1%
시 68
 
8.1%
전 67
 
8.0%
로 50
 
5.9%
면 38
 
4.5%
길 22
 
2.6%
Other values (61) 224
26.6%

등록일
Date

Distinct52
Distinct (%)77.6%
Missing0
Missing (%)0.0%
Memory size668.0 B
Minimum1981-05-12 00:00:00
Maximum2020-07-31 00:00:00
2023-12-13T04:58:01.010780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:58:01.184933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

대표
Text

Distinct57
Distinct (%)85.1%
Missing0
Missing (%)0.0%
Memory size668.0 B
2023-12-13T04:58:01.481574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length3
Min length3

Characters and Unicode

Total characters201
Distinct characters95
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique52 ?
Unique (%)77.6%

Sample

1st row서호석
2nd row강명호
3rd row유왕열
4th row박선희
5th row백낙진
ValueCountFrequency (%)
김병옥 6
 
9.0%
장복식 3
 
4.5%
서호석 2
 
3.0%
채병덕 2
 
3.0%
임철석 2
 
3.0%
박진보 1
 
1.5%
신규식 1
 
1.5%
채문석 1
 
1.5%
양정표 1
 
1.5%
장태수 1
 
1.5%
Other values (47) 47
70.1%
2023-12-13T04:58:01.866804image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 18
 
9.0%
병 8
 
4.0%
옥 6
 
3.0%
장 6
 
3.0%
정 6
 
3.0%
진 6
 
3.0%
영 5
 
2.5%
박 5
 
2.5%
석 5
 
2.5%
호 5
 
2.5%
Other values (85) 131
65.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 201
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 18
 
9.0%
병 8
 
4.0%
옥 6
 
3.0%
장 6
 
3.0%
정 6
 
3.0%
진 6
 
3.0%
영 5
 
2.5%
박 5
 
2.5%
석 5
 
2.5%
호 5
 
2.5%
Other values (85) 131
65.2%

Most occurring scripts

ValueCountFrequency (%)
Hangul 201
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 18
 
9.0%
병 8
 
4.0%
옥 6
 
3.0%
장 6
 
3.0%
정 6
 
3.0%
진 6
 
3.0%
영 5
 
2.5%
박 5
 
2.5%
석 5
 
2.5%
호 5
 
2.5%
Other values (85) 131
65.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 201
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 18
 
9.0%
병 8
 
4.0%
옥 6
 
3.0%
장 6
 
3.0%
정 6
 
3.0%
진 6
 
3.0%
영 5
 
2.5%
박 5
 
2.5%
석 5
 
2.5%
호 5
 
2.5%
Other values (85) 131
65.2%

전화번호
Text

MISSING 

Distinct60
Distinct (%)96.8%
Missing5
Missing (%)7.5%
Memory size668.0 B
2023-12-13T04:58:02.192411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique58 ?
Unique (%)93.5%

Sample

1st row063-855-9065
2nd row063-863-6946
3rd row063-854-1017
4th row063-856-5960
5th row063-836-6008
ValueCountFrequency (%)
063-858-8651 2
 
3.2%
063-855-9065 2
 
3.2%
063-855-4337 1
 
1.6%
063-857-0388 1
 
1.6%
063-855-6136 1
 
1.6%
063-836-8999 1
 
1.6%
063-861-0968 1
 
1.6%
063-856-4379 1
 
1.6%
063-852-5026 1
 
1.6%
063-858-5596 1
 
1.6%
Other values (50) 50
80.6%
2023-12-13T04:58:02.663462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 124
16.7%
- 124
16.7%
0 108
14.5%
3 97
13.0%
8 94
12.6%
5 65
8.7%
1 42
 
5.6%
4 26
 
3.5%
2 25
 
3.4%
7 20
 
2.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 620
83.3%
Dash Punctuation 124
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 124
20.0%
0 108
17.4%
3 97
15.6%
8 94
15.2%
5 65
10.5%
1 42
 
6.8%
4 26
 
4.2%
2 25
 
4.0%
7 20
 
3.2%
9 19
 
3.1%
Dash Punctuation
ValueCountFrequency (%)
- 124
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 744
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
6 124
16.7%
- 124
16.7%
0 108
14.5%
3 97
13.0%
8 94
12.6%
5 65
8.7%
1 42
 
5.6%
4 26
 
3.5%
2 25
 
3.4%
7 20
 
2.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 744
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 124
16.7%
- 124
16.7%
0 108
14.5%
3 97
13.0%
8 94
12.6%
5 65
8.7%
1 42
 
5.6%
4 26
 
3.5%
2 25
 
3.4%
7 20
 
2.7%

Interactions

2023-12-13T04:57:58.432509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:58:02.797388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번상호명사업장 소재지등록일대표전화번호
연번1.0001.0001.0000.9350.8680.875
상호명1.0001.0001.0001.0001.0001.000
사업장 소재지1.0001.0001.0001.0001.0001.000
등록일0.9351.0001.0001.0000.9920.968
대표0.8681.0001.0000.9921.0001.000
전화번호0.8751.0001.0000.9681.0001.000

Missing values

2023-12-13T04:57:58.597331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:57:58.749333image/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

연번상호명사업장 소재지등록일대표전화번호
01신흥농약사전라북도 익산시 익산대로20길 161981-05-12서호석063-855-9065
12한림종묘농약사전라북도 익산시 금마면 금마길 45-11983-02-05강명호063-863-6946
23대풍농약사전라북도 익산시 인북로8길 12-11986-03-22유왕열063-854-1017
34새호남농약사전라북도 익산시 황등면 황등로 1681986-05-03박선희063-856-5960
45금마농협전라북도 익산시 금마면 동고도리 761-11986-06-23백낙진063-836-6008
56쌍용종묘농약사전라북도 익산시 인북로 49(인화동1가)1987-09-04백봉기063-854-6288
67믿음종묘농약사전라북도 익산시 인북로8길 22-21989-03-11이희용063-854-0887
78용안농약사전라북도 익산시 용안면 현내로 389-11989-03-13김경수063-861-3603
89역전농약사전라북도 익산시 용동면 용동1길 77-11989-05-18김기흥063-862-4566
910오산농협전라북도 익산시 오산면 오산로 191989-11-20채병덕063-857-1240
연번상호명사업장 소재지등록일대표전화번호
5758부성농자재마트전라북도 익산시 왕궁면 쌍제1길 452016-03-24오재홍063-261-7445
5859백제농자재마트전라북도 익산시 함열읍 함열로 772017-04-14현은숙063-862-6533
5960그린아그로전라북도 익산시 황등면 황등로 145-12017-07-28고동만063-855-8315
6061신영아그로전라북도 익산시 오산면 만신길 22017-12-22정광수<NA>
6162뉴그린농자재전라북도 익산시 황등면 익산대로 1090-72018-08-22김덕진063-855-5060
6263㈜신농팜케미컬전라북도 익산시 삼기면 산단오룡길 792019-07-05신규식063-918-5288
6364전북아그로전라북도 익산시 오산면 오산로 492019-12-03김남수<NA>
6465그린팜전라북도 익산시 목천동 411-72019-12-10이서희<NA>
6566농업회사법인 유한회사 그린팜전라북도 익산시 오산면 신후길 103-82020-05-07문정님<NA>
6667제일농약사전라북도 익산시 여산면 가람로 3752020-07-31김대운063-861-6188