Overview

Dataset statistics

Number of variables26
Number of observations28
Missing cells1
Missing cells (%)0.1%
Duplicate rows1
Duplicate rows (%)3.6%
Total size in memory6.0 KiB
Average record size in memory218.7 B

Variable types

Numeric3
Categorical21
Boolean2

Dataset

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

Alerts

결제일시_년 has constant value ""Constant
품목분류 has constant value ""Constant
결제수단 has constant value ""Constant
Dataset has 1 (3.6%) duplicate rowsDuplicates
결제일시_시간대 is highly imbalanced (62.9%)Imbalance
매출구분 is highly imbalanced (77.8%)Imbalance
품목할인여부 is highly imbalanced (50.9%)Imbalance
주문할인여부(쿠폰 등) is highly imbalanced (50.9%)Imbalance
국가 is highly imbalanced (77.8%)Imbalance
규격 is highly imbalanced (77.8%)Imbalance
알코올도수 has 1 (3.6%) missing valuesMissing

Reproduction

Analysis started2024-03-13 16:16:22.582965
Analysis finished2024-03-13 16:16:22.929013
Duration0.35 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

픽업일자
Real number (ℝ)

Distinct8
Distinct (%)28.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20230379
Minimum20230102
Maximum20230721
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2024-03-14T01:16:22.977298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20230102
5-th percentile20230102
Q120230264
median20230319
Q320230719
95-th percentile20230720
Maximum20230721
Range619
Interquartile range (IQR)455.75

Descriptive statistics

Standard deviation236.85493
Coefficient of variation (CV)1.1707884 × 10-5
Kurtosis-1.1675162
Mean20230379
Median Absolute Deviation (MAD)216.5
Skewness0.49707691
Sum5.6645061 × 108
Variance56100.258
MonotonicityIncreasing
2024-03-14T01:16:23.076388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
20230102 6
21.4%
20230317 6
21.4%
20230720 6
21.4%
20230319 4
14.3%
20230320 3
10.7%
20230103 1
 
3.6%
20230719 1
 
3.6%
20230721 1
 
3.6%
ValueCountFrequency (%)
20230102 6
21.4%
20230103 1
 
3.6%
20230317 6
21.4%
20230319 4
14.3%
20230320 3
10.7%
20230719 1
 
3.6%
20230720 6
21.4%
20230721 1
 
3.6%
ValueCountFrequency (%)
20230721 1
 
3.6%
20230720 6
21.4%
20230719 1
 
3.6%
20230320 3
10.7%
20230319 4
14.3%
20230317 6
21.4%
20230103 1
 
3.6%
20230102 6
21.4%

결제일시_년
Categorical

CONSTANT 

Distinct1
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023
28 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023
2nd row2023
3rd row2023
4th row2023
5th row2023

Common Values

ValueCountFrequency (%)
2023 28
100.0%

Length

2024-03-14T01:16:23.229892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:23.319999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023 28
100.0%

결제일시_월
Categorical

Distinct5
Distinct (%)17.9%
Missing0
Missing (%)0.0%
Memory size356.0 B
3
13 
1
7 
7
5 
6
2 
5
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)3.6%

Sample

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

Common Values

ValueCountFrequency (%)
3 13
46.4%
1 7
25.0%
7 5
 
17.9%
6 2
 
7.1%
5 1
 
3.6%

Length

2024-03-14T01:16:23.415871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:23.524056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 13
46.4%
1 7
25.0%
7 5
 
17.9%
6 2
 
7.1%
5 1
 
3.6%

결제일시_일
Real number (ℝ)

Distinct7
Distinct (%)25.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.392857
Minimum2
Maximum28
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2024-03-14T01:16:23.646298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile2
Q113.5
median19
Q320
95-th percentile26.25
Maximum28
Range26
Interquartile range (IQR)6.5

Descriptive statistics

Standard deviation8.2432432
Coefficient of variation (CV)0.53552392
Kurtosis-0.61361354
Mean15.392857
Median Absolute Deviation (MAD)2
Skewness-0.77794327
Sum431
Variance67.951058
MonotonicityNot monotonic
2024-03-14T01:16:23.796780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
20 7
25.0%
2 6
21.4%
17 6
21.4%
19 5
17.9%
28 2
 
