Breaking News: Grepper is joining You.com. Read the official announcement!

pandas create new column based on other columns

Add Answer

YOU.com answered on May 14, 2020 Popularity 8/10 Helpfulness 2/10

answer pandas create new column based on other columns

related pandas create column from another column

related Add new column based on condition on some other column in pandas.

related pandas new column from others

related pandas create new column conditional on other columns

related pandas create a new column based on condition of two columns

related create new columns pandas from another column

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

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

Closely Related Answers

pandas create column from another column

Comment

# Creates a new column 'blue_yn' based on the existing 'color' column
# If the 'color' column value is 'blue' then the new column value is 'YES'
df['blue_yn'] = np.where(df['color'] == 'blue', 'YES', 'NO')
# Can also do this using .apply and a lambda function
df['blue_yn']= df['color'].apply(lambda x: 'YES' if (x == 'blue') else 'NO')

Popularity 10/10 Helpfulness 8/10 Language python

Source: Grepper

Tags: pandas pa

Link to this answer
Share Copy Link

Contributed on Aug 15 2021

Trained Tuna

0 Answers Avg Quality 2/10

Add new column based on condition on some other column in pandas.

Comment

# np.where(condition, value if condition is true, value if condition is false)

df['hasimage'] = np.where(df['photos']!= '[]', True, False)
df.head()

Popularity 10/10 Helpfulness 5/10 Language python

Source: www.dataquest.io

Tags: add

Link to this answer
Share Copy Link

Contributed on Aug 08 2021

LawlietL

0 Answers Avg Quality 2/10

pandas new column from others

Comment

import pandas as pd

#Here a and b are existing columns

df['c'] = df.apply(lambda row: row.a + row.b, axis=1)
df
#    a  b  c
# 0  1  3  4
# 1  2  4  6

Popularity 9/10 Helpfulness 5/10 Language python

Source: stackoverflow.com

Tags: pandas pa

Link to this answer
Share Copy Link

Contributed on May 07 2021

Troubled Dev

0 Answers Avg Quality 2/10

pandas create new column conditional on other columns

Comment

# For creating new column with multiple conditions
conditions = [
    (df['Base Column 1'] == 'A') & (df['Base Column 2'] == 'B'),
    (df['Base Column 3'] == 'C')]
choices = ['Conditional Value 1', 'Conditional Value 2']
df['New Column'] = np.select(conditions, choices, default='Conditional Value 1')

Popularity 10/10 Helpfulness 5/10 Language python

Source: Grepper

Tags: conditional cond

Link to this answer
Share Copy Link

Contributed on May 14 2020

Talented Toucan

0 Answers Avg Quality 2/10

pandas create a new column based on condition of two columns

Comment

conditions = [
    df['gender'].eq('male') & df['pet1'].eq(df['pet2']),
    df['gender'].eq('female') & df['pet1'].isin(['cat', 'dog'])
]

choices = [5,5]

df['points'] = np.select(conditions, choices, default=0)

print(df)
     gender      pet1      pet2  points
0      male       dog       dog       5
1      male       cat       cat       5
2      male       dog       cat       0
3    female       cat  squirrel       5
4    female       dog       dog       5
5    female  squirrel       cat       0
6  squirrel       dog       cat       0

Popularity 10/10 Helpfulness 4/10 Language python

Source: stackoverflow.com

Tags: multiple-conditions mult

Link to this answer
Share Copy Link

Contributed on Dec 01 2020

Courageous Cobra

0 Answers Avg Quality 2/10

create new columns pandas from another column

Comment

def label_race (row):
   if row['eri_hispanic'] == 1 :
      return 'Hispanic'
   if row['eri_afr_amer'] + row['eri_asian'] + row['eri_hawaiian'] + row['eri_nat_amer'] + row['eri_white'] > 1 :
      return 'Two Or More'
   if row['eri_nat_amer'] == 1 :
      return 'A/I AK Native'
   if row['eri_asian'] == 1:
      return 'Asian'
   if row['eri_afr_amer']  == 1:
      return 'Black/AA'
   if row['eri_hawaiian'] == 1:
      return 'Haw/Pac Isl.'
   if row['eri_white'] == 1:
      return 'White'
   return 'Other'

df.apply(lambda row: label_race(row), axis=1)

Popularity 10/10 Helpfulness 3/10 Language python

Source: stackoverflow.com

Tags: pandas pa

Link to this answer
Share Copy Link

Contributed on Jan 07 2021

Stupid Salmon

0 Answers Avg Quality 2/10

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 data

Link to this answer
Share Copy Link

Contributed on Jul 14 2022

Travinth Dayalaeaswaran

0 Answers Avg Quality 2/10

pandas create new column based on other columns

Contents

More Related Answers

pandas create new column based on other columns

Closely Related Answers

pandas create column from another column

Add new column based on condition on some other column in pandas.

pandas new column from others

pandas create new column conditional on other columns

pandas create a new column based on condition of two columns

create new columns pandas from another column

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

Grepper

Documentation

Social

Legal

Contact

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