How to split column of a table?
조회 수: 5 (최근 30일)
이전 댓글 표시
Hello everyone,
I want to split a multi-column of a table into several columns and I tried to use
newtable = splitvars(tbl);
% or
newtable = splitvars(tbl, 'Multico');
But I got this error
Undefined function or variable 'splitvars'.
Could you suggest an alternative to this method?
I'm using MATLAB R2017b.
Many thanks,
댓글 수: 4
Adam Danz
2019년 12월 19일
Could you explain in more detail what the inputs and expected outputs would be? Maybe provide an example.
채택된 답변
Adam Danz
2019년 12월 19일
편집: Adam Danz
2019년 12월 19일
T = [omni(:,1), array2table(omni.Var2)];
% Specify VariableNames if you wish
% T = [omni(:,1), array2table(omni.Var2,'VariableNames',{. . .})];
Results
head(T) % show first few rows
ans =
8×12 table
omni_datetime Var1 Var2 Var3 Var4 Var5 Var6 Var7 Var8 Var9 Var10 Var11
____________________ ____ ____ ____ ____ _____ ____ ____ _____ ____ _____ _____
01-Jan-2013 00:00:00 2.4 2.2 -0.6 -0.4 44561 1.6 358 0.054 0.42 2 4
01-Jan-2013 01:00:00 2.5 1.8 -1.4 -0.5 37181 2.1 355 0.046 0.52 2.31 4
01-Jan-2013 02:00:00 2.8 2.2 -1.6 -0.4 28131 1.8 359 0.033 0.44 1.49 3
01-Jan-2013 03:00:00 3 2.8 -1.1 0 24936 1.9 352 0.032 0.44 1.35 2
01-Jan-2013 04:00:00 3 2.5 -1.6 0.4 23930 2 351 0.033 0.47 1.41 1
01-Jan-2013 05:00:00 3.1 2.5 -1.4 0.8 22626 2.1 349 0.036 0.49 1.37 3
01-Jan-2013 06:00:00 3 2.6 -1.3 0.8 23016 2.2 343 0.038 0.5 1.54 1
01-Jan-2013 07:00:00 3 2.4 -1.8 0.6 24192 2.3 341 0.038 0.51 1.62 0
댓글 수: 11
Adam Danz
2019년 12월 20일
The AM/PM needs to be specified in the actual time-values.
t_final = {
'00:24:05 AM'
'10:36:05 AM'
. . .
};
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Type Conversion에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!