Overview

Dataset statistics

Number of variables7
Number of observations95
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.4 KiB
Average record size in memory58.3 B

Variable types

Numeric1
Categorical3
Text2
Boolean1

Dataset

Description전북특별자치도 축산물 이동판매 승인내역 현황 데이터입니다. (조합, 행사일자(일정), 이동판대장소, 승인여부, 차량번호 등)
Author전북특별자치도
URLhttps://www.data.go.kr/data/3081484/fileData.do

Alerts

승인여부 has constant value ""Constant
조합 is highly overall correlated with 시도 and 1 other fieldsHigh correlation
시도 is highly overall correlated with 조합 and 1 other fieldsHigh correlation
차량번호 is highly overall correlated with 조합 and 1 other fieldsHigh correlation
순번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 12:53:38.701035
Analysis finished2024-03-14 12:53:39.882012
Duration1.18 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct95
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean48
Minimum1
Maximum95
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size983.0 B
2024-03-14T21:53:40.014005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile5.7
Q124.5
median48
Q371.5
95-th percentile90.3
Maximum95
Range94
Interquartile range (IQR)47

Descriptive statistics

Standard deviation27.568098
Coefficient of variation (CV)0.57433536
Kurtosis-1.2
Mean48
Median Absolute Deviation (MAD)24
Skewness0
Sum4560
Variance760
MonotonicityStrictly increasing
2024-03-14T21:53:40.258987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.1%
2 1
 
1.1%
71 1
 
1.1%
70 1
 
1.1%
69 1
 
1.1%
68 1
 
1.1%
67 1
 
1.1%
66 1
 
1.1%
65 1
 
1.1%
64 1
 
1.1%
Other values (85) 85
89.5%
ValueCountFrequency (%)
1 1
1.1%
2 1
1.1%
3 1
1.1%
4 1
1.1%
5 1
1.1%
6 1
1.1%
7 1
1.1%
8 1
1.1%
9 1
1.1%
10 1
1.1%
ValueCountFrequency (%)
95 1
1.1%
94 1
1.1%
93 1
1.1%
92 1
1.1%
91 1
1.1%
90 1
1.1%
89 1
1.1%
88 1
1.1%
87 1
1.1%
86 1
1.1%

조합
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)12.6%
Missing0
Missing (%)0.0%
Memory size888.0 B
전주김제완주축협
25 
임실축협
22 
장수농협
13 
남원축협
11 
NH참예우조공법인
Other values (7)
17 

Length

Max length9
Median length4
Mean length5.6526316
Min length4

Unique

Unique2 ?
Unique (%)2.1%

Sample

1st row동진강낙협
2nd row임실축협
3rd row동진강낙농축협
4th row임실축협
5th row임실축협

Common Values

ValueCountFrequency (%)
전주김제완주축협 25
26.3%
임실축협 22
23.2%
장수농협 13
13.7%
남원축협 11
11.6%
NH참예우조공법인 7
 
7.4%
동진강낙농축협 4
 
4.2%
동진강낙협 3
 
3.2%
무진장축협 3
 
3.2%
화산농협 3
 
3.2%
익산군산축협 2
 
2.1%
Other values (2) 2
 
2.1%

Length

2024-03-14T21:53:40.491840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
전주김제완주축협 25
26.3%
임실축협 22
23.2%
장수농협 13
13.7%
남원축협 11
11.6%
nh참예우조공법인 7
 
7.4%
동진강낙농축협 4
 
4.2%
동진강낙협 3
 
3.2%
무진장축협 3
 
3.2%
화산농협 3
 
3.2%
익산군산축협 2
 
2.1%
Other values (2) 2
 
2.1%
Distinct94
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size888.0 B
2024-03-14T21:53:41.668599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length36
Mean length19.673684
Min length10

Characters and Unicode

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

Unique

Unique93 ?
Unique (%)97.9%

Sample

1st row01월 09 16 23 30(4일)
2nd row01월 09 23(2일)
3rd row02월 06 13 27(3일)
4th row02월 06(1일)
5th row02월 12 13 14(3일)
ValueCountFrequency (%)
09월 16
 
3.2%
12 16
 
