cleaning the outliers from a large data sets xlsx

2 views (last 30 days)
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 Comments
ennes mulla
ennes mulla on 10 Nov 2022
yes but how to detect them in the first place?

Sign in to comment.

Answers (1)

Cris LaPierre
Cris LaPierre on 10 Nov 2022
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:

Categories

Find more on Get Started with MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by