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.
Instructions
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 orders
.
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 email
and save them to a variable called emails
.
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 frances_palmer
.
We need some customer reviews for our comfortable shoes. Select all orders for shoe_type
: clogs
, boots
, and ballet flats
and save them to the variable comfy_shoes
.