Convert datetime into seperate columns

4 Ansichten (letzte 30 Tage)
Yoni Verhaegen -WE-1718-
Yoni Verhaegen -WE-1718- am 25 Jul. 2020
Bearbeitet: Brittany Scheid am 25 Jul. 2020
I have a CSV table that I load in Matlab and looks as follows (see below). I would like to separate the datetime column into separate values in the form of a double array, with 1 column for 'year', 1 column for 'month', and 1 column for 'day', something like:
2020 | 07 | 20
2020 | 07 | 20
The hour is not important. How can I do this? I attach the CSV file which can be loaded as:
seawatertemp_westhinder = readtable('seawatertemp_westhinder.csv');

Akzeptierte Antwort

Brittany Scheid
Brittany Scheid am 25 Jul. 2020
Bearbeitet: Brittany Scheid am 25 Jul. 2020
In one line to get a double array:
[y,m,d] = ymd(seawatertemp_westhinder.times);
[y,m,d]
% Add to table
seawatertemp_westhinder.year= y
seawatertemp_westhinder.month = m
seawatertemp_westhinder.day= d

Weitere Antworten (0)

Kategorien

Mehr zu Dates and Time finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by