using readtable to convert columns containing dates to datetime

Question

Mailinh Nguyen 2020-11-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/635715-using-readtable-to-convert-columns-containing-dates-to-datetime

回答： Akira Agata 2020-11-4

US_Presidents.xlsx

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');

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Akira Agata 2020-11-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/635715-using-readtable-to-convert-columns-containing-dates-to-datetime#answer_533445

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"));