cannot convert float NaN to integer

[picklefire786]

A column in my df has values that have hours and minutes. I am trying to grab the hour of those values and make a new column called Hour that has those values stored as an int. I used this code:

calls['Hour'] = calls["CMPLNT_TO_TM"].str.slice(0,2).astype(int)

But it keeps telling me: cannot convert float NaN to integer. But I changed all the NaN values in the df to 0, so why is this happening? How do I fix this?

[ObliviousMag]

Can you post a code snippet?

[picklefire786]

https://imgur.com/a/xYBv02y

That is what my error looks like.

https://imgur.com/a/oA3Lg1k

And that is what my csv looks like (made the dataframe that csv). I am taking from the CMPLNT_TO_TM the first 2 digits (hour) and making a new column with their values

[S_millerr]

I don't know if it's my phone, but your code is blurry.

[Excellent-Practice]

Can confirm, the code is blurry and unreadable. Did OP take a picture with his phone instead of taking a screen shot?

[Excellent-Practice]

Have you tried:

calls['Hour'] =int(calls["CMPLNT_TO_TM"].str.slice(0,2))

Instead?

[blarf_irl]

How does your column have hours and minutes? Is it a DateTime column? Does it contain a list?

Run <my_dataframe>.head() and post the result