You’ve completed the lesson! You’ve just learned the basics of working with a single table in Pandas, including:
- Create a table from scratch
- Loading data from another file
- Selecting certain rows or columns of a table
Let’s practice what you’ve learned.
In this example, you’ll be the data analyst for ShoeFly.com, a fictional online shoe store. You’ve seen this data; now it’s your turn to work with it!
Load the data from
shoefly.csv into the variable
Inspect the first 5 lines of the data.
Your marketing department wants to send out an email blast to everyone who ordered shoes!
Select all of the email addresses from the column
Frances Palmer claims that her order was wrong. What did Frances Palmer order?
Use logic to select that row of
orders and save it to the variable
We need some customer reviews for our comfortable shoes. Select all orders for
ballet flats and save them to the variable