df type not permanently changing to int

Question

Sorry to be asking a question again but this isn't making sense to me

I'm trying to change the datatype of my column into an int and did the following:

df.Age.astype(object).astype(int)

this works and it looks like it's changed to an int but then if I do

df.Age

it is then appearing as an object data type? How I can make the change permanent?

why `astype(object).astype(int)`? why not `.astype(int)` directly? — DeepSpace, Apr 29 '20 at 16:12
@DeepSpace astype(object).astype is what I had been reading about when trying to work it out — lross12, Apr 29 '20 at 16:14
@drec4s yeah that does, I can see where I went wrong now thanks to the answer from briba — lross12, Apr 29 '20 at 16:15

briba · Accepted Answer · 2020-04-29T16:14:40.653

3

You have to assign with the serie:

df.Age = df.Age.astype(int)

Consider also:

df["Age"] = pd.to_numeric(df["Age"])

edited Apr 29 '20 at 16:14

answered Apr 29 '20 at 16:11

briba

Thank you that's got it working, and well the aystype way is what I had been reading online. Never actually seen the to_numeric way – lross12 Apr 29 '20 at 16:14

1 Answers1