using readtable to convert columns containing dates to datetime

2 次查看（过去 30 天）
Mailinh Nguyen
Mailinh Nguyen 2020-11-4
回答： Akira Agata 2020-11-4
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');

请先登录，再回答此问题。

回答（1 个）

Akira Agata
Akira Agata 2020-11-4
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"));

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by