How to extract specific data from data files?
3 views (last 30 days)
Show older comments
I want to extract specific data from a table that I've transferred into Matlab. The table looks kind of like this.
id. dataa datab datac datad
--------- ----------- -------- ----------- --------
111 135 134 ... ...
111 143 176 ...
111 124 187
222 123 287
222 473 853
I specifically want to extract all the data for a specific id number.
I am also using an input statement to get the ID number for which I'm supposed to extract data.
So far I have something similar to
giveid = input('insert the ID for analysis: ');
Thank you for any help.
0 Comments
Answers (1)
Kevin Holly
on 10 Jun 2022
data = [111 135 134
111 143 176
111 124 187
222 123 287
222 473 853]
t = array2table(data)
t.Properties.VariableNames = ["ID" "DataA" "DataB"]
% giveid = input('insert the ID for analysis: ');
giveid = 111 %You can use the line above instead
t(t.ID==giveid,:)
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!