How to differentiate the data in excel using a variable?
12 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Vishnuvardhan Naidu Tanga
le 18 Nov 2022
Commenté : Star Strider
le 21 Nov 2022
Hello all,
I am trying to do a differentiation of a variable in excel data with respect to an other variable. For example in my case, the data which has a name in Y in excel has to be differentiated with respect to X. and I need each value after differentiation. Can someone please tell me how can i do it. I am attaching the excel data.
5 commentaires
Jan
le 20 Nov 2022
If you have imported the data already, it is useful to post a small example, how they are represented in Matlab.
You asked for a differentiation at first, but now for an integration. While gradient(x,t) does the first, trapz(x,t) does the second.
Réponse acceptée
Star Strider
le 20 Nov 2022
T1 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/1198533/matlab.xlsx')
[~,dx] = gradient(T1{:,1:2:end});
[~,dy] = gradient(T1{:,2:2:end});
dydx = dy ./ dx
figure
for k = 1:size(dydx,2)
subplot(4,2,k)
yyaxis left
plot(T1{:,(2*k-1)}, T1{:,(2*k-1)+1})
ylim([0 4])
yyaxis right
plot(T1{:,(2*k-1)}, dydx(:,k))
xlim([0 0.2])
ylim([-40 0])
grid
title(sprintf('X%d,Y%d',[1 1]*k))
end
hl = legend('Data','Derivative');
hs42 = subplot(4,2,8);
hs42.Visible = 'off';
hl.Position = hs42.Position;
% figure % Check First & Last Assignments
% yyaxis left
% plot(T1.X1, T1.Y1, T1.X7, T1.Y7)
% yyaxis right
% plot(T1.X1,dydx(:,1), T1.X7,dydx(:,7))
% grid
This appears to me to be correct. Check it to be certain it produces the desired result.
.
2 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!