Pandas: Index column title or name
Pandas Indexing: Exercise-7 with Solution
Write a Pandas program to create a dataframe and set a title or name of the index column.
Test Data:
0 s001 V Alberto Franco 15/05/2002 35 street1 t1 1 s002 V Gino Mcneill 17/05/2002 32 street2 t2 2 s003 VI Ryan Parkes 16/02/1999 33 street3 t3 3 s001 VI Eesha Hinton 25/09/1998 30 street1 t4 4 s002 V Gino Mcneill 11/05/2002 31 street2 t5 5 s004 VI David Parkes 15/09/1997 32 street4 t6
Sample Solution:
Python Code :
import pandas as pd
df = pd.DataFrame({
'school_code': ['s001','s002','s003','s001','s002','s004'],
'class': ['V', 'V', 'VI', 'VI', 'V', 'VI'],
'name': ['Alberto Franco','Gino Mcneill','Ryan Parkes', 'Eesha Hinton', 'Gino Mcneill', 'David Parkes'],
'date_Of_Birth': ['15/05/2002','17/05/2002','16/02/1999','25/09/1998','11/05/2002','15/09/1997'],
'weight': [35, 32, 33, 30, 31, 32],
'address': ['street1', 'street2', 'street3', 'street1', 'street2', 'street4']},
index = ['t1', 't2', 't3', 't4', 't5', 't6'])
print("Original DataFrame:")
print(df)
df.index.name = 'Index_name'
print("\nSaid DataFrame with a title or name of the index column:")
print(df)
Sample Output:
Original DataFrame: school_code class name date_Of_Birth weight address t1 s001 V Alberto Franco 15/05/2002 35 street1 t2 s002 V Gino Mcneill 17/05/2002 32 street2 t3 s003 VI Ryan Parkes 16/02/1999 33 street3 t4 s001 VI Eesha Hinton 25/09/1998 30 street1 t5 s002 V Gino Mcneill 11/05/2002 31 street2 t6 s004 VI David Parkes 15/09/1997 32 street4 Said DataFrame with a title or name of the index column: school_code class ... weight address Index_name ... t1 s001 V ... 35 street1 t2 s002 V ... 32 street2 t3 s003 VI ... 33 street3 t4 s001 VI ... 30 street1 t5 s002 V ... 31 street2 t6 s004 VI ... 32 street4 [6 rows x 6 columns]
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to create a dataframe indexing by date and time.
Next: Write a Pandas program to set value in a specific cell in a given dataframe using index.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://w3resource.com/python-exercises/pandas/index/pandas-indexing-exercise-7.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics