是否可以使用第三个变量作为R中的滤波器来绘制两个变量? [英] Is it possible to plot two variables using a third one as filter in R?
问题描述
我正在尝试使用两个变量( DATE
和 INT_RATE
)创建一个图,并将第三个变量过滤器> GRADE
.问题是我真的无法弄清楚如何使用变量 GRADE
作为行的过滤器.
I am trying to create a plot using two variables (DATE
and INT_RATE
) using for filter the content of a third variable GRADE
.
The problem is that I can't really figure out how to use the variable GRADE
as a filter for the row.
在下面的部分中,我提供了详细的初始数据示例以及我要实现的绘图图.预先感谢.
In the below section i provide a detailed sample of starting data as well as draw of the plot I'm trying to achieve. Thanks in advance.
STARTING DATA
| DATE | INT_RATE | GRADE |
––––––––––––––––––––––––––––––
| 1-jan | 5% | A | <-- A
| 5-feb | 3% | B |
| 9-feb | 2% | D |
| 1-apr | 3% | A | <-- A
| 5-jun | 5% | A | <-- A
| 1-aug | 3% | G |
| 1-sep | 2% | E |
| 3-nov | 1% | C |
| 8-dec | 8% | A | <-- A
| . | . | . |
| . | . | . |
| . | . | . |
这是我想要实现的图形,这是非常基本的图形,除了之前需要进行的过滤工作之外.
And this is the kind of graph i would like to achieve, which is a very basic one, except for the filtering work needed before.
WANTED RESULT:
GRADE "A"
INT_RATE
|
|
8%-| •
| ̷
| ̷
| ̷
5%-| • •
| \ /
| \ /
| \ /
| \ /
3%-| •
|
|
|
|
––––––––––––––––––––––––––––––––––-–––>
| ˆ ˆ ˆ ˆ DATE
|1-jan 1-apr 5-jun 8-dec
在@apax的宝贵帮助下,我设法得到了一个图,但是由于R显示它的方式很奇怪,所以结果令人不满意(我认为这可能与所讨论的数据集非常大这一事实有关80万行).你有什么建议吗?
Following the precious help from @apax I managed to get a plot, but the result is not satisfying because of the weird way R is displaying it (I think it might be related to the fact that the dataset in question is very large 800k rows). Do you have any suggestion?
顺便说一句,这解决了我的问题:
By the way, this solved my problem:
plot(x = DATE, y = INT_RATE, data = filter(df, GRADE == "A"))
我还上传了格式错误的图表的PNG.再次感谢所有人.
I am also uploading a PNG of the malformed chart. Thanks again to all.
推荐答案
这是一种快速的一线解决方案,我假设您的数据存储在名为 df
Here's a quick one-liner solution where I assume your data is stored in an object named df
library(dplyr) ## For filter() function below
plot(x = DATE, y = INT_RATE, data = filter(df, GRADE == "A"))
这篇关于是否可以使用第三个变量作为R中的滤波器来绘制两个变量?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!