Overview

Dataset statistics

Number of variables23
Number of observations122
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)0.8%
Total size in memory22.1 KiB
Average record size in memory185.1 B

Variable types

Categorical23

Dataset

Description샘플 데이터
Author대한제분㈜ / 0234550285
URLhttps://www.bigdata-transportation.kr/frn/prdt/detail?prdtId=PRDTNUM_000000020455

Alerts

Dataset has 1 (0.8%) duplicate rowsDuplicates
HOUR_PAY is highly imbalanced (68.5%)Imbalance
FG_SALES is highly imbalanced (91.4%)Imbalance
FG_SYSTEM is highly imbalanced (52.9%)Imbalance
AGE is highly imbalanced (55.0%)Imbalance
GENDER is highly imbalanced (57.5%)Imbalance
TYPE is highly imbalanced (82.6%)Imbalance
QUANTITY is highly imbalanced (53.5%)Imbalance
PAYMENT is highly imbalanced (85.2%)Imbalance
COUPON is highly imbalanced (61.8%)Imbalance
COUNTRY is highly imbalanced (55.5%)Imbalance
STANDARD is highly imbalanced (76.1%)Imbalance

Reproduction

Analysis started2024-01-06 11:59:35.172783
Analysis finished2024-01-06 11:59:35.700771
Duration0.53 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

YEAR_PAY
Categorical

Distinct3
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2023
64 
2022
57 
년
 
1

Length

Max length4
Median length4
Mean length3.9754098
Min length1

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row년
2nd row2022
3rd row2022
4th row2022
5th row2022

Common Values

ValueCountFrequency (%)
2023 64
52.5%
2022 57
46.7%
년 1
 
0.8%

Length

2024-01-06T11:59:36.050195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:36.399240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023 64
52.5%
2022 57
46.7%
년 1
 
0.8%

MONTH_PAY
Categorical

Distinct5
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
11
40 
2
34 
1
30 
12
17 
월
 
1

Length

Max length2
Median length1
Mean length1.4672131
Min length1

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row월
2nd row11
3rd row11
4th row11
5th row11

Common Values

ValueCountFrequency (%)
11 40
32.8%
2 34
27.9%
1 30
24.6%
12 17
13.9%
월 1
 
0.8%

Length

2024-01-06T11:59:36.720973image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:37.047728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
11 40
32.8%
2 34
27.9%
1 30
24.6%
12 17
13.9%
월 1
 
0.8%

DAY_PAY
Categorical

Distinct24
Distinct (%)19.7%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2
23 
27
13 
3
10 
4
9 
23
9 
Other values (19)
58 

Length

Max length2
Median length1
Mean length1.4754098
Min length1

Unique

Unique4 ?
Unique (%)3.3%

Sample

1st row일
2nd row1
3rd row1
4th row1
5th row1

Common Values

ValueCountFrequency (%)
2 23
18.9%
27 13
10.7%
3 10
 
8.2%
4 9
 
7.4%
23 9
 
7.4%
6 6
 
4.9%
5 6
 
4.9%
15 5
 
4.1%
1 5
 
4.1%
11 5
 
4.1%
Other values (14) 31
25.4%

Length

2024-01-06T11:59:37.501042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2 23
18.9%
27 13
10.7%
3 10
 
8.2%
4 9
 
7.4%
23 9
 
7.4%
6 6
 
4.9%
5 6
 
4.9%
15 5
 
4.1%
1 5
 
4.1%
11 5
 
4.1%
Other values (14) 31
25.4%

HOUR_PAY
Categorical

IMBALANCE 

Distinct4
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
12시 ~ 18시
109 
19시 ~ 23시
 
6
08시 ~ 11시
 
6
시간대
 
1

Length

Max length9
Median length9
Mean length8.9508197
Min length3

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row시간대
2nd row12시 ~ 18시
3rd row12시 ~ 18시
4th row19시 ~ 23시
5th row19시 ~ 23시

