How to fill a blank cell with the value of the cell above it in a table?

Question

KD 2025-3-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2175563-how-to-fill-a-blank-cell-with-the-value-of-the-cell-above-it-in-a-table

评论： KD 2025-3-24

采纳的回答： Matt J

blankcell.png

在 MATLAB Online 中打开

Hello,

I am running a script that reads through a large excel file and creates a table. One of the columns in the file will sometimes have blank cells. The value should be the value that is above it, but this sheet is large and updated often, so it would be too much to manually update it each time.

This is the code I'm currently using that isn't working:

for j = 1:height(data)
    %Fill in blank data
    if isempty(data.Var1)
        data.Var1 = fillmissing(data.Var1,'previous');
    end
end

I attached the output that I'm getting. Instead of 0x0 char, it should be the value listed above.

Thank you!

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

请先登录，再进行评论。

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

Answer 1

Matt J 2025-3-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2175563-how-to-fill-a-blank-cell-with-the-value-of-the-cell-above-it-in-a-table#answer_1562369

编辑：Matt J 2025-3-24

在 MATLAB Online 中打开

The only line of code you need is this one

data.Var1=fillmissing(data.Var1,'previous')

Get rid of the lines around it.

Var1={'ABC01';'';'ddddd';''}; Var2=(1:4)';
data=table(Var1,Var2)
data = 4x2 table
       Var1       Var2
    __________    ____

    {'ABC01' }     1  
    {0x0 char}     2  
    {'ddddd' }     3  
    {0x0 char}     4  
data.Var1=fillmissing(data.Var1,'previous')
data = 4x2 table
      Var1       Var2
    _________    ____

    {'ABC01'}     1  
    {'ABC01'}     2  
    {'ddddd'}     3  
    {'ddddd'}     4  