Replacing multiple values in CSV file

Question

I have a CSV file where one of the columns is titled "Type". Under this column I'm trying to replace values "Ford" and "GMC" as "Automotive". I believe with what I have, there's definitely an issue with formatting. Please advise.

df_jobs["Type"].replace(to_replace = "Ford", "GMC", value = "Automotive", inplace=True)

The error I'm getting is

"SyntaxError: positional argument follows keyword argument"

haccks · Accepted Answer · 2021-06-10 23:53:35Z

2

Error is self explanatory. "GMC" is a positional argument which is followed by to_replace = "Ford" which is a keyword argument.
What you need is make a list of "Ford" and "GMC" and then pass it to to_replace key:

df_jobs["Type"].replace(to_replace = ["Ford", "GMC"], value = "Automotive", inplace=True)

edited Jun 10, 2021 at 23:53

answered Jun 10, 2021 at 23:44

haccks

107k28 gold badges181 silver badges274 bronze badges

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

Collectives™ on Stack Overflow

Replacing multiple values in CSV file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related