首页 > 解决方案 > R排序数据框

问题描述

我需要按第一列(贸易价值)对 data.fram 进行排序。我的 data.frame 的属性是:

 str(Data_OUT)
'data.frame':   68 obs. of  9 variables:
 $ Trade Value              : num  6 7.5 8 8.5 9 9 9.5 10 10.5 10.5 ...
 $ Running Back.Player Name : chr  "" "" "" "" ...
 $ Running Back.Trend       : num  NA NA NA NA NA NA 0 0 NA NA ...
 $ Wide Receiver.Player Name: chr  "Mohamed Sanu" "Marquise Brown" "Tyrell Williams" "Marvin Jones" ...
 $ Wide Receiver.Trend      : num  0 0 0 0 0 0 0 0 0 0 ...
 $ Tight End.Player Name    : chr  "" "" "" "" ...
 $ Tight End.Trend          : num  NA NA NA NA NA NA NA NA NA NA ...
 $ Quarterback.Player Name  : chr  "" "" "" "" ...
 $ Quarterback.Trend        : num  NA NA NA NA NA NA 0 NA NA NA ...

summary(Data_OUT)
     Trade Value    Running Back.Player Name Running Back.Trend Wide Receiver.Player Name
     Min.   : 6.00   Length:68                Min.   :0          Length:68                
     1st Qu.:12.88   Class :character         1st Qu.:0          Class :character         
     Median :21.25   Mode  :character         Median :0          Mode  :character         
     Mean   :24.73                            Mean   :0                                   
     3rd Qu.:32.00                            3rd Qu.:0                                   
     Max.   :69.00                            Max.   :0                                   
                                              NA's   :33                                  
     Wide Receiver.Trend Tight End.Player Name Tight End.Trend Quarterback.Player Name
     Min.   :0           Length:68             Min.   :0       Length:68              
     1st Qu.:0           Class :character      1st Qu.:0       Class :character       
     Median :0           Mode  :character      Median :0       Mode  :character       
     Mean   :0                                 Mean   :0                              
     3rd Qu.:0                                 3rd Qu.:0                              
     Max.   :0                                 Max.   :0                              
     NA's   :32                                NA's   :60                             
     Quarterback.Trend
     Min.   :0        
     1st Qu.:0        
     Median :0        
     Mean   :0        
     3rd Qu.:0        
     Max.   :0        
     NA's   :59      

我正在尝试使用此代码:

Data_OUT <- Data_OUT %>% dplyr::arrange(desc('Trade Value'))

但结果是表格是升序而不是降序排序。

我试过了:

Data_OUT <- Data_OUT[order(-'Trend Value'),]

但我收到错误:“错误 -”趋势值“:一元运算符的参数无效”

有人有其他建议吗?

谢谢!

标签: r

解决方案


您可以更改为,小心使用`'

Data_OUT <- Data_OUT %>% dplyr::arrange(desc(`Trade Value`))

推荐阅读