beverages Archives - DexLab Analytics | Big Data Hadoop SAS R Analytics Predictive Modeling & Excel VBA

How do you Like your Coffee? Strong with a Lot of Numbers!?

How-do-you-like-your-coffee

 

In the health conscious world today, people are often engaging in hot debates as to which drinks have the most and least amounts of caffeine in them. But as data analysts we do not like to engage in any critical discussion without having a few graphs to show for our arguments! So, the moment someone put the kettle on, we turned on our computers to sip a cuppa and make a few caffeinated graphs.

The moment we head on to a cafe or a breakfast joint these days, we are bombarded with a long list of beverages which include an assortment of coffees, tea and other sugary drinks that promise to refresh our Monday-blues thirst with a shot of energizing elixir! It is not only spoiling to have so many options, but in fact confusing to say the least when the waiter/waitress keenly asks us how we would like our coffee.

But coffee, that is dubbed as the Devil’s juice (which I believe, further adds to its charm) is known to be bad for our health when drunk too much. So, we analysed and researched and downloaded some of the data of caffeine in various drinks like tea, soda and different blends of coffee pasted them on an Excel sheet and then used Proc Import to feed and read the data into SAS datasets.

The problem we faced next was that each category still had a few too many drinks to get a quick mental grasp on the matter (i.e. typically 100+). So, we took a two stage approach. The first thing we did was to plot just a handful of drinks in each of the categories which we then recognized as we have or want to drink, and then we plotted the entire list. The images of the small subset graphs are attached below:

 

1

Here’s a graph of caffeine content in the most popular coffees:

2

 

3

Here is the complete list of data for all coffees:

Drink

Fluid ounces

Caffeine

mg Caffeine

  (mg)per fluid oz
