我有一个数据框:
Number Superclass Class Subclass
<dbl> <chr> <chr> <chr>
1 3 NA Class: Benzene and substituted derivatives NA
2 3 Superclass: Benzenoids NA NA
3 4 Superclass: Painkiller NA NA
我想要平整数据帧并向上合并,以便在同一行上有超类、类和子类:
Number Superclass Class Subclass
<dbl> <chr> <chr> <chr>
1 3 Superclass: Benzenoids Class: Benzene and substituted derivatives NA
2 4 Superclass: Painkiller NA NA
我试过了
df%>%
group_by(Number) %>%
summarise_all(na.omit)
但它只包括所有三个类都存在的行,并删除只有一个超类或超级AND类的任何行