MATLAB Answers

create a variable and specify its column

조회 수: 4(최근 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
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.

태그

제품


릴리스

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by