Nescafe Ice Java0.9100117.6
Stok Black Coffee Shots0.44090.9
Coffee Crave Fearless Black1284470.3
Chameleon Cold Brew Coffee32216067.5
Black Insomnia Coffee1270258.5
Death Wish Coffee1266055
Coffee (Espresso)1.57751.3
Killer Coffee8.543050.8
Biggby Espresso210050
Gourmesso Coffee Pods1.46548.1
Bizzy Cold Brew1675046.9
Peet’s Coffee Espresso1.57046.7
Nespresso Coffee Capsules1.46044.4
Robusta Coffee826533.1
Gloria Jean’s Coffee26733
Shock Coffee Triple Latte823128.9
Chameleon Cold Brew RTD Coffee1027027
Stumptown Cold Brew Coffee10.527926.6
Long Black615425.7
Greek Coffee (Metrios)25025
Turkish Coffee25025
Illy Issimo Cafe6.815522.8
Seattle’s Best Brewed Coffee1226021.7
Stumptown Cold Brew Chocolate + Milk1634021.2
Coffee Bean & Tea leaf Coffee1633320.8
Starbucks Grande Coffee1633020.6
Coffee (Brewed)816320.4
High Brew Coffee816320.4
Stumptown Cold Brew + Milk1631919.9
Starbucks Doubleshot6.512519.2
Caribou Brewed Coffee1630519.1
Black Medicine Iced Coffee1120618.7
TrueStart Performance Coffee5.19518.6
Costa Coffee15.227718.2
Bulletproof Coffee814518.1
Don Tomas Estate Coffee814518.1
Starbucks Via Ready Brew813516.9
Peet’s Brewed Coffee1626716.7
Gold Peak Coffee812615.8
Cafe Viva Probiotic Coffee812515.6
Dunkin’ Donuts Brewed Coffee1421015
K-Cup Coffee812015
Keurig Vue Pack1218015
Starbucks Grande Caffe Americano1622514.1
Starbucks Iced Espresso1622514.1
Starbucks Latte Macchiato1622514.1
Barista Bros Iced Coffee16.921913
Einstein Bros Coffee1620612.9
Americano Coffee1215412.8
Cappuccino1215412.8
Dutch Bros. Coffee2025612.8
Caffe Mocha1215212.7
Starbucks Protein and Coffee1114012.7
Biggby Brewed Coffee1620012.5
Starbucks Cold Brew Coffee1620012.5
Dunkin’ Donuts Iced Coffee2429712.4
Biggby Iced Coffee1619212
Panera Bread Coffee1618911.8
Pronto Coffee66711.2
Muscle Milk Coffee House1112010.9
Starbucks Grande Caffe Mocha1617510.9
Dunkin’ Donuts Latte1415110.8
Dunkin’ Donuts Mocha1415110.8
Vita Coco Cafe11.112010.8
Starbucks Discoveries Caffe Mocha50.753910.6
Starbucks Bottled Iced Coffee1111510.5
McDonalds (McCafe) Mocha1616710.4
Peet’s Caffe Mocha1616510.3
Peet’s Iced Mocha1616510.3
Tim Hortons Large Brewed Coffee2020010
Baskin Robbins Cappuccino Blast242349.8
Starbucks Doubleshot Energy + Coffee151459.7
Latte161549.6
Dare Iced Coffee16.91609.5
Starbucks Bottled Frappuccino9.5909.5
Peet’s Iced Coffee161509.4
Starbucks Grande Caffe Latte161509.4
Starbucks Grande Cappuccino161509.4
Flat White8.5779.1
McDonalds Coffee161459.1
McDonalds Iced Coffee222009.1
V Double Espresso Iced Coffee16.11479.1
Bean and Body Coffee8729
McDonalds (McCafe) Latte161428.9
Peet’s Caffe Americano161408.8
Peet’s Caffe Latte161408.8
Peet’s Cappuccino161408.8
Peet’s Iced Latte161408.8
Skinny Cow Iced Coffee8708.8
International Delight Iced Coffee8658.1
Starbucks Verismo Coffee Pods8607.5
Coffee (Instant)8577.1
Zola Coconut Water Espresso17.51257.1
Real Beanz Iced Coffee9.5666.9
Caffe Nero Coffee12806.7
Chick-fil-A Iced Coffee14946.7
Peet’s Decaf Espresso1.5106.7
Dunkin’ Donuts Iced Latte241516.3
Biggby Creamy Lattes161006.2
Biggby Frozen Lattes161006.2
Big Train Java Chip Ice Coffee8496.1
CoolBrew Coffee10606
Tim Hortons Small English Toffee Coffee10606
Tim Hortons Small French Vanilla Coffee10606
Dunkin’ Donuts Dunkaccino14835.9
Svelte Cappuccino Protein Shake11655.9
SlimFast Cappuccino Delight Shake10404
Choffy (roasted cacao)6233.8
Starbucks Refreshers16503.1
Indulgio Cappuccino8202.5
Starbucks Decaf Coffee16251.6
Coffee Leaf Tea8121.5
Dunkin’ Donuts Coolatta24180.8
Nescafe’ Ricoffy860.8
Arby’s Jamocha Shake16120.7
Coffee (Decaf, Brewed)860.7
Coffee (Decaf, Instant)830.3

Detailed data on all kinds of popular sodas:

