segregate table in mat lab

hi I have the following table in mat lab.

I want to create a procedure or function in mat lab so as I can loop through the mention table and segregate it into two tables:

First one contains all information for the station LR as shown below

Secon one contain all information for the staionn LZ as shown below

Anyone can help me to do this algorithm will be appreciate

Regards.

[Jos (10584)]

What do you mean exactly by "I have the following table in matlab"? (emphasise on the word "in"!)

As a table array, cell array?

[wissam abdallah]

hi Mr, i mean by the table that i posted in my previous thread is a matrix having 5 columns and about 10000 rows information related for LR40102 and LZ40103 meteorological stations, i would like to segregate this matrix into tow tables in mat lab.

the first table should contains all information for the station LR40102 like the red one posted in my previous thread.

the second table should contains all information for the station LZ40103 like the blue one posted in my previous thread. Regards.

[Guillaume]

@wissam,

don't expect us to know about your other questions. If we have to look at the posting history of everybody who asks a question to know what they're talking about, we'd never have time to actually answer questions.

Do you have a matrix or a table? A table is a particular type of object in matlab which is not the same as a matrix.

[wissam abdallah]

Ok i would like to apologize about the history thread. about the table yes i have matrix table as shown below

[Steven Lord]

Once you've subdivided your data based on ST_CODE, what types of operations do you want to perform on the data? Consider using some of the grouped calculations functionality shown on this documentation page.

I also see you have date data (YEAR, MONTH, DAY) in your table. If you have access to release R2016b you might want to investigate storing your data in a timetable (introduced in R2016b) instead if you want to perform some date-based analysis on your data.

[wissam abdallah]

after subdivided the global matrix i would like to:

1-plot the mean of TMIN per monthes(12 monthes)in year 2010 and 2011 for station LR40102.

as well as

2- plot the mean of TMIN per monthes(12 monthes)in year 2010 and 2011 for station LZ40103.

3- i would like to separate the Matrix rows of my data into two matrix's one for LR40102 and the other for LZ40103. and thus i could make all the calculation on the appropriate matrix separately.

Regards.

Answer 1

[Peter Perkins]

Simple solution posted in reply to your identical double post.

Answer 2

[Pawel Jastrzebski]

Consider the following code:

% table
t = array2table(rand(10,2))
rowNames = {'a1' 'a2' 'a3' 'a4' 'a5' 'b1' 'b2' 'b3' 'b4' 'b5'}
t.Properties.RowNames = rowNames

% 1st WAY 
% if you know where your elements are in the table
% i.e. the split is 50/50 then

splitVector_1stHalf = 1:0.5*size(t,1)
splitVector_2stHalf = 0.5*size(t,1)+1:size(t,1)

t1 = t(splitVector_1stHalf,:)
t2 = t(splitVector_2stHalf,:)

clear t;

%---------------------------------------------------
% table
t = array2table(rand(10,2))
rowNames = {'a1' 'b2' 'b3' 'a4' 'a5' 'b1' 'a2' 'a3' 'b4' 'b5'}
t.Properties.RowNames = rowNames

% 2nd way
% get the split by the row name

% get the row names
names = t.Properties.RowNames
compare = strfind(names,'a');

logicalVecotor = logical(zeros(1,size(compare,1)));

for i=1:size(compare,1)
logicalVecotor(i) =  isempty(compare{i});
end

logicalVecotor

t1new = t(logicalVecotor,:)
t2new = t(~logicalVecotor,:)

[wissam abdallah]

hi Mr first i have create climSumry table getting from climTable_Summary.xlsx this excel file was posted in my first thread that contains all information about LR40102 and LZ40103 meteorological stations, it is contains all rows marked in red and blue colors.

% climSumry is a matrix which was created by the following command % climSumry=readtable('climTable_Summary.xlsx')

Now following your code i have i have written the following algorithm >> climSumry = array2table(rand(10,2)) rowNames = {'LR40102' 'LZ40103'} climSumry.Properties.RowNames = rowNames % 2nd way % get the split by the row name % get the row names names = climSumry.Properties.RowNames compare = strfind(names,'LR40102'); logicalVecotor = logical(zeros(1,size(compare,1))); for i=1:size(compare,1) logicalVecotor(i) = isempty(compare{i}); end logicalVecotor t1new = climSumry(logicalVecotor,:) t2new = climSumry(~logicalVecotor,:)

i am getting the following errors: climSumry =

      Var1        Var2  
    ________    ________

     0.65574     0.70605
    0.035712    0.031833
     0.84913     0.27692
     0.93399    0.046171
     0.67874    0.097132
     0.75774     0.82346
     0.74313     0.69483
     0.39223      0.3171
     0.65548     0.95022
     0.17119    0.034446

rowNames =

    'LR40102'    'LZ40103'

The RowNames property must contain one name for each row in the table.

[Pawel Jastrzebski]

1. It would have been so much easier if to understand the problem if you had embedded the code as code, not as a plain text.
2. You're using readtable to import the data from the excel spreadsheet to matlab - you import is as a TABLE already - don't use array2mat after that. I did it in my example as I needed to quickly create some exemplary table to work with.
3. In my example I make have assigned the row names to the table and made a division using those names. If you want to make sure this method works, you need to import your data with the first column being treated as the 'row names'.
4. If you want to keep your first column as a variable rather than 'row names' - then I believe Peter Perkins has provided the way to do it in your other thread.
5. General remark, if someone provides a workable example as a solution to your problem - first thing you should do is to make sure you understand every single function used. That means reading the definitions up in the documentation.

[wissam abdallah]

Ok . Mr thank you for your support. Regards