3.2%
13 15
 
3.0%
17 15
 
3.0%
06 14
 
2.8%
20 14
 
2.8%
22 14
 
2.8%
07월 13
 
2.6%
16 13
 
2.6%
10 13
 
2.6%
Other values (103) 357
71.4%
2024-03-14T21:53:43.156180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
415
22.2%
0 239
12.8%
1 221
11.8%
2 197
10.5%
95
 
5.1%
( 93
 
5.0%
93
 
5.0%
) 93
 
5.0%
3 80
 
4.3%
5 63
 
3.4%
Other values (6) 280
15.0%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 1078
57.7%
Space Separator 415
 
22.2%
Other Letter 188
 
10.1%
Open Punctuation 93
 
5.0%
Close Punctuation 93
 
5.0%
Other Punctuation 2
 
0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 239
22.2%
1 221
20.5%
2 197
18.3%
3 80
 
7.4%
5 63
 
5.8%
7 60
 
5.6%
6 60
 
5.6%
4 59
 
5.5%
9 50
 
4.6%
8 49
 
4.5%
Other Letter
ValueCountFrequency (%)
95
50.5%
93
49.5%
Space Separator
ValueCountFrequency (%)
415
100.0%
Open Punctuation
ValueCountFrequency (%)
( 93
100.0%
Close Punctuation
ValueCountFrequency (%)
) 93
100.0%
Other Punctuation
ValueCountFrequency (%)
/ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1681
89.9%
Hangul 188
 
10.1%

Most frequent character per script

Common
ValueCountFrequency (%)
415
24.7%
0 239
14.2%
1 221
13.1%
2 197
11.7%
( 93
 
5.5%
) 93
 
5.5%
3 80
 
4.8%
5 63
 
3.7%
7 60
 
3.6%
6 60
 
3.6%
Other values (4) 160
 
9.5%
Hangul
ValueCountFrequency (%)
95
50.5%
93
49.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1681
89.9%
Hangul 188
 
10.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
415
24.7%
0 239
14.2%
1 221
13.1%
2 197
11.7%
( 93
 
5.5%
) 93
 
5.5%
3 80
 
4.8%
5 63
 
3.7%
7 60
 
3.6%
6 60
 
3.6%
Other values (4) 160
 
9.5%
Hangul
ValueCountFrequency (%)
95
50.5%
93
49.5%

시도
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)9.5%
Missing0
Missing (%)0.0%
Memory size888.0 B
전주
29 
완주
21 
장수
14 
김제
13 
남원
11 
Other values (4)

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique2 ?
Unique (%)2.1%

Sample

1st row김제
2nd row전주
3rd row김제
4th row전주
5th row전주

Common Values

ValueCountFrequency (%)
전주 29
30.5%
완주 21
22.1%
장수 14
14.7%
김제 13
13.7%
남원 11
 
11.6%
진안 3
 
3.2%
임실 2
 
2.1%
군산 1
 
1.1%
익산 1
 
1.1%

Length

2024-03-14T21:53:43.376799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T21:53:43.572035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전주 29
30.5%
완주 21
22.1%
장수 14
14.7%
김제 13
13.7%
남원 11
 
11.6%
진안 3
 
3.2%
임실 2
 
2.1%
군산 1
 
1.1%
익산 1
 
1.1%
Distinct54
Distinct (%)56.8%
Missing0
Missing (%)0.0%
Memory size888.0 B
2024-03-14T21:53:44.310453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length61
Median length49
Mean length24.463158
Min length9

Characters and Unicode

Total characters2324
Distinct characters172
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

Unique40 ?
Unique (%)42.1%

Sample

1st row검산동 320(육유소비촉진행사)
2nd row덕진구 백제대로 729 농협전북지역본부앞
3rd row검산동 320(육우소비촉진행사)
4th row덕진구 백제대로 729 농협전북지역본부 앞
5th row완산구 효자로 225 전북도의회광장
ValueCountFrequency (%)
26
 
5.8%
이서면 14
 
3.1%
직거래장터 13
 
2.9%
덕진구 12
 
2.7%
어현동 12
 
2.7%
백제대로 11
 
2.4%
729 11
 
