Overview

Dataset statistics

Number of variables7
Number of observations101
Missing cells2
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.8 KiB
Average record size in memory59.3 B

Variable types

Numeric2
Categorical2
Text2
DateTime1

Dataset

Description전북특별자치도 시군별 쌀 가공업체 현황(시군명, 상호, 주소, 주생산품, 월사용능력(톤), 가공용쌀매입대상자 지정일)
Author전북특별자치도
URLhttps://www.data.go.kr/data/15055748/fileData.do

Alerts

연번 is highly overall correlated with 시군명High correlation
시군명 is highly overall correlated with 연번High correlation
월사용능력 (톤) has 2 (2.0%) missing valuesMissing
연번 has unique valuesUnique
상호 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2024-03-14 11:45:35.146769
Analysis finished2024-03-14 11:45:37.386416
Duration2.24 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct101
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean51
Minimum1
Maximum101
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2024-03-14T20:45:37.609291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6
Q126
median51
Q376
95-th percentile96
Maximum101
Range100
Interquartile range (IQR)50

Descriptive statistics

Standard deviation29.300171
Coefficient of variation (CV)0.57451315
Kurtosis-1.2
Mean51
Median Absolute Deviation (MAD)25
Skewness0
Sum5151
Variance858.5
MonotonicityStrictly increasing
2024-03-14T20:45:38.077569image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.0%
65 1
 
1.0%
75 1
 
1.0%
74 1
 
1.0%
73 1
 
1.0%
72 1
 
1.0%
71 1
 
1.0%
70 1
 
1.0%
69 1
 
1.0%
68 1
 
1.0%
Other values (91) 91
90.1%
ValueCountFrequency (%)
1 1
1.0%
2 1
1.0%
3 1
1.0%
4 1
1.0%
5 1
1.0%
6 1
1.0%
7 1
1.0%
8 1
1.0%
9 1
1.0%
10 1
1.0%
ValueCountFrequency (%)
101 1
1.0%
100 1
1.0%
99 1
1.0%
98 1
1.0%
97 1
1.0%
96 1
1.0%
95 1
1.0%
94 1
1.0%
93 1
1.0%
92 1
1.0%

시군명
Categorical

HIGH CORRELATION 

Distinct14
Distinct (%)13.9%
Missing0
Missing (%)0.0%
Memory size936.0 B
김제시청
15 
전주시청
15 
익산시청
12 
군산시청
11 
완주군청
11 
Other values (9)
37 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique2 ?
Unique (%)2.0%

Sample

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

Common Values

ValueCountFrequency (%)
김제시청 15
14.9%
전주시청 15
14.9%
익산시청 12
11.9%
군산시청 11
10.9%
완주군청 11
10.9%
정읍시청 7
6.9%
남원시청 6
 
5.9%
순창군청 6
 
5.9%
부안군청 5
 
5.0%
진안군청 5
 
5.0%
Other values (4) 8
7.9%

Length

2024-03-14T20:45:38.389831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
김제시청 15
14.9%
전주시청 15
14.9%
익산시청 12
11.9%
군산시청 11
10.9%
완주군청 11
10.9%
정읍시청 7
6.9%
남원시청 6
 
5.9%
순창군청 6
 
5.9%
부안군청 5
 
5.0%
진안군청 5
 
5.0%
Other values (4) 8
7.9%

상호
Text

UNIQUE 

Distinct101
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size936.0 B
2024-03-14T20:45:39.126041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length14
Mean length9.2079208
Min length2

Characters and Unicode

Total characters930
Distinct characters209
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

Unique101 ?
Unique (%)100.0%

Sample

1st row농업회사법인고은(유)
2nd row사임당푸드영농조합법인
3rd row선운산쌀과방영농조합법인
4th row롯데칠성음료(주)군산공장
5th row대광제면
ValueCountFrequency (%)
농업회사법인 8
 
6.4%
유한회사 5
 
4.0%
주식회사 3
 
2.4%
영농조합법인 2
 
1.6%
농업회사법인고은(유 1
 
0.8%
원광탁주 1
 
0.8%
미광식품 1
 
0.8%
한떡협전북전주시지부 1
 
0.8%
주)천본 1
 
