Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Analyzing Beer

Analyzing Beer

Presented at the Florida Brewers Guild annual meeting 2019

craftbeersci

August 07, 2019
Tweet

More Decks by craftbeersci

Other Decks in Science

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 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”
  8. 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
  9. Managing Data in the Brewery Options for data entry •

    Excel spreadsheets • Brewery management software • Brewery pi • R Shiny app • Google forms
  10. 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
  11. 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.
  12. 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
  13. 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
  14. R DEMO Visualizing data and saving time Repetitive process Generating

    reports Same style, different data Making R work for you
  15. 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/