MATLAB Answers

create a variable and specify its column

조회 수: 5(최근 30일)
alpedhuez
alpedhuez 28 Jun 2020
댓글: alpedhuez 29 Jun 2020
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 28 Jun 2020
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 29 Jun 2020
'movevar' will allow to choose the location of a variable in a table.

댓글을 달려면 로그인하십시오.

채택된 답변

the cyclist
the cyclist 28 Jun 2020
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

댓글을 달려면 로그인하십시오.

추가 답변(1개)

Gaganjyoti Baishya
Gaganjyoti Baishya 28 Jun 2020
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.

  댓글 수: 1

alpedhuez
alpedhuez 29 Jun 2020
Thank you.

댓글을 달려면 로그인하십시오.

태그

제품


릴리스

R2020a

Translated by