MATLAB: Combination of tables across columns

joining tables

Hello, I have one table with the example values below:

Time1 Time2 Time3

'00:10' '00:10' '00:10'

'00:20' '00:20' '00:20'

'00:30' '00:30' '00:30'

'00:40' '00:40' '00:40'

'00:50' '00:50' '00:50'

And a second table with values:

Precipitation1 Precipitation2 Precipitation3

0,16 0 0,01

0,05 0,42 0,27

0,05 0,02 0,18

0,20 0 0,11

0,26 0 0,4

I'm looking for a combination of tables across columns that will look like:

Time1 Precipitation1 Time2 Precipitation2 Time3 Precipitation3

'00:10' 0,16 '00:10' 0 '00:10' 0,01

'00:20' 0,05 '00:20' 0,42 '00:20' 0,27

'00:30' 0,05 '00:30' 0,02 '00:30' 0,18

'00:40' 0,20 '00:40' 0 '00:40' 0,11

'00:50' 0,26 '00:50' 0 '00:50' 0,4

Thanks!!!

Best Answer

Where T1 and T2 are your two tables:

T = [T1,T2];
T = T(:,[1,4,2,5,3,6])

Related Solutions

MATLAB: Get in Order respond when using “eig” command

To sort the eigenvalues to be increasing in magnitude, use the following:

[U, d] = eig(k, m, 'vector');
[d, ind] = sort(d);
U = U(:, ind);

The eig function doesn't sort the eigenvalues it returns, for two reasons:

1) This is not needed for many applications, and would slow down the computation time for these cases. 2) For non-symmetric eigenvalue problems, the eigenvalues are complex, and none of the sorting methods for complex values are very satisfactory.

For symmetric problems (for the generalized case, this means both matrices are symmetric, and the second matrix is also positive definite), the eigenvalues are typically returned in ascending order by eig, but this is not a guarantee.

MATLAB: Why isn´t datevec accepting strings like this one: “12-12-2012 00:00”

I do not seem to be able to reproduce your problem. Are you sure you are providing strings to datevec (as this is not the case in your example)

datevec({'01-06-2014 00:00', '01-06-2014 00:10', '01-06-2014 00:20',...
         '01-06-2014 00:30', '01-06-2014 00:40', '02-06-2014 00:00',...
         '02-06-2014 00:10', '02-06-2014 00:20', '02-06-2014 00:30', '02-06-2014 00:40'})

ans =

        2014           1           6           0           0           0
        2014           1           6           0          10           0
        2014           1           6           0          20           0
        2014           1           6           0          30           0
        2014           1           6           0          40           0
        2014           2           6           0           0           0
        2014           2           6           0          10           0
        2014           2           6           0          20           0
        2014           2           6           0          30           0
        2014           2           6           0          40           0

Best Answer

Related Solutions

MATLAB: Get in Order respond when using “eig” command

MATLAB: Why isn´t datevec accepting strings like this one: “12-12-2012 00:00”

Related Question