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

Adding new column to existing DataFrame in Pandas using assign 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)

# append multiple columns to Pandas DataFrame
df2 = df.assign(lost=[2, 1, 3, 4], matches_remaining=[2, 3, 1, 1])

# Print the new DataFrame
print(df2)

Source: itsmycode.com

Similar codes

1 vote324 views2 answers
Joblib
Python
0 vote268 views1 answer
Sys.path[0]
Python
18 votes282 views5 answers
Discord.py get user input
Python
0 vote328 views1 answer
Error: The file/path provided (flaskr) does not appear to exist. Please verify the path is correct. If app is not on PYTHONPATH, ensure the extension is .py
Python Flask
5 votes250 views2 answers
How to get the local time in python
Python
12 votes282 views4 answers
How to know if a input is a interger in python
Python
0 vote282 views1 answer
Python 3 string length
Python
0 vote308 views1 answer
How to order randomly in django orm
Python Django
1 vote286 views1 answer
Django get form id from request
Python
0 vote276 views1 answer
Error: Command '['/home/jonas/twitchslam/env/bin/python3.6', '-Im', 'ensurepip', '--upgrade', '--default-pip']' returned non-zero exit status 1.
Python