How to extract sub matrix from the main matrix?
    4 views (last 30 days)
  
       Show older comments
    
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 
2 Comments
Answers (1)
  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
See Also
Categories
				Find more on Resizing and Reshaping 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!

