create a variable and specify its column
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
alpedhuez
am 28 Jun. 2020
Kommentiert: alpedhuez
am 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 Kommentare
the cyclist
am 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?
Akzeptierte Antwort
the cyclist
am 28 Jun. 2020
% 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])
0 Kommentare
Weitere Antworten (1)
Gaganjyoti Baishya
am 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.
Siehe auch
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!