This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have two sets of data as outlined below. One set has only a subset of record ID's that are of interest, the other set has the full set of record IDs, and two additional columns that have critical information for those IDs. I would like to use the subset to curate the larger set down to only the data that as the record ID listed in the subset. I am having some trouble:
---------subset data---- ------------------Full data set----------
Record ID Record ID Data1 Data2
AAGTCAATC AAGTCAATC SOCS3 5.326
AGGGTCCA GGGTCATTT ABL4 0.314
GGCTTTTA AAGTCAATC LMP2 2.751
The full set will contain multiple of the same record ID that needs to be kept. Please help, thanks