user7289 user7289 - 1 year ago 98
Python Question

Pandas conditional creation of a series/dataframe column

I have a dataframe along the lines of the below:

Type Set
1 A Z
2 B Z
3 B X
4 C Y

I want to add another column to the dataframe (or generate a series) of the same length as the dataframe (= equal number of records/rows) which sets a colour green if Set = 'Z' and 'red' if Set = otherwise.

What's the best way to do this?

Answer Source
df['color'] = np.where(df['Set']=='Z', 'green', 'red')

For example,

import pandas as pd
import numpy as np

df = pd.DataFrame({'Type':list('ABBC'), 'Set':list('ZZXY')})
df['color'] = np.where(df['Set']=='Z', 'green', 'red')


  Set Type  color
0   Z    A  green
1   Z    B  green
2   X    B    red
3   Y    C    red
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download