Overview

Dataset statistics

Number of variables5
Number of observations38
Missing cells10
Missing cells (%)5.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.6 KiB
Average record size in memory43.5 B

Variable types

Categorical1
Text3
DateTime1

Dataset

Description제주특별자치도 제주시 식품관련업 관련 관내 식품 운반업 현황 데이터입니다.
Author제주특별자치도 제주시
URLhttps://www.data.go.kr/data/15056166/fileData.do

Alerts

업종명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
전화번호 has 10 (26.3%) missing valuesMissing
업소명 has unique valuesUnique

Reproduction

Analysis started2023-12-12 22:21:06.457651
Analysis finished2023-12-12 22:21:06.790192
Duration0.33 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

업종명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size436.0 B
식품운반업
38 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row식품운반업
2nd row식품운반업
3rd row식품운반업
4th row식품운반업
5th row식품운반업

Common Values

ValueCountFrequency (%)
식품운반업 38
100.0%

Length

2023-12-13T07:21:06.845500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T07:21:06.929605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
식품운반업 38
100.0%

업소명
Text

UNIQUE 

Distinct38
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size436.0 B
2023-12-13T07:21:07.087204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length10.5
Mean length8.3157895
Min length4

Characters and Unicode

Total characters316
Distinct characters90
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

Unique38 ?
Unique (%)100.0%

Sample

1st row(유)제주종합식품
2nd row한국종합물류
3rd row(주)제주냉동물류
4th row주식회사 대명해운항공물류
5th row주)제양항공해운
ValueCountFrequency (%)
주식회사 4
 
9.3%
유)제주종합식품 1
 
2.3%
주)풍인해운 1
 
2.3%
영원물류주식회사 1
 
2.3%
대제유통 1
 
2.3%
주식회사제주새마을해운물류 1
 
2.3%
주)국제냉동수산 1
 
2.3%
주)대표로지스틱스 1
 
2.3%
주)제주삼다로지스틱스 1
 
2.3%
주)제주로지스틱스 1
 
2.3%
Other values (30) 30
69.8%
2023-12-13T07:21:07.384203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
주 42
 
13.3%
제 24
 
7.6%
) 18
 
