Overview

Dataset statistics

Number of variables5
Number of observations29
Missing cells5
Missing cells (%)3.4%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory44.6 B

Variable types

Categorical1
Text4

Dataset

Description충청남도 홍성군 화물운송업체에 대한 데이터로 화물의 구분+ 상호+대표자+주소+전화번호를 목록에 추가하여 제공하고 있습니다.
Author충청남도 홍성군
URLhttps://www.data.go.kr/data/3073588/fileData.do

Alerts

구분 is highly imbalanced (72.8%)Imbalance
전화번호 has 5 (17.2%) missing valuesMissing
상호 has unique valuesUnique
대표자 has unique valuesUnique

Reproduction

Analysis started2023-12-12 01:19:14.317660
Analysis finished2023-12-12 01:19:14.863693
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구분
Categorical

IMBALANCE 

Distinct3
Distinct (%)10.3%
Missing0
Missing (%)0.0%
Memory size364.0 B
일반화물
27 
개별화물
 
1
용달화물
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique2 ?
Unique (%)6.9%

Sample

1st row일반화물
2nd row일반화물
3rd row일반화물
4th row일반화물
5th row일반화물

Common Values

ValueCountFrequency (%)
일반화물 27
93.1%
개별화물 1
 
3.4%
용달화물 1
 
3.4%

Length

2023-12-12T10:19:14.972610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T10:19:15.090375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
일반화물 27
93.1%
개별화물 1
 
3.4%
용달화물 1
 
3.4%

상호
Text

UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size364.0 B
2023-12-12T10:19:15.340026image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length16
Median length12
Mean length7.1724138
Min length4

Characters and Unicode

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

Unique

Unique29 ?
Unique (%)100.0%

Sample

1st row광일화물자동차(주)
2nd row광천화물자동차㈜
3rd row홍성운수(주)
4th row홍주운수(주)
5th row(주)길가온
ValueCountFrequency (%)
홍성영업소 2
 
6.1%
광일화물자동차(주 1
 
3.0%
광천화물자동차㈜ 1
 
3.0%
개별화물홍성지회 1
 
3.0%
청석산업㈜ 1
 
3.0%
㈜태영환경 1
 
3.0%
㈜에이치더블유로지스 1
 
3.0%
제일익스프레스 1
 
3.0%
주)성룡 1
 
3.0%
내포렉카 1
 
3.0%
Other values (22) 22
66.7%
2023-12-12T10:19:15.762724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 14
 
6.7%
) 13
 