7.1%
3 1
 
3.6%
23 1
 
3.6%
ValueCountFrequency (%)
2 6
21.4%
3 1
 
3.6%
17 6
21.4%
19 5
17.9%
20 7
25.0%
23 1
 
3.6%
28 2
 
7.1%
ValueCountFrequency (%)
28 2
 
7.1%
23 1
 
3.6%
20 7
25.0%
19 5
17.9%
17 6
21.4%
3 1
 
3.6%
2 6
21.4%

결제일시_시간대
Categorical

IMBALANCE 

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
12시 ~ 18시
26 
19시 ~ 23시
 
2

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row12시 ~ 18시
2nd row12시 ~ 18시
3rd row12시 ~ 18시
4th row12시 ~ 18시
5th row12시 ~ 18시

Common Values

ValueCountFrequency (%)
12시 ~ 18시 26
92.9%
19시 ~ 23시 2
 
7.1%

Length

2024-03-14T01:16:23.924952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:24.033775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
28
33.3%
12시 26
31.0%
18시 26
31.0%
19시 2
 
2.4%
23시 2
 
2.4%

결제요일
Categorical

Distinct6
Distinct (%)21.4%
Missing0
Missing (%)0.0%
Memory size356.0 B
월
9 
수
8 
일
4 
목
4 
화
2 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)3.6%

Sample

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

Common Values

ValueCountFrequency (%)
월 9
32.1%
수 8
28.6%
일 4
14.3%
목 4
14.3%
화 2
 
7.1%
금 1
 
3.6%

Length

2024-03-14T01:16:24.123468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:24.219116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
월 9
32.1%
수 8
28.6%
일 4
14.3%
목 4
14.3%
화 2
 
7.1%
금 1
 
3.6%

영수증번호
Categorical

Distinct9
Distinct (%)32.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
3
6 
O_230317151312_001AC
5 
1
4 
2
4 
O_230319123614_000D3
4 
Other values (4)
5 

Length

Max length20
Median length11
Mean length9.8571429
Min length1

Unique

Unique3 ?
Unique (%)10.7%

Sample

1st row1
2nd row2
3rd row3
4th row3
5th row3

Common Values

ValueCountFrequency (%)
3 6
21.4%
O_230317151312_001AC 5
17.9%
1 4
14.3%
2 4
14.3%
O_230319123614_000D3 4
14.3%
O_230628183720_0042F 2
 
7.1%
O_230317143730_003F9 1
 
3.6%
13 1
 
3.6%
O_230523192601_0005D 1
 
3.6%

Length

2024-03-14T01:16:24.338668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:24.466744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3 6
21.4%
o_230317151312_001ac 5
17.9%
1 4
14.3%
2 4
14.3%
o_230319123614_000d3 4
14.3%
o_230628183720_0042f 2
 
7.1%
o_230317143730_003f9 1
 
3.6%
13 1
 
3.6%
o_230523192601_0005d 1
 
3.6%

매출구분
Categorical

IMBALANCE 

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
정상
27 
반품
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)3.6%

Sample

1st row정상
2nd row정상
3rd row정상
4th row정상
5th row정상

Common Values

ValueCountFrequency (%)
정상 27
96.4%
반품 1
 
3.6%

Length

2024-03-14T01:16:24.625508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:24.735898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 27
96.4%
반품 1
 
3.6%

구매처
Categorical

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
매장
15 
온라인몰
13 

Length

Max length4
Median length2
Mean length2.9285714
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
매장 15
53.6%
온라인몰 13
46.4%

Length

2024-03-14T01:16:24.865823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:24.990578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
매장 15
53.6%
온라인몰 13
46.4%

연령대
Categorical

Distinct4
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size356.0 B
<NA>
17 
30대
6 
50대
4 
40대
 
1

Length

Max length4
Median length4
Mean length3.6071429
Min length3

Unique

Unique1 ?
Unique (%)3.6%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 17
60.7%
30대 6
 
21.4%
50대 4
 
