CODEWITHSUNDEEP
pythonloopspandasdummy-variable
pakkunrob
pakkunrob

Reputation: 445

How to create dummy variables within a loop in python?

So I have a dataframe with a bunch of eatures, some of which I want to make into a dummy variable, some of which I want to leave alone, and I wanted to create a lazy/faster way to do this rather than just typing:

dum_A = pd.get_dummies(df['A'],prefix='A')
dum_B = pd.get_dummies(df['B'],prefix='B')
...
dum_N = pd.get_dummies(df['N'],prefix='N')

So this is the code I came up with below. 

List_of_dummy_names = []
List_of_dummy_col = []

for col in list(df1.columns.values):
     if len(df1[col].value_counts()) <= 7:
        List_of_dummy_names.append('dum_'+col)
        List_of_dummy_col.append(col)

for (dummy, col) in zip(List_of_dummy_names, List_of_dummy_col):
    dummy = pd.get_dummies(df1[col], prefix=col)

But this only returns the variable dummy being a dummy dataframe of the nth feature in the lists. What am I doing wrong here? I thought for each loop its getting a new name from the list, instead it looks like its assinging the new dummy DF each time to the variable dummy.

Many thanks in advance guys.

Upvotes: 0

Views: 2518

Answers (1)

5nv
5nv

Reputation: 450

for col in list(df.columns.values):
     if len(df[col].value_counts()) <= 7:
            df= pd.concat([df,pd.get_dummies(df[col],prefix=col)],axis=0)
            df[col].fillna(0,inplace=True)
        `

Upvotes: 1

Related Questions