我正在尝试按列级别从数据帧中删除新行字符,但某些列不起作用。有人能帮我这里出了什么问题吗
例如:
Df:
col1,col2,col3,col4,col5
1 my,name,is,shiv:
2
3 ""blr"",ind
预期结果:
col1,col2,col3,col4,col5
1 my,name,is,shiv:""blr"",ind
我正在尝试的代码:
df = pd.read_csv('D:/Users/SPate233/Downloads/iMedical/code_11032020/latest_script/PCYC_VOC_Data_Load.csv', delimiter = ',')
col = list(df.columns)
print(col)
new_f = df[col].replace('\n',' ', regex=True)
new_f.to_csv("D:/Users/SPate233/Downloads/iMedical/code_11032020/latest_script/PCYC/test.csv", sep =',', index=False)
将
\r\n
和\n
替换为''
,然后将出现预期的输出相关问题 更多 >
编程相关推荐