Go through the table with a loop and change values

19 ビュー (過去 30 日間)
Megan
Megan 2020 年 2 月 12 日
編集済み: Megan 2020 年 2 月 19 日
I have 30 columns and there are values in these columns.
  2 件のコメント
BN
BN 2020 年 2 月 12 日
編集済み: BN 2020 年 2 月 12 日
Hello, Do you want to replace -9 to NaN across your table? I mean You want to change every -9 in your table to NaN?
Megan
Megan 2020 年 2 月 12 日
yes

サインインしてコメントする。

回答 (3 件)

Subhadeep Koley
Subhadeep Koley 2020 年 2 月 12 日
編集済み: Subhadeep Koley 2020 年 2 月 12 日
ds = record ("xlsfile", "dataset.csv");
data = dataset2table(ds);
[rows, cols] = size(data);
newData = data;
for i = 1: rows
for j = 1: cols
if table2array(data(i, j)) == -9
newData(i, j) = array2table(NaN);
end
end
end
  7 件のコメント
Megan
Megan 2020 年 2 月 12 日
the empty rows are coded automatically as NaN in Matlab.
In my Questionnare -9 also means Error so, I want to change -9 into NaN
Subhadeep Koley
Subhadeep Koley 2020 年 2 月 12 日
Your "dataset.csv" is encoded with UTF-16-LE, which is not fully supported by the function readtable. Therefore, I copied and pasted all the data in a new .xlsx file (attached here).
The below code might be helpful now although it is not a very efficient solution.
clc;
data = readtable('Book1.xlsx');
[rows, cols] = size(data);
newData = data;
for i = 1: rows
for j = 1: cols
temp = table2array(data(i, j));
if iscell(temp)
temp = cell2mat(temp);
end
if temp == -9
newData(i, j) = array2table(NaN);
end
end
end

サインインしてコメントする。


Steven Lord
Steven Lord 2020 年 2 月 12 日
The standardizeMissing function can accept arrays of various types, including table arrays and timetable arrays. If you only want to standardize the form in which missing data is stored for certain variables in your table you can tell it to only operate on specific 'DataVariables' as well.

BN
BN 2020 年 2 月 12 日
編集済み: BN 2020 年 2 月 12 日
I think you won't need to use for loop. If A is the name of the table, then you can just use:
A= readtable('dataset.csv');
A{:,:}(A{:,:}==-9) = NaN
  9 件のコメント
BN
BN 2020 年 2 月 12 日
Oh yes I'm sorry I had a typo, use this:
A= readtable('dataset.csv');
A2 = table2array(A);
A2(A2==-9) = NaN;
Megan
Megan 2020 年 2 月 12 日
No, it did not work :(
Undefined operator '==' for input arguments of type 'cell'.
Error in analysis (line 25)
A2(A2==-9) = NaN;

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeTables についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by