Splitting Table into smaller sub-tables containing all rows
조회 수: 1 (최근 30일)
이전 댓글 표시
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
답변 (1개)
Jan Grüner
2020년 5월 30일
편집: 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.
By using datastore you can also manage a lot more stuff...
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Resizing and Reshaping Matrices에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!