Common Values

ValueCountFrequency (%)
12시 ~ 18시 109
89.3%
19시 ~ 23시 6
 
4.9%
08시 ~ 11시 6
 
4.9%
시간대 1
 
0.8%

Length

2024-01-06T11:59:37.883126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:38.237627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
121
33.2%
12시 109
29.9%
18시 109
29.9%
19시 6
 
1.6%
23시 6
 
1.6%
08시 6
 
1.6%
11시 6
 
1.6%
시간대 1
 
0.3%

DATE_PAY
Categorical

Distinct7
Distinct (%)5.7%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
목
24 
수
23 
금
23 
토
23 
월
16 
Other values (2)
13 

Length

Max length4
Median length1
Mean length1.0245902
Min length1

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row결제요일
2nd row화
3rd row화
4th row화
5th row화

Common Values

ValueCountFrequency (%)
목 24
19.7%
수 23
18.9%
금 23
18.9%
토 23
18.9%
월 16
13.1%
화 12
9.8%
결제요일 1
 
0.8%

Length

2024-01-06T11:59:38.609567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:38.985173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
목 24
19.7%
수 23
18.9%
금 23
18.9%
토 23
18.9%
월 16
13.1%
화 12
9.8%
결제요일 1
 
0.8%

FG_SALES
Categorical

IMBALANCE 

Distinct3
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
정상
120 
매출구분
 
1
반품
 
1

Length

Max length4
Median length2
Mean length2.0163934
Min length2

Unique

Unique2 ?
Unique (%)1.6%

Sample

1st row매출구분
2nd row정상
3rd row정상
4th row정상
5th row정상

Common Values

ValueCountFrequency (%)
정상 120
98.4%
매출구분 1
 
0.8%
반품 1
 
0.8%

Length

2024-01-06T11:59:39.544829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:39.922965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 120
98.4%
매출구분 1
 
0.8%
반품 1
 
0.8%

FG_SYSTEM
Categorical

IMBALANCE 

Distinct3
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
매장
99 
온라인몰
22 
구매처
 
1

Length

Max length4
Median length2
Mean length2.3688525
Min length2

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row구매처
2nd row매장
3rd row매장
4th row매장
5th row매장

Common Values

ValueCountFrequency (%)
매장 99
81.1%
온라인몰 22
 
18.0%
구매처 1
 
0.8%

Length

2024-01-06T11:59:40.287245image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:40.636287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
매장 99
81.1%
온라인몰 22
 
18.0%
구매처 1
 
0.8%

AGE
Categorical

IMBALANCE 

Distinct4
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
<NA>
100 
40대
11 
30대
 
10
연령대
 
1

Length

Max length4
Median length4
Mean length3.8196721
Min length3

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row연령대
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 100
82.0%
40대 11
 
9.0%
30대 10
 
8.2%
연령대 1
 
0.8%

Length

2024-01-06T11:59:40.993863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:41.443540image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 100
82.0%
40대 11
 
9.0%
30대 10
 
8.2%
연령대 1
 
0.8%

GENDER
Categorical

IMBALANCE 

Distinct4
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
미선택
100 
남성
17 
여성
 
4
성별
 
1

Length

Max length3
Median length3
Mean length2.8196721
Min length2

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row성별
2nd row미선택
3rd row미선택
4th row미선택
5th row미선택

Common Values

ValueCountFrequency (%)
미선택 100
82.0%
남성 17
 
13.9%
여성 4
 
3.3%
성별 1
 
0.8%

Length

2024-01-06T11:59:41.941333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:42.257129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미선택 100
82.0%
남성 17
 
13.9%
여성 4
 
3.3%
성별 1
 
0.8%

TYPE
Categorical

IMBALANCE 

Distinct3
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
와인
117 
비주류
 
4
분류
 
1

Length

Max length3
Median length2
Mean length2.0327869
Min length2

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row분류
2nd row와인
3rd row와인
4th row와인
5th row와인

