Extracting and sorting data
3 views (last 30 days)
Show older comments
Hi I am trying to extract a large volume of data every 1 - 20 seconds time interval with a break of 5 seconds, also I want to specify a range for filtering the data before plotting e.g. temp range between 1.0 to 1.7 and I want the First column(time) to correspond to the selected data after filtering. For example I have two columns below:
Time temp
A = 1 1.3
2 1.7
3 0.3
4 0.8
Thanks
1 Comment
Guillaume
on 8 Jul 2019
Edited: Guillaume
on 8 Jul 2019
"I am trying to extract a large volume of data"
Extract from what? It appears you've given us the end result you want but not the starting point. An example of the starting data (in valid matlab syntax or as an attached mat file) would be useful.
Answers (1)
Ruben Costa
on 8 Jul 2019
Hello, as Guillaume said it appears that you have given to us the matrix A in the form that you want.
For sorting a matrix that has different columns you can use the function sortrows! Below you can see a code that specifies what the function does!
A=[1 30 4 20; 0 0.3 0.5 0.7]' %Matrix with 2 columns
% A =
%
% 1.0000 0
% 30.0000 0.3000
% 4.0000 0.5000
% 20.0000 0.7000
B=sortrows(A,1) % 1 is the number of the column to sort by
% %Result
% B =
%
% 1.0000 0
% 4.0000 0.5000
% 20.0000 0.7000
% 30.0000 0.3000
C=sortrows(A,2) % This is the other option of sorting in this case
% C =
%
% 1.0000 0
% 30.0000 0.3000
% 4.0000 0.5000
% 20.0000 0.7000
Hope i've helped you!
0 Comments
See Also
Categories
Find more on Shifting and Sorting Matrices 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!