cleaning the outliers from a large data sets xlsx

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

[Andy]

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..

[ennes mulla]

yes but how to detect them in the first place?

Answer 1

[Cris LaPierre]

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