Convert a object column from an CSV to int in Python

Question

I read data from a CSV file and almost all columns are of the object type. How can I convert them into int. I tried several options but without success. The CSV file is in image. I am especially interested in columns latitude and longitude.

df = pd.read_csv('file'.csv)
de.head()

df.dtypes
listings       object
url            object
guests         object
bedrooms        int64
beds            int64
bathrooms       int64
room_type      object
price         float64
host_name      object
reviews         int64
stars         float64
location       object
latitude       object
longitude      object
dtype: object

How about: df['longitude'] = df['longitude'].astype(str).astype(int)? — some_programmer
– some_programmer, Commented May 7, 2020 at 14:13

Mit · Accepted Answer · 2020-05-07 14:13:32Z

1

you can us .astype(), but perhaps need to do to str first then to int

df["yourColumn"] = df["yourColumn"].astype(str).astype(int)

answered May 7, 2020 at 14:13

Mit

7167 silver badges19 bronze badges

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

Comments

Darkknight · Accepted Answer · 2020-05-07 14:12:52Z

1

You can use the below code to change...

df['longitude'].to_numeric()

answered May 7, 2020 at 14:12

Darkknight

1,87613 silver badges23 bronze badges

1 Comment

aug 57az Oct 5 at 13:38

but wont it take too long to do every column one by one isnt there any other way to do it fast

Collectives™ on Stack Overflow

Convert a object column from an CSV to int in Python

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related