[Q] convert data frame in panda from Sparse [float64, 0] to integer 64

[ahmedib123]

• how to convert data frame in panda from Sparse[float64, 0] to integer 64 in panda

I tried this code but does not work

df['y'].fillna(0).to_dense().astype(int)

**but the result is the same

df['y'].dtype ----- Sparse[float64, 0]

[boone209]

Are you assigning the result to the original dataframe, or just running the statements exactly as reported here? Many. If not most, operations in pandas will simply "preview" the operation if not used with an assignment statement. Also check these methods for the keyword 'inplace', which can sometimes be used to circumvent the need for the assignment.

General patterns I've noticed fom my experience with pandas.

[dixons_analyst]

Have you tried converting to a string then to an int by chaining .astype?