Hi,
I understand that you want to clean your CSV file by eliminating all the rows with zeros in column C (keep the first and last row) and save it.
One way to implement the above task is with the code below:
% Set output directory and filename pattern
outputDir = 'C:\Users\output_files';
outputFilenamePattern = 'output_RPM_%d.csv';
[file, filepath] = uigetfile({'*.csv;*.xlsx;*.xls'}, 'Select Trajectory Table File(s)', 'C:\Users\INARUPAR\Desktop\MATLAB WORKOUT\', 'MultiSelect', 'on');
if ~iscell(file)
file = {file};
end
for i = 1:numel(file)
fullFilePath = fullfile(filepath, file{i});
% Step 1: Load the entire file as text
fileID = fopen(fullFilePath, 'r');
fileContent = textscan(fileID, '%s', 'Delimiter', '\n', 'Whitespace', '');
fclose(fileID);
% Convert the cell array to a string array
fileLines = string(fileContent{1});
% Step 2: Extract the data columns into a table
% Find the line where the data starts
dataStartLine = find(contains(fileLines, 'X,X [ms],Y1,Y2,Y3,Y4,Y5,Y6,Y7,Y8'), 1);
% Extract the data lines
dataLines = fileLines(dataStartLine:end);
% Write these lines to a temporary CSV file
tempFileName = 'temp_data.csv';
fileID = fopen(tempFileName, 'w');
fprintf(fileID, '%s\n', dataLines);
fclose(fileID);
% Read the data into a table
opts = detectImportOptions(tempFileName);
opts.SelectedVariableNames = {'X', 'X_ms_', 'Y1', 'Y2', 'Y3', 'Y4', 'Y5', 'Y6', 'Y7', 'Y8'};
data = readtable(tempFileName, opts);
% Step 3: Remove leading zeros from Y1
firstNonZeroIndex = find(data.Y1 ~= 0, 1, 'first');
data = data(firstNonZeroIndex-1:end, :);
% Step 4: Remove trailing zeros from Y1
lastNonZeroIndex = find(data.Y1 ~= 0, 1, 'last');
data = data(1:lastNonZeroIndex+1, :);
% Step 5: Combine metadata and data into a new file
outputFileName = fullfile(outputDir, sprintf(outputFilenamePattern, i));
% Write the metadata (all lines before the data start line)
fileID = fopen(outputFileName, 'w');
fprintf(fileID, '%s\n', fileLines(1:dataStartLine-2));
fclose(fileID);
% Append the cleaned data to the new file
writetable(data, outputFileName, 'WriteVariableNames', true, 'WriteMode', 'append');
% Optionally, delete the temporary file
delete(tempFileName);
disp(['Data processing complete for file: ', file{i}, '. Output saved to ', outputFileName]);
end
The code processes selected trajectory data files by extracting data, removing rows with zeros in column C, and saving the cleaned data with metadata to a new output file in a specified directory.
You can change the output directory by modifying the “outputDir” variable, and the output file name can also be adjusted using the “outputFilenamePattern” variable.
Hope it helps!
