how to add a single blank row in a table

Question

Abdul Suleman 2020-3-28

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513609-how-to-add-a-single-blank-row-in-a-table

评论： winkmal 2024-1-8

采纳的回答： Adam Danz

Dear collegues,

Supose my table is as follows

1 2 3

4 5 6

7 8 9

I want to convert it in:

1 2 3

4 5 6

7 8 9

That is, adding a blank row between some table rows. Can some one help me in this issue?

Thank you for you time.

Best,

Abdul

2 个评论
显示无隐藏无

Abdul Suleman 2020-3-28

Thanks Adam for you help. In fact your answer helps solve my problem only partially. I would like to have " " (white space) instead of NaN. Since I am saving my table as an excel file, it would be easy to replace NaN by " " in Excel environment. Best. Abdul

Adam Danz 2020-3-28

编辑：Adam Danz 2020-3-29

在 MATLAB Online 中打开

Bad news: In Matlab, numeric arrays cannot have empty values as you describe them. Numeric empty values are represented as NaN.

Good news: However, if you use writematrix, the NaN values will be written as empty values in Excel which completes you query :)

M = magic(4); 
M([2 5 10]) = nan; %insert NaNs
writematrix(M,'myExcelFile.xlsx')

请先登录，再进行评论。

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

Answer 1

Adam Danz 2020-3-28

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513609-how-to-add-a-single-blank-row-in-a-table#answer_422556

编辑：Adam Danz 2020-3-31

在 MATLAB Online 中打开

Note that "missing" values are represented by NaN values for numeric data.

% Create demo table
T = array2table(reshape(1:9,3,3)); 
% Which row should contain the empty values?
rowNum = 3;  
% Create new table with row of empty values
Tnew = T([1:rowNum,rowNum:end], :); 
Tnew{rowNum,:} = missing; 

Result:

% Original table
T =
  3×3 table
    Var1    Var2    Var3
    ____    ____    ____
     1       4       7  
     2       5       8  
     3       6       9  
% Updated table
Tnew =
  4×3 table
    Var1    Var2    Var3
    ____    ____    ____
      1       4       7 
      2       5       8 
    NaN     NaN     NaN 
      3       6       9  

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

winkmal 2024-1-8

Your solution works like a charm, even for a timetable. Though this can produce a duplicate timestamp (which it does in my case, but this can be fixed afterwards).

请先登录，再进行评论。