Removing NaN from an array in a table

Question

Sonali 2023-12-26

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2063987-removing-nan-from-an-array-in-a-table

评论： Sonali 2023-12-28

Screenshot 2023-12-25 200131.png

I opened a cdf file and saved the data in a table. It has arrays in the table's rows. Is there anyway we can make a single table with the rows of arrays as a part of table?

data file:

https://drive.google.com/file/d/16MKcQ0Yfbpy8WKixvtL-OeEixdrwa8mL/view?usp=sharing

4 个评论
显示 2更早的评论隐藏 2更早的评论

Sonali 2023-12-28

please check the data link above

Sonali 2023-12-28

Screenshot 2023-12-25 200131.png

I tried rmmissing. It didnt work with the current dataset.

Splitvars is for columns. Here we have multirows in each row of the table.

Here's the datafile, in case someone needs and can provide a better solution.

https://drive.google.com/file/d/16MKcQ0Yfbpy8WKixvtL-OeEixdrwa8mL/view?usp=sharing

请先登录，再进行评论。

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

Answer 1

Rangesh 2023-12-26

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2063987-removing-nan-from-an-array-in-a-table#answer_1377377

在 MATLAB Online 中打开

Hi Sonali,

I understand that you are looking to separate the rows of array present in the table to individual columns in the table and remove the NaN values from the table.

Here is reference code on how to address this issue:

Creating table "patients” containing a multicolumn variable “BloodPressure” which contains “NaN” values.

LastName = ["Sanchez";"Johnson";"Zhang";"Diaz";"Brown"];
Age = [38;43;38;40;49];
Weight = [176;163;131;133;119];
BloodPressure = [NaN NaN; 109 77; 125 83; NaN 75; 122 80];
patients = table(LastName,Age,Weight,BloodPressure)
patients = 5×4 table
    LastName     Age    Weight    BloodPressure
    _________    ___    ______    _____________

    "Sanchez"    38      176       NaN    NaN  
    "Johnson"    43      163       109     77  
    "Zhang"      38      131       125     83  
    "Diaz"       40      133       NaN     75  
    "Brown"      49      119       122     80  

Splitting the variable across the columns of "BloodPressure".

splitvars(patients,'BloodPressure')
ans = 5×5 table
    LastName     Age    Weight    BloodPressure_1    BloodPressure_2
    _________    ___    ______    _______________    _______________

    "Sanchez"    38      176            NaN                NaN      
    "Johnson"    43      163            109                 77      
    "Zhang"      38      131            125                 83      
    "Diaz"       40      133            NaN                 75      
    "Brown"      49      119            122                 80      

Removing the NaN values from the table.

rmmissing(patients)
ans = 3×4 table
    LastName     Age    Weight    BloodPressure
    _________    ___    ______    _____________

    "Johnson"    43      163       109     77  
    "Zhang"      38      131       125     83  
    "Brown"      49      119       122     80  

For further understanding on the functions used, please do refer the following documentation: