MATLAB Answers

create a variable and specify its column

1 view (last 30 days)
alpedhuez
alpedhuez on 28 Jun 2020
Commented: alpedhuez on 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 Comments

the cyclist
the cyclist on 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 on 29 Jun 2020
'movevar' will allow to choose the location of a variable in a table.

Sign in to comment.

Accepted Answer

the cyclist
the cyclist on 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 Comments

Sign in to comment.

More Answers (1)

Gaganjyoti Baishya
Gaganjyoti Baishya on 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.

Tags

Products


Release

R2020a

Community Treasure Hunt

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

Start Hunting!