Import CSV files, find extraction condition, and local maxima

3 次查看（过去 30 天）
GH
GH 2020-6-18
编辑： Image Analyst 2020-6-19
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 个评论
显示 2更早的评论
Image Analyst
Image Analyst 2020-6-18
Not going there. Why didn't you attach it with the paper clip icon?
GH
GH 2020-6-18
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...!

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Image Analyst
Image Analyst 2020-6-18
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 个评论
显示 2更早的评论
GH
GH 2020-6-19
编辑：GH 2020-6-19
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 2020-6-19
编辑：Image Analyst 2020-6-19
This seems to work fine to read in the matrix
data = readmatrix('dataset.csv', 'numHeaderLines', 1)
fprintf('Done running %s.m ...\n', mfilename);

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by