好像是关于tidyr包的

请问如何才能将character那一列移到像mtcars所给的那样？

重命名行索引使用rownames,示例：

df <- data.frame("Colours" = c("Red", "Red", "Green", "Yellow"), 
                 "Number" =c(1,2,3,6),"Category"= c('a','b','c','d'))
rownames(df)<-df$Category 
df$Category <-NULL
print(df)

'''
Colours Number
a     Red      1
b     Red      2
c   Green      3
d  Yellow      6
'''

没听明白你得意思