14.3%
40대 1
 
3.6%

Length

2024-03-14T01:16:25.108843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:25.208814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 17
60.7%
30대 6
 
21.4%
50대 4
 
14.3%
40대 1
 
3.6%

성별
Categorical

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
<NA>
17 
남성
11 

Length

Max length4
Median length4
Mean length3.2142857
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
<NA> 17
60.7%
남성 11
39.3%

Length

2024-03-14T01:16:25.343842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:25.447294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 17
60.7%
남성 11
39.3%

품목분류
Categorical

CONSTANT 

Distinct1
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size356.0 B
와인
28 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
와인 28
100.0%

Length

2024-03-14T01:16:25.559628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:25.649555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
와인 28
100.0%

구매수량
Categorical

Distinct3
Distinct (%)10.7%
Missing0
Missing (%)0.0%
Memory size356.0 B
1
20 
2
5 
3
3 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1 20
71.4%
2 5
 
17.9%
3 3
 
10.7%

Length

2024-03-14T01:16:25.749648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:25.869964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1 20
71.4%
2 5
 
17.9%
3 3
 
10.7%

실결제금액대
Categorical

Distinct6
Distinct (%)21.4%
Missing0
Missing (%)0.0%
Memory size356.0 B
10만원대
14 
8만원대
7 
20만원대
4 
6만원대
 
1
7만원대
 
1

Length

Max length5
Median length5
Mean length4.6785714
Min length4

Unique

Unique3 ?
Unique (%)10.7%

Sample

1st row6만원대
2nd row10만원대
3rd row10만원대
4th row8만원대
5th row10만원대

Common Values

ValueCountFrequency (%)
10만원대 14
50.0%
8만원대 7
25.0%
20만원대 4
 
14.3%
6만원대 1
 
3.6%
7만원대 1
 
3.6%
50만원대 1
 
3.6%

Length

2024-03-14T01:16:26.025107image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:26.160054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10만원대 14
50.0%
8만원대 7
25.0%
20만원대 4
 
14.3%
6만원대 1
 
3.6%
7만원대 1
 
3.6%
50만원대 1
 
3.6%

제품단가대
Categorical

Distinct8
Distinct (%)28.6%
Missing0
Missing (%)0.0%
Memory size356.0 B
10만원대
13 
9만원대
5 
8만원대
3 
7만원대
2 
5만원대
2 
Other values (3)
3 

Length

Max length5
Median length5
Mean length4.5357143
Min length4

Unique

Unique3 ?
Unique (%)10.7%

Sample

1st row7만원대
2nd row10만원대
3rd row10만원대
4th row9만원대
5th row20만원대

Common Values

ValueCountFrequency (%)
10만원대 13
46.4%
9만원대 5
 
17.9%
8만원대 3
 
10.7%
7만원대 2
 
7.1%
5만원대 2
 
7.1%
20만원대 1
 
3.6%
6만원대 1
 
3.6%
60만원대 1
 
3.6%

Length

2024-03-14T01:16:26.304082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:26.415546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
10만원대 13
46.4%
9만원대 5
 
17.9%
8만원대 3
 
10.7%
7만원대 2
 
7.1%
5만원대 2
 
7.1%
20만원대 1
 
3.6%
6만원대 1
 
3.6%
60만원대 1
 
3.6%

결제수단
Categorical

CONSTANT 

Distinct1
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size356.0 B
카드
28 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row카드
2nd row카드
3rd row카드
4th row카드
5th row카드

Common Values

ValueCountFrequency (%)
카드 28
100.0%

Length

2024-03-14T01:16:26.544100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:26.665312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
카드 28
100.0%

품목할인여부
Boolean

IMBALANCE 

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size160.0 B
False
25 
True
3 
ValueCountFrequency (%)
False 25
89.3%
True 3
 
10.7%
2024-03-14T01:16:26.743440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

주문할인여부(쿠폰 등)
Boolean

IMBALANCE 

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size160.0 B
True
25 
False
3 
ValueCountFrequency (%)
True 25
89.3%
False 3
 
10.7%
2024-03-14T01:16:26.819312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

