如何替换列中的空白？Pandas

//1 myDataFrame['Gender'] = myDataFrame['Gender'].replace('^\s*$', np.nan) //2 myDataFrame['Gender'] = myDataFrame['Gender'].replace('', np.nan) myDataFrame.to_csv('new_Paymets_Loan.csv')

Gender Male Female Female Male Female Male Male Male Male Male Male Male Male Female Male Male Male Male Male Male Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male Male Male Female Male Male Male Male Female Female Female Male Male Male Male Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male Male Male Male Male Female Female Male Male Male Male Female Male Female Female Male Female Female Female Male Male Male Male Male Male Male Female Male Male Male Male Male Male Male Male Male Male Male Female Male Male Male Male Male Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male Male Female Male Male Male Male Male Male Female Male Male Female Male Male Male Male Female Male Male Female Male Male Female Male Male Male Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male Male Male Male Female Male Male Male Male Male Female Female Male Male Male Male Male Male Male Female Male Male Male Female Male Male Male Male Male Male Female Male Male Female Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male Male Male Male Male Male Male Male Male Female Male Female Male Female Male Male Male Female Male Male Male Male Male Male Female Male Male Male Male Female Male Male Female Female Male Male Female Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male Male Female Male Male Male Female Male Male Male Male Male Male Male Male Male Female Male Male Male Male Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male Male Male Male Female Female Male Male Male Female Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male Male Male Female Male Female Male Male Male Female Male Male Male Male Male Male Female Male Male Male Male Female Male Male Male Male Male Female Male Male Male Male Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female Female Male Male Male Male Male Male Male Male Female Female Female Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Male Female Male

2条回答

网友

1楼 · 编辑于 2024-09-27 22:35:40

您可以使用下面的命令删除空白

myDataFrame['Gender'].replace('\s','',inplace=True,regex=True)

网友

2楼 · 编辑于 2024-09-27 22:35:40

您希望字符串NaN位于文本csv文件中。只需将其放在数据框中：

myDataFrame['Gender'] = myDataFrame['Gender'].str.replace('^\s*$', 'NaN')

相关问题更多 >

编程相关推荐

热门问题

热门文章