MATLAB Answers

Import CSV files, find extraction condition, and local maxima

3 views (last 30 days)
GH
GH on 18 Jun 2020
Edited: Image Analyst on 19 Jun 2020
Hi everyone,
I am trying to read in multiple .csv files with lot of data (mostly numbers except : the first row contains 2 strings and several numbers, and these first row numbers are actully the same in every .csv)
After that I have to find in the first row the value '50' and get its column and then find the local maxima in that.
Can you pls help me, how to solve this?
Thanks in advance.

  4 Comments

Show 1 older comment
GH
GH on 18 Jun 2020
Hey there,
I created a Google drive link, with a dataset (I have 6 of this kind in one folder) and I also made an .xlsx file, where I highlighted which data - column and rows would like to extract (to find the local maximas in those colums...)and I highlighted the two strings in the begining.
https://drive.google.com/drive/folders/1RU7sAqIykvlhtj-FpdNLhYZchq1_xhGi?usp=sharing
I would appreciate any help.
Thank you very very much, if something is still unclear do not hesitate to comment on it.
Image Analyst
Image Analyst on 18 Jun 2020
Not going there. Why didn't you attach it with the paper clip icon?
GH
GH on 18 Jun 2020
Although, I changed a little on the dataset, I didn't want to leave it on public forever, and I wasn't sure about I can delete the comment later on, but I attached them here now, sorry about that...!

Sign in to comment.

Accepted Answer

Image Analyst
Image Analyst on 18 Jun 2020
Grace:
This should do it:
% Create sample matrix.
m = randi(500, 100, 30);
% Find out all the rows that have a 50 in them.
rowsWith50 = find(any(m == 50, 2))
% If any row(s) do, then find the column with the 50 in it,
% and get the max of that column.
if ~isempty(rowsWith50)
firstRowWith50 = m(rowsWith50(1), :);
% Get its column
columnWith50 = find(firstRowWith50 == 50, 1, 'first')
% Find the max of this column over all rows
theMax = max(m(:, columnWith50))
end

  4 Comments

Show 1 older comment
Image Analyst
Image Analyst on 18 Jun 2020
Try importdata(). Or look in csvread() or dlmread(). One or both of them let you specify what row to start with -- how many headerlines to skip.
GH
GH on 19 Jun 2020
Unfortunately, it seems like this solution isn't working for me, because 50 would be one of the variable like 'y' and I would like to search in its column the belonging 'x' which is /are the local maximas. Your solution works great for if the value 50 can be also one of the solution. (My x datas are much more smaller values, then 50 so now the code finds 50 as highest in the column, my apologies if I was unclear)
But I managed to read in the csv files due to your tips thank you
Image Analyst
Image Analyst on 19 Jun 2020
This seems to work fine to read in the matrix
data = readmatrix('dataset.csv', 'numHeaderLines', 1)
fprintf('Done running %s.m ...\n', mfilename);

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!