/Python/Adding new column to existing DataFrame in Pandas using concat method

Adding new column to existing DataFrame in Pandas using concat method

# 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))

Source: itsmycode.com

Similar codes

2 votes240 views1 answer
Python insert object into list
Python
0 vote263 views1 answer
How to read unicode in python
Python
1 vote289 views1 answer
Append to list in dictionary python if exists
Python
3 votes319 views1 answer
Axis = 1 python
Python
16 votes343 views6 answers
Django forms
Python Django
0 vote318 views1 answer
The webpage at http://127.0.0.1:8000/ might be temporarily down or it may have moved permanently to a new web address. django
Python Django
1 vote313 views4 answers
Pandas count zeros in column
Python
-1 vote243 views1 answer
Pyside2 qt designer tab widget example
Python
1 vote265 views1 answer
How to take input complex number in python
Python
26 votes293 views6 answers
Delete columns pandas
Python