How to add field name as a string column to array
이전 댓글 표시
So I have an excel spreadsheet where each sheet is named. When I import this data into matlab, it creates a struct where its fields are the names of the sheets. and I'm trying to add a column to the data populated with the name of the spreadsheet but I'm new to matlab and can't figure it out. So the struct in matlab is like the following:
data = {
field1: [10x10 double]
field2: [10x10 double]
field3: [10x10 double]
}
and I'd like to process it to be like the following:
data = [
[10x11] %the extra column is filled with "field1"
[10x11] %extra column is "field2"
[10x11] %"field3"
]
where ultimately I want to merge everything and have
data = [30x11]
and each row is labeled with field1, field2 or field3.
I've tried several things such as using parfor loops but have not yet managed to make it work.
Any help would be appreciated. Thanks!
답변 (0개)
카테고리
도움말 센터 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!