我有一个这样完成的数据框:
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
and ID10
后缀。字符串前面的部分ID9
and ID10
具有任意长度,所以我不知道先验。
对于可重现的示例,这是我的数据框:
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"))
我怎样才能做到这一点?