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 件のコメント

Andrei Bobrov
Andrei Bobrov 2019 年 3 月 8 日
Question.xlsx - empty file.
MAHMOUD ALZIOUD
MAHMOUD ALZIOUD 2019 年 3 月 8 日
here it is

サインインしてコメントする。

回答 (1 件)

KALYAN ACHARJYA
KALYAN ACHARJYA 2019 年 3 月 9 日
編集済み: madhan ravi 2019 年 3 月 9 日

0 投票

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 件のコメント

MAHMOUD ALZIOUD
MAHMOUD ALZIOUD 2019 年 3 月 12 日
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

サインインしてコメントする。

質問済み:

2019 年 3 月 8 日

コメント済み:

2019 年 3 月 12 日

Community Treasure Hunt

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

Start Hunting!

Translated by