Course
Python for Spreadsheet Users
BasicSkill Level
Updated 07/2024Start Course for Free
Included withPremium or Teams
PythonProgramming4 hr13 videos48 Exercises3,900 XP28,941Statement 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 BusinessCourse Description
Prerequisites
Pivot Tables in Google Sheets1
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.
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.
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.
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.
Python for Spreadsheet Users
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance review
Included withPremium or Teams
Enroll NowJoin 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.