How to extract specific data from data files?
2 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
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!