r - 按日期范围和 ID 连接,面板数据
问题描述
我有基本的基金数据,我想按日期范围和基金ID添加经理姓名
我尝试了模糊右连接
x = fuzzy_right_join(manager, fundret, by = c("fundName" = "fundName", "date"= "managerStartdate", "date" = "managerENDdate"), match_fun = list('==', '>', '<'))
但有一个错误
Error in mf(rep(u_x, n_y), rep(u_y, each = n_x), ...) :could not find function "mf
我尝试了一些 if /else 功能,但仍然不起作用......
library(lubridate)
manager=data.frame(managerName=c("A","B","C","D","E","F","G","H","I","J","K","L","M","N"),
fundName=c("fundA","fundA","fundA","fundA","fundA","fundA","fundA","fundA","fundA","fundA","fundA","fundB","fundB","fundC"),
managerStartdate=ymd(c("20040227","20041218","20140317","20140317","20120405","20151119","20140620","20150901","20100118","20150107","20051029","20140321","20130320","20140321")),
mangerENDdate=ymd(c("20051029","20050412","20151119","20170113","20130628","20170224","20150107","20170328","20140620","NA","20100118","20180912","20140430","20180912")))
fundret=data.frame(
fundName=c("fundA","fundA","fundA","fundA","fundA","fundA","fundB","fundC"),
date=ymd(c("20020628","20041003","20120508","20140321","20160101","20170201","20140707","20170909")),
ret=c(0.05,0.3,0.44444,0.00023,-0.0058,0.00006,-0.5,0.7))
这是我想联合的
wantedresult=data.frame(
fundName=c("fundA","fundA","fundA","fundA","fundA","fundA","fundB","fundC"),
date=ymd(c("20020628","20041003","20120508","20140321","20160101","20170201","20140707","20170909")),
ret=c(0.05,0.3,0.44444,0.00023,-0.0058,0.00006,-0.5,0.7),
managerName=c("NA","A","I&E","C&D","D&J","J","L","N"))
谢谢你的帮助
经理:https ://i.stack.imgur.com/sbfk7.jpg
基金: https ://i.stack.imgur.com/aQyj1.jpg
想要的结果: https ://i.stack.imgur.com/DbWap.jpg
解决方案
如果您在 match_fun 参数中使用反引号而不是引号,它应该可以工作。
match_fun = list(反引号==反引号,反引号>反引号,反引号
反引号 = `
推荐阅读
- java - 正则表达式在字符串中查找变量
- spring - 是否有任何可用的 Spring 5.0.6.RELEASE osgified 版本补丁?
- python-3.x - 动画控制台 App 3 点加载器,我该怎么做?
- python - 内部服务器错误:AWS Elastic Beanstalk 上的 Flask 上的 Dash
- android - 滚动视图中的回收站视图
- html - 我需要编写什么 HTML 或 CSS 才能使占位符属性的文本可以用鼠标选择/突出显示?
- javascript - 如何在反应中呈现有关道具更改的返回数据
- ansible - 如何在ansible playbook中使用文件的行作为变量?
- uml - 真的需要我的用例图的建议。我正在尝试为下一个目标建模一个用例:
- python - Anaconda 安装的 cudatoolkit 和 cudnn 会影响我当前的配置吗?