how sort data in the excel

14 次查看（过去 30 天）

显示更早的评论

Life is Wonderful 2023-9-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2022192-how-sort-data-in-the-excel

评论： Image Analyst 2023-9-17

采纳的回答： Image Analyst

sort_dataset.xlsx

在 MATLAB Online 中打开

Hi there,

I'm looking for assistance sorting data ( increasing and decreasing order ). I've attached a spreadsheet, and I'd like to order the mean, standard deviation, and variance values as well as the filename.

I need advice on the strategy using the sample code I've attached below.

Thank you

filename = "sort_dataset.xlsx";
sheet = 1;
xlRange = 'A1:E253';
[num,txt,raw] =  xlsread(filename,sheet,xlRange)

2 个评论
显示无隐藏无

Dyuman Joshi 2023-9-17

So you want to sort the data by mean and store the corresponding filenames, and do the same for standard deviation and variance?

If not, then please specify what is the output you want to obtain.

Life is Wonderful 2023-9-17

Yes, you have understood the problem definition correctly.

请先登录，再进行评论。

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

采纳的回答

Image Analyst 2023-9-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2022192-how-sort-data-in-the-excel#answer_1312092

编辑：Image Analyst 2023-9-17

在 MATLAB Online 中打开

sort_dataset.xlsx

Try this:

filename = "sort_dataset.xlsx";
% Read data into a table variable.
t =  readtable(filename)
% Sort table in order of increasing meandata
t2 = sortrows(t, 'meandata','ascend')
% Sort table in order of decreasing meandata
t3 = sortrows(t, 'meandata','descend')
% Sort table in order of increasing stdddata
t4 = sortrows(t, 'stdddata','ascend')
% Sort table in order of decreasing stdddata
t5 = sortrows(t, 'stdddata','descend')
% Sort table in order of increasing vardata
t6 = sortrows(t, 'vardata','ascend')
% Sort table in order of decreasing vardata
t7 = sortrows(t, 'vardata','descend')
% Sort table in order of increasing FileName
t8 = sortrows(t, 'FileName','ascend')
% Sort table in order of decreasing FileName
t9 = sortrows(t, 'FileName','descend')

8 个评论
显示 6更早的评论隐藏 6更早的评论

Life is Wonderful 2023-9-17

编辑：Life is Wonderful 2023-9-17

Histogram -Gaussian Fit

Zoom figure

Image Analyst 2023-9-17

OK. Do you need anymore help? I think I answered all your questions.

If this Answer solves your original question, then could you please click the "Accept this answer" link to award the answerer with "reputation points" for their efforts in helping you? They'd appreciate it. Thanks in advance. 🙂 Note: you can only accept one answer (so pick the best one) but you can click the "Vote" icon for as many Answers as you want. Voting for an answer will also award reputation points.

请先登录，再进行评论。