w3resource

Pandas: Create a new DataFrame based on existing Series and override the existing columns names

Pandas Joining and merging DataFrame: Exercise-11 with Solution

Write a Pandas program to create a new DataFrame based on existing series, using specified argument and override the existing columns names.

Sample Solution:

Python Code :

import pandas as pd
s1 = pd.Series([0, 1, 2, 3], name='col1')
s2 = pd.Series([0, 1, 2, 3])
s3 = pd.Series([0, 1, 4, 5], name='col3')
df = pd.concat([s1, s2, s3], axis=1, keys=['column1', 'column2', 'column3'])
print(df)

Sample Output:

    column1  column2  column3
0        0        0        0
1        1        1        1
2        2        2        4
3        3        3        5          

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Pandas program to merge two given datasets using multiple join keys.
Next: Write a Pandas program to create a combination from two dataframes where a column id combination appears more than once in both dataframes.

What is the difficulty level of this exercise?

Test your Programming skills with w3resource's quiz.



Follow us on Facebook and Twitter for latest update.