DrinkFluid ouncesCaffeinemg Caffeine
(mg)per fluid oz
Bawls Exxtra161509.4
Blink Energy Water16.91508.9
Flatt Cola8658.1
Afri Cola12897.4
Fritz Kola11.2837.4
Premium Cola11.2837.4
Hansen’s Diet Red8.3576.9
Bawls10646.4
Bawls Orange10646.4
Bawls Cherry161006.2
Bawls Root Beer161006.2
Mountain Dew Game Fuel201216
Monster Mutant201155.8
Pepsi Max12695.8
Ski Soda12695.8
Sun Drop Soda12645.3
Mountain Dew Black Label16835.2
DOC 360201005
Mountain Dew Voltage12554.6
Diet Mountain Dew12544.5
Mountain Dew12544.5
Mountain Dew Baja Blast16724.5
Mountain Dew Live Wire12544.5
Pepsi One12544.5
Cult Cola16.9754.4
Surge Citrus Soda16694.3
Dr Pepper 1012514.2
Mello Yello12514.2
Mello Yello Zero12514.2
Starbucks Refreshers Canned12504.2
Cheerwine12484
Diet Cheerwine12484
Diet RC Cola12473.9
Diet Coke12463.8
Diet Coke Plus12453.8
Diet Coke with Lemon12453.8
Diet Coke with Lime12463.8
Diet Vanilla Coke12453.8
Hint Caffeine Kick Water16603.8
Soda Stream16603.8
TAB Diet Cola12453.8
Zevia Cola12453.8
RC Cola12433.6
RC Cola, Cherry12433.6
Shasta Cola12433.6
Diet Pepsi UK, AU, NZ12433.5
Diet Sunkist Orange Soda12423.5
Faygo Cola12423.5
Pepsi Max UK, NZ, AU12433.5
Diet Dr Pepper12413.4
Dr Pepper12413.4
Sunkist Orange Soda12413.4
Sunkist Sparkling Lemonade12413.4
Sunkist Ten20683.4
Diet Mr. Pibb12403.3
Honest Professor Fizz12403.3
Kickapoo Soda: Joy Juice & Fruit Shine12403.3
Pibb Xtra12403.3
Pibb Zero12403.3
Diet Dr Pepper Cherry12393.2
Diet Dr Pepper Cherry Vanilla12393.2
Diet Ruby Red Squirt12393.2
Diet Wild Cherry Pepsi12383.2
Dr Pepper Cherry12393.2
Dr Pepper Cherry Vanilla12393.2
Jazz Caramel Cream12383.2
Pepsi Cola12383.2
Pepsi Diet Lemon12383.2
Pepsi Diet Lime12383.2
Pepsi Diet Vanilla12383.2
Pepsi Throwback12383.2
Pepsi True7.5243.2
Ruby Red Squirt12393.2
TK Diet Cola12383.2
Wild Cherry Pepsi12383.2
Ale 8 112373.1
Crystal Pepsi20633.1
Inca Kola16503.1
Red Flash12373.1
Co-Operative Diet Cola16.9503
Double Cola12363
1893 Cola12342.8
Big Red Soda12342.8
Caffeinated Club Soda12342.8
Cherry Coke12342.8
Cherry Coke Zero12342.8
Coca-Cola Classic12342.8
Coke Zero12342.8
Diet Cherry Coca-Cola12342.8
Diet Coke with Splenda12342.8
Diet Pepsi12342.8
Vanilla Coke12342.8
Pepsi Next12322.7
Slurpee16402.5
A&W Cream Soda12292.4
Coca-Cola Life12282.3
Red Rock Cola12262.2
Barq’s Root Beer12221.8
Diet A&W Cream Soda12221.8
Pepsi Slurpee8141.8
Faygo Moon Mist12201.6
PC Cola Diet12131.1
PC Cola12121
Ritz Cola12100.9
Canada Dry Green Tea Ginger Ale1290.8
Boost Nutritional Drink850.6
7-Up1200
A&W Root Beer1200
Barq’s Red Creme Soda1200
Coca-Cola caffeine free1200
Diet Barq’s Root Beer1200
Fanta1200
Fresca1200
Ginger Ale or Ginger Beer1200
IBC Root Beer1200
Kinley Soda1200
Mug Root Beer1200
Orange Crush2000
Pepsi Caffeine Free1200
Sprite1200
Squirt Soda1200
Tonic Water11.900
Tropicana Twister Soda2000
Vernors Ginger Ale1200

While we are not too big a fan of the dancing bologna to be added into serious graphs, but in this we figured we would add a few minimalistic pictures of the drinks to make it easier to be distinguished.

Feel free to share how well your favourite drink fared in this very hotly debated list. And for more interesting data analysis news and Big Data courses stay tuned with DexLab Analytics. 

Call us to know more