Hi HSukas,
Steps to Filter Data
- Read the CSV File: Use readcell to read the data if it's structured like a cell array.
- Define the Criteria for Removal: Create a list of keywords or phrases that you want to filter out.
- Filter the Data: Use logical indexing to remove rows that contain any of the specified phrases.
I wrote an example code for the same:
% Step 1: Read the CSV file
data = readcell('your_file.csv'); % Replace 'your_file.csv' with your actual filename
% Step 2: Define the phrases to remove
phrasesToRemove = {"Number%", "Under $50", "$50-$100", "$100-$200"};
% Step 3: Initialize a logical index for rows to keep
rowsToKeep = true(size(data, 1), 1); % Assume all rows are to be kept initially
% Loop through each phrase and update the logical index
for i = 1:length(phrasesToRemove)
% Create a logical array that is true for rows containing the phrase
containsPhrase = contains(data, phrasesToRemove{i}, 'IgnoreCase', true);
rowsToKeep = rowsToKeep & ~any(containsPhrase, 2); % Keep rows that do not contain the phrase
end
% Step 4: Filter the data
filteredData = data(rowsToKeep, :);
% (Optional) Step 5: Write the cleaned data to a new CSV file
writecell(filteredData, 'cleaned_data.csv'); % Replace with desired output filename
% Display the cleaned data
disp(filteredData);
Hope this helps!
Here is the documentation for “contains” and “readcell’ function of MATLAB:
