How to import data with column headings?
조회 수: 40 (최근 30일)
이전 댓글 표시
Hello all, attached is a sample of my data. I would like to import the data as a matrix, when I do so, I lose column headings. Importing data as a table will work (see attached), however, I don't want my data to be in table form. I want my data in a matrix with top row as column headings as it is in csv sheet. Any thought would be appreciated. I tried to convert the table into array (table2array) but I lose column heading again.
댓글 수: 0
채택된 답변
Image Analyst
2017년 12월 24일
This works for me:
[~, ~, data] = xlsread('data.csv')
What happened when you tried it?
댓글 수: 2
Image Analyst
2017년 12월 24일
Like Walter says in his answer, that's not possible. You can either do a cell array, like I showed you, or use a table, like you've already done. I suggest you use a table. Tables are great and you'd do yourself a favor to get used to them.
추가 답변 (1개)
Walter Roberson
2017년 12월 24일
In MATLAB, it is not possible to have a header on a numeric matrix. If you want to preserve the headers, you have two options:
- import as a cell array with each entry being in a different cell; or
- import as a table and use the table VariableDescriptions property to store the headers (note: the variable descriptions only show up if you use summary() or ask for them specifically.)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import and Analysis에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!