Splitting Table into smaller sub-tables containing all rows

Question

Giwrgos Navrozidis 2020-5-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/538287-splitting-table-into-smaller-sub-tables-containing-all-rows

编辑： Jan Grüner 2020-5-30

meter4.txt

I have a txt file containing thousands of measurements from smart meters. On the first column there are the timestamps for each measurement and each column after that represents a smart-meter, each row contains the measurements taken every 15 minutes (the attached txt is a smaller version of my data). How do i split the bigger table into smaller tables, each containing 10 columns (representing a group of 10 smart meters)?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Jan Grüner 2020-5-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/538287-splitting-table-into-smaller-sub-tables-containing-all-rows#answer_443139

编辑：Jan Grüner 2020-5-30

My Idea would be to use a datastore(). The property "VariableNames" contains a list of all column names (using the first line as header). So you can just loop through the data by using the property "SelectedVariableNames" from the 2nd column on forwards without having to load the whole file.

Using readall() you can then load the section.

By using datastore you can also manage a lot more stuff...