Pandas：整个数据帧的rsplit

Question

所有人

是否可以在整个数据帧上运行rsplit而不遍历所有列？我有一个CSV文件，大多数字段后面都有空格（不是列特定的）。在

任何帮助都是非常感谢的。在

编辑： csv将如下所示，我想删除每个字段右侧的所有空格（在读取时csv最好）：

"JoeK    ","Joe     ","Kavanagh   ","joe.kavanagh@nomail.com  "
"BarryD  ","Barry","Dempsy     ","bdempsy@nomail.com"
"OrlaF","Orla    ","Farrel     ","ofjk@nomail.com             " 
"SethB   ","Seth    ","Black      ","sblack@nomail.com         "
"KateW   ","Kate    ","White      ","kw12@nomail.com              "

Answer 1

如果可以将读数与删除空白分开：

df = pd.read_csv('mycsv.csv')
df_nowhitespace = df.applymap(str.strip)