5.7%
( 17
 
5.4%
물 11
 
3.5%
류 10
 
3.2%
스 9
 
2.8%
사 9
 
2.8%
회 9
 
2.8%
식 9
 
2.8%
Other values (80) 158
50.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 272
86.1%
Close Punctuation 18
 
5.7%
Open Punctuation 17
 
5.4%
Space Separator 5
 
1.6%
Decimal Number 4
 
1.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 42
 
15.4%
제 24
 
8.8%
물 11
 
4.0%
류 10
 
3.7%
스 9
 
3.3%
사 9
 
3.3%
회 9
 
3.3%
식 9
 
3.3%
유 7
 
2.6%
운 6
 
2.2%
Other values (74) 136
50.0%
Decimal Number
ValueCountFrequency (%)
6 2
50.0%
3 1
25.0%
7 1
25.0%
Close Punctuation
ValueCountFrequency (%)
) 18
100.0%
Open Punctuation
ValueCountFrequency (%)
( 17
100.0%
Space Separator
ValueCountFrequency (%)
5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 272
86.1%
Common 44
 
13.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 42
 
15.4%
제 24
 
8.8%
물 11
 
4.0%
류 10
 
3.7%
스 9
 
3.3%
사 9
 
3.3%
회 9
 
3.3%
식 9
 
3.3%
유 7
 
2.6%
운 6
 
2.2%
Other values (74) 136
50.0%
Common
ValueCountFrequency (%)
) 18
40.9%
( 17
38.6%
5
 
11.4%
6 2
 
4.5%
3 1
 
2.3%
7 1
 
2.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 272
86.1%
ASCII 44
 
13.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
주 42
 
15.4%
제 24
 
8.8%
물 11
 
4.0%
류 10
 
3.7%
스 9
 
3.3%
사 9
 
3.3%
회 9
 
3.3%
식 9
 
3.3%
유 7
 
2.6%
운 6
 
2.2%
Other values (74) 136
50.0%
ASCII
ValueCountFrequency (%)
) 18
40.9%
( 17
38.6%
5
 
11.4%
6 2
 
4.5%
3 1
 
2.3%
7 1
 
2.3%

소재지
Text

Distinct34
Distinct (%)89.5%
Missing0
Missing (%)0.0%
Memory size436.0 B
2023-12-13T07:21:07.608939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length20.5
Min length18

Characters and Unicode

Total characters779
Distinct characters74
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

Unique32 ?
Unique (%)84.2%

Sample

1st row제주특별자치도 제주시 연미길 100
2nd row제주특별자치도 제주시 임항로 238
3rd row제주특별자치도 제주시 한림읍 한림중앙로 62
4th row제주특별자치도 제주시 애월읍 광성로 166
5th row제주특별자치도 제주시 우정로8길 28
ValueCountFrequency (%)
제주특별자치도 38
23.9%
제주시 38
23.9%
번영로 5
 
3.1%
한림읍 4
 
2.5%
345 4
 
2.5%
일주동로 3
 
1.9%
한림중앙로 2
 
1.3%
62 2
 
1.3%
임항로 2
 
1.3%
9 2
 
1.3%
Other values (57) 59
37.1%
2023-12-13T07:21:07.956780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
134
17.2%
주 79
 
10.1%
제 77
 
9.9%
도 41
 
5.3%
치 38
 
4.9%
시 38
 
4.9%
자 38
 
4.9%
별 38
 
4.9%
특 38
 
4.9%
로 28
 
3.6%
Other values (64) 230
29.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 535
68.7%
Space Separator 134
 
17.2%
Decimal Number 106
 
13.6%
Dash Punctuation 4
 
0.5%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 79
14.8%
제 77
14.4%
도 41
 
7.7%
치 38
 
7.1%
시 38
 
7.1%
자 38
 
7.1%
별 38
 
7.1%
특 38
 
7.1%
로 28
 
5.2%
길 16
 
3.0%
Other values (52) 104
19.4%
Decimal Number
ValueCountFrequency (%)
4 16
15.1%
2 16
15.1%
1 15
14.2%
3 13
12.3%
6 10
9.4%
7 9
8.5%
8 8
7.5%
5 8
7.5%
0 7
6.6%
9 4
 
3.8%
Space Separator
ValueCountFrequency (%)
134
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 535
68.7%
Common 244
31.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 79
14.8%
제 77
14.4%
도 41
 
7.7%
치 38
 
7.1%
시 38
 
7.1%
자 38
 
7.1%
별 38
 
7.1%
특 38
 
7.1%
로 28
 
5.2%
길 16
 
3.0%
Other values (52) 104
19.4%
Common
ValueCountFrequency (%)
134
54.9%
4 16
 
6.6%
2 16
 
6.6%
1 15
 
6.1%
3 13
 
5.3%
6 10
 
4.1%
7 9
 
3.7%
8 8
 
3.3%
5 8
 
3.3%
0 7
 
2.9%
Other values (2) 8
 
3.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 535
68.7%
ASCII 244
31.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
134
54.9%
4 16
 
6.6%
2 16
 
6.6%
1 15
 
6.1%
3 13
 
5.3%
6 10
 
4.1%
7 9
 
3.7%
8 8
 
3.3%
5 8
 
3.3%
0 7
 
2.9%
Other values (2) 8
 
3.3%
Hangul
ValueCountFrequency (%)
주 79
14.8%
제 77
14.4%
도 41
 
7.7%
치 38
 
7.1%
시 38
 
7.1%
자 38
 
7.1%
별 38
 
7.1%
특 38
 
7.1%
로 28
 
5.2%
길 16
 
3.0%
Other values (52) 104
19.4%

전화번호
Text

MISSING 

Distinct27
Distinct (%)96.4%
Missing10
Missing (%)26.3%
Memory size436.0 B
2023-12-13T07:21:08.142482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length12
Mean length12
Min length12

Characters and Unicode

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

Unique26 ?
Unique (%)92.9%

Sample

1st row064-752-2735
2nd row064-759-0602
3rd row064-796-9081
4th row064-713-8178
5th row064-755-7186
ValueCountFrequency (%)
064-796-9081 2
 
7.1%
067-773-0451 1
 
3.6%
064-752-2735 1
 
3.6%
064-756-3396 1
 
3.6%
064-712-0110 1
 
3.6%
064-758-2153 1
 
3.6%
064-758-2222 1
 
3.6%
064-742-7885 1
 
3.6%
064-747-5990 1
 
3.6%
064-723-6624 1
 
3.6%
Other values (17) 17
60.7%
2023-12-13T07:21:08.464684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
- 56
16.7%
0 44
13.1%
7 40
11.9%
6 39
11.6%
4 38
11.3%
5 25
7.4%
8 23
6.8%
2 23
6.8%
1 20
 
6.0%
9 16
 
4.8%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 280
83.3%
Dash Punctuation 56
 
16.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 44
15.7%
7 40
14.3%
6 39
13.9%
4 38
13.6%
5 25
8.9%
8 23
8.2%
2 23
8.2%
1 20
7.1%
9 16
 
5.7%
3 12
 
4.3%
Dash Punctuation
ValueCountFrequency (%)
- 56
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 336
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
- 56
16.7%
0 44
13.1%
7 40
11.9%
6 39
11.6%
4 38
11.3%
5 25
7.4%
8 23
6.8%
2 23
6.8%
1 20
 
6.0%
9 16
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 336
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
- 56
16.7%
0 44
13.1%
7 40
11.9%
6 39
11.6%
4 38
11.3%
5 25
7.4%
8 23
6.8%
2 23
6.8%
1 20
 
6.0%
9 16
 
4.8%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size436.0 B
Minimum2021-02-26 00:00:00
Maximum2021-02-26 00:00:00
2023-12-13T07:21:08.597488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T07:21:08.696833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Correlations

2023-12-13T07:21:08.767819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
업소명소재지전화번호
업소명1.0001.0001.000
소재지1.0001.0001.000
전화번호1.0001.0001.000

Missing values

2023-12-13T07:21:06.666777image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T07:21:06.755599image/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식품운반업(유)제주종합식품제주특별자치도 제주시 연미길 100064-752-27352021-02-26
1식품운반업한국종합물류제주특별자치도 제주시 임항로 238064-759-06022021-02-26
2식품운반업(주)제주냉동물류제주특별자치도 제주시 한림읍 한림중앙로 62064-796-90812021-02-26
3식품운반업주식회사 대명해운항공물류제주특별자치도 제주시 애월읍 광성로 166064-713-81782021-02-26
4식품운반업주)제양항공해운제주특별자치도 제주시 우정로8길 28064-755-71862021-02-26
5식품운반업(주)제주수복냉동물류제주특별자치도 제주시 번영로 345064-752-58702021-02-26
6식품운반업제주씨앤푸드제주특별자치도 제주시 원당로 31064-725-31862021-02-26
7식품운반업제주특판유통제주특별자치도 제주시 복지로 18-17064-744-85912021-02-26
8식품운반업제주우체국제주특별자치도 제주시 북성로 24064-759-59012021-02-26
9식품운반업씨제이 대한통운(주)제주특별자치도 제주시 연삼로 89064-757-12552021-02-26
업종명업소명소재지전화번호데이터기준일자
28식품운반업전국화물7663제주특별자치도 제주시 일주동로 417<NA>2021-02-26
29식품운반업수산대학제주특별자치도 제주시 용담로1길 9064-758-22222021-02-26
30식품운반업제주한라유통제주특별자치도 제주시 신설로7길 49064-758-21532021-02-26
31식품운반업제주진유통제주특별자치도 제주시 우정로4길 40<NA>2021-02-26
32식품운반업(주)제주중앙운수제주특별자치도 제주시 번영로 345<NA>2021-02-26
33식품운반업흥산오름주식회사제주특별자치도 제주시 번영로 345<NA>2021-02-26
34식품운반업(주)로지스제이비엘제주특별자치도 제주시 선반로6길 9<NA>2021-02-26
35식품운반업(주)제주화신물류제주특별자치도 제주시 한림읍 한림중앙로 62064-796-90812021-02-26
36식품운반업영원물류주식회사제주특별자치도 제주시 우정로 34064-712-01102021-02-26
37식품운반업유한회사제주초록푸드제주특별자치도 제주시 번영로 571064-725-33732021-02-26