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

Oli
2016 3 15
1 个回答
回答已采纳
更新时间：2025 5 9
3 次查看（30 天）

0 个投票

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更早的评论 隐藏 2更早的评论

Star Strider
Star Strider 2016-3-15
What’s ‘dbload’? I can’t find it in the online documentation.
Oli
Oli 2016-3-16
Thank you very much. I am using a code which is partly based on the IRIS toolbox (trying to reproduce a result from a scientific paper which employs IRIS). If you could suggest another command that uploads the file (column A are dates, row 1 beginning in B1 are headers of the columns) into the workspace, it would be equally fine for me. For some reason, the time series appears in the workspace with the correct names, but shows NaN if I open it(even though matlab recognizes the various data format e.g. "Covert to Number" when I open the file in the folder structure)
Star Strider
Star Strider 2016-3-16
There are several options: xlsread, textscan, readtable and others.

请先登录，再进行评论。

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

 采纳的回答

Daniel LaCroix
Daniel LaCroix 2016-3-16

1 个投票

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 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Workspace Variables and MAT Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by