Overview

Dataset statistics

Number of variables7
Number of observations4313
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory240.2 KiB
Average record size in memory57.0 B

Variable types

Text1
Numeric1
DateTime2
Categorical3

Dataset

Description전라북도 정읍시 단풍미인쇼핑몰에서 지역농특산물 판매정보(상품명, 주문번호, 주문일, 기관명, 관리부서, 부서연락처) 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15084905/fileData.do

Alerts

기관명 has constant value ""Constant
관리부서 has constant value ""Constant
부서연락처 has constant value ""Constant
데이타기준일 has constant value ""Constant

Reproduction

Analysis started2023-12-12 05:54:56.553624
Analysis finished2023-12-12 05:54:57.610478
Duration1.06 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상품명
Text

Distinct769
Distinct (%)17.8%
Missing0
Missing (%)0.0%
Memory size33.8 KiB
2023-12-12T14:54:57.788634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length86
Median length63
Mean length25.694644
Min length5

Characters and Unicode

Total characters110821
Distinct characters488
Distinct categories10 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique267 ?
Unique (%)6.2%

Sample

1st row참어진 초석잠 한식된장 1킬로그램
2nd row2020년 햅쌀 단풍미인쌀 20킬로그램
3rd row2020년 햅쌀 단풍미인쌀 20킬로그램
4th row2020년 햅쌀 단풍미인쌀 10킬로그램
5th row울외장아찌 1킬로그램
ValueCountFrequency (%)
10킬로그램 695
 
4.4%
5킬로그램 616
 
3.9%
2021추석 533
 
3.4%
2021년 521
 
3.3%
1킬로그램 370
 
2.3%
단풍미인쌀 335
 
2.1%
20킬로그램 327
 
2.1%
2022설명절 272
 
1.7%
유기농 227
 
1.4%
2021년산 209
 
1.3%
Other values (996) 11774
74.1%
2023-12-12T14:54:58.338016image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
20199
 
18.2%
0 6405
 
5.8%
2 5859
 
5.3%
그 5422
 
4.9%
램 5310
 
4.8%
1 4878
 
4.4%
로 4397
 
4.0%
킬 4018
 
3.6%
5 1642
 
1.5%
) 1424
 
1.3%
Other values (478) 51267
46.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 65779
59.4%
Decimal Number 21042
 
19.0%
Space Separator 20199
 
18.2%
Close Punctuation 1424
 
1.3%
Open Punctuation 1423
 
1.3%
Uppercase Letter 540
 
0.5%
Lowercase Letter 370
 
0.3%
Other Punctuation 29
 
< 0.1%
Math Symbol 12
 
< 0.1%
Modifier Symbol 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
그 5422
 
8.2%
램 5310
 
8.1%
로 4397
 
6.7%
킬 4018
 
6.1%
년 1104
 
1.7%
우 1092
 
1.7%
장 1083
 
1.6%
정 1048
 
1.6%
리 1044
 
1.6%
쌀 1002
 
1.5%
Other values (440) 40259
61.2%
Lowercase Letter
ValueCountFrequency (%)
l 116
31.4%
m 111
30.0%
p 92
24.9%
a 17
 
4.6%
e 12
 
3.2%
s 9
 
2.4%
y 5
 
1.4%
i 5
 
1.4%
k 1
 
0.3%
b 1
 
0.3%
Decimal Number
ValueCountFrequency (%)
0 6405
30.4%
2 5859
27.8%
1 4878
23.2%
5 1642
 
7.8%
3 909
 
4.3%
4 575
 
2.7%
8 371
 
1.8%
7 258
 
1.2%
6 125
 
0.6%
9 20
 
0.1%
Uppercase Letter
ValueCountFrequency (%)
X 476
88.1%
P 24
 
4.4%
U 19
 
3.5%
L 10
 
1.9%
D 5
 
0.9%
T 3
 
0.6%
B 1
 
0.2%
E 1
 
0.2%
A 1
 
0.2%
Other Punctuation
ValueCountFrequency (%)
% 24
82.8%
& 4
 
13.8%
: 1
 
3.4%
Space Separator
ValueCountFrequency (%)
20199
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1424
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1423
100.0%
Math Symbol
ValueCountFrequency (%)
× 12
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 65777
59.4%
Common 44132
39.8%
Latin 910
 