6.2%
( 13
 
6.2%
성 10
 
4.8%
홍 10
 
4.8%
물 8
 
3.8%
카 6
 
2.9%
스 5
 
2.4%
㈜ 5
 
2.4%
화 5
 
2.4%
Other values (69) 119
57.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 172
82.7%
Close Punctuation 13
 
6.2%
Open Punctuation 13
 
6.2%
Other Symbol 5
 
2.4%
Control 3
 
1.4%
Space Separator 2
 
1.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 14
 
8.1%
성 10
 
5.8%
홍 10
 
5.8%
물 8
 
4.7%
카 6
 
3.5%
스 5
 
2.9%
화 5
 
2.9%
렉 5
 
2.9%
영 4
 
2.3%
일 4
 
2.3%
Other values (63) 101
58.7%
Space Separator
ValueCountFrequency (%)
  1
50.0%
1
50.0%
Close Punctuation
ValueCountFrequency (%)
) 13
100.0%
Open Punctuation
ValueCountFrequency (%)
( 13
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 5
100.0%
Control
ValueCountFrequency (%)
3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 177
85.1%
Common 31
 
14.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 14
 
7.9%
성 10
 
5.6%
홍 10
 
5.6%
물 8
 
4.5%
카 6
 
3.4%
스 5
 
2.8%
㈜ 5
 
2.8%
화 5
 
2.8%
렉 5
 
2.8%
영 4
 
2.3%
Other values (64) 105
59.3%
Common
ValueCountFrequency (%)
) 13
41.9%
( 13
41.9%
3
 
9.7%
  1
 
3.2%
1
 
3.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 172
82.7%
ASCII 30
 
14.4%
None 6
 
2.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 14
 
8.1%
성 10
 
5.8%
홍 10
 
5.8%
물 8
 
4.7%
카 6
 
3.5%
스 5
 
2.9%
화 5
 
2.9%
렉 5
 
2.9%
영 4
 
2.3%
일 4
 
2.3%
Other values (63) 101
58.7%
ASCII
ValueCountFrequency (%)
) 13
43.3%
( 13
43.3%
3
 
10.0%
1
 
3.3%
None
ValueCountFrequency (%)
㈜ 5
83.3%
  1
 
16.7%

대표자
Text

UNIQUE 

Distinct29
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size364.0 B
2023-12-12T10:19:16.029964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9655172
Min length2

Characters and Unicode

Total characters86
Distinct characters54
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

Unique29 ?
Unique (%)100.0%

Sample

1st row김기범
2nd row이철우
3rd row신동균
4th row임은숙
5th row한정윤
ValueCountFrequency (%)
김기범 1
 
3.4%
주정현 1
 
3.4%
신종식 1
 
3.4%
신동영 1
 
3.4%
최영 1
 
3.4%
배희숙 1
 
3.4%
박병휘 1
 
3.4%
김재유 1
 
3.4%
황윤성 1
 
3.4%
곽영수 1
 
3.4%
Other values (19) 19
65.5%
2023-12-12T10:19:16.452356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
김 6
 
7.0%
신 4
 
4.7%
최 4
 
4.7%
윤 3
 
3.5%
박 3
 
3.5%
동 3
 
3.5%
영 3
 
3.5%
정 3
 
3.5%
재 2
 
2.3%
배 2
 
2.3%
Other values (44) 53
61.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 86
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
김 6
 
7.0%
신 4
 
4.7%
최 4
 
4.7%
윤 3
 
3.5%
박 3
 
3.5%
동 3
 
3.5%
영 3
 
3.5%
정 3
 
3.5%
재 2
 
2.3%
배 2
 
2.3%
Other values (44) 53
61.6%

Most occurring scripts

ValueCountFrequency (%)
Hangul 86
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
김 6
 
7.0%
신 4
 
4.7%
최 4
 
4.7%
윤 3
 
3.5%
박 3
 
3.5%
동 3
 
3.5%
영 3
 
3.5%
정 3
 
3.5%
재 2
 
2.3%
배 2
 
2.3%
Other values (44) 53
61.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 86
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
김 6
 
7.0%
신 4
 
4.7%
최 4
 
4.7%
윤 3
 
3.5%
박 3
 
3.5%
동 3
 
3.5%
영 3
 
3.5%
정 3
 
3.5%
재 2
 
2.3%
배 2
 
2.3%
Other values (44) 53
61.6%

주    소
Text

Distinct27
Distinct (%)93.1%
Missing0
Missing (%)0.0%
Memory size364.0 B
2023-12-12T10:19:16.713473image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length19
Mean length14.37931
Min length9

Characters and Unicode

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

Unique

Unique26 ?
Unique (%)89.7%

Sample

1st row홍성군 갈산면 수덕사로 317번길 137-42
2nd row광천읍 광천로 292
3rd row금마면 충서로 1913
4th row금마면 충서로 1913
5th row금마면 충서로 1913
ValueCountFrequency (%)
금마면 9
 
10.3%
홍성읍 8
 
9.2%
충서로 5
 
5.7%
홍성군 5
 
5.7%
1913 4
 
4.6%
홍성 3
 
3.4%
광천읍 3
 
3.4%
갈산면 2
 
2.3%
조양로 2
 
2.3%
홍북면 2
 
2.3%
Other values (44) 44
50.6%
2023-12-12T10:19:17.169379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
58
 
13.9%
1 24
 
5.8%
3 21
 
5.0%
2 21
 
5.0%
홍 20
 
4.8%
로 19
 
4.6%
성 17
 
4.1%
면 16
 
3.8%
- 13
 
3.1%
서 12
 
2.9%
Other values (59) 196
47.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 221
53.0%
Decimal Number 122
29.3%
Space Separator 58
 
13.9%
Dash Punctuation 13
 
3.1%
Control 1
 
0.2%
Open Punctuation 1
 
0.2%
Close Punctuation 1
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
홍 20
 
9.0%
로 19
 
8.6%
성 17
 
7.7%
면 16
 
7.2%
서 12
 
5.4%
금 11
 
5.0%
마 11
 
5.0%
읍 11
 
5.0%
길 9
 
4.1%
충 9
 
4.1%
Other values (44) 86
38.9%
Decimal Number
ValueCountFrequency (%)
1 24
19.7%
3 21
17.2%
2 21
17.2%
9 10
8.2%
5 9
 
7.4%
7 9
 
7.4%
4 9
 
7.4%
0 7
 
5.7%
6 6
 
4.9%
8 6
 
4.9%
Space Separator
ValueCountFrequency (%)
58
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Control
ValueCountFrequency (%)
1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 221
53.0%
Common 196
47.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
홍 20
 
9.0%
로 19
 
8.6%
성 17
 
7.7%
면 16
 
7.2%
서 12
 
5.4%
금 11
 
5.0%
마 11
 
5.0%
읍 11
 
5.0%
길 9
 
4.1%
충 9
 
4.1%
Other values (44) 86
38.9%
Common
ValueCountFrequency (%)
58
29.6%
1 24
12.2%
3 21
 
10.7%
2 21
 
10.7%
- 13
 
6.6%
9 10
 
5.1%
5 9
 
4.6%
7 9
 
4.6%
4 9
 
4.6%
0 7
 
3.6%
Other values (5) 15
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 221
53.0%
ASCII 196
47.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
58
29.6%
1 24
12.2%
3 21
 
10.7%
2 21
 
10.7%
- 13
 
6.6%
9 10
 
5.1%
5 9
 
4.6%
7 9
 
4.6%
4 9
 
4.6%
0 7
 
3.6%
Other values (5) 15
 
7.7%
Hangul
ValueCountFrequency (%)
홍 20
 
9.0%
로 19
 
8.6%
성 17
 
7.7%
면 16
 
7.2%
서 12
 
5.4%
금 11
 
5.0%
마 11
 
5.0%
읍 11
 
5.0%
길 9
 
4.1%
충 9
 
4.1%
Other values (44) 86
38.9%

전화번호
Text

MISSING 

Distinct21
Distinct (%)87.5%
Missing5
Missing (%)17.2%
Memory size364.0 B
2023-12-12T10:19:17.412074image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length8
Mean length8.6666667
Min length8

Characters and Unicode

Total characters208
Distinct characters16
Distinct categories5 ?
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 (%)79.2%

Sample

1st row02-2068-3796
2nd row641-2103
3rd row633-2424
4th row632-1632
5th row632-1632
ValueCountFrequency (%)
633-2424 3
 
12.5%
632-1632 2
 
8.3%
632-3366 1
 
4.2%
02-2068-3796 1
 
4.2%
641-8390 1
 
4.2%
632-6464 1
 
4.2%
641-4686 1
 
4.2%
632-6757 1
 
4.2%
02-777-0961 1
 
4.2%
632-2964 1
 
4.2%
Other values (11) 11
45.8%
2023-12-12T10:19:17.719824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6 41
19.7%
3 37
17.8%
- 27
13.0%
2 25
12.0%
4 18
8.7%
1 17
8.2%
0 11
 
5.3%
7 10
 
4.8%
8 9
 
4.3%
9 7
 
3.4%
Other values (6) 6
 
2.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 176
84.6%
Dash Punctuation 27
 
13.0%
Other Letter 3
 
1.4%
Open Punctuation 1
 
0.5%
Close Punctuation 1
 
0.5%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
6 41
23.3%
3 37
21.0%
2 25
14.2%
4 18
10.2%
1 17
9.7%
0 11
 
6.2%
7 10
 
5.7%
8 9
 
5.1%
9 7
 
4.0%
5 1
 
0.6%
Other Letter
ValueCountFrequency (%)
영 1
33.3%
업 1
33.3%
소 1
33.3%
Dash Punctuation
ValueCountFrequency (%)
- 27
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 205
98.6%
Hangul 3
 
1.4%

Most frequent character per script

Common
ValueCountFrequency (%)
6 41
20.0%
3 37
18.0%
- 27
13.2%
2 25
12.2%
4 18
8.8%
1 17
8.3%
0 11
 
5.4%
7 10
 
4.9%
8 9
 
4.4%
9 7
 
3.4%
Other values (3) 3
 
1.5%
Hangul
ValueCountFrequency (%)
영 1
33.3%
업 1
33.3%
소 1
33.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 205
98.6%
Hangul 3
 
1.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6 41
20.0%
3 37
18.0%
- 27
13.2%
2 25
12.2%
4 18
8.8%
1 17
8.3%
0 11
 
5.4%
7 10
 
4.9%
8 9
 
4.4%
9 7
 
3.4%
Other values (3) 3
 
1.5%
Hangul
ValueCountFrequency (%)
영 1
33.3%
업 1
33.3%
소 1
33.3%

Correlations

2023-12-12T10:19:17.832469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분상호대표자주    소전화번호
구분1.0001.0001.0001.0001.000
상호1.0001.0001.0001.0001.000
대표자1.0001.0001.0001.0001.000
주    소1.0001.0001.0001.0000.990
전화번호1.0001.0001.0000.9901.000

Missing values

2023-12-12T10:19:14.694133image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T10:19:14.818590image/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일반화물광일화물자동차(주)김기범홍성군 갈산면 수덕사로 317번길 137-4202-2068-3796
1일반화물광천화물자동차㈜이철우광천읍 광천로 292641-2103
2일반화물홍성운수(주)신동균금마면 충서로 1913633-2424
3일반화물홍주운수(주)임은숙금마면 충서로 1913632-1632
4일반화물(주)길가온한정윤금마면 충서로 1913632-1632
5일반화물경일화물(주)최일운홍성읍 조양로 209641-3131
6일반화물(주)제일물류김창규홍성읍 홍성천길278632-1710
7일반화물(주)한양물류송요섭홍성읍 월산리 법원로 19 (우일빙딩 5층)(영업소)032-763-1011
8일반화물우리익스프레스김용성홍성읍 백월로52-15634-6618
9일반화물부성통상(주)이정민금마면 신곡리 380-2633-2424
구분상호대표자주    소전화번호
19일반화물동아운수㈜ 홍성영업소전유호서부면 서부서길7602-777-0961
20일반화물(주)대유  홍성영업소곽영수홍성읍 고암리 325-2632-6757
21일반화물내포렉카황윤성금마면 화양리328-12번지25통633-2424
22일반화물(주)성룡김재유홍성군 은하면 충서로77641-4686
23일반화물제일익스프레스박병휘홍성군 홍성읍 조양로 143번길 43-8<NA>
24일반화물㈜에이치더블유로지스배희숙홍성군 금마면 가산리 474-9<NA>
25일반화물㈜태영환경최영홍성 금마 금마로516번길 52<NA>
26일반화물청석산업㈜신동영홍성 홍성 충서로 1913<NA>
27개별화물개별화물홍성지회신종식홍성읍 도청대로3632-6464
28용달화물용달화물홍성지회최문수광천읍 광천로359번길21-24632-2703