Practice Exercise #5 – Pandas II – data frame creation
Assignment Summary
This exercise builds off of the previous week’s introduction to Pandas. In this scenario, we will use Pandas and repl.it to examine and later analyze a data set. More specifically, we will import a csv, customize its presentation, do some basic data analysis and export our results as .csv file that can be shared with colleauges.
Video
Today’s Assignment
Task 1: Using Pandas and the provided .csv dataset (see D2L attachments for this week), export a Pandas dataframe as a CSV. This csv will be automatically be part of your activity submission.
Task 2: Analyze the dataframe using the value count function (this video contains the steps to use the value.count function).
Submission steps: Share your repl.it URL in order to submit your assignment (consult the week video from the previous week if you want to see the sharing steps). Both task 1 and 2 will be present in the repl.it share, under files, whenever viewers navigate here:
Template
Resources
- Review additional graph options in matplotlib
- Pandas Value Count documentation
- Pandas commands that are helpful for printing a data frame
- Pandas frequent commands cheat sheet