How to organise large data sets from scientific instruments

1 view (last 30 days)
Hello,
I was wondering if there was an easy way to sort large excel datasets. For example, data collected from an instrument. If I knew which row and column the data I wanted started and finished, is there a way to extract that data throughout the entire spreadsheet with a simple function or script?
To make this more clear, I'll provide you with an example.
100 cells of data. I want to extract the data from every 5 through 10 cells and leave the rest and repeat this sequence until I get to the 100th cell. This would be similar to having a sensor turned on for 100 minutes but only recorded good data between minutes 5 through 10, then would wait until minutes 15 through 20 and so on.
Hopefully I'm being clear. You can see if you had to sort through a total of 30,000 bins of data doing this manually would laborious.
Cheers,
Jack.

Answers (0)

Categories

Find more on Data Import from 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!