r - 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'),]
但我收到错误:“错误 -”趋势值“:一元运算符的参数无效”
有人有其他建议吗?
谢谢!
解决方案
您可以更改为,小心使用`和'
Data_OUT <- Data_OUT %>% dplyr::arrange(desc(`Trade Value`))
推荐阅读
- laravel - Vue.js - Laravel 填充日期时间本地输入字段
- python - Anaconda 3 安装错误 - 没有脚本文件夹,也没有 conda 命令提示符和快捷方式
- c# - Web 参考 C# 的可配置值
- python - 在 python 中,如何为使用打开文件的函数编写单元测试?
- android - 当我们对某些用户进行身份验证时,我们是否需要添加 livedata?
- android - 以线性布局居中 Edittext - Android
- sql - 在oracle plsql中添加n个工作日,包括自定义假期列表
- return - 布尔返回类型混淆
- javascript - 使用 Node Express 从 Apache Ignite 获取数据的问题
- ios - 将CustomView添加到navigationItem后,CustomView总是返回nil