Divide multiple columns by another column in pandas
Solution 1:
I believe df[['B','C']].div(df.A, axis=0)
and df.iloc[:,1:].div(df.A, axis=0)
work.
Solution 2:
do: df.iloc[:,1:] = df.iloc[:,1:].div(df.A, axis=0)
This will divide all columns other than the 1st column with the 'A' column used as divisor.
Results are 1st column + all columns after / 'divisor column'
.