How would I calculate the change in columns of one table and display it in another?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Aryan Cross
el 12 de Nov. de 2020
Comentada: Aryan Cross
el 12 de Nov. de 2020
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 comentarios
Respuesta aceptada
Cris LaPierre
el 12 de Nov. de 2020
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])
Más respuestas (0)
Ver también
Categorías
Más información sobre Dates and Time en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!