cleaning the outliers from a large data sets xlsx

1 次查看（过去 30 天）
ennes mulla
ennes mulla 2022-11-10
回答： Cris LaPierre 2022-11-10
Hello everyone.
I have a set of data that shows the measurement of multiple solar panels where each has its own generated energy
the data is almost 60 columns where the first one is the timestamps and the rest are the measurement of each panel. I need to clean the outliers of each column, I have tried multiple functions but it didn't work. For instance, using
rmoutliers
However, it can be applied if I can extract each column alone and then use and when I plotted the data I still could see clearly a lot of outlier (or points of measurement that is really overshooting). Can you help me, please? I am looking for a robust solution that I can apply without the need to extract each column separately. I have attached the data file to this question
Many thanks in advance
  2 个评论
Andy
Andy 2022-11-10
What do you want to do with an outlier, remove the value or replace it with something i.e. NaN. If you remove it then do you want to remove all the data for that date..

请先登录，再进行评论。

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

回答（1 个）

Cris LaPierre
Cris LaPierre 2022-11-10
If you process your data in a live script, consider interactively exploring different ways to detect and remove outliers using the Clean Outlier Data live task. See here:
https://www.mathworks.com/help/matlab/ref/cleanoutlierdata.html

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by