Overview

Dataset statistics

Number of variables6
Number of observations29
Missing cells36
Missing cells (%)20.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.5 KiB
Average record size in memory53.6 B

Variable types

Unsupported4
Text2

Dataset

Description농산물산지유통센터현황20159
Author전라북도
URLhttps://www.bigdatahub.go.kr/opendata/dataSet/detail.nm?contentId=37&rlik=49451aebf056b486&serviceId=202552

Alerts

Unnamed: 0 has 29 (100.0%) missing valuesMissing
농산물 산지유통센터 현황(2015.9월) has 1 (3.4%) missing valuesMissing
Unnamed: 2 has 1 (3.4%) missing valuesMissing
Unnamed: 3 has 1 (3.4%) missing valuesMissing
Unnamed: 4 has 2 (6.9%) missing valuesMissing
Unnamed: 5 has 2 (6.9%) missing valuesMissing
Unnamed: 0 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 3 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 4 is an unsupported type, check if it needs cleaning or further analysisUnsupported
Unnamed: 5 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-03-14 01:28:35.169319
Analysis finished2024-03-14 01:28:35.545722
Duration0.38 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

Unnamed: 0
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing29
Missing (%)100.0%
Memory size393.0 B

농산물 산지유통센터 현황(2015.9월)
Text

MISSING 

Distinct28
Distinct (%)100.0%
Missing1
Missing (%)3.4%
Memory size364.0 B
2024-03-14T10:28:35.663411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length12
Median length11
Mean length6.1785714
Min length3

Characters and Unicode

Total characters173
Distinct characters72
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

Unique28 ?
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 1
 
3.4%
익산원협(1 1
 
3.4%
Other values (19) 19
65.5%
2024-03-14T10:28:35.959064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
협 20
 
11.6%
농 17
 
9.8%
) 10
 
5.8%
( 10
 
5.8%
주 6
 
3.5%
원 6
 
3.5%
군 5
 
2.9%
안 5
 
2.9%
산 4
 
2.3%
부 4
 
2.3%
Other values (62) 86
49.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 150
86.7%
Close Punctuation 10
 
5.8%
Open Punctuation 10
 
5.8%
Decimal Number 2
 
1.2%
Space Separator 1
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
협 20
 
13.3%
농 17
 
11.3%
주 6
 
4.0%
원 6
 
4.0%
군 5
 
3.3%
안 5
 
3.3%
산 4
 
2.7%
부 4
 
2.7%
유 3
 
2.0%
영 3
 
2.0%
Other values (58) 77
51.3%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Decimal Number
ValueCountFrequency (%)
1 2
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 150
86.7%
Common 23
 
13.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
협 20
 
13.3%
농 17
 
11.3%
주 6
 
4.0%
원 6
 
4.0%
군 5
 
3.3%
안 5
 
3.3%
산 4
 
2.7%
부 4
 
2.7%
유 3
 
2.0%
영 3
 
2.0%
Other values (58) 77
51.3%
Common
ValueCountFrequency (%)
) 10
43.5%
( 10
43.5%
1 2
 
8.7%
1
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 150
86.7%
ASCII 23
 
13.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
협 20
 
13.3%
농 17
 
11.3%
주 6
 
4.0%
원 6
 
4.0%
군 5
 
3.3%
안 5
 
3.3%
산 4
 
2.7%
부 4
 
2.7%
유 3
 
2.0%
영 3
 
2.0%
Other values (58) 77
51.3%
ASCII
ValueCountFrequency (%)
) 10
43.5%
( 10
43.5%
1 2
 
8.7%
1
 
4.3%

Unnamed: 2
Text

MISSING 

Distinct28
Distinct (%)100.0%
Missing1
Missing (%)3.4%
Memory size364.0 B
2024-03-14T10:28:36.194414image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length17
Mean length14.785714
Min length3

Characters and Unicode

Total characters414
Distinct characters82
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

Unique28 ?
Unique (%)100.0%

Sample

1st row사업장
2nd row익산시 망성면 신작리 526-2
3rd row전주시 전미동 56-5
4th row전주시 송천동2가 산 21-1
5th row부안군 상서면 가오리 734-9
ValueCountFrequency (%)
김제시 3
 
3.1%
익산시 3
 
3.1%
완주군 3
 
3.1%
부안군 3
 
3.1%
남원시 3
 
3.1%
정읍시 2
 
2.0%
전주시 2
 
2.0%
고산면 2
 
2.0%
상서면 2
 
2.0%
사업장 1
 
1.0%
Other values (74) 74
75.5%
2024-03-14T10:28:36.516019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
70
 
16.9%
리 20
 
4.8%
- 18
 
4.3%
1 17
 
4.1%
면 15
 
3.6%
시 13
 
3.1%
4 13
 
3.1%
5 13
 
3.1%
군 13
 
3.1%
2 12
 
2.9%
Other values (72) 210
50.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 222
53.6%
Decimal Number 104
25.1%
Space Separator 70
 
16.9%
Dash Punctuation 18
 
4.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 20
 
9.0%
면 15
 
6.8%
시 13
 
5.9%
군 13
 
5.9%
동 10
 
4.5%
산 9
 
4.1%
읍 8
 
3.6%
주 8
 
3.6%
안 7
 
3.2%
부 5
 
2.3%
Other values (60) 114
51.4%
Decimal Number
ValueCountFrequency (%)
1 17
16.3%
4 13
12.5%
5 13
12.5%
2 12
11.5%
6 10
9.6%
3 10
9.6%
9 9
8.7%
7 8
7.7%
8 7
6.7%
0 5
 
4.8%
Space Separator
ValueCountFrequency (%)
70
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 18
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 222
53.6%
Common 192
46.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 20
 
9.0%
면 15
 
6.8%
시 13
 
5.9%
군 13
 
5.9%
동 10
 
4.5%
산 9
 
4.1%
읍 8
 
3.6%
주 8
 
3.6%
안 7
 
3.2%
부 5
 
2.3%
Other values (60) 114
51.4%
Common
ValueCountFrequency (%)
70
36.5%
- 18
 
9.4%
1 17
 
8.9%
4 13
 
6.8%
5 13
 
6.8%
2 12
 
6.2%
6 10
 
5.2%
3 10
 
5.2%
9 9
 
4.7%
7 8
 
4.2%
Other values (2) 12
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 222
53.6%
ASCII 192
46.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
70
36.5%
- 18
 
9.4%
1 17
 
8.9%
4 13
 
6.8%
5 13
 
6.8%
2 12
 
6.2%
6 10
 
5.2%
3 10
 
5.2%
9 9
 
4.7%
7 8
 
4.2%
Other values (2) 12
 
6.2%
Hangul
ValueCountFrequency (%)
리 20
 
9.0%
면 15
 
6.8%
시 13
 
5.9%
군 13
 
5.9%
동 10
 
4.5%
산 9
 
4.1%
읍 8
 
3.6%
주 8
 
3.6%
안 7
 
3.2%
부 5
 
2.3%
Other values (60) 114
51.4%

Unnamed: 3
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing1
Missing (%)3.4%
Memory size364.0 B

Unnamed: 4
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)6.9%
Memory size364.0 B

