Overview

Dataset statistics

Number of variables5
Number of observations23
Missing cells1
Missing cells (%)0.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.0 KiB
Average record size in memory45.6 B

Variable types

Categorical2
Text3

Dataset

Description전북특별자치도 군산시 소재한 농기계수리업소현황으로 시군, 판매업소명, 도로명주소, 사후관리업소등록현황, 연락처 등을 제공하고 있습니다.
Author전북특별자치도 군산시
URLhttps://www.data.go.kr/data/15086951/fileData.do

Alerts

시군 has constant value ""Constant
연락처 has 1 (4.3%) missing valuesMissing
판매업소명 has unique valuesUnique
도로명주소 has unique valuesUnique

Reproduction

Analysis started2024-03-14 19:39:55.460020
Analysis finished2024-03-14 19:39:56.116983
Duration0.66 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군
Categorical

CONSTANT 

Distinct1
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size312.0 B
군산시
23 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row군산시
2nd row군산시
3rd row군산시
4th row군산시
5th row군산시

Common Values

ValueCountFrequency (%)
군산시 23
100.0%

Length

2024-03-15T04:39:56.230212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T04:39:56.398082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
군산시 23
100.0%

판매업소명
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size312.0 B
2024-03-15T04:39:57.043635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length11
Mean length8.1304348
Min length4

Characters and Unicode

Total characters187
Distinct characters79
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

Unique23 ?
Unique (%)100.0%

Sample

1st row대흥종합기계
2nd row군장종합기계(LS농기계)
3rd row대동공업㈜
4th row한성건조기 군산출장소
5th row군산농업협동조합
ValueCountFrequency (%)
군산대리점 2
 
7.1%
한성건조기 2
 
7.1%
대흥종합기계 1
 
3.6%
미래종합농기계 1
 
3.6%
신세계농축산기계 1
 
3.6%
국제농기계군산대리점 1
 
3.6%
㈜지에스엠 1
 
3.6%
유)동아하이테크 1
 
3.6%
얀마농기계 1
 
3.6%
서군산농기계센터 1
 
3.6%
Other values (16) 16
57.1%
2024-03-15T04:39:58.157989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
기 13
 
7.0%
농 12
 
6.4%
계 12
 
6.4%
산 9
 
4.8%
군 8
 
4.3%
합 7
 
3.7%
동 6
 
3.2%
대 6
 
3.2%
업 5
 
2.7%
조 5
 
2.7%
Other values (69) 104
55.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 168
89.8%
Space Separator 5
 
2.7%
Open Punctuation 4
 
2.1%
Close Punctuation 4
 
2.1%
Uppercase Letter 4
 
2.1%
Other Symbol 2
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
기 13
 
7.7%
농 12
 
7.1%
계 12
 
7.1%
산 9
 
5.4%
군 8
 
4.8%
합 7
 
4.2%
동 6
 
3.6%
대 6
 
3.6%
업 5
 
3.0%
조 5
 
3.0%
Other values (61) 85
50.6%
Uppercase Letter
ValueCountFrequency (%)
G 1
25.0%
K 1
25.0%
L 1
25.0%
S 1
25.0%
Space Separator
ValueCountFrequency (%)
5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 170
90.9%
Common 13
 
7.0%
Latin 4
 
2.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
기 13
 
7.6%
농 12
 
7.1%
계 12
 
7.1%
산 9
 
5.3%
군 8
 
4.7%
합 7
 
4.1%
동 6
 
3.5%
대 6
 
3.5%
업 5
 
2.9%
조 5
 
2.9%
Other values (62) 87
51.2%
Latin
ValueCountFrequency (%)
G 1
25.0%
K 1
25.0%
L 1
25.0%
S 1
25.0%
Common
ValueCountFrequency (%)
5
38.5%
( 4
30.8%
) 4
30.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 168
89.8%
ASCII 17
 
9.1%
None 2
 
1.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
기 13
 
7.7%
농 12
 
7.1%
계 12
 
7.1%
산 9
 
5.4%
군 8
 
4.8%
합 7
 
4.2%
동 6
 
3.6%
대 6
 
3.6%
업 5
 
3.0%
조 5
 
3.0%
Other values (61) 85
50.6%
ASCII
ValueCountFrequency (%)
5
29.4%
( 4
23.5%
) 4
23.5%
G 1
 
