Filter löschen
Filter löschen

How to extract sub matrix from the main matrix?

3 Ansichten (letzte 30 Tage)
MAHMOUD ALZIOUD
MAHMOUD ALZIOUD am 8 Mär. 2019
Kommentiert: MAHMOUD ALZIOUD am 12 Mär. 2019
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

Antworten (1)

KALYAN ACHARJYA
KALYAN ACHARJYA am 9 Mär. 2019
Bearbeitet: madhan ravi am 9 Mär. 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 Kommentar
MAHMOUD ALZIOUD
MAHMOUD ALZIOUD am 12 Mär. 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

Melden Sie sich an, um zu kommentieren.

Community Treasure Hunt

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

Start Hunting!

Translated by