我有一个以美元为单位的数据框。我想对它进行计算,但美元使之不可能。我试图使用df.iloc[:, 4].replace("$", " ", regex=True)
删除它,但不幸的是没有任何更改。如果我加上inplace=True
,那么整个单词将消失。我做错了什么?尝试了许多stackoverflow帖子,但没有任何效果。我不能使用str.replace()
,因为它涉及整个专栏,而不是一个单词
我的代码:
order_id quantity item_name choice_description item_price
0 1 1 Chips and Fresh Tomato Salsa NaN $2.39
1 1 1 Izze [Clementine] $3.39
2 1 1 Nantucket Nectar [Apple] $3.39
3 1 1 Chips and Tomatillo-Green Chili Salsa NaN $2.39
4 2 2 Chicken Bowl [Tomatillo-Red Chili Salsa (Hot), [Black Beans... $16.98
... ... ... ... ... ...
4617 1833 1 Steak Burrito [Fresh Tomato Salsa, [Rice, Black Beans, Sour ... $11.75
4618 1833 1 Steak Burrito [Fresh Tomato Salsa, [Rice, Sour Cream, Cheese... $11.75
4619 1834 1 Chicken Salad Bowl [Fresh Tomato Salsa, [Fajita Vegetables, Pinto... $11.25
4620 1834 1 Chicken Salad Bowl [Fresh Tomato Salsa, [Fajita Vegetables, Lettu... $8.75
4621 1834 1 Chicken Salad Bowl [Fresh Tomato Salsa, [Fajita Vegetables, Pinto... $8.75
然后调用函数replace(),但表保持不变:
df.iloc[:, 4].replace("$", " ", regex=True)
提前谢谢
或者:
相关问题 更多 >
编程相关推荐