How to import data from a csv that contains strings numbers and blank cells

4 次查看（过去 30 天）

R2 2015-4-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/202706-how-to-import-data-from-a-csv-that-contains-strings-numbers-and-blank-cells

评论： Star Strider 2015-4-19

I have a csv that contains a single column with a lot of data in it. The data is a variety of strings, numbers and blanks, where I want to keep it in the exact order including all of the blank cells. So an example of the data would be:

I have tried to use importdata and this works perfectly, the problem is my csv has over 1 million rows and for some reason using importdata only imports to just over the first 100k rows.

Any help would be appreciated!

5 个评论
显示 3更早的评论隐藏 3更早的评论

Philip Caplan 2015-4-15

Have you tried using "csvread" to import the entire column? For some examples, please see:

http://www.mathworks.com/help/matlab/ref/csvread.html

R2 2015-4-16

csvread does not work as it only accepts numerical values, as I have text in the column as well as numbers I get an error message.

请先登录，再进行评论。

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

采纳的回答

Star Strider 2015-4-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/202706-how-to-import-data-from-a-csv-that-contains-strings-numbers-and-blank-cells#answer_175518

在 MATLAB Online 中打开

I would experiment with textscan.

Example:

fidi = fopen('filename.csv');
D = textscan(fidi, '%s', 'Delimiter',',');
fclose(fidi);

This should read everything in as a cell array of strings. (I don’t have your file, so this is just a guess on my part. I will leave it to you to experiment.) You may need other arguments in the textscan call (such as 'EndOfLine'), but it may work as described here without any changes.