MATLAB: Extracting timetable variables as array

arrayextracttimetablevariables

i have a timetable imported from excel with undefined number or variables (number of usable variables change depending on situation).

Is there a possibility to extract all the variables with names that are written on top row of timetable as array into MATLAB?

e.g.: tempC = [11, 11, 11, 11, ….]

windspeed = [7.00, 7.00, 7.00, …]

thanks for your help!

Best Answer

tempC = timetable_csv{:}{2};

windspeed = timetable_csv{:}{3};

timestamp = timetable_csv{:}{1};

Related Solutions

MATLAB: How to quickly index the first cell of sets of the array with near similar names

You can do that using eval but it is not efficient to use eval in your code frequently

mn={'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Win','Spr','Sum','Aut','Anuual'};
x = zeros(1,length(mn));
for i=1:length(mn)
x(i) = eval(['P_' mn{i} '(1)']);     
end

MATLAB: Timetable 2 table error

Don't need to convert, plot() is overloaded to be datetime aware. Just use the t-table time variable (presuming that's what you want to plot other variable(s) against) as the X and the selected others as the y argument(s).

Example concocted from the documentation example for illustration:

Date = datetime({'2015-12-18';'2015-12-18';'2015-12-18'});
StormDuration = [hours(1);hours(2);hours(12)];
Temp = [37.3;39.1;42.3];
Pressure = [29.4;29.6;30.0];
Precip = [0.1;0.9;0.0];
TT = timetable(Temp,Pressure,Precip,StormDuration,'RowTimes',Date+StormDuration);
>> TT  % show what got...
TT =
  3×4 timetable
            Time            Temp    Pressure    Precip    StormDuration
    ____________________    ____    ________    ______    _____________
    18-Dec-2015 01:00:00    37.3    29.4        0.1        1 hr        
    18-Dec-2015 02:00:00    39.1    29.6        0.9        2 hr        
    18-Dec-2015 12:00:00    42.3      30          0       12 hr        
>> 
% now plot the temperature variable
plot(TT.Time.StormDuration,TT.Temp,'*-')
hold on  % get ready to add to plot
plot(TT.Time,TT.Precip,'x-')
As long as same variable type, can concatenate and plot them together as well...
figure  % new figure
plot(TT.Time,[TT.Temp TT.Pressure TT.Precip],'*-')

Best Answer

Related Solutions

MATLAB: How to quickly index the first cell of sets of the array with near similar names

MATLAB: Timetable 2 table error

Related Question