/Python/Pandas assign multiple columns at once

Pandas assign multiple columns at once

Set dtype for multiple columns pandas

import pandas as pd

df = pd.DataFrame({'id':['a1', 'a2', 'a3', 'a4'],
  				   'A':['0', '1', '2', '3'],
                   'B':['1', '1', '1', '1'],
                   'C':['0', '1', '1', '0']})

df[['A', 'B', 'C']] = df[['A', 'B', 'C']].apply(pd.to_numeric, axis = 1)

Pandas assign multiple columns at once

df = pd.DataFrame({'col1':[0,1,2], 'col2':[0,1,2], 'col3':[0,1,2]})

df
   col1  col2  col3
0     0     0     0
1     1     1     1
2     2     2     2

df['col1'], df['col2'], df['col3'] = zip(*df.apply(lambda r: (1, 2, 3), axis=1))

df
   col1  col2  col3
0     1     2     3
1     1     2     3
2     1     2     3

Assign multiple columns pandas

import pandas as pd

df = {'col_1': [0, 1, 2, 3],
        'col_2': [4, 5, 6, 7]}
df = pd.DataFrame(df)

df[[ 'column_new_1', 'column_new_2','column_new_3']] = [np.nan, 'dogs',3]  #thought this wo

Source: edureka.co

Similar codes

15 votes197 views3 answers
Remove word from string in python
Python
0 vote168 views1 answer
Mean =[0,0] covariance = [[1,0],[0,100]] ds = np.random.multivariate_normal(mean,covariance,500) dframe = pd.DataFrame(ds, columns=['col1', 'col2']) fig = sns.kdeplot(dframe).get_figure() fig.savefig('kde1.png')
Python
2 votes154 views1 answer
Color to black and white cv2
Python
0 vote131 views1 answer
Python valueerror "invalid syntax for number"
Python
1 vote148 views1 answer
Set up and run a two-sample independent t-test
Python
0 vote126 views1 answer
How to copy content of one file to another in python
Python
0 vote157 views1 answer
How to append panda columns using loop
Python
0 vote137 views1 answer
Create database tables python
Python
8 votes137 views3 answers
Get_dummies
Python
8 votes143 views6 answers
Declare variable in python
Python