How to extract sub matrix from the main matrix?

4 views (last 30 days)
Dear All, I have a numerical matrix of three columns, (Year, Month and Day), but each days does not have the same number of rows as another day, how can I tell MATLAB please to extract a matrix from the main one based on the 2nd & 3rd column value? for example I attached the file, what is the code to extract the matrix from 1/1/2010 to 2/3/2010? please see the excel file

Answers (1)

KALYAN ACHARJYA
KALYAN ACHARJYA on 9 Mar 2019
Edited: madhan ravi on 9 Mar 2019
What I have found that there is no data as 2/3/2010.
Suppose I take as example your exel file having
Row 1: 10 1 1
...
..
Row 46: 10 2 4
Supose you want access the some portion of the excel file (2,2) to (10,3)-Submatrix includes the elements having inbetween,
it goes this way
filename='Question.xlsx';
data=xlsread(filename);
Data=data(2:10,2:3)
Output:
Data =
1 1
1 1
1 1
1 1
1 1
1 2
1 2
1 2
1 2
  1 Comment
MAHMOUD ALZIOUD
MAHMOUD ALZIOUD on 12 Mar 2019
this can be done if i have small datab but actully i have 1.2 million rows of data and i cannot do this manually

Sign in to comment.

Categories

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