Analyzing Spreadsheet Data with Python
We all know how hard it can be to sift through spreadsheets sometimes. With hundreds upon hundreds of rows and columns, there’s a lot of data to get through! But not to worry, we have some good news for you: all that data can be analyzed in Python with just a few lines of code. No longer do you have to scroll through your lagging spreadsheets! With only a few keystrokes, you can cherry pick the data that you need. Get your spreadsheets ready because with this project, you’ll be able to launch your journey into the world of data analysis!Login to enroll
Classes StartMay 11, 2021
A Look At the Project Ahead
- Load data from a spreadsheet to Python
- Use Pandas, a Python library, to perform spreadsheet operations such as subsetting, filtering and calculating column mean, median and max
- Export your data table to an Excel spreadsheet
What You'll Need
Otherwise, all you'll need is a web browser!
Everything else is provided to you via the IBM Skills Network Labs environment, where you will have access to JupyterLab. This platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer or Safari.
Yasmine Hemmati, IBM