create a variable and specify its column

2 次查看（过去 30 天）
alpedhuez
alpedhuez 2020-6-28
评论： alpedhuez 2020-6-29
Suppose I have a table
day temperature
1/1/2020 30
I want to create a vaiable 'month" from 'day' and put it next to 'day' like
day month temperature
1/1/2020 1 30
Please advise.
  2 个评论
the cyclist
the cyclist 2020-6-28
For you future reference, it is better to actually show what you have via MATLAB syntax (or actually uploading the data). Otherwise, we need to guess about the formats of everything.
Specifically, is day a string, a character array, or a datetime?
alpedhuez
alpedhuez 2020-6-29
'movevar' will allow to choose the location of a variable in a table.

请先登录，再进行评论。

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

采纳的回答

the cyclist
the cyclist 2020-6-28
The specifics will depend on what format the variable day is. Here, I assume it is a datetime.
% Create the table
day = datetime('1/1/2020');
temperature = 30;
T = table(day,temperature);
% Derive month from day
T.month = month(day);
% Rearrange the columns
T = T(:,[1 3 2])
You might find this documention page helpful.

更多回答（1 个）

Gaganjyoti Baishya
Gaganjyoti Baishya 2020-6-28
Hi
You can get the month from the day string by iterating it till you get the month.
for i=1:size
if day(i)=='/'
if day(i+2)=='/'
month=day(i+1);
else
month=day(i+1) + day(i+2) %char concatenate
end
break;
end
month gives the required value of month. You just need to put it in the column.

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by