Remove rows from a table if a variable with the same name in another table does not exist

5 次查看（过去 30 天）
chiefjia
chiefjia 2021-9-27
编辑： chiefjia 2021-9-28
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'
for i=1:height(transaction_dates.isin)
for j=1:width(stockprice_data)
if transaction_dates.isin(i,:) ~= stockprice_data(j,:)
transaction_dates = removevars(transaction_dates
end
end
end
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.
  1 个评论
Siddharth Bhutiya
Siddharth Bhutiya 2021-9-27
This should be easy to do. Can you attach sample data containing both the tables? That way people can play around with it and suggest potential ways to do that instead of trying to guess and generate the data themselves based on the description.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Cris LaPierre
Cris LaPierre 2021-9-27
Have you tried using the Join Tables live task? This will interactively let you align two tables using key variables. Once you have the table you want, you can generate the corresponding code.
  3 个评论
显示 1更早的评论
Cris LaPierre
Cris LaPierre 2021-9-28
Based on the comments in your code, it looked like you were trying to align tables. If so, this is worth a shot. Take a look at the venn diagrams in the app and see if one of them represents what you are trying to do.
chiefjia
chiefjia 2021-9-28
Hi Cris,
thank you for your suggestion, I've tried this approach and it worked. I had to first convert the ISINs, which were listed as variables in stockprice_data, into row values of a single column named 'isin'. Then, I implemented the jointable live task and got the result.
Thank you!

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by