Select value from the list by defining criteria

1 次查看（过去 30 天）

显示更早的评论

Shiba Subedi 2019-9-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/482822-select-value-from-the-list-by-defining-criteria

评论： Adam Danz 2019-10-2

采纳的回答： Bob Thompson

Dear All,

I have a big dataset with the format,

1 2019-09-25 19:33:00 27.7100 86.3200 10 291.122 4.00 1.79 R023E

1 2019-09-25 19:33:00 27.7100 86.3200 10 197.274 4.00 4.44 S8618

1 2019-09-25 19:33:00 27.7100 86.3200 10 170.200 4.00 4.14 RA5AB

I would like to have new set of data

(i) If column 10 has always valule R023E

(ii) If column 7 > 30.00

what is the solution?

采纳的回答

Bob Thompson 2019-9-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/482822-select-value-from-the-list-by-defining-criteria#answer_394123

I would use readtable to import the data, the logic indexing to narrow down the results.

data = readtable('mydata.xlsx');
reducedata = data(data(:,10) == 'R023E' & data(:,7) > 30,:);

7 个评论
显示 5更早的评论隐藏 5更早的评论

Bob Thompson 2019-10-2

I would agree that dot indexing is more efficient, but I assumed that variable names were inconsistent or unknown.

Adam Danz 2019-10-2

That's a good point. However, the variable names can be set in readtable() or after the table is created. If it is known that the data in column #7 is needed, they can name that column anything they want.

请先登录，再进行评论。

类别

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Text Files

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

Community Treasure Hunt

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

Start Hunting!

Translated by