Extracting data from excel file; Adding a new column; plotting the first and the newly added column

1 次查看（过去 30 天）

显示更早的评论

Ali Awada 2020-10-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/616293-extracting-data-from-excel-file-adding-a-new-column-plotting-the-first-and-the-newly-added-column

评论： Ameer Hamza 2020-10-16

采纳的回答： Ameer Hamza

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Ameer Hamza 2020-10-16

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/616293-extracting-data-from-excel-file-adding-a-new-column-plotting-the-first-and-the-newly-added-column#answer_515948

在 MATLAB Online 中打开

Something like this

M = readmatrix('sample.xlsx');
M = [M, M(:,2)-mean(M(:,2))];
plot(M(:,1), M(:,3))

2 个评论
显示无隐藏无

Ali Awada 2020-10-16

thanks Ameer! always on point!

Ameer Hamza 2020-10-16

I am glad to be of help!!!

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by