Loading CSV file (date column A, identifier row, rest data)

1 次查看（过去 30 天）
Oli
Oli 2016-3-15
评论： Oli 2016-3-24
I want to Import the attached csv with following Code: >> d = dbload('data_US.csv');
If I then check for the variable d, it shows correctly 13 fields, but each of the fields contains only NaN's
Thank you very much
  4 个评论
显示 2更早的评论
Star Strider
Star Strider 2016-3-16
There are several options: xlsread, textscan, readtable and others.

请先登录，再进行评论。

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

采纳的回答

Daniel LaCroix
Daniel LaCroix 2016-3-16
There is a function called csvread that should load the file.
If your file has headers (or anything other than numbers), the command won't work. To get around this, set it to have an offset of one row (and no column offset).
data=csvread('data_US.csv') or data=csvread('data_US.csv',1,0)
You can also select a more specific range of data if you need to, so check out the documentation if that's something you want to do.

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by