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..
Abhinav Agarwal
I come from Northwestern University, which is ranked 9th in the US. Although the high-quality academics at school taught me all the basics I needed, obtaining practical experience was a challenge.... Read More