I am a MATLAB novice and stumped by a seemingly easy thing: I am analysing frequency reserve and unfortunately my Excel data for a certain amount of time looks like this:
frequency_type_a 190 35 5
frequency_type_a 50 55 6
frequency_type_a 60 200 10
frequency_type_b 170 89 6
frequency_type_b 83 35 15
frequency_type_c 200 64 17
frequency_type_c 89 32 15
So the problem is that all the different types of reserve are in the file - however I just want to analyse one type. I could use a import wizard, however I will be needing to do this for +100 files and don't want to click myself through the import manager every time! I have tried this so far:
[num text raw] = xlsread('ERGEBNISLISTE_ANONYM_SRL_2014-06-02.CSV');
typeb(raw(:,2)=='frequency_type_b')
The error message says: ??? Undefined function or method 'eq' for input arguments of type 'cell'. So I'm guessing that only works for numbers in Matrices. I have also looked at cat, match and writing a if-function, but none of them seemed doable.Is there a way to solve my problem? Maybe even a different approach, like only loading a specific type in the first place?
Any help is much appreciated!
