删除数据帧值的后缀 [英] Remove a suffix to a value of a data frame

问题描述

我有一个这样的数据框：

I have a data frame done this way:

 a       b         c
--------------------------------
 1     2011     mal ID9     
 2     2012     yesterday ID10 
 3     2010     misch ID10 
 4     1995     ship ID9 
 5     2008     se ID9 
 6     1998     falling ID10 
 7     2011     friend ID9 
 8     2011     use to be ID10 
       ...

我要删除的 ID9 和 ID10 后缀。字符串中 ID9 和 ID10 前面的部分具有任意长度，所以我不知道是先验的。

What I want is removed the ID9and ID10 suffix. The part of the string that precedes ID9 and ID10 has arbitrarily length so I don't know a priori.

对于一个可重现的示例，这是我的数据帧：

For a reproducible example, this is my dataframe:

z <- data.frame(a = c(1,2,3,4,5,6,7,8),
                b = c(2011,2012,2010,1995,2008,1998,2011,2011),
                c = c("mal ID9", "yesterday ID10", "misch ID10", "mal ID10", "se ID9", "falling ID10", "friend ID9", "use to be ID10"))

这是我想要的结果：

zz <- data.frame(a = c(1,2,3,4,5,6,7,8),
                b = c(2011,2012,2010,1995,2008,1998,2011,2011),
                c = c("mal", "yesterday", "misch", "mal", "se", "falling", "friend", "use to be"))

我该怎么做？

推荐答案

这应该有效

    z$c=gsub(" ID.*","",z$c)

这篇关于删除数据帧值的后缀的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！