0 Python

Asked Aug 03 '18 at 11:41

Active Aug 03 '18 at 12:46

Viewed 336 times

I have a lot of dummy variables (T/F) that I want to convert to 1/0 with a function, I've tried the one below but it is not working...thanks for your help!

def function_country(row):
    if row == 'True':
        val = 1
    else:
        val = 0
    return val

df2.apply(function_country,axis=1)

ValueError: ('The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all().', 'occurred at index 0')

edited Aug 03 '18 at 12:46

Sheldore

37,862
7
57
71

asked Aug 03 '18 at 11:41

Mastodon87

Use `df = df.astype(int)` – jezrael Aug 03 '18 at 11:41
thanks for you suggestion, I've just tried, but I'm getting this error: ValueError: Wrong number of dimensions – Mastodon87 Aug 03 '18 at 11:43
it is fine now, thanks! – Mastodon87 Aug 03 '18 at 11:47
There are all boolean columns in dataframe ? – jezrael Aug 03 '18 at 11:48
Because if not, is possible first filtr only `boolean` columns - `cols = df.select_dtypes(bool).columns` `df[cols] = df[cols].astype(int)` – jezrael Aug 03 '18 at 11:52
Or `m = df.dtypes == 'bool'` `df.loc[:, m] = df.loc[:, m] .astype(int)` – jezrael Aug 03 '18 at 11:53

Convert True/False to 1/0 Python

0 Answers0