How to organise large data sets from scientific instruments
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
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 comentarios
Respuestas (0)
Ver también
Categorías
Más información sobre Data Import and Analysis en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!