0.8%
Han 2
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
그 5422
 
8.2%
램 5310
 
8.1%
로 4397
 
6.7%
킬 4018
 
6.1%
년 1104
 
1.7%
우 1092
 
1.7%
장 1083
 
1.6%
정 1048
 
1.6%
리 1044
 
1.6%
쌀 1002
 
1.5%
Other values (439) 40257
61.2%
Latin
ValueCountFrequency (%)
X 476
52.3%
l 116
 
12.7%
m 111
 
12.2%
p 92
 
10.1%
P 24
 
2.6%
U 19
 
2.1%
a 17
 
1.9%
e 12
 
1.3%
L 10
 
1.1%
s 9
 
1.0%
Other values (10) 24
 
2.6%
Common
ValueCountFrequency (%)
20199
45.8%
0 6405
 
14.5%
2 5859
 
13.3%
1 4878
 
11.1%
5 1642
 
3.7%
) 1424
 
3.2%
( 1423
 
3.2%
3 909
 
2.1%
4 575
 
1.3%
8 371
 
0.8%
Other values (8) 447
 
1.0%
Han
ValueCountFrequency (%)
生 2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 65777
59.4%
ASCII 45030
40.6%
None 12
 
< 0.1%
CJK 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
20199
44.9%
0 6405
 
14.2%
2 5859
 
13.0%
1 4878
 
10.8%
5 1642
 
3.6%
) 1424
 
