how can I initialize multiple columns in a single instance in an existing pandas DataFrame object? I can initialize single column at an instance, this way:
df = pd.DataFrame({'a':[1,2,3],'b':[4,5,6]}, dtype='int') df['c'] = 0 but i cannot do something like:
df[['c','d']] = 0 or df[['c']['d']] = 0 is there a way i can achieve this?
I prefer this solution.
df = df.assign(**{'c': 0, 'd': 0}) i got a solution here.
df.reindex(columns = list['cd']) will do the trick.
actually it will be:
df.reindex(columns = list['abcd']) 
df.reindex(columns = list('abcd')).fillna(0).
columns = list('abcd') or columns = ['a','b','c','d'] for the columns argument.
pd.concat
pd.concat([df, pd.DataFrame(0, df.index, list('cd'))], axis=1) 
join
df.join(pd.DataFrame(0, df.index, list('cd')))
