Sliding window binning and average

5 次查看（过去 30 天）
Farshad Daraei Ghadikolaei
评论： Mehmed Saad 2020-4-21
Hi all, I have data in a .csv file with two difderent columns and each column has 245438 row. Please kindly help me to find a MATLAB code to bin the first column with a sliding window of 30 and threshold 1 and make an average of corresponding data in second column for each bin.

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

回答（1 个）

Mehmed Saad
Mehmed Saad 2020-4-20
  1. Read data from csv file using readtable, suppose you store it in variable T and the two column of tables are C1 and C2. To access first column use , T.C1 and for 2nd use T.C2
  2. For sliding window, use conv or filter maybe with (ones(1,30))
  3. After filtering, apply threshold by comparing result of step 2 with threshold i.e 1
  6 个评论
显示 4更早的评论
Farshad Daraei Ghadikolaei
Farshad Daraei Ghadikolaei 2020-4-20
Thanks Muhammad for your contribution. I have developed the answer of Thiago Henrique Gomes: (https://au.mathworks.com/matlabcentral/answers/492847-how-to-create-a-sliding-window-function-over-column-vector-m) to reach what code related to my question.

请先登录，再进行评论。

类别

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

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by