How can I use a loop to store a table in separate arrays?
1 回表示 (過去 30 日間)
古いコメントを表示
Juliette Smoorenburg
2020 年 3 月 24 日
コメント済み: Obinna Princewill Okoro
2020 年 3 月 24 日
Hi all,
I've got a table [35040x29 table] and I want to create separate arrays so I'll get a [35040x1] format
In the following code I did it manually, but I want to use a loop to create the separate arrays in a much faster way.
house_1_U = table1.H01U_kWh;
house_1_G = table1.H01G_kWh;
house_2_U = table1.H02G_kWh;
house_2_G = table1.H02U_kWh;
Thanks in advance!
Juliette
2 件のコメント
採用された回答
Adam Danz
2020 年 3 月 24 日
編集済み: Adam Danz
2020 年 3 月 24 日
The best approach is to not break apart the table and use indexing instead. Tables are neat, tidy, and they keep the data together rather than scattering the data between several variables. Instead of using house_1_G you could just use table1.H01G_kWh.
If you must break apart the table, you could put each column into a cell array using the line below.
c = arrayfun(@(x){table1(:,x)}, 1:size(table1,2));
Then, to access column 2,
c{2}
Avoid putting each column of the table into a separate variables as the demo shows in your question. This requires dynamic variable naming which is a really bad form of programming and causes many problems.
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Matrices and Arrays についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!