/ Home

Course: Python For Oshawa Learners

Note: Customized Python

Chapter: 1 | Virtual Environment

1. Miniconda Setup
2. Create env

Misc

• Skip duplicate entry while adding by using try/except

• Add a new column called “location” with default text

• Loop through existing table and fill
  • for odd ids, fill the locaiton column with Toronto
  • for even ids, fill the locaiton column with Oshawa
• Add restaurant
  • restid, name, location, category (southindian, japanese)
  • add 5 restaurants you visited before
• Add reviews table
  • revid, review_by (str), review_date (datetime), content

• Add 2 reviews for each restaurant