import pandas as pd
import numpy as np
df = pd.DataFrame([
[-0.532681, 'foo sai', 0],
[1.490752, 'bar', 1],
[-1.387326, 'foo-', '-'],
[0.814772, 'baz', ' - '],
[-0.222552, ' -', ' -'],
[-1.176781, 'qux', '- '],
], columns='A B C'.split())
print(df)
print('-------------------------------')
print(df.replace(r'[^\w][\s]', np.nan, regex=True))
如何使用正则表达式替换任何空白字符和连字符(-)?
使用以下代码,可以实现上述功能:
A B C
0 -0.532681 foo sai 0
1 1.490752 bar 1
2 -1.387326 foo- -
3 0.814772 baz NaN
4 -0.222552 - NaN
5 -1.176781 qux NaN
but return that i expect is this:<br>
A B C
0 -0.532681 foo sai 0
1 1.490752 bar 1
2 -1.387326 foo- Nan
3 0.814772 baz NaN
4 -0.222552 Nan NaN
5 -1.176781 qux NaN
^ & $
分别替换foo bar
中的空格吗? - Umar.H