Common Values

ValueCountFrequency (%)
와인 117
95.9%
비주류 4
 
3.3%
분류 1
 
0.8%

Length

2024-01-06T11:59:42.841218image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:43.258278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
와인 117
95.9%
비주류 4
 
3.3%
분류 1
 
0.8%

QUANTITY
Categorical

IMBALANCE 

Distinct10
Distinct (%)8.2%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
1
89 
2
9 
3
9 
8
 
6
5
 
4
Other values (5)
 
5

Length

Max length4
Median length1
Mean length1.0327869
Min length1

Unique

Unique5 ?
Unique (%)4.1%

Sample

1st row구매수량
2nd row1
3rd row1
4th row1
5th row2

Common Values

ValueCountFrequency (%)
1 89
73.0%
2 9
 
7.4%
3 9
 
7.4%
8 6
 
4.9%
5 4
 
3.3%
구매수량 1
 
0.8%
12 1
 
0.8%
4 1
 
0.8%
6 1
 
0.8%
7 1
 
0.8%

Length

2024-01-06T11:59:43.622075image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:44.171467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 89
73.0%
2 9
 
7.4%
3 9
 
7.4%
8 6
 
4.9%
5 4
 
3.3%
구매수량 1
 
0.8%
12 1
 
0.8%
4 1
 
0.8%
6 1
 
0.8%
7 1
 
0.8%

AM_TOTAL
Categorical

Distinct20
Distinct (%)16.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
10만원대
41 
20만원대
13 
6만원대
11 
8만원대
10 
5만원대
5 
Other values (15)
42 

Length

Max length8
Median length5
Mean length4.704918
Min length4

Unique

Unique3 ?
Unique (%)2.5%

Sample

1st row총금액대
2nd row100만원 이상
3rd row6만원대
4th row60만원대
5th row1만원대

Common Values

ValueCountFrequency (%)
10만원대 41
33.6%
20만원대 13
 
10.7%
6만원대 11
 
9.0%
8만원대 10
 
8.2%
5만원대 5
 
4.1%
70만원대 5
 
4.1%
30만원대 5
 
4.1%
4만원대 4
 
3.3%
7만원대 4
 
3.3%
40만원대 4
 
3.3%
Other values (10) 20
16.4%

Length

2024-01-06T11:59:44.665741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
10만원대 41
32.5%
20만원대 13
 
10.3%
6만원대 11
 
8.7%
8만원대 10
 
7.9%
5만원대 5
 
4.0%
70만원대 5
 
4.0%
30만원대 5
 
4.0%
4만원대 4
 
3.2%
7만원대 4
 
3.2%
40만원대 4
 
3.2%
Other values (12) 24
19.0%

AM_SALE
Categorical

Distinct16
Distinct (%)13.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
10만원대
42 
6만원대
19 
20만원대
11 
5만원대
11 
8만원대
8 
Other values (11)
31 

Length

Max length8
Median length6
Mean length4.5737705
Min length4

Unique

Unique5 ?
Unique (%)4.1%

Sample

1st row제품단가대
2nd row100만원 이상
3rd row6만원대
4th row60만원대
5th row1만원 미만

Common Values

ValueCountFrequency (%)
10만원대 42
34.4%
6만원대 19
15.6%
20만원대 11
 
9.0%
5만원대 11
 
9.0%
8만원대 8
 
6.6%
4만원대 7
 
5.7%
9만원대 5
 
4.1%
1만원 미만 4
 
3.3%
7만원대 4
 
3.3%
60만원대 3
 
2.5%
Other values (6) 8
 
6.6%

Length

2024-01-06T11:59:45.291789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
10만원대 42
33.1%
6만원대 19
15.0%
20만원대 11
 
8.7%
5만원대 11
 
8.7%
8만원대 8
 
6.3%
4만원대 7
 
5.5%
9만원대 5
 
3.9%
미만 4
 
