/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

0 vote106 views2 answers
Python dictionary append value if key exists
Python
21 votes108 views4 answers
Get list input from user in python
Python
0 vote106 views1 answer
How to create a scoreboard for the top 5 players in python
Python
0 vote97 views1 answer
Alternatives for appending to numpy array
Python
0 vote106 views1 answer
Python list of deeper paths
Python
0 vote100 views1 answer
Bulk m4a to wav ffmepeg
Python
2 votes106 views1 answer
Generate a list of random non repeated numbers python
Python
7 votes108 views2 answers
Set vs list
Python
9 votes103 views3 answers
Pygame key pressed once
Python
2 votes103 views1 answer
Python sort the values in a dictionaryi
Python