국가
Categorical

IMBALANCE 

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
프랑스
27 
미국
 
1

Length

Max length3
Median length3
Mean length2.9642857
Min length2

Unique

Unique1 ?
Unique (%)3.6%

Sample

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

Common Values

ValueCountFrequency (%)
프랑스 27
96.4%
미국 1
 
3.6%

Length

2024-03-14T01:16:26.926655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:27.027001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
프랑스 27
96.4%
미국 1
 
3.6%

지역
Categorical

Distinct4
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size356.0 B
Bourgogne
19 
Champagne
6 
Alsace
2 
Oregon
 
1

Length

Max length9
Median length9
Mean length8.6785714
Min length6

Unique

Unique1 ?
Unique (%)3.6%

Sample

1st rowBourgogne
2nd rowBourgogne
3rd rowBourgogne
4th rowChampagne
5th rowChampagne

Common Values

ValueCountFrequency (%)
Bourgogne 19
67.9%
Champagne 6
 
21.4%
Alsace 2
 
7.1%
Oregon 1
 
3.6%

Length

2024-03-14T01:16:27.359897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:27.474843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
bourgogne 19
67.9%
champagne 6
 
21.4%
alsace 2
 
7.1%
oregon 1
 
3.6%

빈티지
Categorical

Distinct8
Distinct (%)28.6%
Missing0
Missing (%)0.0%
Memory size356.0 B
2020
13 
NV
4 
2019
3 
2017
3 
2018
2 
Other values (3)
3 

Length

Max length4
Median length4
Mean length3.7142857
Min length2

Unique

Unique3 ?
Unique (%)10.7%

Sample

1st row2019
2nd row2017
3rd row2019
4th rowNV
5th rowNV

Common Values

ValueCountFrequency (%)
2020 13
46.4%
NV 4
 
14.3%
2019 3
 
10.7%
2017 3
 
10.7%
2018 2
 
7.1%
2009 1
 
3.6%
2008 1
 
3.6%
2012 1
 
3.6%

Length

2024-03-14T01:16:27.589367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:27.728577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 13
46.4%
nv 4
 
14.3%
2019 3
 
10.7%
2017 3
 
10.7%
2018 2
 
7.1%
2009 1
 
3.6%
2008 1
 
3.6%
2012 1
 
3.6%

규격
Categorical

IMBALANCE 

Distinct2
Distinct (%)7.1%
Missing0
Missing (%)0.0%
Memory size356.0 B
750ml
27 
1500ml
 
1

Length

Max length6
Median length5
Mean length5.0357143
Min length5

Unique

Unique1 ?
Unique (%)3.6%

Sample

1st row750ml
2nd row750ml
3rd row750ml
4th row750ml
5th row1500ml

Common Values

ValueCountFrequency (%)
750ml 27
96.4%
1500ml 1
 
3.6%

Length

2024-03-14T01:16:27.844295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:27.937544image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
750ml 27
96.4%
1500ml 1
 
3.6%

알코올도수
Real number (ℝ)

MISSING 

Distinct6
Distinct (%)22.2%
Missing1
Missing (%)3.6%
Infinite0
Infinite (%)0.0%
Mean13.111111
Minimum12
Maximum14.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2024-03-14T01:16:28.025930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum12
5-th percentile12
Q112.5
median13
Q313.75
95-th percentile14.5
Maximum14.5
Range2.5
Interquartile range (IQR)1.25

Descriptive statistics

Standard deviation0.85859157
Coefficient of variation (CV)0.065485798
Kurtosis-1.0711803
Mean13.111111
Median Absolute Deviation (MAD)0.5
Skewness0.56270111
Sum354
Variance0.73717949
MonotonicityNot monotonic
2024-03-14T01:16:28.156936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
12.5 10
35.7%
14.5 5
17.9%
13.0 4
 
14.3%
13.5 3
 
10.7%
12.0 3
 
10.7%
14.0 2
 
7.1%
(Missing) 1
 
3.6%
ValueCountFrequency (%)
12.0 3
 
10.7%
12.5 10
35.7%
13.0 4
 
14.3%
13.5 3
 
