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

Last update on December 21 2024 07:53:35 (UTC/GMT +8 hours)

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.