3.1%
7만원대 4
 
3.1%
1만원 4
 
3.1%
Other values (8) 12
 
9.4%

PAYMENT
Categorical

IMBALANCE 

Distinct3
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
카드
118 
계좌이체
 
3
결제수단
 
1

Length

Max length4
Median length2
Mean length2.0655738
Min length2

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row결제수단
2nd row카드
3rd row카드
4th row카드
5th row카드

Common Values

ValueCountFrequency (%)
카드 118
96.7%
계좌이체 3
 
2.5%
결제수단 1
 
0.8%

Length

2024-01-06T11:59:45.807843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:46.300597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
카드 118
96.7%
계좌이체 3
 
2.5%
결제수단 1
 
0.8%

COUPON
Categorical

IMBALANCE 

Distinct3
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
<NA>
106 
비티스몰 쿠폰
15 
쿠폰사용여부
 
1

Length

Max length7
Median length4
Mean length4.3852459
Min length4

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row쿠폰사용여부
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 106
86.9%
비티스몰 쿠폰 15
 
12.3%
쿠폰사용여부 1
 
0.8%

Length

2024-01-06T11:59:46.716671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:47.048478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 106
77.4%
비티스몰 15
 
10.9%
쿠폰 15
 
10.9%
쿠폰사용여부 1
 
0.7%

COUNTRY
Categorical

IMBALANCE 

Distinct8
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
프랑스
93 
미국
13 
이태리
 
5
호주
 
4
<NA>
 
3
Other values (3)
 
4

Length

Max length4
Median length3
Mean length2.8852459
Min length2

Unique

Unique2 ?
Unique (%)1.6%

Sample

1st row국가
2nd row프랑스
3rd row미국
4th row프랑스
5th row프랑스

Common Values

ValueCountFrequency (%)
프랑스 93
76.2%
미국 13
 
10.7%
이태리 5
 
4.1%
호주 4
 
3.3%
<NA> 3
 
2.5%
스페인 2
 
1.6%
국가 1
 
0.8%
뉴질랜드 1
 
0.8%

Length

2024-01-06T11:59:47.419021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:47.784982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
프랑스 93
76.2%
미국 13
 
10.7%
이태리 5
 
4.1%
호주 4
 
3.3%
na 3
 
2.5%
스페인 2
 
1.6%
국가 1
 
0.8%
뉴질랜드 1
 
0.8%

REGION
Categorical

Distinct16
Distinct (%)13.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Bourgogne
66 
Champagne
18 
Oregon
7 
California
 
6
<NA>
 
4
Other values (11)
21 

Length

Max length18
Median length9
Mean length8.9262295
Min length2

Unique

Unique4 ?
Unique (%)3.3%

Sample

1st row지역
2nd rowBourgogne
3rd rowCalifornia
4th rowBourgogne
5th rowNormandy

Common Values

ValueCountFrequency (%)
Bourgogne 66
54.1%
Champagne 18
 
14.8%
Oregon 7
 
5.7%
California 6
 
4.9%
<NA> 4
 
3.3%
South Australia 4
 
3.3%
Piemonte 3
 
2.5%
Normandy 2
 
1.6%
Castilla La Mancha 2
 
1.6%
Toscana 2
 
1.6%
Other values (6) 8
 
6.6%

Length

2024-01-06T11:59:48.257217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
bourgogne 66
50.8%
champagne 18
 
13.8%
oregon 7
 
5.4%
california 6
 
4.6%
na 4
 
3.1%
south 4
 
3.1%
australia 4
 
3.1%
piemonte 3
 
2.3%
toscana 2
 
1.5%
roussillon 2
 
1.5%
Other values (9) 14
 
10.8%

VINTAGE
Categorical

Distinct13
Distinct (%)10.7%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
2019
39 
2020
31 
2018
17 
NV
17 
<NA>
4 
Other values (8)
14 

Length

Max length4
Median length4
Mean length3.7131148
Min length2

