Pandas: Insert a column at a specific index in a given DataFrame
Pandas Indexing: Exercise-22 with Solution
Write a Pandas program to insert a column at a specific index in a given DataFrame.
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'],
'weight': [35, 32, 33, 30, 31, 32]},
index = [1, 2, 3, 4, 5, 6])
print("Original DataFrame with single index:")
print(df)
date_of_birth = ['15/05/2002','17/05/2002','16/02/1999','25/09/1998','11/05/2002','15/09/1997']
idx = 3
print("\nInsert 'date_of_birth' column in 3rd position of the said DataFrame:")
df.insert(loc=idx, column='date_of_birth', value=date_of_birth)
print(df)
Sample Output:
Original DataFrame with single index: school_code class name weight 1 s001 V Alberto Franco 35 2 s002 V Gino Mcneill 32 3 s003 VI Ryan Parkes 33 4 s001 VI Eesha Hinton 30 5 s002 V Gino Mcneill 31 6 s004 VI David Parkes 32 Insert 'date_of_birth' column in 3rd position of the said DataFrame: school_code class name date_of_birth weight 1 s001 V Alberto Franco 15/05/2002 35 2 s002 V Gino Mcneill 17/05/2002 32 3 s003 VI Ryan Parkes 16/02/1999 33 4 s001 VI Eesha Hinton 25/09/1998 30 5 s002 V Gino Mcneill 11/05/2002 31 6 s004 VI David Parkes 15/09/1997 32
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to drop a index level from a multi-level column index of a dataframe.
Next: Write a Pandas program to print a DataFrame without 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-22.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics