Hi Anette,
I understand that you want to plot the number of overlapping values between specific columns of multiple Excel files, and display these overlaps as bars on a graph, labeled with the corresponding file names.
I assume that your Excel files are consistently named and formatted, and that you have access to all files within your MATLAB environment.
You can follow the below steps to acheive the same:
- Load Excel Files and Extract Columns: First, read the Excel files and extract the relevant columns (2 to 4) for comparison. Ensure you store these columns in a structured format for easy access.
- Find Overlapping Values: Compare the values in each specified column between all pairs of files to find overlaps.
overlaps = zeros(numFiles, numFiles, 3);
for i = 1:numFiles-1
for j = i+1:numFiles
for col = 1:3
% Find overlapping values
overlaps(i, j, col) = sum(ismember(data{i, col}, data{j, col}));
end
end
end
- Prepare Data for Plotting: Gather the overlap data and prepare labels for the plot.
for i = 1:numFiles-1
for j = i+1:numFiles
for col = 1:3
if overlaps(i, j, col) > 0
labels{end+1} = sprintf('output%d-output%d col%d', i, j, col+1);
overlapCounts(end+1) = overlaps(i, j, col);
end
end
end
end
end
- Plot the Data: Use MATLAB's bar plot to visualize the number of overlaps with appropriate labels.
- Refine and Test: Ensure the script handles all files correctly, and test with a subset of files if necessary to verify functionality.
References:
- Refer to the documentation of readmatrix for reading data from Excel files: https://www.mathworks.com/help/matlab/ref/readmatrix.html
- Refer to the documentation of ismember for finding common elements: https://www.mathworks.com/help/matlab/ref/ismember.html
- Refer to the documentation of bar for creating bar plots: https://www.mathworks.com/help/matlab/ref/bar.html
Hope this helps!