Unique

Unique5 ?
Unique (%)4.1%

Sample

1st row빈티지
2nd row2007
3rd row2018
4th row2020
5th rowNV

Common Values

ValueCountFrequency (%)
2019 39
32.0%
2020 31
25.4%
2018 17
13.9%
NV 17
13.9%
<NA> 4
 
3.3%
2017 3
 
2.5%
2016 3
 
2.5%
2015 3
 
2.5%
빈티지 1
 
0.8%
2007 1
 
0.8%
Other values (3) 3
 
2.5%

Length

2024-01-06T11:59:48.640838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2019 39
32.0%
2020 31
25.4%
2018 17
13.9%
nv 17
13.9%
na 4
 
3.3%
2017 3
 
2.5%
2016 3
 
2.5%
2015 3
 
2.5%
빈티지 1
 
0.8%
2007 1
 
0.8%
Other values (3) 3
 
2.5%

STANDARD
Categorical

IMBALANCE 

Distinct8
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
750ml
110 
375ml
 
4
330ml
 
2
100g
 
2
규격
 
1
Other values (3)
 
3

Length

Max length6
Median length5
Mean length4.9508197
Min length2

Unique

Unique4 ?
Unique (%)3.3%

Sample

1st row규격
2nd row750ml
3rd row750ml
4th row750ml
5th row330ml

Common Values

ValueCountFrequency (%)
750ml 110
90.2%
375ml 4
 
3.3%
330ml 2
 
1.6%
100g 2
 
1.6%
규격 1
 
0.8%
1500ml 1
 
0.8%
250g 1
 
0.8%
<NA> 1
 
0.8%

Length

2024-01-06T11:59:49.128890image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:49.674612image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
750ml 110
90.2%
375ml 4
 
3.3%
330ml 2
 
1.6%
100g 2
 
1.6%
규격 1
 
0.8%
1500ml 1
 
0.8%
250g 1
 
0.8%
na 1
 
0.8%

ALCOHOL
Categorical

Distinct16
Distinct (%)13.1%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
13.5
25 
13
19 
12.5
19 
<NA>
12 
12
9 
Other values (11)
38 

Length

Max length5
Median length4
Mean length3.1885246
Min length1

Unique

Unique3 ?
Unique (%)2.5%

Sample

1st row알코올도수
2nd row<NA>
3rd row15
4th row13
5th row4.5

Common Values

ValueCountFrequency (%)
13.5 25
20.5%
13 19
15.6%
12.5 19
15.6%
<NA> 12
9.8%
12 9
 
7.4%
15 8
 
6.6%
14 8
 
6.6%
14.5 7
 
5.7%
11.5 4
 
3.3%
4.5 2
 
1.6%
Other values (6) 9
 
7.4%

Length

2024-01-06T11:59:50.148361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
13.5 25
20.5%
13 19
15.6%
12.5 19
15.6%
na 12
9.8%
12 9
 
7.4%
15 8
 
6.6%
14 8
 
6.6%
14.5 7
 
5.7%
11.5 4
 
3.3%
4.5 2
 
1.6%
Other values (6) 9
 
7.4%

CLASS
Categorical

Distinct9
Distinct (%)7.4%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Village
32 
<NA>
30 
Regionale
20 
Grand Cru
15 
1er Cru
14 
Other values (4)
11 

Length

Max length13
Median length9
Mean length6.8934426
Min length2

Unique

Unique1 ?
Unique (%)0.8%

Sample

1st row등급
2nd rowGrand Cru
3rd row<NA>
4th row1er Cru
5th row<NA>

Common Values

ValueCountFrequency (%)
Village 32
26.2%
<NA> 30
24.6%
Regionale 20
16.4%
Grand Cru 15
12.3%
1er Cru 14
11.5%
Vin de France 5
 
4.1%
DOC 3
 
2.5%
DOCG 2
 
1.6%
등급 1
 
0.8%

Length

