我有以下代码,例如在目前的情况下可以正常工作,但在未来可能无法正常工作。
由于发生错误。
如何修复这个问题?
变量 total 是:
total.name = 'New_Row'
total_df = total.to_frame().T
total_df.at['New_Row', 'CURRENCY'] = ''
total_df.at['New_Row', 'MANDATE'] = Portfolio
total_df.at['New_Row', 'COMPOSITE'] = 'GRAND TOTAL'
total_df.set_index('COMPOSITE',inplace=True)
由于发生错误。
FutureWarning: Setting an item of incompatible dtype is deprecated and
will raise in a future error of pandas. Value 'GRAND TOTAL' has dtype incompatible with float64, please explicitly cast to a compatible dtype first.
total_df.at['New_Row', 'COMPOSITE'] = 'GRAND TOTAL'
如何修复这个问题?
变量 total 是:
CURRENCY
MANDATE Mandate_Test
USD AMOUNT 123
LOCAL AMOUNT 12
Beg. Mkt 123
End. Mkt 456
Name: New_Row, dtype: object
['New_Row', 'COMPOSITE']
的输入是float64类型。'GRAND TOTAL'
是一个字符串,所以不适用。 - undefined