Overview

Dataset statistics

Number of variables5
Number of observations355
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory14.3 KiB
Average record size in memory41.4 B

Variable types

Numeric1
Categorical2
Text1
DateTime1

Dataset

Description광주광역시 각화동농산물도매시장에서 제공하는 중도매인 등록현황 자료로 도매법인, 거래품목, 상호, 허가일자 데이터를 제공합니다.
Author광주광역시
URLhttps://www.data.go.kr/data/15080668/fileData.do

Alerts

연번 is highly overall correlated with 도매법인High correlation
도매법인 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-30 07:47:48.743234
Analysis finished2024-03-30 07:47:49.880936
Duration1.14 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct355
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean178
Minimum1
Maximum355
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.2 KiB
2024-03-30T07:47:50.108898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile18.7
Q189.5
median178
Q3266.5
95-th percentile337.3
Maximum355
Range354
Interquartile range (IQR)177

Descriptive statistics

Standard deviation102.62391
Coefficient of variation (CV)0.57653881
Kurtosis-1.2
Mean178
Median Absolute Deviation (MAD)89
Skewness0
Sum63190
Variance10531.667
MonotonicityStrictly increasing
2024-03-30T07:47:50.744060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.3%
224 1
 
0.3%
244 1
 
0.3%
243 1
 
0.3%
242 1
 
0.3%
241 1
 
0.3%
240 1
 
0.3%
239 1
 
0.3%
238 1
 
0.3%
237 1
 
0.3%
Other values (345) 345
97.2%
ValueCountFrequency (%)
1 1
0.3%
2 1
0.3%
3 1
0.3%
4 1
0.3%
5 1
0.3%
6 1
0.3%
7 1
0.3%
8 1
0.3%
9 1
0.3%
10 1
0.3%
ValueCountFrequency (%)
355 1
0.3%
354 1
0.3%
353 1
0.3%
352 1
0.3%
351 1
0.3%
350 1
0.3%
349 1
0.3%
348 1
0.3%
347 1
0.3%
346 1
0.3%

도매법인
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
광주원협
154 
중앙청과
121 
광주청과
80 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광주원협
2nd row광주원협
3rd row광주원협
4th row광주원협
5th row광주원협

Common Values

ValueCountFrequency (%)
광주원협 154
43.4%
중앙청과 121
34.1%
광주청과 80
22.5%

Length

2024-03-30T07:47:51.266771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-30T07:47:51.814330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주원협 154
43.4%
중앙청과 121
34.1%
광주청과 80
22.5%

거래품목
Categorical

Distinct2
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
채소
229 
과일
126 

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 (%)
채소 229
64.5%
과일 126
35.5%

Length

2024-03-30T07:47:52.361832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-30T07:47:52.740268image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
채소 229
64.5%
과일 126
35.5%

상호
Text

Distinct253
Distinct (%)71.3%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
2024-03-30T07:47:53.843396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length4
Median length3
Mean length2.7690141
Min length1

Characters and Unicode

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

Unique

Unique169 ?
Unique (%)47.6%

Sample

1st row19
2nd row78
3rd row241
4th row199
5th row170
ValueCountFrequency (%)
133 3
 
0.8%
29 3
 
0.8%
127 3
 
0.8%
180 3
 
0.8%
175 3
 
0.8%
176 3
 
0.8%
100 3
 
0.8%
182 3
 
0.8%
11 3
 
0.8%
185 3
 
0.8%
Other values (243) 325
91.5%
2024-03-30T07:47:55.264421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 234
23.8%
2 141
14.3%
0 94
9.6%
3 77
 
7.8%
7 75
 
7.6%
5 71
 
7.2%
8 65
 
6.6%
4 58
 
5.9%
9 57
 
5.8%
6 55
 
5.6%
Other values (6) 56
 
5.7%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 927
94.3%
Other Letter 56
 
5.7%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 234
25.2%
2 141
15.2%
0 94
10.1%
3 77
 
8.3%
7 75
 
8.1%
5 71
 
7.7%
8 65
 
7.0%
4 58
 
6.3%
9 57
 
6.1%
6 55
 
5.9%
Other Letter
ValueCountFrequency (%)
호 50
89.3%
번 2
 
3.6%
백 1
 
1.8%
두 1
 
1.8%
농 1
 
1.8%
산 1
 
1.8%

Most occurring scripts

ValueCountFrequency (%)
Common 927
94.3%
Hangul 56
 
5.7%

Most frequent character per script

Common
ValueCountFrequency (%)
1 234
25.2%
2 141
15.2%
0 94
10.1%
3 77
 
8.3%
7 75
 
8.1%
5 71
 
7.7%
8 65
 
7.0%
4 58
 
6.3%
9 57
 
6.1%
6 55
 
5.9%
Hangul
ValueCountFrequency (%)
호 50
89.3%
번 2
 
3.6%
백 1
 
1.8%
두 1
 
1.8%
농 1
 
1.8%
산 1
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 927
94.3%
Hangul 56
 
5.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 234
25.2%
2 141
15.2%
0 94
10.1%
3 77
 
8.3%
7 75
 
8.1%
5 71
 
7.7%
8 65
 
7.0%
4 58
 
6.3%
9 57
 
6.1%
6 55
 
5.9%
Hangul
ValueCountFrequency (%)
호 50
89.3%
번 2
 
3.6%
백 1
 
1.8%
두 1
 
1.8%
농 1
 
1.8%
산 1
 
1.8%

허가일자
Date

Distinct245
Distinct (%)69.0%
Missing0
Missing (%)0.0%
Memory size2.9 KiB
Minimum2019-03-18 00:00:00
Maximum2024-03-28 00:00:00
2024-03-30T07:47:55.797782image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-30T07:47:56.509471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-03-30T07:47:48.979219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-30T07:47:56.863354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번도매법인거래품목
연번1.0000.8570.264
도매법인0.8571.0000.097
거래품목0.2640.0971.000
2024-03-30T07:47:57.095378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
거래품목도매법인
거래품목1.0000.160
도매법인0.1601.000
2024-03-30T07:47:57.340983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번도매법인거래품목
연번1.0000.7720.200
도매법인0.7721.0000.160
거래품목0.2000.1601.000

Missing values

2024-03-30T07:47:49.331702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-30T07:47:49.731224image/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광주원협과일192024-03-24
12광주원협채소782024-03-10
23광주원협채소2412020-05-26
34광주원협과일1992022-07-31
45광주원협채소1702024-03-18
56광주원협과일1352021-08-26
67광주원협과일282023-05-21
78광주원협과일222024-03-20
89광주원협과일1882023-08-24
910광주원협과일82020-09-30
연번도매법인거래품목상호허가일자
345346광주원협채소1582023-12-08
346347광주원협과일722023-12-21
347348광주청과채소131호2023-12-27
348349광주청과채소1912023-12-27
349350광주청과채소2292024-01-12
350351광주원협채소2392024-03-09
351352중앙청과채소290호2021-06-07
352353중앙청과채소134호2021-07-05
353354중앙청과채소500호2021-09-10
354355중앙청과과일88호2021-12-27