Craft Beer Analysis
Let's start with a couple of SQL queries
SELECT name, style, abv, ibu FROM beers.csv WHERE abv > .03 AND ibu <60
Run to view results
SELECT name, style, abv, ibu FROM beers.csv
WHERE style LIKE '%IPA%'
OR style LIKE '%Lager%'
OR style LIKE '%Porter%'
OR style LIKE '%Pilsner%'
Run to view results
Now let's switch to Python
# import the libraries we need
import numpy as np
import pandas as pd
Run to view results
# create a new variable to identify IPA beers
beers['IPA'] = np.where(beers['style'].str.contains("IPA"), True, False)
beers['IPA'].describe()
Run to view results
# and another variable to identify American beers
beers['American'] = np.where(beers['style'].str.contains("American"), True, False)
beers['American'].describe()
Run to view results
Create some visualizations using Deepnote
Run to view results
Run to view results
# save your updated dataset
beers.to_csv('beers.csv')
Run to view results