Combine date and time

I have 5 coloumn data consist year, month, date, hour and elevation data. I want to merge the data into two coloumn so it become:

coloumn1(datetime) coloumn 2

YYYY-MM-DD HH:mm:ss Elevation Data

I have tried some examples from matlab forum, but it not work. I used 2016b matlab version. Can anyone help me? Thank you.

Answer 1

[Cris LaPierre]

The best way to combine data types (datetime and numeric) is to use a table. There are several possible approaches. Here is one.

1. Load the table
2. Use datetime to create Date from first 3 columns. Add hours(column 4) to it to complete datetime
3. Create variable for elevation data
4. Use table to combine Date and Elev
5. Format the date

data = readmatrix("tidal data.txt");
Date = datetime(data(:,1:3)) + hours(data(:,4));
Elev = data(:,5);

T = table(Date,Elev);
T.Date.Format = 'yyyy-MM-DD HH:mm:ss'

T = 69445×2 table
            Date            Elev
    ____________________    ____

    2008-10-300 02:00:00    1772
    2008-10-300 03:00:00    1712
    2008-10-300 04:00:00    1650
    2008-10-300 05:00:00    1637
    2008-10-300 06:00:00    1715
    2008-10-300 07:00:00    1761
    2008-10-300 08:00:00    1907
    2008-10-300 09:00:00    2069
    2008-10-300 10:00:00    2129
    2008-10-300 11:00:00    2150
    2008-10-300 12:00:00    2096
    2008-10-300 13:00:00    2046
    2008-10-300 14:00:00    1963
    2008-10-300 15:00:00    1842
    2008-10-300 16:00:00    1765
    2008-10-300 17:00:00    1745

[Amra Rajuli]

Thank you very much. It is very helpful