Convert a table column of mixed data type to one data type

1 次查看（过去 30 天）
JFz
JFz 2016-6-16
回答： Kirby Fears 2016-6-16
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
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
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);

类别

在 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