Convert a table column of mixed data type to one data type
1 次查看(过去 30 天)
显示 更早的评论
Hi,
I have a table column that has both integers and strings. The integers are for dates. I would like to convert the integers to dates and then dates to strings.
How to do that?
Thanks in advance!
Jennifer
1 个评论
James Tursa
2016-6-16
Please post a small example, showing exactly what you have in the column and what the desired output would be. Specifically, what is the integer value and how is it related to a date?
回答(1 个)
Kirby Fears
2016-6-16
Jennifer,
Here's an example using a cell mixed type cell array "Var1" in table "t". You should be able to solve your problem with a similar approach.
t = cell2table({'date1',736495,'date2',736496,'date3',736497}');
ix = cellfun(@isnumeric,t.Var1);
t.Var1(ix) = cellfun(@(x)datestr(x,'yyyymmdd'),t.Var1(ix),'UniformOutput',false);
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Time Series Objects 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!