Convert CSV into Multiple 1-D Arrays

6 次查看（过去 30 天）
Justin Kuo
Justin Kuo 2021-3-17
评论： Star Strider 2021-3-17
I have a spreadsheet saved as a .csv. The first row is headers and the remaining are data. I want to read this file and create an array for each column and the name of each array should be the header (the string in the first row of that column). The data is 159 columns by 9591 rows and I have multiple sheets so I'd like for the arrays in MATLAB to name themselves.
For example, if my spreadsheet looks like:
Name Birthday Age
Alex January 1 30
Bob February 1 35
Charlie March 1 40
I would want for MATLAB to generate three arrays. One named "Name" that has the values "Alex", "Bob", and "Charlie", one named "Birthday" that has the values "January 1", "February 1", and "March 1" and one named "Age" with values "30", "35", and "40". My actual data is all numbers.
Any suggestions"

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

采纳的回答

Star Strider
Star Strider 2021-3-17
If you have R2013b or later, use the readtable funciton. It should do everything you want. You can create separate tables for each variable if you want to do that. (I would not recommend it, however. It would be best to just keep everything in the original table.)
  2 个评论
Justin Kuo
Justin Kuo 2021-3-17
I see. Thank you. It's been a few years since I've used MATLAB and I didn't use tables much back then.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by