How I automated the creation of my grocery list from a bunch of recipe websites with Python

The problem and motivation

My manually created list

Approach

SELECT group_name, COUNT(*) as count
FROM FD_DES
LEFT JOIN FD_GROUP ON FD_DES.group_id = FD_GROUP.group_id
WHERE shortdes LIKE ?
AND FD_GROUP.group_id NOT IN ('0300', '0800',
'1800', '1900',
'2100', '2200',
'2500', '3500','3600')
GROUP BY group_name
ORDER BY count DESC
LIMIT 1

Using the code

My .txt input list (I have been quite obsessed with thewoksoflife.com lately )
C:\Users\plcpi\Google Drive\Personal Projects\Ingredients extractor> python grocery.py 'recipes0908.txt'
Results of running the code

Performance Assessment

Final Thoughts

Side note: Improvements

Using Python, R and Dataviz tools to do interesting stuff with data in my spare time

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store