0.8%
라이스영농조합법인 1
 
0.8%
Other values (101) 101
80.8%
2024-03-14T20:45:40.146090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
농 45
 
4.8%
사 41
 
4.4%
인 41
 
4.4%
주 40
 
4.3%
법 40
 
4.3%
회 36
 
3.9%
조 28
 
3.0%
) 25
 
2.7%
업 25
 
2.7%
( 25
 
2.7%
Other values (199) 584
62.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 856
92.0%
Close Punctuation 25
 
2.7%
Open Punctuation 25
 
2.7%
Space Separator 24
 
2.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
농 45
 
5.3%
사 41
 
4.8%
인 41
 
4.8%
주 40
 
4.7%
법 40
 
4.7%
회 36
 
4.2%
조 28
 
3.3%
업 25
 
2.9%
합 23
 
2.7%
식 22
 
2.6%
Other values (196) 515
60.2%
Close Punctuation
ValueCountFrequency (%)
) 25
100.0%
Open Punctuation
ValueCountFrequency (%)
( 25
100.0%
Space Separator
ValueCountFrequency (%)
24
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 856
92.0%
Common 74
 
8.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
농 45
 
5.3%
사 41
 
4.8%
인 41
 
4.8%
주 40
 
4.7%
법 40
 
4.7%
회 36
 
4.2%
조 28
 
3.3%
업 25
 
2.9%
합 23
 
2.7%
식 22
 
2.6%
Other values (196) 515
60.2%
Common
ValueCountFrequency (%)
) 25
33.8%
( 25
33.8%
24
32.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 856
92.0%
ASCII 74
 
8.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
농 45
 
5.3%
사 41
 
4.8%
인 41
 
4.8%
주 40
 
4.7%
법 40
 
4.7%
회 36
 
4.2%
조 28
 
3.3%
업 25
 
2.9%
합 23
 
2.7%
식 22
 
2.6%
Other values (196) 515
60.2%
ASCII
ValueCountFrequency (%)
) 25
33.8%
( 25
33.8%
24
32.4%

주소
Text

UNIQUE 

Distinct101
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size936.0 B
2024-03-14T20:45:40.909529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length49
Median length35
Mean length23.871287
Min length15

Characters and Unicode

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

Unique

Unique101 ?
Unique (%)100.0%

Sample

1st row전북 고창군 아산면 계산리 384 32
2nd row전북 고창군 고창읍 태봉로 551
3rd row전북 고창군 무장면 무장남북로 20 1 선운산쌀과방
4th row전북 군산시 소룡동 176 1
5th row전북 군산시 경암동 683 4
ValueCountFrequency (%)
전북 100
 
16.2%
1 18
 
2.9%
김제시 15
 
2.4%
전주시 15
 
2.4%
익산시 12
 
1.9%
완주군 11
 
1.8%
군산시 11
 
1.8%
덕진구 8
 
1.3%
2 7
 
1.1%
완산구 7
 
1.1%
Other values (320) 412
66.9%
2024-03-14T20:45:42.116501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
563
23.4%
전 120
 
5.0%
북 107
 
4.4%
1 101
 
4.2%
시 68
 
2.8%
2 68
 
2.8%
산 59
 
2.4%
3 51
 
2.1%
면 48
 
2.0%
리 46
 
1.9%
Other values (210) 1180
48.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1385
57.4%
Space Separator 563
23.4%
Decimal Number 428
 
17.8%
Open Punctuation 16
 
0.7%
Close Punctuation 16
 
0.7%
Uppercase Letter 2
 
0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 120
 
8.7%
북 107
 
7.7%
시 68
 
4.9%
산 59
 
4.3%
면 48
 
3.5%
리 46
 
3.3%
군 46
 
3.3%
동 44
 
3.2%
주 34
 
2.5%
길 28
 
2.0%
Other values (195) 785
56.7%
Decimal Number
ValueCountFrequency (%)
1 101
23.6%
2 68
15.9%
3 51
11.9%
7 39
 
9.1%
5 34
 
7.9%
4 33
 
7.7%
8 28
 
6.5%
6 27
 
6.3%
0 26
 
6.1%
9 21
 
4.9%
Space Separator
ValueCountFrequency (%)
563
100.0%
Open Punctuation
ValueCountFrequency (%)
( 16
100.0%
Close Punctuation
ValueCountFrequency (%)
) 16
100.0%
Uppercase Letter
ValueCountFrequency (%)
F 2
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1385
57.4%
Common 1024
42.5%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 120
 
8.7%
북 107
 
7.7%
시 68
 
4.9%
산 59
 
4.3%
면 48
 
3.5%
리 46
 
3.3%
군 46
 
3.3%
동 44
 
3.2%
주 34
 
2.5%
길 28
 
2.0%
Other values (195) 785
56.7%
Common
ValueCountFrequency (%)
563
55.0%
1 101
 
9.9%
2 68
 
6.6%
3 51
 
5.0%
7 39
 
3.8%
5 34
 
3.3%
4 33
 
3.2%
8 28
 
2.7%
6 27
 
2.6%
0 26
 
2.5%
Other values (4) 54
 
5.3%
Latin
ValueCountFrequency (%)
F 2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1385
57.4%
ASCII 1026
42.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
563
54.9%
1 101
 
9.8%
2 68
 
6.6%
3 51
 
5.0%
7 39
 
3.8%
5 34
 
3.3%
4 33
 
3.2%
8 28
 
2.7%
6 27
 
2.6%
0 26
 
2.5%
Other values (5) 56
 
5.5%
Hangul
ValueCountFrequency (%)
전 120
 
8.7%
북 107
 
7.7%
시 68
 
4.9%
산 59
 
4.3%
면 48
 
3.5%
리 46
 
3.3%
군 46
 
3.3%
동 44
 
3.2%
주 34
 
2.5%
길 28
 
2.0%
Other values (195) 785
56.7%

주생산품
Categorical

Distinct9
Distinct (%)8.9%
Missing0
Missing (%)0.0%
Memory size936.0 B
누룽지
30 
떡류
29 
주류
21 
조미식품
7 
제과·제빵
4 
Other values (4)
10 

Length

Max length5
Median length2
Mean length2.7029703
Min length2

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row주류
2nd row떡류
3rd row제과·제빵
4th row주류
5th row떡류

Common Values

ValueCountFrequency (%)
누룽지 30
29.7%
떡류 29
28.7%
주류 21
20.8%
조미식품 7
 
6.9%
제과·제빵 4
 
4.0%
가공밥류 4
 
4.0%
쌀가루 3
 
3.0%
곡물가공 2
 
2.0%
음료 1
 
1.0%

Length

2024-03-14T20:45:42.547410image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T20:45:42.832371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
누룽지 30
29.7%
떡류 29
28.7%
주류 21
20.8%
조미식품 7
 
6.9%
제과·제빵 4
 
4.0%
가공밥류 4
 
4.0%
쌀가루 3
 
3.0%
곡물가공 2
 
2.0%
음료 1
 
1.0%

월사용능력 (톤)
Real number (ℝ)

MISSING 

Distinct37
Distinct (%)37.4%
Missing2
Missing (%)2.0%
Infinite0
Infinite (%)0.0%
Mean86.111111
Minimum2
Maximum1500
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2024-03-14T20:45:43.061109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile4
Q110
median20
Q340
95-th percentile410
Maximum1500
Range1498
Interquartile range (IQR)30

Descriptive statistics

Standard deviation228.7183
Coefficient of variation (CV)2.6560834
Kurtosis22.661172
Mean86.111111
Median Absolute Deviation (MAD)10
Skewness4.5919698
Sum8525
Variance52312.059
MonotonicityNot monotonic
2024-03-14T20:45:43.297648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
10 24
23.8%
20 8
 
7.9%
15 6
 
5.9%
40 5
 
5.0%
24 4
 
4.0%
30 4
 
4.0%
36 3
 
3.0%
50 3
 
3.0%
60 3
 
3.0%
9 2
 
2.0%
Other values (27) 37
36.6%
ValueCountFrequency (%)
2 2
 
2.0%
3 2
 
2.0%
4 2
 
2.0%
6 2
 
2.0%
8 2
 
2.0%
9 2
 
2.0%
10 24
23.8%
11 2
 
2.0%
12 1
 
1.0%
15 6
 
5.9%
ValueCountFrequency (%)
1500 1
1.0%
1232 1
1.0%
1000 1
1.0%
500 2
2.0%
400 1
1.0%
360 1
1.0%
300 1
1.0%
250 1
1.0%
160 1
1.0%
144 1
1.0%

가공용쌀매입대상자 지정일
Date

Distinct97
Distinct (%)96.0%
Missing0
Missing (%)0.0%
Memory size936.0 B
Minimum1991-01-18 00:00:00
Maximum2020-09-21 00:00:00
2024-03-14T20:45:43.619884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T20:45:43.885448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-03-14T20:45:36.246295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T20:45:35.751575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T20:45:36.497269image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T20:45:35.991185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T20:45:44.248719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번시군명주생산품월사용능력 (톤)가공용쌀매입대상자 지정일
연번1.0000.9380.3550.2000.989
시군명0.9381.0000.6120.0000.994
주생산품0.3550.6121.0000.6210.889
월사용능력 (톤)0.2000.0000.6211.0000.000
가공용쌀매입대상자 지정일0.9890.9940.8890.0001.000
2024-03-14T20:45:44.413476image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
주생산품시군명
주생산품1.0000.302
시군명0.3021.000
2024-03-14T20:45:44.554945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번월사용능력 (톤)시군명주생산품
연번1.000-0.0820.7370.171
월사용능력 (톤)-0.0821.0000.0000.384
시군명0.7370.0001.0000.302
주생산품0.1710.3840.3021.000

Missing values

2024-03-14T20:45:36.852371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T20:45:37.235114image/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고창군청농업회사법인고은(유)전북 고창군 아산면 계산리 384 32주류362013-03-28
12고창군청사임당푸드영농조합법인전북 고창군 고창읍 태봉로 551떡류102015-01-15
23고창군청선운산쌀과방영농조합법인전북 고창군 무장면 무장남북로 20 1 선운산쌀과방제과·제빵102017-11-22
34군산시청롯데칠성음료(주)군산공장전북 군산시 소룡동 176 1주류15001991-01-18
45군산시청대광제면전북 군산시 경암동 683 4떡류102000-06-27
56군산시청(주)대두식품전북 군산시 서수면 마룡리 93 19쌀가루5002005-05-12
67군산시청군산양조공사전북 군산시 옥산면 대위로 137주류222010-02-24
78군산시청농업회사법인주식회사백화전북 군산시 나포면 주곡리 677번지주류202010-07-14
89군산시청실로암식품전북 군산시 경암동 679 5 실로암식품누룽지152011-11-25
910군산시청옹고집영농조합법인전북 군산시 나포면 서왕길 34 (공장동)조미식품252012-09-18
연번시군명상호주소주생산품월사용능력 (톤)가공용쌀매입대상자 지정일
9192정읍시청마이코 인터내셔널(방아다리)전북 정읍시 감곡면 원삼1길 27 원삼1길 27누룽지102017-12-20
9293정읍시청작은농부이야기전북 정읍시 2산단5길 37 (하북동) 1동누룽지302018-01-22
9394정읍시청농부의선물전북 정읍시 소성면 등계리 1342 농부의선물누룽지302019-01-10
9495정읍시청농업회사법인주식회사 고부전북 정읍시 고부면 덕안리 957 고부쌀가루5002019-11-15
9596정읍시청농업회사법인 유한회사 일등라이스푸드전북 정읍시 감곡면 삼평리 609 12 일등라이스푸드떡류402020-07-15
9697진안군청매일제과산업(주)전북 진안군 진안읍 연장리 1066 7누룽지482005-04-30
9798진안군청진안홍삼주조장전북 진안군 거북바위로3길 20주류102008-06-16
9899진안군청성수주조장전북 진안군 성수면 외궁리 674 8주류102013-09-05
99100진안군청단양선교관선교식품전북 진안군 진안읍 반월리 1816제과·제빵102015-08-05
100101진안군청농업회사법인주식회사고원식품전북 진안군 진안읍 홍삼한방로 32떡류402017-03-29