How to extract specific data from data files?

2 views (last 30 days)
lina
lina on 10 Jun 2022
Answered: Kevin Holly on 10 Jun 2022
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.

Answers (1)

Kevin Holly
Kevin Holly on 10 Jun 2022
data = [111 135 134
111 143 176
111 124 187
222 123 287
222 473 853]
data = 5×3
111 135 134 111 143 176 111 124 187 222 123 287 222 473 853
t = array2table(data)
t = 5×3 table
data1 data2 data3 _____ _____ _____ 111 135 134 111 143 176 111 124 187 222 123 287 222 473 853
t.Properties.VariableNames = ["ID" "DataA" "DataB"]
t = 5×3 table
ID DataA DataB ___ _____ _____ 111 135 134 111 143 176 111 124 187 222 123 287 222 473 853
% giveid = input('insert the ID for analysis: ');
giveid = 111 %You can use the line above instead
giveid = 111
t(t.ID==giveid,:)
ans = 3×3 table
ID DataA DataB ___ _____ _____ 111 135 134 111 143 176 111 124 187

Community Treasure Hunt

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

Start Hunting!