MATLAB: How to find and replace text in an imported table

findreplacetable

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.

Best Answer

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};

Related Solutions

MATLAB: Find matched string in table

Compare the text data stored in the table with a string array. Let's build a sample using the example from the documentation for the table function.

load patients
patients = table(LastName,Gender,Age,Height,Weight,Smoker,Systolic,Diastolic);

Let's extract patients under 40, separated by gender.

malePatientsUnder40 = patients(patients.Gender == "Male" & patients.Age < 40, :)
femalePatientsUnder40 = patients(patients.Gender == "Female" & patients.Age < 40, :)

Let's check against the full list of patients under 40.

patientsUnder40 = patients(patients.Age < 40, :);

Combine the male and female patients into one larger table and compare it against the full list.

isequal(sortrows([malePatientsUnder40; femalePatientsUnder40]), sortrows(patientsUnder40))

MATLAB: How to organize a table using a specified cell array

One approach is to use the findgroups function:

load patients
T = table(Age,Gender,Height,Weight,Smoker,...
    'RowNames',LastName);
[Grp,ID] = findgroups(T.Gender);
Males = T(Grp==2,:);

The ‘ID’ variable indicates that these are sorted lexiically, so 1=Female, and 2=Male.

Best Answer

Related Solutions

MATLAB: Find matched string in table

MATLAB: How to organize a table using a specified cell array

Related Question