2.4%
소리길 10
 
2.2%
완주로컬푸드 10
 
2.2%
완산구 10
 
2.2%
Other values (131) 320
71.3%
2024-03-14T21:53:45.307252image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
427
 
18.4%
71
 
3.1%
2 70
 
3.0%
53
 
2.3%
50
 
2.2%
48
 
2.1%
47
 
2.0%
0 45
 
1.9%
1 40
 
1.7%
38
 
1.6%
Other values (162) 1435
61.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1534
66.0%
Space Separator 427
 
18.4%
Decimal Number 272
 
11.7%
Close Punctuation 31
 
1.3%
Open Punctuation 31
 
1.3%
Dash Punctuation 15
 
0.6%
Uppercase Letter 14
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
71
 
4.6%
53
 
3.5%
50
 
3.3%
48
 
3.1%
47
 
3.1%
38
 
2.5%
37
 
2.4%
36
 
2.3%
34
 
2.2%
34
 
2.2%
Other values (146) 1086
70.8%
Decimal Number
ValueCountFrequency (%)
2 70
25.7%
0 45
16.5%
1 40
14.7%
8 33
12.1%
7 20
 
7.4%
9 19
 
7.0%
3 16
 
5.9%
5 12
 
4.4%
6 9
 
3.3%
4 8
 
2.9%
Uppercase Letter
ValueCountFrequency (%)
L 7
50.0%
H 7
50.0%
Space Separator
ValueCountFrequency (%)
427
100.0%
Close Punctuation
ValueCountFrequency (%)
) 31
100.0%
Open Punctuation
ValueCountFrequency (%)
( 31
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 15
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1534
66.0%
Common 776
33.4%
Latin 14
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
71
 
4.6%
53
 
3.5%
50
 
3.3%
48
 
3.1%
47
 
3.1%
38
 
2.5%
37
 
2.4%
36
 
2.3%
34
 
2.2%
34
 
2.2%
Other values (146) 1086
70.8%
Common
ValueCountFrequency (%)
427
55.0%
2 70
 
9.0%
0 45
 
5.8%
1 40
 
5.2%
8 33
 
4.3%
) 31
 
4.0%
( 31
 
4.0%
7 20
 
2.6%
9 19
 
2.4%
3 16
 
2.1%
Other values (4) 44
 
5.7%
Latin
ValueCountFrequency (%)
L 7
50.0%
H 7
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1534
66.0%
ASCII 790
34.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
427
54.1%
2 70
 
8.9%
0 45
 
5.7%
1 40
 
5.1%
8 33
 
4.2%
) 31
 
3.9%
( 31
 
3.9%
7 20
 
2.5%
9 19
 
2.4%
3 16
 
2.0%
Other values (6) 58
 
7.3%
Hangul
ValueCountFrequency (%)
71
 
4.6%
53
 
3.5%
50
 
3.3%
48
 
3.1%
47
 
3.1%
38
 
2.5%
37
 
2.4%
36
 
2.3%
34
 
2.2%
34
 
2.2%
Other values (146) 1086
70.8%

승인여부
Boolean

CONSTANT 

Distinct1
Distinct (%)1.1%
Missing0
Missing (%)0.0%
Memory size223.0 B
True
95 
ValueCountFrequency (%)
True 95
100.0%
2024-03-14T21:53:45.484346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

차량번호
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)10.5%
Missing0
Missing (%)0.0%
Memory size888.0 B
99러94*0
22 
95마20*3
20 
95라92*5
13 
94두33*3
12 
95가91*5
11 
Other values (5)
17 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique2 ?
Unique (%)2.1%

Sample

1st row95나79*8
2nd row95마20*3
3rd row95나79*8
4th row95마20*3
5th row94두33*3

Common Values

ValueCountFrequency (%)
99러94*0 22
23.2%
95마20*3 20
21.1%
95라92*5 13
13.7%
94두33*3 12
12.6%
95가91*5 11
11.6%
95나79*8 7
 
7.4%
94우31*2 5
 
5.3%
95라39*5 3
 
3.2%
95마20*4 1
 
1.1%
95라92*1 1
 
1.1%

Length

