ternary operator in Python

Asked Feb 23 '21 at 12:33

Active Feb 23 '21 at 12:46

Viewed 73 times

I am doing the following exercise and I have some part of it

Create a new column with a 1 if the country's % Renewable value is at or above the median for all countries in the top 15, and a 0 if the country's % Renewable value is below the median.

My code:

df = answer_one()
print(df)
mean = df['#% Renewable'].mean()
df['ratio'] = df['#% Renewable'] > mean

I want to know if there is a way to create in one line a ternary operator, something like:

If renewable > mean then 0 if renewable < mean then 1.

but not sure how to achieve this on python in one line

asked Feb 23 '21 at 12:33

Luis Valencia

32,619
93
286
506

1

`result = 0 if renewable>mean else 1` – sahasrara62 Feb 23 '21 at 12:35
What do you want to do if renewable == mean? (asking Luis not sahasrara) – Yuval.R Feb 23 '21 at 12:38
with a 1 if the country's % Renewable value is at or above – Luis Valencia Feb 23 '21 at 12:40
@sahasrara62 this doesnt work, df['ratio'] = 0 if df['% Renewable']>mean else 1, I get this error: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all(). – Luis Valencia Feb 23 '21 at 12:41
Does this answer your question? [Pandas: Ternary conditional operator for setting a value in a DataFrame](https://stackoverflow.com/questions/46525270/pandas-ternary-conditional-operator-for-setting-a-value-in-a-dataframe) – Tomerikoo Feb 23 '21 at 12:42
TL;DR - `df['ratio'] = np.where(df['#% Renewable'] > mean, 1, 0)` – Tomerikoo Feb 23 '21 at 12:42
median is the middle number versus mean which is the average of the numbers – Golden Lion Mar 02 '21 at 18:07

ternary operator in Python

0 Answers0