Pandas in Python – Pivot and unPivot


This is Jing, a data scientist with great passion for applying data science and big data technology in the industry. Today you are going to learn Pandas with me. I will talk about how to using Pandas to pivot and unpivot data when you are processing data with python in this blog.

Here is a list of commonly used functions in pandas for pivoting and unpivoting data we will cover today in this blog.

  • pivot_table ( )
  • stack ( )
  • unstack ( )
  • melt ( )

Before we look at each function, we need to create an example dataset so that you could understand the function better through the examples. And import the pandas library as pd which is a name we will use in the following code. Then follows explanation, examples and exercise of each function listed above.

Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.

Hope you find it is helpful for you to learn more about Pandas!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s