Python Pandas – 从 DataFrame 列中的字符串中删除数字
要从字符串中删除数字，我们可以使用replace()方法并简单地替换。让我们首先导入require库-
import pandas as pd
使用学生记录创建DataFrame。Id列有带数字的字符串-
dataFrame = pd.DataFrame(
{
"Id": ['S01','S02','S03','S04','S05','S06','S07'],"Name": ['Jack', 'Robin', 'Ted', 'Robin', 'Scarlett', 'Kat', 'Ted'],"Result": ['Pass', 'Fail', 'Pass', 'Fail', 'Pass', 'Pass', 'Pass']
}
)从特定列的字符串中删除数字，即此处的“Id”-
dataFrame['Id'] = dataFrame['Id'].str.replace('\d+', '')示例
以下是代码-
import pandas as pd
#使用学生记录创建DataFrame
dataFrame = pd.DataFrame(
{
"Id": ['S01','S02','S03','S04','S05','S06','S07'],"Name": ['Jack', 'Robin', 'Ted', 'Robin', 'Scarlett', 'Kat', 'Ted'],"Result": ['Pass', 'Fail', 'Pass', 'Fail', 'Pass', 'Pass', 'Pass']
}
)
print"DataFrame ...\n",dataFrame
#从特定列的字符串中删除数字
dataFrame['Id'] = dataFrame['Id'].str.replace('\d+', '')
print"\nUpdated DataFrame...\n", dataFrame输出结果这将产生以下输出-
DataFrame ...
Id Name Result
0 S01 Jack Pass
1 S02 Robin Fail
2 S03 Ted Pass
3 S04 Robin Fail
4 S05 Scarlett Pass
5 S06 Kat Pass
6 S07 Ted Pass
Updated DataFrame...
Id Name Result
0 S Jack Pass
1 S Robin Fail
2 S Ted Pass
3 S Robin Fail
4 S Scarlett Pass
5 S Kat Pass
6 S Ted Pass热门推荐
10 给老师祝福语简短元旦
11 搞笑舞蹈生日祝福语简短
12 送花简短有内涵祝福语
13 简短搞笑的虎年祝福语
14 姐妹乔迁贺卡祝福语简短
15 送猫猫生日祝福语简短
16 女生求婚朋友祝福语简短
17 感谢母校寄语简短祝福语
18 别人转岗的祝福语简短