How do I find and replace text in an imported table?
18 次查看(过去 30 天)
显示 更早的评论
I've imported data from an Excel file and have it as a table (DemographicsData). I would now like to find all cells that contain 'Male' and replace them with '1' and 'Female' with '2'. How do I run this command? I'm new with MATLAB and would appreciate any help.
0 个评论
采纳的回答
Adam Danz
2019-8-28
编辑:Adam Danz
2019-8-28
Presumably there's a column in your table for sex|gender and the Male|Female categories are listed in that column. You could use findgroups() to automatically replace M|F with group numbers.
% assuming the table is named T and the
% column is named "sex"
T.sex = findgroups(T.sex);
Another option is to assign those values directly,
T.sex(strcmpi(T.sex,'Male')) = {1};
T.sex(strcmpi(T.sex,'Female')) = {2};
9 个评论
Adam Danz
2021-3-23
编辑:Adam Danz
2021-3-23
@Lorenz Bankel thanks a lot for taking the time to point out that error. I updated that comment to fix the error.
Explanation of my error:
Since matlab does not allow subscripting as in T(ind) into a table (as of r2021a), I was incorrectly subscripting rows and columns using T(row,col) which selects all rows and columns listed, not just the combinations of (row,col) indices.
Explanation of the correction:
Instead, the table is now converted to a cell array and sub2ind is used to get the linear indices that correspond to the selected rows and column. The updated cell array then replaces the values in the table.
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Live Scripts and Functions 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!