Normalize only certain columns?

Question

I am using code below to normalize columns but it tries to and starts with my label columns, is there anyway to only normalize certain columns?

x = df.values #returns a numpy array
min_max_scaler = preprocessing.MinMaxScaler()
x_scaled = min_max_scaler.fit_transform(x)
df = pd.DataFrame(x_scaled)

Thanks

Alexandru Placinta · Accepted Answer · 2022-03-06 23:46:32Z

1

You can do

df[[col1, col2]] = scaler.fit_transform(df[[col1, col2]])

More details here: pandas dataframe columns scaling with sklearn

answered Mar 6, 2022 at 23:46

Alexandru Placinta

6893 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Thanos Natsikas · Accepted Answer · 2022-03-06 23:59:26Z

1

Or, if you want to scale just some columns, but don't drop the rest of the columns:

scale_cols = ['a','b']
resid_cols = df.drop(columns = scale_cols).columns
df = pd.concat([pd.DataFrame(scaler.fit_transform(df[scale_cols]),columns =scale_cols),df[resid_cols]],axis=1)

answered Mar 6, 2022 at 23:59

Thanos Natsikas

1565 bronze badges

Collectives™ on Stack Overflow

Normalize only certain columns?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related