Skip to main content

Course

Python for Spreadsheet Users

BasicSkill Level

4.8+

Updated 07/2024

Use your knowledge of common spreadsheet functions and techniques to explore Python!

Start Course for Free

PythonProgramming4 hr13 videos48 Exercises3,900 XP29,020Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Training 2 or more people?

Try DataCamp for Business

Course Description

Are you looking for a better solution than the one you’ve built in a spreadsheet? If so, then Python for Spreadsheet Users is a great introduction to the Python language, and will put you on the right path towards automating repetitive work, diving deeper into your data, and widening the scope of what you are capable of accomplishing. Throughout the course, we’ll draw parallels to common spreadsheet functions and techniques, so you’ll always have a familiar reference point as you dive head first into Python.

Prerequisites

Pivot Tables in Google Sheets

1

Diving In

Let's get right into it! In this chapter, you'll become acclimated with Python syntax, loading your data into a Python session, and how to explore and edit this data to answer business questions.

Welcome to Python!

Importing packages

Loading data

Looking at data with print()

DataFrames and their methods

The .head() method

.info() and .describe() methods

The .sort_values() method

Filtering rows and creating columns

Creating columns

Putting it all together

2

Pivoting in Python

The pivot table is a core tool in the savvy spreadsheet user's arsenal. In this chapter, we'll focus on simply recreating this functionality in Python using some handy DataFrame methods.

Grouping and summing: the beginner's pivot table

Pure summary with .sum()

.groupby() and .sum() together

Summarizing and sorting values

Grouping by multiple columns

Which is a list?

Movie genre performance by location

What do seniors like?

More useful summary tools

Best-selling movie by location

Which movie averages the most sales

3

Working with Multiple Sheets

This chapter will focus on how to import and manage multiple sheets from a workbook, as well as how to join these sheets together using the Python equivalent of a VLOOKUP: the left join.

Working with multiple sheets

pd.ExcelFile() function

.sheet_names attribute

.parse() method

Preparing to put tables together

.str.lower() and .str.title()

.str.strip()

Selecting and .drop()

Merging: The VLOOKUP of Python

Merging for ticket prices

Merging for theater locations

Putting it all together again

4

Plotting Data

Now that you're able to import and manipulate your data in Python, let's shift our focus to visualizing this data so that our insights are easily communicable to others.

How visualization works in Python

How to build a graph in Python

Top grossing films

Best genres

Building up the barplot

Put a title on it

Label your axes!

Make it pretty with sns

The power of hue

Interpreting hue

Genre by market

Genre by ticket type

Wrapping up

Python for Spreadsheet Users

Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.8

from 34 reviews

94%

3%

0%

3%

0%

Sort by

Noor E Mustafa

3 weeks ago

James Kiwanuka

5 weeks ago

This is a very well structured and accessible course. Excellent tutor.

Amit

3 months ago

Stanislau

3 months ago

Ricky

3 months ago

Siti Noorbani

3 months ago

Noor E Mustafa

"This is a very well structured and accessible course. Excellent tutor."

James Kiwanuka

Amit

FAQs

Is Python for Spreadsheet Users a good first Python course for someone who only knows Google Sheets?

Yes. The course is designed for spreadsheet users transitioning to Python. It draws parallels to familiar spreadsheet functions so you always have a reference point.

Does the course teach the Python equivalent of VLOOKUP?

Yes. Chapter 3 covers the left join in Python, which is the equivalent of VLOOKUP, and shows you how to import and combine data from multiple sheets.

Will I learn to create pivot tables in Python?

Yes. Chapter 2 focuses on recreating pivot table functionality in Python using pandas DataFrame methods, a core tool for spreadsheet users.

Does the course cover data visualization?

Yes. The final chapter teaches you how to plot data in Python so that your insights are easy to communicate to others, similar to charting in a spreadsheet.

What Google Sheets courses should I complete before starting?

You should complete Introduction to Google Sheets, Intermediate Google Sheets, Data Analysis in Google Sheets, and Pivot Tables in Google Sheets first.

Join over 19 million learners and start Python for Spreadsheet Users today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Grow your data skills with DataCamp for Mobile

Make progress on the go with our mobile courses and daily 5-minute coding challenges.