10.7%
14.0 2
 
7.1%
14.5 5
17.9%
ValueCountFrequency (%)
14.5 5
17.9%
14.0 2
 
7.1%
13.5 3
 
10.7%
13.0 4
 
14.3%
12.5 10
35.7%
12.0 3
 
10.7%

등급
Categorical

Distinct4
Distinct (%)14.3%
Missing0
Missing (%)0.0%
Memory size356.0 B
Village
18 
Regionale
4 
1er Cru
3 
<NA>
3 

Length

Max length9
Median length7
Mean length6.9642857
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowVillage
2nd row1er Cru
3rd rowVillage
4th rowVillage
5th rowVillage

Common Values

ValueCountFrequency (%)
Village 18
64.3%
Regionale 4
 
14.3%
1er Cru 3
 
10.7%
<NA> 3
 
10.7%

Length

2024-03-14T01:16:28.305248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:28.415147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
village 18
58.1%
regionale 4
 
12.9%
1er 3
 
9.7%
cru 3
 
9.7%
na 3
 
9.7%

포도품종
Categorical

Distinct5
Distinct (%)17.9%
Missing0
Missing (%)0.0%
Memory size356.0 B
Pinot Noir
19 
Chardonnay
5 
Auxerrois, Pinot Blanc, Pinot Gris
2 
Pinot Noir 55%, Pinot Meunier 45%
 
1
Chardonnay 70%, Pinot Blanc 30%
 
1

Length

Max length34
Median length10
Mean length13.321429
Min length10

Unique

Unique2 ?
Unique (%)7.1%

Sample

1st rowPinot Noir
2nd rowPinot Noir
3rd rowChardonnay
4th rowChardonnay
5th rowChardonnay

Common Values

ValueCountFrequency (%)
Pinot Noir 19
67.9%
Chardonnay 5
 
17.9%
Auxerrois, Pinot Blanc, Pinot Gris 2
 
7.1%
Pinot Noir 55%, Pinot Meunier 45% 1
 
3.6%
Chardonnay 70%, Pinot Blanc 30% 1
 
3.6%

Length

2024-03-14T01:16:28.519875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:28.623653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
pinot 26
40.6%
noir 20
31.2%
chardonnay 6
 
9.4%
blanc 3
 
4.7%
auxerrois 2
 
3.1%
gris 2
 
3.1%
55 1
 
1.6%
meunier 1
 
1.6%
45 1
 
1.6%
70 1
 
1.6%

와인종류
Categorical

Distinct3
Distinct (%)10.7%
Missing0
Missing (%)0.0%
Memory size356.0 B
Red
19 
Sparkling
6 
White
3 

Length

Max length9
Median length3
Mean length4.5
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowRed
2nd rowRed
3rd rowWhite
4th rowSparkling
5th rowSparkling

Common Values

ValueCountFrequency (%)
Red 19
67.9%
Sparkling 6
 
21.4%
White 3
 
10.7%

Length

2024-03-14T01:16:28.755605image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-14T01:16:28.856597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
red 19
67.9%
sparkling 6
 
21.4%
white 3
 
10.7%

Sample