Unnamed: 5
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing2
Missing (%)6.9%
Memory size364.0 B

Correlations

2024-03-14T10:28:36.587250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
농산물 산지유통센터 현황(2015.9월)Unnamed: 2
농산물 산지유통센터 현황(2015.9월)1.0001.000
Unnamed: 21.0001.000

Missing values

2024-03-14T10:28:35.318474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T10:28:35.403215image/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.
2024-03-14T10:28:35.492535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

Unnamed: 0농산물 산지유통센터 현황(2015.9월)Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5
0<NA><NA><NA>NaNNaNNaN
1<NA>조직명사업장부지(평)건축(평)기계 장비(종)
2<NA>망성농협익산시 망성면 신작리 526-2647913202
3<NA>전주농협전주시 전미동 56-522704981
4<NA>전주원협전주시 송천동2가 산 21-112112347
5<NA>부안새만금유통(영)부안군 상서면 가오리 734-96392726
6<NA>정읍원협정읍시 용계동 696-13661505
7<NA>완주임협완주군 고산면 읍내리 799-16762607
8<NA>진안군진안군 진안읍 군상리 243-110004507
9<NA>부안중앙농협부안군 상서면 통정리 44843682505
Unnamed: 0농산물 산지유통센터 현황(2015.9월)Unnamed: 2Unnamed: 3Unnamed: 4Unnamed: 5
19<NA>백구농협김제시 백구면 반월리 255-1외 48963788
20<NA>남부안농협보안면 영전리 4883693003
21<NA>익산원협(1)익산시 목천동 916-214887108
22<NA>변산농협(1)부안군 변산면 지서리 372-5218293002
23<NA>부안유통부안군동진면하장리 176414054508
24<NA>한국참다래 유통사업단익산시 함라면 신대리 166341513082
25<NA>운봉농협남원시 운봉읍 동천리 324-4외343924854
26<NA>춘향골농협남원시 금지면 신월리 738외1439913089
27<NA>한우물영농조합김제시 용지면 부교리 87-1025002282
28<NA>오수관촌농협오수면 용정리 19123569379