Merging a dataset with entries for every day with the other one with entries only for weekdays

Question

alpedhuez 2018-5-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/402073-merging-a-dataset-with-entries-for-every-day-with-the-other-one-with-entries-only-for-weekdays

评论： Sammit Jain 2018-5-23

I have two datasets. The first one has data for every day. The second one has entries and data only for weekdays. How can I merge these two datasets so that the outcome file with entries for every day?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Sammit Jain 2018-5-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/402073-merging-a-dataset-with-entries-for-every-day-with-the-other-one-with-entries-only-for-weekdays#answer_321498

在 MATLAB Online 中打开

I think what you're trying to accomplish is well-documented here, as a special case of the outerjoin function.

For example, consider your table A

A = table({'a' 'b' 'c' 'e' 'h'}',[1 2 3 11 17]',...
    'VariableNames',{'Key1' 'Var1'})
    Key1    Var1
      ____    ____
      'a'       1 
      'b'       2 
      'c'       3 
      'e'      11 
      'h'      17 
And now consider another table B
B = table({'a','b','d','e'}',[4;5;6;7],...
    'VariableNames',{'Key1' 'Var2'})
    Key1    Var2
    ____    ____
    'a'      4  
    'b'      5  
    'd'      6  
    'e'      7

Notice that the first column in both tables has some entries in common with the other and some not. This is a direct analogy to your weekday and all days example.

C = outerjoin(A,B,'MergeKeys',true)

After this, your table C will have the merged dataset/table.

    Key1    Var1    Var2
    ____    ____    ____
    'a'       1       4 
    'b'       2       5 
    'c'       3     NaN 
    'd'     NaN       6 
    'e'      11       7 
    'h'      17     NaN

Here you can explore more options in the outerjoin documentation to filter your data into exactly one column if needed.

2 个评论
显示无隐藏无

alpedhuez 2018-5-23

But I want to outerjoin only using dates (Key1) but not using other keys. Please advise.

Sammit Jain 2018-5-23

There are options in the outerjoin function that you can try configuring. See here - https://www.mathworks.com/help/matlab/ref/outerjoin.html Alternatively, once you have combined data, you can filter it out depending on your requirements.

请先登录，再进行评论。