create a variable and specify its column

Question

alpedhuez 2020-6-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/556168-create-a-variable-and-specify-its-column

评论： 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 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 2020-6-29

'movevar' will allow to choose the location of a variable in a table.

请先登录，再进行评论。

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

Answer 1

the cyclist 2020-6-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/556168-create-a-variable-and-specify-its-column#answer_458314

在 MATLAB Online 中打开

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.

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

请先登录，再进行评论。

Answer 2

Gaganjyoti Baishya 2020-6-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/556168-create-a-variable-and-specify-its-column#answer_458308

在 MATLAB Online 中打开

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