How to set a particular column as index of a dataframe using pandas
This recipe helps you set a particular column as index of a dataframe using pandas
Recipe Objective
While working with dataframe, we migh have index which we might be interested in setting up as index; suppose person name.
So this recipe is a short example on How to set a particular column as index of a dataframe. Let's get started.
Step 1 - Import the library
import pandas as pd
import seaborn as sb
Let's pause and look at these imports. Pandas is generally used for performing mathematical operation and preferably over arrays. Seaborn is just used in here to import dataset.
Step 2 - Setup the Data
df = sb.load_dataset('tips')
print(df.head())
Here we have imported tips dataset from seaborn library.
Step 3 - Setting index
df=df.set_index('total_bill')
print(df.head())
Here we have set our index to be total_bill.
Step 4 - Let's look at our dataset now
Once we run the above code snippet, we will see:
Scroll down to the ipython file to look at the results.
We can see total_bill becoming the first column and acting as index for our dataset.
What Users are saying..
Ed Godalle
I am the Director of Data Analytics with over 10+ years of IT experience. I have a background in SQL, Python, and Big Data working with Accenture, IBM, and Infosys. I am looking to enhance my skills... Read More