如何转换Int64列在float

Question

我有一个问题:https://platform.stratascratch.com/coding-question?id=9900&python=1和我需要返回结果'工资'在浮动，但.astype(float)不工作

我代码:

# Import your libraries
import pandas as pd
# Start writing code
result = employee.groupby(['department'])['salary'].sum().reset_index()
result['salary'] = result['salary']
result['salary'] = result['salary'].astype(float)
result

我试着用这个:result['salary'] = pd.to_numeric(result['salary'], downcast='float')但结果是一样的:打印

Answer 1

不确定astype(float)方法不适合您的原因，但也许可以尝试to_numeric方法:

result['salary'] = pd.to_numeric(result['salary'], downcast='float')

Answer 2

你可以试试:

result['salary'] = result['salary'] / 1.0