2024-03-14T21:53:45.640652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T21:53:45.841445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
99러94*0 22
23.2%
95마20*3 20
21.1%
95라92*5 13
13.7%
94두33*3 12
12.6%
95가91*5 11
11.6%
95나79*8 7
 
7.4%
94우31*2 5
 
5.3%
95라39*5 3
 
3.2%
95마20*4 1
 
1.1%
95라92*1 1
 
1.1%

Interactions

2024-03-14T21:53:39.284241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T21:53:46.013064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번조합행사일자(일수)시도이동판매장소차량번호
순번1.0000.3441.0000.2500.0000.487
조합0.3441.0000.0000.9291.0000.969
행사일자(일수)1.0000.0001.0001.0000.9200.000
시도0.2500.9291.0001.0001.0000.870
이동판매장소0.0001.0000.9201.0001.0000.970
차량번호0.4870.9690.0000.8700.9701.000
2024-03-14T21:53:46.475364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
차량번호조합시도
차량번호1.0000.8640.635
조합0.8641.0000.730
시도0.6350.7301.000
2024-03-14T21:53:46.717466image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번조합시도차량번호
순번1.0000.1450.1110.165
조합0.1451.0000.7300.864
시도0.1110.7301.0000.635
차량번호0.1650.8640.6351.000

Missing values

2024-03-14T21:53:39.600891image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T21:53:39.801850image/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동진강낙협01월 09 16 23 30(4일)김제검산동 320(육유소비촉진행사)Y95나79*8
12임실축협01월 09 23(2일)전주덕진구 백제대로 729 농협전북지역본부앞Y95마20*3
23동진강낙농축협02월 06 13 27(3일)김제검산동 320(육우소비촉진행사)Y95나79*8
34임실축협02월 06(1일)전주덕진구 백제대로 729 농협전북지역본부 앞Y95마20*3
45임실축협02월 12 13 14(3일)전주완산구 효자로 225 전북도의회광장Y94두33*3
56남원축협02월 12 13 14 15 16(5일)남원어현동 소리길 100-8Y95가91*5
67전주김제완주축협02월 11 12 13 14 15 16 17 (7일)김제남북로 218 전주김제완주축협 김제지점 하나로마트 앞Y99러94*0
78동진강낙농축협03월 06 13 20 27(4일)김제검산동 320(육우소비촉진행사)Y95나79*8
89임실축협03월 06 20(2일)전주덕진구 백제대로 729 농협전북지역본부 앞Y95마20*3
910남원축협03월 19 20 26 27(4일)남원어현동 소리길 100-8Y95가91*5
순번조합행사일자(일수)시도이동판매장소승인여부차량번호
8586남원축협10월 24(1일)남원어현동 소리길 100-8(변경전) 어현동 사랑의 광장(변경후)Y95가91*5
8687남원축협10월 25(1일)남원어현동 사랑의 광장Y95가91*5
8788무진장축협10월 30 31 11/1(3일)진안진안읍 단양리 마이산 북부주차장 (마이문화제 진안고원 홍삼축제)Y95라39*5
8889익산군산축협10월 30 31 11/1 2 3 4 5 6 7 8 (10일)익산익산시 어양동 중앙체육공원(천문송이 국화축제)Y94우31*2
8990전주김제완주축협11월 05 12 19 26(4일)완주이서면 지사제로 29 에코르아파트 2단지 앞 지사율공원 주차장(완주로컬푸드 직거래장터)Y99러94*0
9091전주김제완주축협11월 06 13 20 27(4일)완주이서면 갈산리 650 LH아파트 10단지 앞 소리공원 내 (완주로컬푸드 직거래장터)Y99러94*0
9192임실축협11월 20(1일)전주덕진구 백제대로 729 농협전북지역본부 앞Y95마20*3
9293임실축협11월 14 21 28(3일)전주혁신도시 산학연 클러스터 2용지(한국전기안전공사 옆)Y95마20*3
9394NH참예우조공법인11월 05(1일)전주완산구 유연로 217 호반베르디움아파트 주차장Y94두33*3
9495남원축협11월 06 07 13 14 20 21 27 28(8일)남원어현동 소리길 100-8Y95가91*5