How would I calculate the change in columns of one table and display it in another?
2 次查看(过去 30 天)
显示 更早的评论
For example, I have a table:
User Date1 Date2 Date3 ....(I have 500+ dates)
{'A'} 1 6 10 ...
{'B'} 2 8 11 ...
{'C'} 3 9 14 ...
{'D'} 4 11 11 ...
I would like to create this table, showing the changes as each date progresses
User Date2 Date3 ....(I have 500+ dates)
{'A'} 5 4 ...
{'B'} 6 3 ...
{'C'} 6 5 ...
{'D'} 7 0 ...
0 个评论
采纳的回答
Cris LaPierre
2020-11-12
You won't be able to do this with tables. Using Accessing Data in Tables, extract the data, take the diff along dimension 2, then build a new table from the results.
Date1 = [1:4]';
Date2 = [6 8 9 11]';
Date3 = [10 11 14 11]';
User = ["A" "B" "C" "D"]';
T = table(User,Date1,Date2,Date3)
T2 = diff(T{:,2:end},[],2)
T2 = table(T.User,T2);
T2=splitvars(T2);
T2.Properties.VariableNames = T.Properties.VariableNames([1,3:end])
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Type Identification 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!