3.2%
( 1423
 
3.2%
3 909
 
2.0%
4 575
 
1.3%
X 476
 
1.1%
Other values (27) 1240
 
2.8%
Hangul
ValueCountFrequency (%)
그 5422
 
8.2%
램 5310
 
8.1%
로 4397
 
6.7%
킬 4018
 
6.1%
년 1104
 
1.7%
우 1092
 
1.7%
장 1083
 
1.6%
정 1048
 
1.6%
리 1044
 
1.6%
쌀 1002
 
1.5%
Other values (439) 40257
61.2%
None
ValueCountFrequency (%)
× 12
100.0%
CJK
ValueCountFrequency (%)
生 2
100.0%

주문번호
Real number (ℝ)

Distinct4103
Distinct (%)95.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean54356.682
Minimum44792
Maximum63966
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size38.0 KiB
2023-12-12T14:54:58.517951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum44792
5-th percentile45863.2
Q149545
median54028
Q359102
95-th percentile63216.8
Maximum63966
Range19174
Interquartile range (IQR)9557

Descriptive statistics

Standard deviation5635.2861
Coefficient of variation (CV)0.10367237
Kurtosis-1.245866
Mean54356.682
Median Absolute Deviation (MAD)4709
Skewness0.060141468
Sum2.3444037 × 108
Variance31756449
MonotonicityIncreasing
2023-12-12T14:54:58.727401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
60633 7
 
0.2%
59700 6
 
0.1%
63482 5
 
0.1%
61364 5
 
0.1%
57099 5
 
0.1%
63068 4
 
0.1%
60526 4
 
0.1%
63882 4
 
0.1%
62463 4
 
0.1%
61945 4
 
0.1%
Other values (4093) 4265
98.9%
ValueCountFrequency (%)
44792 1
< 0.1%
44796 1
< 0.1%
44803 1
< 0.1%
44805 1
< 0.1%
44832 1
< 0.1%
44836 1
< 0.1%
44840 1
< 0.1%
44846 1
< 0.1%
44848 1
< 0.1%
44850 1
< 0.1%
ValueCountFrequency (%)
63966 1
< 0.1%
63964 1
< 0.1%
63962 1
< 0.1%
63960 1
< 0.1%
63949 1
< 0.1%
63947 1
< 0.1%
63945 1
< 0.1%
63943 1
< 0.1%
63926 1
< 0.1%
63921 2
< 0.1%

주문일
Date

Distinct361
Distinct (%)8.4%
Missing0
Missing (%)0.0%
Memory size33.8 KiB
Minimum2021-06-01 00:00:00
Maximum2022-05-31 00:00:00
2023-12-12T14:54:58.922214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:54:59.101903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size33.8 KiB
전라북도 정읍시청
4313 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전라북도 정읍시청
2nd row전라북도 정읍시청
3rd row전라북도 정읍시청
4th row전라북도 정읍시청
5th row전라북도 정읍시청

Common Values

ValueCountFrequency (%)
전라북도 정읍시청 4313
100.0%

Length

2023-12-12T14:54:59.252948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:54:59.371999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전라북도 4313
50.0%
정읍시청 4313
50.0%

관리부서
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size33.8 KiB
농수산유통과
4313 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row농수산유통과
2nd row농수산유통과
3rd row농수산유통과
4th row농수산유통과
5th row농수산유통과

Common Values

ValueCountFrequency (%)
농수산유통과 4313
100.0%

Length

2023-12-12T14:54:59.486043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:54:59.629259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
농수산유통과 4313
100.0%

부서연락처
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size33.8 KiB
063-539-6204
4313 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row063-539-6204
2nd row063-539-6204
3rd row063-539-6204
4th row063-539-6204
5th row063-539-6204

Common Values

ValueCountFrequency (%)
063-539-6204 4313
100.0%

Length

2023-12-12T14:54:59.798032image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:54:59.937562image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
063-539-6204 4313
100.0%

데이타기준일
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size33.8 KiB
Minimum2022-12-31 00:00:00
Maximum2022-12-31 00:00:00
2023-12-12T14:55:00.049025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:55:00.160733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T14:54:57.238395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Missing values

2023-12-12T14:54:57.417478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:54:57.550471image/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참어진 초석잠 한식된장 1킬로그램447922021-06-01전라북도 정읍시청농수산유통과063-539-62042022-12-31
12020년 햅쌀 단풍미인쌀 20킬로그램447962021-06-01전라북도 정읍시청농수산유통과063-539-62042022-12-31
22020년 햅쌀 단풍미인쌀 20킬로그램448032021-06-01전라북도 정읍시청농수산유통과063-539-62042022-12-31
32020년 햅쌀 단풍미인쌀 10킬로그램448052021-06-01전라북도 정읍시청농수산유통과063-539-62042022-12-31
4울외장아찌 1킬로그램448322021-06-01전라북도 정읍시청농수산유통과063-539-62042022-12-31
52020년 햅쌀 단풍미인쌀 10킬로그램448362021-06-02전라북도 정읍시청농수산유통과063-539-62042022-12-31
6귀리5호선물세트448402021-06-02전라북도 정읍시청농수산유통과063-539-62042022-12-31
7무우장아찌 2킬로그램448462021-06-02전라북도 정읍시청농수산유통과063-539-62042022-12-31
8콜라겐품은 알로에잼 1세트448482021-06-02전라북도 정읍시청농수산유통과063-539-62042022-12-31
92020년 햅쌀 단풍미인쌀 20킬로그램448502021-06-02전라북도 정읍시청농수산유통과063-539-62042022-12-31
상품명주문번호주문일기관명관리부서부서연락처데이타기준일
4303유황오리 훈제슬라이스 300그램 300그램X4팩639212022-05-30전라북도 정읍시청농수산유통과063-539-62042022-12-31
430422 가정의달 내장산누에환(냉동건조)500그램X2639262022-05-30전라북도 정읍시청농수산유통과063-539-62042022-12-31
43052021년 단풍미인쌀 10킬로그램639432022-05-31전라북도 정읍시청농수산유통과063-539-62042022-12-31
4306마이코 국내산 가바 현미 수제 누룽지 선물세트 1킬로그램639452022-05-31전라북도 정읍시청농수산유통과063-539-62042022-12-31
4307생 알로에 1킬로그램639472022-05-31전라북도 정읍시청농수산유통과063-539-62042022-12-31
4308오리훈제 선물세트 진심1호639492022-05-31전라북도 정읍시청농수산유통과063-539-62042022-12-31
4309두승산콩마을 두부500그램X4팩639602022-05-31전라북도 정읍시청농수산유통과063-539-62042022-12-31
431022 가정의달 귀리랑 뻥150그램X4봉지639622022-05-31전라북도 정읍시청농수산유통과063-539-62042022-12-31
4311알로에묘목 1그루 알로에묘목(대)1그루 영양퇴비500그램639642022-05-31전라북도 정읍시청농수산유통과063-539-62042022-12-31
4312꿀고구마5킬로그램(베니하루까 큐어링완료 사이즈100그램에서450그램 랜덤발송)639662022-05-31전라북도 정읍시청농수산유통과063-539-62042022-12-31