How to organise large data sets from scientific instruments

1 次查看（过去 30 天）
Jack B
Jack B 2015-7-3
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.

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by