Create a new column in Pandas DataFrame based on the existing columns

Travinth Dayalaeaswaran answered on September 22, 2021 Popularity 9/10 Helpfulness 1/10

answer Create a new column in Pandas DataFrame based on the existing columns

related How to Create new dataframe columns from existing column

related pandas create new column based on other columns

related Adding new column to existing DataFrame in Pandas using assign method

Create a new column in Pandas DataFrame based on the existing columns

Comment

# importing pandas as pd
import pandas as pd
  
# Creating the DataFrame
df = pd.DataFrame({'Date':['10/2/2011', '11/2/2011', '12/2/2011', '13/2/2011'],
                    'Event':['Music', 'Poetry', 'Theatre', 'Comedy'],
                    'Cost':[10000, 5000, 15000, 2000]})
  
# Print the dataframe
print(df)

Popularity 9/10 Helpfulness 1/10 Language python

Source: www.geeksforgeeks.org

Tags: dataframe pandas python

Link to this answer
Share Copy Link

Contributed on Jul 14 2022

Travinth Dayalaeaswaran

0 Answers Avg Quality 2/10

Closely Related Answers

How to Create new dataframe columns from existing column

Comment

new_df = df.filter(like='n_') \
           .replace(0., np.inf) \
           .apply(lambda x: sorted(x), axis=1, result_type='expand') \
           .replace(np.inf, 0.0)

new_df.columns = ['new_1', 'new_2', 'new_3']

out = pd.concat([df, new_df], axis=1)

Popularity 10/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: dataframe data

Link to this answer
Share Copy Link

Contributed on Sep 22 2021

Long Lion

0 Answers Avg Quality 2/10

pandas create new column based on other columns

Comment

import pandas as pd

# Create a sample DataFrame
data = {'A': [1, 2, 3],
        'B': [4, 5, 6]}
df = pd.DataFrame(data)

# Create a new column 'C' by summing values from columns 'A' and 'B'
df['C'] = df['A'] + df['B']

# Print the updated DataFrame
print(df)

Popularity 8/10 Helpfulness 2/10 Language python

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

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

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

Popularity 10/10 Helpfulness 2/10 Language python

Source: itsmycode.com

Tags: assign as

Link to this answer
Share Copy Link

Contributed on Jan 24 2022

Gorgeous Gazelle

0 Answers Avg Quality 2/10

Create a new column in Pandas DataFrame based on the existing columns

Contents

More Related Answers

Create a new column in Pandas DataFrame based on the existing columns

Closely Related Answers

How to Create new dataframe columns from existing column

pandas create new column based on other columns

Adding new column to existing DataFrame in Pandas using assign method

Grepper

Documentation

Social

Legal

Contact

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