Removing NaN from an array in a table

3 次查看（过去 30 天）
Sonali
Sonali 2023-12-26
评论： Sonali 2023-12-28
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更早的评论
Sonali
Sonali 2023-12-28
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

请先登录，再进行评论。

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

回答（1 个）

Rangesh
Rangesh 2023-12-26
Ran in:
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:
I hope this resolves your query.
Thanks,
Rangesh.
  1 个评论
Sonali
Sonali 2023-12-28
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

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by