How to match two data frames in R based on multiple criteria instead of a key variable?
I have two dataframes that I want to match in R.
Dataframe A has 24,300 cases with the following variables: Name, Gender, Age, DateTime_Event
Dataframe B has 3,000 cases with the following variables: ID, Gender, Age, Date_Time_Start, Date_Time_End
Note that cases from Dataframe B can be matched to more than one case in Dataframe A.
I want to match the two dataframes by copying the relative ID from Dataframe B to the corresponding row in Dataframe A based on age, gender, and date/time. Specifically, the matching criteria include all the following:
* The Gender and Age variables should exactly match in both dataframes.
* The DateTime_Event from Dataframe A should be between the Date_Time_Start and the Date_Time_End in Dataframe B.
This research amid at designing a digital unit in Electronic Secretary, and measure its effectiveness in developing Data base preparation skills using MS Access among commercial technical education learners. To achieve this objective, the researchers used a mixed approach of descriptive and Qauzi-experimental research procedures. To identify data b...
The data base for the Army Selection and Classification Project (Project A) contains two major samples referred to as the concurrent validation sample and the longitudinal validation sample. The former was drawn from a cohort that joined the Army in 1983/84, and the latter from a cohort that entered in 1986/87. This paper describes the data base re...
This is one of three volumes describing the analytical aspects of the Quick-Reacting General War Gaming System (QUICK). This volume addresses the system data requirements, the organization and structure of the data base, and the concepts and techniques employed to prepare a game data base for subsequent Plan Generation and Simulation. In addition,...