5.9%
K 1
 
5.9%
L 1
 
5.9%
S 1
 
5.9%
None
ValueCountFrequency (%)
㈜ 2
100.0%

도로명주소
Text

UNIQUE 

Distinct23
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size312.0 B
2024-03-15T04:39:59.046381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length22.869565
Min length19

Characters and Unicode

Total characters526
Distinct characters65
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

Unique23 ?
Unique (%)100.0%

Sample

1st row전북특별자치도 군산시 대야면 만경로 1941
2nd row전북특별자치도 군산시 대야면 만경로 1700
3rd row전북특별자치도 군산시 개정면 동정2길 5
4th row전북특별자치도 군산시 서수면 항쟁로 223
5th row전북특별자치도 군산시 쌍천로 27
ValueCountFrequency (%)
전북특별자치도 23
20.9%
군산시 23
20.9%
대야면 7
 
6.4%
개정면 6
 
5.5%
만경로 4
 
3.6%
번영로 3
 
2.7%
1700 2
 
1.8%
서수면 2
 
1.8%
회현면 2
 
1.8%
156 1
 
0.9%
Other values (37) 37
33.6%
2024-03-15T04:40:00.313917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
90
17.1%
산 27
 
5.1%
북 25
 
4.8%
전 23
 
4.4%
특 23
 
4.4%
별 23
 
4.4%
자 23
 
4.4%
치 23
 
4.4%
도 23
 
4.4%
군 23
 
4.4%
Other values (55) 223
42.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 364
69.2%
Space Separator 90
 
17.1%
Decimal Number 68
 
12.9%
Dash Punctuation 4
 
0.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 27
 
7.4%
북 25
 
6.9%
전 23
 
6.3%
특 23
 
6.3%
별 23
 
6.3%
자 23
 
6.3%
치 23
 
6.3%
도 23
 
6.3%
군 23
 
6.3%
시 23
 
6.3%
Other values (43) 128
35.2%
Decimal Number
ValueCountFrequency (%)
1 11
16.2%
0 10
14.7%
2 10
14.7%
4 9
13.2%
5 8
11.8%
7 7
10.3%
9 6
8.8%
8 4
 
5.9%
6 2
 
2.9%
3 1
 
1.5%
Space Separator
ValueCountFrequency (%)
90
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 364
69.2%
Common 162
30.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 27
 
7.4%
북 25
 
6.9%
전 23
 
6.3%
특 23
 
6.3%
별 23
 
6.3%
자 23
 
6.3%
치 23
 
6.3%
도 23
 
6.3%
군 23
 
6.3%
시 23
 
6.3%
Other values (43) 128
35.2%
Common
ValueCountFrequency (%)
90
55.6%
1 11
 
6.8%
0 10
 
6.2%
2 10
 
6.2%
4 9
 
5.6%
5 8
 
4.9%
7 7
 
4.3%
9 6
 
3.7%
8 4
 
2.5%
- 4
 
2.5%
Other values (2) 3
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 364
69.2%
ASCII 162
30.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
90
55.6%
1 11
 
6.8%
0 10
 
6.2%
2 10
 
6.2%
4 9
 
5.6%
5 8
 
4.9%
7 7
 
4.3%
9 6
 
3.7%
8 4
 
2.5%
- 4
 
2.5%
Other values (2) 3
 
1.9%
Hangul
ValueCountFrequency (%)
산 27
 
7.4%
북 25
 
6.9%
전 23
 
6.3%
특 23
 
6.3%
별 23
 
6.3%
자 23
 
6.3%
치 23
 
6.3%
도 23
 
6.3%
군 23
 
6.3%
시 23
 
6.3%
Other values (43) 128
35.2%

사후관리업소등급
Categorical

Distinct3
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size312.0 B
소형
11 
중형
10 
대형
2 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row중형
2nd row대형
3rd row중형
4th row소형
5th row중형

Common Values

ValueCountFrequency (%)
소형 11
47.8%
중형 10
43.5%
대형 2
 
8.7%

Length

2024-03-15T04:40:00.772950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T04:40:01.075240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
소형 11
47.8%
중형 10
43.5%
대형 2
 
8.7%

연락처
Text

MISSING 

