Extracting data from excel file; Adding a new column; plotting the first and the newly added column
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello,
Can someone please help with the following code:
I need to import data from an excel file(9600x2). Then i need to add a new column such that the new column is equal to the value in the second column minus the mean of the entire second column.
At the end i want to plot the 3rd column values versus the 1st column values.
Thank you in advance
0 commentaires
Réponse acceptée
Ameer Hamza
le 16 Oct 2020
Something like this
M = readmatrix('sample.xlsx');
M = [M, M(:,2)-mean(M(:,2))];
plot(M(:,1), M(:,3))
2 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB 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!