How to extract specific data from data files?
10 ビュー (過去 30 日間)
古いコメントを表示
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 件のコメント
回答 (1 件)
Kevin Holly
2022 年 6 月 10 日
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 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!