sheetalbongale / ale-gorithm

All things Beer! Beer Educator and Recommender Web App | Deployed on GCP > https://alegorithm-fxljyqhslq-uc.a.run.app/ | UT Data Analysis and Visualization Nov 2019 - May 2020.

Hi! My name is Sheetal Bongale 👋

I am a product focused full-stack Data Scientist with a keen interest in python programming, machine learning, MLOps and using AI for good. I enjoy working on complex problems and fix them with easy and effective data driven solutions. My data science experience involves projects in demand forecasting and inventory optimization, time series analysis, predictive modeling, metrics and dashboard buidling, model evaluations and performance, recommender systems, language processing, network analysis and experimentation.

👩🏻‍💻 Current Expertise | Tool Stack

• Languages: Python, SQL, C++, Javascript
• DS/ML Focus: Time Series Forecasting, Predictive Algorithms, Recommender Systems, NLP, MLOps, ML feature development, Dashboards
• Deployment: GCP, Heroku, Docker
• Other: Databricks, Snowflake, Airflow, Tableau, Postman, VSCode, Git

ale-gorithm's Issues

Deployment

Using Heroku or some cloud platform

HTML Landing Page - Basic Skeleton

Must use HTML and CSS

Create DB and add tables for merged master dataset

Add 'Find Breweries' section and button on landing page

Check if all (at least 5) routes work

Routes

• Must have at least 5 routes
• Must have 1 home route that uses a Jinja template
• Must at least 1 route that uses Plotly or D3 for visualization in a Jinja template
• Must at least 1 route that access and filter and serves data from the database as a json
• (May have a route the dynamically filters and displays data to the UI)
• (May have a route that serves a model, returning result as json)
• (May have a route that serves a model trough the UI)

Get data-set and do preliminary exploration

Bug: Recommender dropdown fails for beerstyles that have a slash '/' in the name

Add table in the DB for breweries locations

Updates brewery addresses with more accurate data

List pulled from google maps has some incorrect addresses. Trying another site

Word-Cloud Chart for Popular Beer Styles of all time

Display beer-style values on recommender page

Modify app.py for connection to GCP and create GCP instance and DB

Create .env file. Create GCP instance. Upload data.

Add selector on app.py to return top 5 beers for a selected style

Create a Jinja Template for atleast one Home Route

Create Bar Chart for popular Beerstyles

Bug - No beer recommendations for 'German Kolsh' and 'English Extra Special'

Find top 5 beers for each style

Footer size

for some reason in html footer size is not correct

Create merge table for beers

Web Scrape-Get data from BA or CraftBeer to get all the beer styles

Create 3 Gauge Charts for ABV, IBU, SRM for every beerstyle

Create route for home page ('/')

Add @app.route('/') and render index.html - that way when the user clicks the Ale-gorithm logo, homepage is reloaded

Testing on Postman

Requirement: Must use Postman with at least one request for each route

Fix Duplicated Beer Process Image

grab more addresses to the brewery list

Create Virtual Environment- Pipfiles

load all data to mysql

merged_final_data
brewery_addresses
beer_styles_links

Create Jinja Template for Recommender page

Create Jinja Template for Dashboard page

Clean data some more and join to get a master csv for reviews

Add US Breweries Stats data from BreweryAssociation

Update final README.md

Add button to toggle between 2 maps

Connect 'About Us' icon to 'About Us' section of the index page

Add Hero/Header Section to the dashboard page

Update SQL top_5_beers table

beer_idd need to be added and Beer_names needs to be removed

Create Flask app file

README.md

Display fixed text before showing beerstyle values and glassware type

Selectors not working on beer recommender page

Not calling JSON correctly

Add 'About Us' icon to dashboard nav bar

Recommender section - Top 5 Beers and their details

Create plots for the data-set

Requirement: Must at least have 1 route that uses Plotly or D3 for visualization in a Jinja template

Google Map API Call to get all the breweries from every state and country

Scrape to get - address of every brewery from every state

final d3-plot

Front-End: some elements on recommender page fail to align to center of the page

Add Favorite Beers to Index page

Draft proposal

A one page proposal

Get Beer styles from BeerAdvocate

US Barrels Heat Map