using readtable to convert columns containing dates to datetime

2 Ansichten (letzte 30 Tage)
Mailinh Nguyen
Mailinh Nguyen am 4 Nov. 2020
Beantwortet: Akira Agata am 4 Nov. 2020
I need to convert columns containing dates in the xlsx file to datetime format using readtable()
This is what have so far, but there is an error.
T = readtable('US_Presidents.xlsx'); %Create a table by reading from a file.
datetime(US_Presidents.BirthDate,'InputFormat', 'yyyy-MM-dd');

Antworten (1)

Akira Agata
Akira Agata am 4 Nov. 2020
Like this?
T = readtable('US_Presidents.xlsx','PreserveVariableNames',true);
T.("Birth Date") = datetime(T.("Birth Date"));
T.("Death Date") = datetime(T.("Death Date"));
T.("Date took office") = datetime(T.("Date took office"));
T.("Date left Office") = datetime(T.("Date left Office"));

Kategorien

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

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by