픽업일자결제일시_년결제일시_월결제일시_일결제일시_시간대결제요일영수증번호매출구분구매처연령대성별품목분류구매수량실결제금액대제품단가대결제수단품목할인여부주문할인여부(쿠폰 등)국가지역빈티지규격알코올도수등급포도품종와인종류
02023010220231212시 ~ 18시월1정상매장<NA><NA>와인16만원대7만원대카드NY프랑스Bourgogne2019750ml13.0VillagePinot NoirRed
12023010220231212시 ~ 18시월2정상매장<NA><NA>와인110만원대10만원대카드NY프랑스Bourgogne2017750ml12.51er CruPinot NoirRed
22023010220231212시 ~ 18시월3정상매장<NA><NA>와인110만원대10만원대카드NY프랑스Bourgogne2019750ml14.0VillageChardonnayWhite
32023010220231212시 ~ 18시월3정상매장<NA><NA>와인18만원대9만원대카드NY프랑스ChampagneNV750ml12.5VillageChardonnaySparkling
42023010220231212시 ~ 18시월3정상매장<NA><NA>와인110만원대20만원대카드NY프랑스ChampagneNV1500ml12.5VillageChardonnaySparkling
52023010220231212시 ~ 18시월3정상매장<NA><NA>와인18만원대9만원대카드NY프랑스ChampagneNV750ml12.5VillageChardonnaySparkling
62023010320231312시 ~ 18시화1정상매장<NA><NA>와인110만원대10만원대카드NY미국Oregon2018750ml14.5<NA>Pinot NoirRed
720230317202331712시 ~ 18시금O_230317143730_003F9정상온라인몰30대남성와인110만원대10만원대카드NN프랑스Bourgogne2020750ml13.5VillagePinot NoirRed
820230317202331712시 ~ 18시수O_230317151312_001AC정상온라인몰30대남성와인210만원대9만원대카드NY프랑스Bourgogne2020750ml12.5VillagePinot NoirRed
920230317202331712시 ~ 18시수O_230317151312_001AC정상온라인몰30대남성와인310만원대6만원대카드NY프랑스Bourgogne2020750ml13.0RegionalePinot NoirRed
픽업일자결제일시_년결제일시_월결제일시_일결제일시_시간대결제요일영수증번호매출구분구매처연령대성별품목분류구매수량실결제금액대제품단가대결제수단품목할인여부주문할인여부(쿠폰 등)국가지역빈티지규격알코올도수등급포도품종와인종류
1820230320202332012시 ~ 18시월2정상매장<NA><NA>와인220만원대10만원대카드NY프랑스Bourgogne2020750ml13.0RegionalePinot NoirRed
1920230320202332012시 ~ 18시월2정상매장<NA><NA>와인220만원대10만원대카드NY프랑스Bourgogne2020750ml12.5VillagePinot NoirRed
2020230719202371919시 ~ 23시수13정상매장<NA><NA>와인110만원대10만원대카드NY프랑스ChampagneNV750ml12.5VillagePinot Noir 55%, Pinot Meunier 45%Sparkling
2120230720202372012시 ~ 18시목1반품매장<NA><NA>와인310만원대5만원대카드NY프랑스Alsace2017750ml14.5<NA>Auxerrois, Pinot Blanc, Pinot GrisWhite
2220230720202372012시 ~ 18시목2정상매장<NA><NA>와인310만원대5만원대카드NY프랑스Alsace2017750ml14.5<NA>Auxerrois, Pinot Blanc, Pinot GrisWhite
2320230720202372012시 ~ 18시목3정상매장<NA><NA>와인110만원대10만원대카드NY프랑스Bourgogne2009750ml<NA>1er CruPinot NoirRed
2420230720202372012시 ~ 18시목3정상매장<NA><NA>와인17만원대7만원대카드NY프랑스Bourgogne2008750ml12.5RegionalePinot NoirRed
2520230720202362812시 ~ 18시수O_230628183720_0042F정상온라인몰<NA><NA>와인110만원대10만원대카드YY프랑스Champagne2018750ml12.0VillageChardonnay 70%, Pinot Blanc 30%Sparkling
2620230720202362812시 ~ 18시수O_230628183720_0042F정상온라인몰<NA><NA>와인150만원대60만원대카드YY프랑스Champagne2012750ml12.51er CruChardonnaySparkling
2720230721202352319시 ~ 23시화O_230523192601_0005D정상온라인몰40대남성와인18만원대8만원대카드YN프랑스Bourgogne2019750ml13.0RegionalePinot NoirRed

Duplicate rows

Most frequently occurring

픽업일자결제일시_년결제일시_월결제일시_일결제일시_시간대결제요일영수증번호매출구분구매처연령대성별품목분류구매수량실결제금액대제품단가대결제수단품목할인여부주문할인여부(쿠폰 등)국가지역빈티지규격알코올도수등급포도품종와인종류# duplicates
02023010220231212시 ~ 18시월3정상매장<NA><NA>와인18만원대9만원대카드NY프랑스ChampagneNV750ml12.5VillageChardonnaySparkling2