如何删除R数据框中的美元符号?
要删除R数据框中的美元符号,我们可以按照以下步骤操作-
首先,创建一个数据框。
然后,使用gsub函数和lapply函数删除美元符号。
示例
创建数据框
让我们创建一个数据框,如下所示-
Product<-sample(c("Milk","Sugar","Bread","Wheat"),25,replace=TRUE)
Price<-
sample(c("$10","$5","$12","$15","$9","$8","$11","$14","$13"),25,replace=TRUE)
df<-data.frame(Product,Price)
df输出结果执行时,上述脚本生成以下内容output(thisoutputwillvaryonyoursystemduetorandomization)-
Product Price 1 Milk $11 2 Sugar $5 3 Milk $5 4 Bread $10 5 Sugar $8 6 Sugar $11 7 Sugar $5 8 Wheat $15 9 Sugar $5 10 Wheat $15 11 Wheat $5 12 Milk $8 13 Milk $13 14 Wheat $13 15 Wheat $5 16 Milk $13 17 Wheat $12 18 Bread $5 19 Bread $10 20 Milk $9 21 Milk $14 22 Bread $11 23 Milk $8 24 Sugar $10 25 Bread $8
删除美元符号
使用gsub函数和lapply函数从价格列中删除美元符号,如下所示-
Product<-sample(c("Milk","Sugar","Bread","Wheat"),25,replace=TRUE)
Price<-
sample(c("$10","$5","$12","$15","$9","$8","$11","$14","$13"),25,replace=TRUE)
df<-data.frame(Product,Price)
df[]<-lapply(df,gsub,pattern="$",fixed=TRUE,replacement="")
df输出结果Product Price 1 Sugar 15 2 Sugar 14 3 Wheat 8 4 Sugar 10 5 Milk 11 6 Milk 5 7 Sugar 11 8 Sugar 14 9 Milk 12 10 Wheat 10 11 Wheat 15 12 Bread 11 13 Bread 13 14 Milk 5 15 Bread 13 16 Wheat 11 17 Wheat 13 18 Sugar 10 19 Sugar 12 20 Milk 9 21 Milk 13 22 Wheat 15 23 Sugar 9 24 Bread 14 25 Milk 5
热门推荐
2 送蛇的祝福语简短
4 圆圆的祝福语简短
10 妹妹生日祝福语简短唯美
11 简短大气的狗年祝福语
12 理科元旦祝福语大全简短
13 给婴儿祝福语简短的话
14 永远漂亮祝福语女生简短
15 领证幽默祝福语简短
16 顾客简短祝福语大全集
17 男朋友祝福语简短新年
18 简短朋友旅行祝福语大全