记一次dataframe的replace不生效情况

记一次dataframe的replace不生效情况

• 替换不生效格式

import pandas as pd

new_list = ['-', '-', '-', '-', '-', '-']
# 创建示例 DataFrame
df = pd.DataFrame([new_list], columns=['pay_amount', 'lastdaypay_amount', 'pay_order_num',
                                                             'lastdaypay_order_num', 'pay_goods_num', 'lastdaypay_goods_num'])

# 将'-'替换为None
df.replace('-', None, inplace=True)

print(df.to_string())

• 替换生效格式

import pandas as pd

new_list = ['-', '-', '-', '-', '-', '-']
# 创建示例 DataFrame
df = pd.DataFrame([new_list], columns=['pay_amount', 'lastdaypay_amount', 'pay_order_num',
                                                             'lastdaypay_order_num', 'pay_goods_num', 'lastdaypay_goods_num'])

# 将'-'替换为None
df.replace({'-': None}, inplace=True)

print(df.to_string())