Pandas if else

Pandas if python

df['new column name'] = df['column name'].apply(lambda x: 'value if condition is met' if x condition else 'value if condition is not met')

Source: datatofish.com

If condition dataframe python

df.loc[df['age1'] - df['age2'] > 0, 'diff'] = df['age1'] - df['age2']

Source: stackoverflow.com

Pandas if else

df.loc[df['column name'] condition, 'new column name'] = 'value if condition is met'

Source: datatofish.com

Pandas if python

import pandas as pd

names = {'First_name': ['Jon','Bill','Maria','Emma']}
df = pd.DataFrame(names,columns=['First_name'])

df.loc[(df['First_name'] == 'Bill') | (df['First_name'] == 'Emma'), 'name_match'] = 'Match'  
df.loc[(df['First_name'] != 'Bill') & (df['First_name'] != 'Emma'), 'name_match'] = 'Mismatch'  

print (df)

Source: datatofish.com

Pandas if python

import pandas as pd

numbers = {'set_of_numbers': [1,2,3,4,5,6,7,8,9,10]}
df = pd.DataFrame(numbers,columns=['set_of_numbers'])

df['equal_or_lower_than_4?'] = df['set_of_numbers'].apply(lambda x: 'True' if x <= 4 else 'False')

print (df)

Source: datatofish.com

Pandas if python

import pandas as pd

numbers = {'set_of_numbers': [1,2,3,4,5,6,7,8,9,10,0,0]}
df = pd.DataFrame(numbers,columns=['set_of_numbers'])
print (df)

df.loc[df['set_of_numbers'] == 0, 'set_of_numbers'] = 999
df.loc[df['set_of_numbers'] == 5, 'set_of_numbers'] = 555

print (df)

Source: datatofish.com

Similar codes

3 votes142 views1 answer
Load pandas from text
Python
0 vote203 views2 answers
ValueError: 'mean_absolute_error' is not a valid scoring value. Use sorted(sklearn.metrics.SCORERS.keys()) to get valid options.
Python
21 votes107 views6 answers
Pygame install
Python
0 vote158 views1 answer
Django tempalte tag datetime to timestamp
Python Django
0 vote109 views1 answer
Check if all elements in array are true python
Python
12 votes125 views2 answers
Online ide for python 3
Python
0 vote113 views1 answer
Binarizer pyspark
Python
5 votes124 views1 answer
Godot enum
Python
0 vote106 views1 answer
Sentence similarity spacy
Python
1 vote112 views1 answer
Python how to set multiple conditional for single var
Python