Distinct22
Distinct (%)100.0%
Missing1
Missing (%)4.3%
Memory size312.0 B
2024-03-15T04:40:01.854065image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique22 ?
Unique (%)100.0%

Sample

1st row063-451-3656
2nd row063-451-9040
3rd row063-453-5100
4th row063-453-6110
5th row063-452-3329
ValueCountFrequency (%)
063-451-3656 1
 
4.5%
063-451-9040 1
 
4.5%
063-452-8358 1
 
4.5%
063-453-4004 1
 
4.5%
063-452-7845 1
 
4.5%
063-467-7999 1
 
4.5%
063-462-1706 1
 
4.5%
063-467-3006 1
 
4.5%
063-467-6119 1
 
4.5%
063-451-0666 1
 
4.5%
Other values (12) 12
54.5%
2024-03-15T04:40:03.023722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 44
16.7%
6 39
14.8%
0 38
14.4%
3 33
12.5%
4 31
11.7%
5 24
9.1%
1 15
 
5.7%
2 15
 
5.7%
9 12
 
4.5%
7 9
 
3.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 220
83.3%
Dash Punctuation 44
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 39
17.7%
0 38
17.3%
3 33
15.0%
4 31
14.1%
5 24
10.9%
1 15
 
6.8%
2 15
 
6.8%
9 12
 
5.5%
7 9
 
4.1%
8 4
 
1.8%
Dash Punctuation
ValueCountFrequency (%)
- 44
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 264
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 44
16.7%
6 39
14.8%
0 38
14.4%
3 33
12.5%
4 31
11.7%
5 24
9.1%
1 15
 
5.7%
2 15
 
5.7%
9 12
 
4.5%
7 9
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 264
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 44
16.7%
6 39
14.8%
0 38
14.4%
3 33
12.5%
4 31
11.7%
5 24
9.1%
1 15
 
5.7%
2 15
 
5.7%
9 12
 
4.5%
7 9
 
3.4%

Correlations

2024-03-15T04:40:03.285443image/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

2024-03-15T04:39:55.804925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T04:39:56.050350image/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군산시대흥종합기계전북특별자치도 군산시 대야면 만경로 1941중형063-451-3656
1군산시군장종합기계(LS농기계)전북특별자치도 군산시 대야면 만경로 1700대형063-451-9040
2군산시대동공업㈜전북특별자치도 군산시 개정면 동정2길 5중형063-453-5100
3군산시한성건조기 군산출장소전북특별자치도 군산시 서수면 항쟁로 223소형063-453-6110
4군산시군산농업협동조합전북특별자치도 군산시 쌍천로 27중형063-452-3329
5군산시(주)호성 구보다군산지점전북특별자치도 군산시 개정면 번영로 526중형063-451-0497
6군산시대야농업협동조합전북특별자치도 군산시 대야면 만경로 1807소형063-451-1992
7군산시동양농기계전북특별자치도 군산시 개정면 운회길 12중형063-452-5920
8군산시회현농업협동조합전북특별자치도 군산시 회현면 광지산길 9소형063-460-1904
9군산시준종합농기계전북특별자치도 군산시 개정면 번영로 722소형063-453-3650
시군판매업소명도로명주소사후관리업소등급연락처
13군산시KG케미컬 군산대리점전북특별자치도 군산시 대야면 대야관통로 54소형063-451-0666
14군산시(유)히타치코리아전북특별자치도 군산시 개정면 아동북길 75-28중형063-467-6119
15군산시서군산농기계센터전북특별자치도 군산시 공항로 409소형<NA>
16군산시얀마농기계전북특별자치도 군산시 회현면 증석길 156중형063-467-3006
17군산시(유)동아하이테크전북특별자치도 군산시 산단남북로 70소형063-462-1706
18군산시㈜지에스엠전북특별자치도 군산시 동장산로 105-9중형063-467-7999
19군산시국제농기계군산대리점전북특별자치도 군산시 개정면 개정안길 45중형063-452-7845
20군산시신세계농축산기계전북특별자치도 군산시 대야면 만경로 1700소형063-453-4004
21군산시미래종합농기계전북특별자치도 군산시 대야면 복교리 448-5중형063-452-8358
22군산시퍼스트농기계전북특별자치도 군산시 개정들4길 18소형063-452-4724