2024-01-06T11:59:50.718351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:51.179696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
village 32
19.9%
na 30
18.6%
cru 29
18.0%
regionale 20
12.4%
grand 15
9.3%
1er 14
8.7%
vin 5
 
3.1%
de 5
 
3.1%
france 5
 
3.1%
doc 3
 
1.9%
Other values (2) 3
 
1.9%

GRAPE_VARIETY
Categorical

Distinct22
Distinct (%)18.0%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Chardonnay
45 
Pinot Noir
33 
Aligote
7 
Cabernet Sauvignon
6 
<NA>
 
4
Other values (17)
27 

Length

Max length78
Median length10
Mean length11.737705
Min length4

Unique

Unique9 ?
Unique (%)7.4%

Sample

1st row포도품종
2nd rowPinot Noir
3rd rowCabernet Sauvignon
4th rowPinot Noir
5th rowApple

Common Values

ValueCountFrequency (%)
Chardonnay 45
36.9%
Pinot Noir 33
27.0%
Aligote 7
 
5.7%
Cabernet Sauvignon 6
 
4.9%
<NA> 4
 
3.3%
Aligote 90%, Pinot Noir 10% 3
 
2.5%
Gamay 3
 
2.5%
Moscato 2
 
1.6%
Garnacha 2
 
1.6%
Sangiovese 2
 
1.6%
Other values (12) 15
 
12.3%

Length

2024-01-06T11:59:51.740708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
chardonnay 48
23.0%
noir 41
19.6%
pinot 41
19.6%
aligote 10
 
4.8%
cabernet 6
 
2.9%
sauvignon 6
 
2.9%
90 5
 
2.4%
10 5
 
2.4%
grenache 4
 
1.9%
na 4
 
1.9%
Other values (25) 39
18.7%

WINE_TYPE
Categorical

Distinct8
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size1.1 KiB
Red
47 
White
40 
Sparkling
27 
<NA>
 
3
Cider
 
2
Other values (3)
 
3

Length

Max length9
Median length5
Mean length5.057377
Min length3

Unique

Unique3 ?
Unique (%)2.5%

Sample

1st row와인종류
2nd rowRed
3rd rowRed
4th rowRed
5th rowCider

Common Values

ValueCountFrequency (%)
Red 47
38.5%
White 40
32.8%
Sparkling 27
22.1%
<NA> 3
 
2.5%
Cider 2
 
1.6%
와인종류 1
 
0.8%
Jam 1
 
0.8%
Rose 1
 
0.8%

Length

2024-01-06T11:59:52.208916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-06T11:59:52.591069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
red 47
38.5%
white 40
32.8%
sparkling 27
22.1%
na 3
 
2.5%
cider 2
 
1.6%
와인종류 1
 
0.8%
jam 1
 
0.8%
rose 1
 
0.8%

Sample

