Looping through columns using Python and Pandas

Question

I am trying to figure out how to loop through columns to replace its values.

My dataset looks like this:

In this example, I want to replace the decimal comma of the first two columns with decimal points.

When trying to use a for loop like

for col in opel_Df[['Altitude Variation', 'Vehicle Speed Instantaneous']]:
    opel_Df[col] = opel_Df[col].replace(',', '.')

nothing happens, but this is because I have to set inplace=True, but when I do so, I get none values:

How can I do it?

U13-Forward · Accepted Answer · 2021-10-24 11:37:08Z

0

I would do:

col = ['Altitude Variation', 'Vehicle Speed Instantaneous']

opel_Df[col] = opel_Df[col].replace(',', '\.', regex=True)

answered Oct 24, 2021 at 11:37

U13-Forward

71.8k15 gold badges100 silver badges125 bronze badges

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

1 Answer 1