Remove rows from a table if a variable with the same name in another table does not exist
4 views (last 30 days)
Dear MATLAB experts,
I'm trying to find a way of removing rows from the table 'transaction_dates' if there is not a variable in the table 'stockprice_data' with the same "isin" as in any of the rows of the variable "isin" in the table 'transaction_dates'. I have yet not figured out how to solve this problem, but tried to come up with a solution as in the code below:
% 'transaction_dates' and 'stockprice_data' need to be aligned since 240
% columns were removed from 'stockprice_data', which correspond to many
% rows in 'transaction_dates'
if transaction_dates.isin(i,:) ~= stockprice_data(j,:)
transaction_dates = removevars(transaction_dates
the code is definitely not complete and far from being right, but it's what I've got so far, as I'm quite of a beginner in the programming world.
I would really appreciate your help.
Thank you in advance.