清空筛选条件
清空筛选条件

one column in to multiple column

4 次查看（过去 30 天）
Amila
Amila 2022-10-7
编辑： Image Analyst 2022-10-8
I have a .mat data file (results.mat). The first five columns are the date and time like yyyy, mm,dd,mm.
The 12th column has the data I need Results(:,12).
I wanted to use date (dt4) to split the column in to multiple columns:
dt4 =datetime(Results(:,1),Results(:,2), Results(:,3),0,0,0);
I tried to use
newtable = reshape(Results(:,12), 157, []);
then I realized that some days have different amount of data.
I want the date as column name. Could you kindly help me? I am new to MATLAB.
  1 个评论
Image Analyst
Image Analyst 2022-10-8
编辑：Image Analyst 2022-10-8
You forgot to attach results.mat!
Perhaps use addvars.
If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:
TUTORIAL: How to ask a question (on Answers) and get a fast answer

请先登录，再进行评论。

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

回答（1 个）

dpb
dpb 2022-10-8
It's not possible to have a table with different number or rows by variable(column); MATLAB is NOT a spreadsheet (which is agoodthing™).
It is also generally better to keep data as fields and use the field values as grouping or selection variables than to break up into different variables and then have to try to recombine to do something with.
Attach the data as a .mat file and describe what you're trying to accomplish and somebody's bound to have a way to approach it "the MATLAB way".

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by