Replacing column values with loop result pandas

Question

I have dataframe that looks like this:

State   State_theft_sum Model_1 Model_year_1
Alabama 2154    Chevrolet Pickup (Full Size)    2005.0  
Alaska  547 Chevrolet Pickup (Full Size)    2003.0
Arizona 5270    Honda Accord    1997.0

DF goes on and on, so changing values separately isn't the way. I though i might be able to replace them using result of loop which would format string as I want it to be, here is the loop:

for model_year in df_total['Model_year_1']:
    model_year = model_year.split('.')
    model_year = model_year[0]
    print(model_year)

Result of the loop:

I need this to be formatted as a string as I will use it as text for Choropleth chart.

Is there any way I can change the values inside a column of DF without needing to create new DF from the loop and then joining them and after that deleting the column with .0?

Mitchell Olislagers · Accepted Answer · 2021-01-18 00:01:10Z

1

You could probably just convert it to a float, then to an int and then to a str to avoid the loop.

df["Model_year_1"] = df["Model_year_1"].astype('float').astype('int').astype('str')

edited Jan 18, 2021 at 0:01

answered Jan 17, 2021 at 23:48

Mitchell Olislagers

1,8271 gold badge6 silver badges11 bronze badges

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

2 Comments

Aleksander Kuś Over a year ago

I tried doing that but then i have this error: "ValueError: invalid literal for int() with base 10: '2005.0'"

Mitchell Olislagers Over a year ago

I didn't realize the years were strings. I've updated the answer.

Collectives™ on Stack Overflow

Replacing column values with loop result pandas

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related