By Dawn Washington, David Owens, and Grey Hardy
Description: In 2017 an entrepreneur wanted to open a brewery in the United States, USA. She needed to determine the top five styles of beer that contains the highest alcohol by volume (ABV) should be produced. A competitive location was identified by finding the top five states with the least number of competitors producing those beers in that state. She analyzed 2,410 US craft beers and 510 US breweries.
Business questions to answer:
- Which style has the highest alcohol by volume (ABV)?
- What is the most brewed style of beer?
- Which state(s) has the most selection of beers with highest alcohol by volume (ABV) rating?
- Which state(s) has the least selection of beers with highest alcohol by volume (ABV) rating? Potential Hypotheses:
- She assumes the beer with the highest alcohol by volume (ABV) is the most profitable.
A state not producing a large amount of high ABV beers would be the ideal location to open her brewery.
Data Sets:
- Craft Beers Dataset This dataset contains a list of 2,410 US craft beers and 510 US breweries. The beers and breweries are linked together by the "id". This data was collected in January 2017 from CraftCans.com.
Breakdown of tasks:
- Create GitHub repository
- Add dataset to GitHub
- Create readme
- Merge datasets
- Do analysis on beer styles
- Do analysis on brewery locations
- Create visualizations using Python analysis
- Create presentation using PowerPoint and include Python visualizations and provide explanations
Visualization ideas:
- Create a bar or line chart to display the highest alcohol by volume (ABV)
- Create a scatter or bar chart to display the state that has the most of that style
- Create a stacked bar chart to display the states that have the most selection of beers with the highest alcohol by volume (ABV)
- Create a stacked bar chart to display the states that have the least selection of beers with highest alcohol by volume (ABV)