🚀 Master the language of AI with our brand new course: "Prompt Engineering for Everyone" Learn more

Offered By: IBM

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!

Continue reading

Guided Project

Data Science

3.12k+ Enrolled
4.4
(520 Reviews)

At a Glance

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!

A Look At the Project Ahead

Once you have completed, this project, you’ll be able to:
  • 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

Before starting this project, it'll be helpful to have some basic Python knowledge, such as the concept of a list, dictionary, function, class, instance variable, method, etc.

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.

Instructor

Weiqing Wang, IBM

Other Contributors

Kathy An, IBM
Yasmine Hemmati, IBM

Estimated Effort

40 Minutes

Level

Beginner

Skills You Will Learn

Python

Language

English

Course Code

GPXX0AYQEN

Tell Your Friends!

Saved this page to your clipboard!

Sign up to our newsletter

Stay connected with the latest industry news and knowledge!