Flavors of Cacao Nationwide Chocolate Ratings Tori Unger

  • Slides: 17
Download presentation
Flavors of Cacao Nationwide Chocolate Ratings Tori Unger DSCI 101 Fall 2018

Flavors of Cacao Nationwide Chocolate Ratings Tori Unger DSCI 101 Fall 2018

Reviews of Chocolate Flavors • Which country sells the best tasting chocolate? • What

Reviews of Chocolate Flavors • Which country sells the best tasting chocolate? • What makes chocolate tasty? • 10 Fields investigated • Company (Maker-if known) • Specific Bean Origin or Bar Name • REF • Review Date • Cocoa Percent • • • Company Location Rating Bean Type Broad Bean Origin Rating Description

My Data • Flavors of Cacao dataset from Kaggle. com • Originally from Flavors

My Data • Flavors of Cacao dataset from Kaggle. com • Originally from Flavors of Cacao database • Compressed CSV file • 30 k. B • 125 k. B

Cleaning the Data

Cleaning the Data

Cleaning Methods • Simple formatting • Fixing spaces • ’s everywhere Company (Maker-if known)

Cleaning Methods • Simple formatting • Fixing spaces • ’s everywhere Company (Maker-if known) Specific Bean Origin or Bar Company REF Review Date Cocoa Percent Location Name Askinosie San Jose del Tambo Bahen & Co. Rating Bean Type Forastero 3 (Arriba) 175 2007 0. 7 U. S. A. Houseblend 1474 2015 0. 8 Australia 3. 25 Bahen & Co. Papua New Guinea 1474 2015 0. 7 Australia 3. 5 Bahen & Co. Sambirano 995 2012 0. 7 Australia 3 Trinitario Broad Bean Origin Ecuador Papua New Guinea Madagascar

Cleaning Methods • Splitting cells • Consistency issues

Cleaning Methods • Splitting cells • Consistency issues

Analyzing the Fields This Photo by Unknown Author is licensed under CC BY-NC

Analyzing the Fields This Photo by Unknown Author is licensed under CC BY-NC

 • Cocoa Percent • Percent • 70% /1 6/ 905 1 29 2:

• Cocoa Percent • Percent • 70% /1 6/ 905 1 29 2: /1 00 9 0 : 0 6/ 30 5 12 0 A /1 M : 0 9 0 7/ 05 1 : 00 1/ A 2: 19 00 M 0 : 00 5 7/ A 2/ 12: 19 00 M 7/ 05 1 : 00 A 3/ 2: 19 00 M 0 : 00 5 7/ A 4/ 12: 19 00 M 7/ 05 1 : 00 A 5/ 2: 19 00 M 0 : 00 5 7/ A 6/ 12: 19 00 M 7/ 05 1 : 00 A 7/ 2: 19 00 M 0 : 00 5 7/ A 8/ 12: 19 00 M 0 : 0 5 7/ 0 A 9/ 12: 19 00 M 05 : 1 00 A 2: 00 M : 0 0 AM • Integer • 2007 6/ 28 Native Fields • Company • Text • Amedei Review Date Frequency 300 • Review Date 250 100 50 247 285 200 165 150 72 77 93 123 195 184 219 111 24 0

 • Company Location • Text • Italy • Rating • Based on flavor,

• Company Location • Text • Italy • Rating • Based on flavor, texture, after melt, and overall opinion Rating Frequency • Decimal • 3. 75 Italy France U. S. A. Brazil U. K. Belgium Switzerland Spain Sao Tome Guatemala Germany Madagascar Australia Scotland Ecuador Colombia Canada Venezuela New Zealand Amsterdam Argentina Bolivia Singapore Denmark Israel Poland Vietnam Lithuania Chile Iceland Hungary Austria Fiji Netherlands Peru Japan Costa Rica South Korea Domincan Republic Finland Philippines Honduras Sweden Russia St. Lucia Grenada Nicaragua Suriname Ireland Mexico South Africa Portugal Eucador Wales Martinique Puerto Rico Czech Republic Niacragua Ghana India Native Fields 764 Company Location Frequency 156 63 17 96 5. 00 125 40 38 25 4 10 35 17 49 10 54 23 20 17 4 9 2 3 15 9 8 11 6 2 3 22 26 4 4 17 17 9 5 5 2 1 6 5 1 2 3 5 1 4 4 3 3 1 1 1 4 1 1 392 341 303 259 210 98 127 2 14 4. 00 3. 75 3. 50 3. 25 3. 00 2. 75 2. 50 2. 25 32 2. 00 3 10 4 1. 75 1. 50 1. 00

Native Fields • Bean Type • Text • Trinitario • Broad Bean Origin •

Native Fields • Bean Type • Text • Trinitario • Broad Bean Origin • Text • Venezuela Average of Rating Row Labels Belize Bolivia Brazil Colombia Costa Rica Dom. Rep. , Madagascar Dominican Republic Ecuador Ghana Gre. , PNG, Haw. , Haiti, Mad Guat. , D. R. , Peru, Mad. , PNG Guatemala Haiti Indonesia Jamaica Madagascar Mexico Nicaragua Papua New Guinea Peru, Dom. Rep Sao Tome & Principe South America St. Lucia Tobago Unknown Ven, Bolivia, D. R. Venezuela, Java Vietnam Column Labels Amaz Criollo, Forastero on mix Beniano Blend Criollo Trinitario Forastero (Arriba) (Nacional) (Parazinho)Trinitario 4. 00 4. 00 4. 33 4. 00 4. 17 4. 00

Derived Fields Rating Description

Derived Fields Rating Description

Conclusions

Conclusions

Where is the Highest Rated Chocolate? • Amedei company in Italy

Where is the Highest Rated Chocolate? • Amedei company in Italy

What Factors Contribute to the Tastiest Chocolate? • Cocoa Percent

What Factors Contribute to the Tastiest Chocolate? • Cocoa Percent

What Factors Contribute to the Tastiest Chocolate? • Type of Bean

What Factors Contribute to the Tastiest Chocolate? • Type of Bean

Future Work • Fix the Specific Bean Origin or Bar Name • Names of

Future Work • Fix the Specific Bean Origin or Bar Name • Names of chocolate bars • Impacts on ratings • Reviewers • Same people? • Why significant drop in 2017?

Questions or Comments? Thank you for your time!

Questions or Comments? Thank you for your time!