Analyzing Beer

Presented at the Florida Brewers Guild annual meeting 2019

Transcript

1. Analyzing Beer D a t a d r i v e n d e c i s i o n m a k i n g i n t h e b r e w h o u s e F B G A n n u a l C o n f e r e n c e A u g u s t 7 t h , 2 0 1 9 A r t h u r R u d o l p h P h D @ c r a f t b e e r s c i J a v i e r a R u d o l p h @ j a v i r u d o l p h
2. I don’t buy it! And neither should you. So who are we and why are we here? Javiera Rudolph PhD Student at UF Ecological stats & systems biology Data scientist R Ladies Gainesville organizer Arthur Rudolph Recent UF PhD Graduate Quality Manager at First Magnitude Yeast Wrangler USDA Microbiologist
3. Outline • The Quality Program – It’s more than a lab – The data you (already) collect – Good data management – Managing data in the brewery • Analyzing Beer – The R environment – Visualizing data – (Semi) Automatic reports – Resources for R
4. Brewers Association Quality Priority Pyramid The Quality Program: It’s more than a lab. The quality program is about creating an environment that enables you to make your best beer. Master Brewers Food Safety Resources
5. The data you (already) collect • Specific gravity, pH, & temperature – Mash and lauter – Pre-boil and post-boil – Throughout fermentation • Cell counts & viability – Pre-pitch and throughout fermentation • Dates & times • Who’s doing the work
6. The data you (already) collect • DO in process and package • Titratable acidity • Alcohol content (calculated or measured) • Micro results • Taste panel results • FV and BBT used • Brewhouse and packaged volumes • Sales figures
7. GOOD DATA MANAGEMENT
8. GOOD DATA MANAGEMENT The bad things: • Empty cells • Highlighted cells • Long comments in between • Merged cells • Multiple sheets or colors • Transform this into a variable or feature • Even if not in R, concepts for pivot tables in excel. What you want: • Rectangular data sets • Each row is one “observation”
10. Managing Data in the Brewery There’s a lot to deal with. • Physical copies of logs • Lab notebooks • Excel spreadsheets • Brewery management software reports • Output from lab equipment • Notes scribbled on scraps of paper
11. Managing Data in the Brewery Options for data entry • Excel spreadsheets • Brewery management software • Brewery pi • R Shiny app • Google forms
12. Data entry with Google forms • Free! • Easy to access • Completion required • Data protected • Easy to monitor • Spreadsheet output • Text or paragraph answers • Drop down menus • Multiple choice or check boxes • Scales and grids • Time and date • Timestamps
13. ANALYZING BEER
14. WHAT IS R? R is a free software environment for statistical computing and graphics – R website RStudio is an integrated development environment (IDE) for R.
17. THE ADVANTAGES OF A SCRIPT- BASED WORKFLOW –Replication, for you and others • Time saving = money savings –No more memory game – Clicking sequences • How do you explain your intern what you’ve done? • Or yourself in a few of months
18. BREWERY EXAMPLE
23. The data you (already) collect • Specific gravity, pH, & temperature – Mash and lauter – Pre-boil and post-boil – Throughout fermentation • Cell counts & viability – Pre-pitch and throughout fermentation • Dates & times • Who’s doing the work
24. Modeling yeast population dynamics ASBC yeast-14
25. R DEMO Visualizing data and saving time Repetitive process Generating reports Same style, different data Making R work for you
26. R RESOURCES Google #rstats community • Twitter threads Online courses • https://www.codecademy.com/learn/learn-r • https://swcarpentry.github.io/r-novice-gapminder/ • Our course with USFSP RLadies • @RLadiesGNV, • @RLadiesGlobal, https://rladies.org/
27. We’re a Resource too! Javiera Rudolph @javirudolph Ar thur Rudolph @craftbeersci ar thur@craftbeersci.com QUESTIONS?