how to filter data in matlab like in excel

16 次查看（过去 30 天）

John 2013-11-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/107600-how-to-filter-data-in-matlab-like-in-excel

评论： Nagarajan G 2020-5-17

Hi,

I have a variable 'data' with 2 columns, time (1-24) and energy consumption. I have a whole year of data. If I only wanted to look at the consumption at 10 pm, how could I filter out the energy consumption data points at 10pm?

Thanks for your help

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

L K 2016-9-11

Hi, i have a same problem, can you please tell me how to give the data(2 columns in excel file having phase and amplitude) to filter, i want the output of filter to be plot of phase and amplitude. pls help

请先登录，再进行评论。

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

采纳的回答

Laurent 2013-11-26

4
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/107600-how-to-filter-data-in-matlab-like-in-excel#answer_116386

在 MATLAB Online 中打开

You can use indexing. For example:

tenpm=data(data(:,1)==22,2);

data(:,1)==22 selects only the rows in which the first column contains the value 22 (for 10 pm) and ',2' selects only the energy consumption values, which are then stored in the variable 'tenpm'. If you also want to keep the first column, you can change to:

tenpm=data(data(:,1)==22,:);