Converting Timetable to Individual Columns

Question

Cameron Power 2018-6-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406374-converting-timetable-to-individual-columns

评论： Cameron Power 2018-6-19

Hello, I am trying to convert my timetable into a table with hour, day, month, and year in separate columns. This is so I can create a plot of hour with respect too another variable, if you have any ideas they would be much appreciated, thank you.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Shweta Singh 2018-6-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/406374-converting-timetable-to-individual-columns#answer_325338

在 MATLAB Online 中打开

Hi,

Since I don't have access to the data you are trying to convert, I am going to use the air quality data included with MATLAB. Here are the steps you can try:

% Create a timetable
indoors = readtable('indoors.csv'); 
indoors = table2timetable(indoors);  
% access the 'Time' column; times is now a datetime
times = indoors.Time;
% Create table
times_table = table(times.Hour, times.Day, times.Month, times.Year);
% The variable names appears as Var1, Var2, ... They can be changed using Properties
times_table.Properties.VariableNames = {'Hour', 'Day', 'Month', 'Year'};