YEAR_PAYMONTH_PAYDAY_PAYHOUR_PAYDATE_PAYFG_SALESFG_SYSTEMAGEGENDERTYPEQUANTITYAM_TOTALAM_SALEPAYMENTCOUPONCOUNTRYREGIONVINTAGESTANDARDALCOHOLCLASSGRAPE_VARIETYWINE_TYPE
0년월일시간대결제요일매출구분구매처연령대성별분류구매수량총금액대제품단가대결제수단쿠폰사용여부국가지역빈티지규격알코올도수등급포도품종와인종류
1202211112시 ~ 18시화정상매장<NA>미선택와인1100만원 이상100만원 이상카드<NA>프랑스Bourgogne2007750ml<NA>Grand CruPinot NoirRed
2202211112시 ~ 18시화정상매장<NA>미선택와인16만원대6만원대카드<NA>미국California2018750ml15<NA>Cabernet SauvignonRed
3202211119시 ~ 23시화정상매장<NA>미선택와인160만원대60만원대카드<NA>프랑스Bourgogne2020750ml131er CruPinot NoirRed
4202211119시 ~ 23시화정상매장<NA>미선택와인21만원대1만원 미만카드<NA>프랑스NormandyNV330ml4.5<NA>AppleCider
5202211212시 ~ 18시수정상매장<NA>미선택와인250만원대20만원대카드<NA>프랑스ChampagneNV750ml12.5Grand CruChardonnay 40%, Pinot Noir 60%Sparkling
6202211212시 ~ 18시수정상매장<NA>미선택와인110만원대10만원대카드<NA>프랑스ChampagneNV750ml12.5Grand CruPinot NoirSparkling
7202211212시 ~ 18시수정상매장<NA>미선택와인120만원대20만원대카드<NA>프랑스Bourgogne2020750ml13.5VillagePinot NoirRed
8202211212시 ~ 18시수정상매장<NA>미선택와인330만원대10만원대카드<NA>프랑스Bourgogne2020750ml11.5Vin de FranceAligote 90%, Pinot Noir 10%Sparkling
9202211312시 ~ 18시목정상매장<NA>미선택비주류11만원대1만원대카드<NA><NA><NA><NA>100g<NA><NA><NA><NA>
YEAR_PAYMONTH_PAYDAY_PAYHOUR_PAYDATE_PAYFG_SALESFG_SYSTEMAGEGENDERTYPEQUANTITYAM_TOTALAM_SALEPAYMENTCOUPONCOUNTRYREGIONVINTAGESTANDARDALCOHOLCLASSGRAPE_VARIETYWINE_TYPE
112202321112시 ~ 18시토정상매장<NA>미선택와인110만원대10만원대카드<NA>프랑스Bourgogne2019750ml13.5VillageChardonnayWhite
113202321112시 ~ 18시토정상매장<NA>미선택비주류11만원 미만1만원 미만카드<NA><NA><NA><NA><NA><NA><NA><NA><NA>
114202321108시 ~ 11시토정상온라인몰30대여성와인15만원대5만원대카드비티스몰 쿠폰프랑스Beaujolais2021750ml<NA>VillageGamayRed
115202321312시 ~ 18시월정상온라인몰40대남성와인370만원대20만원대카드비티스몰 쿠폰프랑스Bourgogne2018750ml<NA>1er CruChardonnayWhite
116202321312시 ~ 18시월정상온라인몰30대남성와인310만원대6만원대카드비티스몰 쿠폰미국California2019750ml15<NA>Cabernet SauvignonRed
117202321412시 ~ 18시화정상매장<NA>미선택와인310만원대5만원대카드<NA>뉴질랜드Martinborough2020750ml14<NA>Pinot NoirRed
118202321412시 ~ 18시화정상매장<NA>미선택와인18만원대8만원대카드<NA>프랑스Bourgogne2019750ml13RegionaleAligoteWhite
119202321412시 ~ 18시화정상매장<NA>미선택와인110만원대10만원대카드<NA>프랑스Bourgogne2019750ml13.5VillageChardonnayWhite
120202321412시 ~ 18시화정상매장<NA>미선택와인110만원대10만원대카드<NA>프랑스Bourgogne2019750ml14VillageChardonnayWhite
121202321512시 ~ 18시수정상매장<NA>미선택와인18만원대8만원대카드<NA>프랑스Bourgogne2019750ml13.5VillagePinot NoirRed

Duplicate rows

Most frequently occurring

YEAR_PAYMONTH_PAYDAY_PAYHOUR_PAYDATE_PAYFG_SALESFG_SYSTEMAGEGENDERTYPEQUANTITYAM_TOTALAM_SALEPAYMENTCOUPONCOUNTRYREGIONVINTAGESTANDARDALCOHOLCLASSGRAPE_VARIETYWINE_TYPE# duplicates
02022111512시 ~ 18시화정상매장<NA>미선택와인110만원대10만원대카드<NA>미국Oregon2018750ml14.5<NA>Pinot NoirRed2