Adding new column to existing DataFrame in Pandas using concat method

Gorgeous Gazelle answered on June 2, 2021 Popularity 9/10 Helpfulness 3/10

answer Adding new column to existing DataFrame in Pandas using concat method

related concat columns pandas dataframe

Adding new column to existing DataFrame in Pandas using concat method

Comment

# import pandas library
import pandas as pd

# create pandas DataFrame
df = pd.DataFrame({'team': ['India', 'South Africa', 'New Zealand', 'England'],
                   'points': [10, 8, 3, 5],
                   'runrate': [0.5, 1.4, 2, -0.6],
                   'wins': [5, 4, 2, 2]})

# print the DataFrame
print(df)

# create a new DataFrame
df2 = pd.DataFrame([[1, 2], [2, 1], [3, 4], [0, 3]],
                   columns=['matches_left', 'lost'])

# concat and Print the new DataFrame
print(pd.concat([df, df2], axis=1))

Popularity 9/10 Helpfulness 3/10 Language python

Source: itsmycode.com

Tags: concat dataframe pandas python using

Link to this answer
Share Copy Link

Contributed on Jan 24 2022

Gorgeous Gazelle

0 Answers Avg Quality 2/10

Closely Related Answers

concat columns pandas dataframe

Comment

In [1]: df1 = pd.DataFrame(
   ...:     {
   ...:         "A": ["A0", "A1", "A2", "A3"],
   ...:         "B": ["B0", "B1", "B2", "B3"],
   ...:         "C": ["C0", "C1", "C2", "C3"],
   ...:         "D": ["D0", "D1", "D2", "D3"],
   ...:     },
   ...:     index=[0, 1, 2, 3],
   ...: )
   
In [8]: df4 = pd.DataFrame(
   ...:     {
   ...:         "B": ["B2", "B3", "B6", "B7"],
   ...:         "D": ["D2", "D3", "D6", "D7"],
   ...:         "F": ["F2", "F3", "F6", "F7"],
   ...:     },
   ...:     index=[2, 3, 6, 7],
   ...: )
   ...: 

In [9]: result = pd.concat([df1, df4], axis=1)
# This will merge columns of both the dataframes

Popularity 10/10 Helpfulness 4/10 Language python

Source: pandas.pydata.org

Tags: concat co

Link to this answer
Share Copy Link

Contributed on Jun 02 2021

Friendly Falcon

0 Answers Avg Quality 2/10

Adding new column to existing DataFrame in Pandas using concat method

Contents

More Related Answers

Adding new column to existing DataFrame in Pandas using concat method

Closely Related Answers

concat columns pandas dataframe

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.