Reshape panel data to wide using text scan
조회 수: 4 (최근 30일)
이전 댓글 표시
I have a panel data and want to group each the last five columns according to the dates and ID names in the first column
댓글 수: 2
답변 (1개)
Rik
2020년 9월 26일
If you want to read an Excel file you can use the aptly named xlsread function. The second or third output is probably what you are looking for.
댓글 수: 2
Rik
2020년 9월 26일
Do you want to process your data inside Excel? Because then you are on the wrong website.
Do you want the result to be written back to Excel? Because you can do that: xlswrite.
What kind of processing do you want? Do you want to sort your data, or do you mean something else by grouping?
(Also, you don't need to post multiple comments, you can simply edit your last comment. As long as there is no newer comment that will not cause any confusion.)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!