Data Science Fundamentals - Lab - Excel Madness
About
Real data is messy, even when it’s clean! In this lab, you’ll use all of your Python and Pandas skills to transform a poorly organized set of Excel files into a format conducive to data science. This task may seem mundane, but it is realistic to many tasks data scientists encounter. Most of our time is spent reading, cleaning, and moving data.
Submission
Lab submissions should be made as per guidance from your instructor. Your submission will be in the form of a link to your Github fork of this repository.
Materials We Provide
| Topic | Description | Link |
|---|---|---|
| Input Data | Various .xlsx files containing our data | Link |
| PLU Codes | Price lookup codes that serve as a dictionary for our data | Link |
| Starter Code | The lab without solutions | Link |
Imports
You’ll need the openpyxl library to work with Excel files. If you don’t have it you can pip install it: pip install openpyxl
Important note
Please ignore the _layouts folder and the config.yml file in the root of this repo. They are needed to make sure the repo renders well; please don’t change them or delete them and your repo will work fine :)