Overview

Dataset statistics

Number of variables4
Number of observations373
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.8 KiB
Average record size in memory32.4 B

Variable types

Text1
DateTime1
Categorical2

Dataset

Description2023년도 광주광역시 서무농수산물도매시장의 중도매인자료를 제공합니다.(제공데이터 : 상호명, 허가일자, 법인명 등)
Author광주광역시
URLhttps://www.data.go.kr/data/15069509/fileData.do

Alerts

구분 is highly imbalanced (63.7%)Imbalance

Reproduction

Analysis started2023-12-12 15:14:42.466936
Analysis finished2023-12-12 15:14:42.813039
Duration0.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호명
Text

Distinct369
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
2023-12-13T00:14:43.125738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length21
Mean length6.7131367
Min length2

Characters and Unicode

Total characters2504
Distinct characters116
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

Unique365 ?
Unique (%)97.9%

Sample

1st row두레65
2nd row농협68번
3rd row농협71번
4th row농협80
5th row농협88번
ValueCountFrequency (%)
두레 2
 
0.4%
호남525 2
 
0.4%
농협199 2
 
0.4%
부흥상회 2
 
0.4%
농협97 2
 
0.4%
두레17 2
 
0.4%
두레300 1
 
0.2%
호남52농협 1
 
0.2%
두레110 1
 
0.2%
농협32 1
 
0.2%
Other values (429) 429
96.4%
2023-12-13T00:14:43.686343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
393
15.7%
1 225
 
9.0%
협 151
 
6.0%
남 139
 
5.6%
호 138
 
5.5%
농 123
 
4.9%
2 105
 
4.2%
5 104
 
4.2%
두 102
 
4.1%
레 102
 
4.1%
Other values (106) 922
36.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1132
45.2%
Decimal Number 966
38.6%
Space Separator 393
 
15.7%
Close Punctuation 6
 
0.2%
Open Punctuation 4
 
0.2%
Other Symbol 3
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
협 151
13.3%
남 139
12.3%
호 138
12.2%
농 123
10.9%
두 102
9.0%
레 102
9.0%
수 64
 
5.7%
산 36
 
3.2%
번 29
 
2.6%
회 29
 
2.6%
Other values (92) 219
19.3%
Decimal Number
ValueCountFrequency (%)
1 225
23.3%
2 105
10.9%
5 104
10.8%
7 97
10.0%
0 88
 
9.1%
3 85
 
8.8%
9 77
 
8.0%
6 70
 
7.2%
8 68
 
7.0%
4 47
 
4.9%
Space Separator
ValueCountFrequency (%)
393
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1369
54.7%
Hangul 1135
45.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
협 151
13.3%
남 139
12.2%
호 138
12.2%
농 123
10.8%
두 102
9.0%
레 102
9.0%
수 64
 
5.6%
산 36
 
3.2%
번 29
 
2.6%
회 29
 
2.6%
Other values (93) 222
19.6%
Common
ValueCountFrequency (%)
393
28.7%
1 225
16.4%
2 105
 
7.7%
5 104
 
7.6%
7 97
 
7.1%
0 88
 
6.4%
3 85
 
6.2%
9 77
 
5.6%
6 70
 
5.1%
8 68
 
5.0%
Other values (3) 57
 
4.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1369
54.7%
Hangul 1132
45.2%
None 3
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
393
28.7%
1 225
16.4%
2 105
 
7.7%
5 104
 
7.6%
7 97
 
7.1%
0 88
 
6.4%
3 85
 
6.2%
9 77
 
5.6%
6 70
 
5.1%
8 68
 
5.0%
Other values (3) 57
 
4.2%
Hangul
ValueCountFrequency (%)
협 151
13.3%
남 139
12.3%
호 138
12.2%
농 123
10.9%
두 102
9.0%
레 102
9.0%
수 64
 
5.7%
산 36
 
3.2%
번 29
 
2.6%
회 29
 
2.6%
Other values (92) 219
19.3%
None
ValueCountFrequency (%)
㈜ 3
100.0%

허가일자
Date

Distinct170
Distinct (%)45.6%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
Minimum2018-10-21 00:00:00
Maximum2023-10-31 00:00:00
2023-12-13T00:14:43.868695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T00:14:44.045961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

구분
Categorical

IMBALANCE 

Distinct5
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
영업중
301 
신규
63 
휴업
 
6
수입
 
2
재개
 
1

Length

Max length3
Median length3
Mean length2.8069705
Min length2

Unique

Unique1 ?
Unique (%)0.3%

Sample

1st row영업중
2nd row영업중
3rd row영업중
4th row영업중
5th row영업중

Common Values

ValueCountFrequency (%)
영업중 301
80.7%
신규 63
 
16.9%
휴업 6
 
1.6%
수입 2
 
0.5%
재개 1
 
0.3%

Length

2023-12-13T00:14:44.191705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:14:44.319824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
영업중 301
80.7%
신규 63
 
16.9%
휴업 6
 
1.6%
수입 2
 
0.5%
재개 1
 
0.3%

법인명
Categorical

Distinct7
Distinct (%)1.9%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
호남 채소
67 
농협 채소
65 
호남 과일
61 
두레 과일
58 
농협 과일
47 
Other values (2)
75 

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 (%)
호남 채소 67
18.0%
농협 채소 65
17.4%
호남 과일 61
16.4%
두레 과일 58
15.5%
농협 과일 47
12.6%
두레 채소 40
10.7%
수협 수산 35
9.4%

Length

2023-12-13T00:14:44.476824image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T00:14:44.628411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
채소 172
23.1%
과일 166
22.3%
호남 128
17.2%
농협 112
15.0%
두레 98
13.1%
수협 35
 
4.7%
수산 35
 
4.7%

Correlations

2023-12-13T00:14:44.725965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분법인명
구분1.0000.118
법인명0.1181.000
2023-12-13T00:14:44.809901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분법인명
구분1.0000.075
법인명0.0751.000
2023-12-13T00:14:44.908929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분법인명
구분1.0000.075
법인명0.0751.000

Missing values

2023-12-13T00:14:42.691496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T00:14:42.778541image/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두레652019-02-26영업중두레 과일
1농협68번2019-02-26영업중농협 과일
2농협71번2019-02-26영업중농협 과일
3농협802019-02-26영업중농협 과일
4농협88번2019-02-26영업중농협 과일
5농협2번2019-02-26영업중농협 과일
6농협9번2019-02-26영업중농협 과일
7농협21번2022-02-23영업중농협 과일
8농협55번2019-02-26영업중농협 과일
9농협22번2019-02-26영업중농협 과일
상호명허가일자구분법인명
363호남5302023-05-30신규호남 과일
364호남7342023-06-09신규호남 과일
365농협1892023-06-26신규농협 과일
366농협1382023-07-10신규농협 채소
367수협215 완진수산2023-07-28신규수협 수산
368두레472023-07-28신규두레 과일
369농협972023-08-03신규농협 과일
370농협992023-08-07신규농협 과일
371두레172023-09-13신규두레 과일
372다옴유통2023-10-11신규농협 과일