How to add two sets of imported data?

Question

Ashley Bhugwandin 2021-12-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1605060-how-to-add-two-sets-of-imported-data

回答： Siddharth Bhutiya 2023-3-30

Hi

I am currently working on a program that requires me to add two sets of data that is imported in tables. However whenever I run the code, I get this error message:

Operator '+' is not supported for operands of type 'table'.

Error in MastersDraft_1 (line 3)

Moisture_content = plus(Lime_additioncombinedprdts,Lime_additioncombinedprdtsratio);

How do I fix it?

4 个评论
显示 2更早的评论隐藏 2更早的评论

Ashley Bhugwandin 2021-12-8

How would I add the respective columns?

Thanks

Peter Perkins 2021-12-10

Please see my post below.

请先登录，再进行评论。

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

Answer 1

Siddharth Bhutiya 2023-3-30

2
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1605060-how-to-add-two-sets-of-imported-data#answer_1205059

在 MATLAB Online 中打开

Starting R2023a, tables now directly support arithmetic operations like plus, minus, sum, etc. So this kind of work becomes very easy. You can directly add two tables or numeric values to a table.

T1 = table([1;3],[2;4]);
T2 = table([1;2],[3;4]);
T = T1 + 10
T = 2×2 table
    Var1    Var2
    ____    ____

     11      12 
     13      14 
T = T1 + T2
T = 2×2 table
    Var1    Var2
    ____    ____

     2       5  
     5       8  

You can find more information about what things are now supported here: Direct Calculations on Tables and Timetables

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

请先登录，再进行评论。

Answer 2

Peter Perkins 2021-12-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1605060-how-to-add-two-sets-of-imported-data#answer_849975

在 MATLAB Online 中打开

Ashley, there's a long example in the doc that talks about "how to perform calculations by using the numeric and categorical data that the table contains" at length:

https://www.mathworks.com/help/matlab/matlab_prog/computations-with-numeric-data-in-table-or-timetable.html

Without more information in your question, the short answer is to do things like

t.X = t.X + 1

or

tplus1 = varfun(@(x)x+1,t)

or perhaps

t{:,["X" "Y" "Z"]) = t{:,["X" "Y" "Z"]) + 1

or

t.Variables = t.Variables + 1