Select Page

Weekend Meal Planner

SQL Recipe Recommender

 

Python + SQL Data Exploration Project

Check out my project on GitHub: What Should I Cook This Weekend!

In this project, I cleaned and transformed a real recipe dataset using Python (pandas) and explored it using BigQuery SQL. The focus was on querying recipes based on available ingredients and dietary preferences.

🔧 Tools & Skills:

  • Python (pandas, CSV cleaning, data preprocessing)

  • SQL (BigQuery)

  • Data wrangling and string manipulation

  • Real-life problem-solving with a touch of food inspiration!

🧹 Key Highlights:

  • Cleaned messy CSV data with broken encoding, inconsistent quotes, and line breaks

  • Escaped special characters to make the dataset BigQuery-friendlyWrote SQL queries to:

  • Filter vegetarian options

  • Select random recipe suggestions

  • Find recipes based on ingredients

Fancy a vegetarian dish? Let’s skip the meat and see what’s cooking. 

Everything’s in the fridge, but no clue what to cook? Let’s choose three recipes at random!

Rare ingredient spotlight section! Japanese-inspired ideas with Furikake?

ï‚Œ