How to strip certain values from a cell in a csv file using Python?

Question

I have a csv file that has a location column that I want to manipulate using Python. The location column has 3 values in each cell (ID, county, state). I want to clean this column so that each cell only shows ID, deleting the county and state values. For example, each cell in this column currently looks like:

[locID 1, countyname, statename], [locID 2, countyname, statename], etc...

The desired outcome is that each cell would look like:

[locID 1], [locID 2], etc...

Any help is greatly appreciated, thank you!

Is that a list of location lists you're showing or is that how the CSV file is laid out? — jonsca
– jonsca, Commented Jun 28, 2022 at 22:46
Welcome to SO. This isn't a discussion forum or tutorial. Please take the tour and take the time to read How to Ask and the other links found on that page. Invest some time with the Tutorial practicing the examples. It will give you an idea of the tools Python offers to help you solve your problem — wwii
– wwii, Commented Jun 28, 2022 at 22:48

Dini · Accepted Answer · 2022-06-28 22:49:23Z

1

You should show your code for better understanding. I don't know if you are using pandas if you are there are specific functions to do it if you're not it is possible too, you just need to replace that row with the id with a loop.

id_column = [1, 'San Antonio', 'Las Vegas']
location_column = id_column[0]

answered Jun 28, 2022 at 22:49

Dini

1674 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

How to strip certain values from a cell in a csv file using Python?

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