Opening CSV file with numbers and strings

Question

V 2015-4-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/197267-opening-csv-file-with-numbers-and-strings

评论： V 2015-4-11

Hi, I am trying to open a csv file which has several columns of numbers. However, often there is a gap in one of the columns and the number gets replaced by "." .

I am trying to load the file into matlab, but if I use fopen followed by textscan, it stops reading on the first "." .

How can I load the csv file into a matlab matrix?

Thanks in advance,

2 个评论
显示无隐藏无

dpb 2015-4-11

Post a (short) section of the file w/ the problem/symptom and show us what you tried, specifically...

V 2015-4-11

编辑：V 2015-4-11

在 MATLAB Online 中打开

123.csv

The code I am using is:

PriceDataLoc = 'C:\123.csv';
PriceData_file = fopen(PriceDataLoc);
Prices1 = textscan(PriceData_file,'%f %f %f %f %f %f','delimiter',' ');
fclose(PriceData_file);
Prices1=[Prices1{:}]

I attach the csv file. A gap in the data is identified with ".". From that point on, the textscan does not read anything else.

Thanks!

请先登录，再进行评论。

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

Answer 1

Stephen23 2015-4-11

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/197267-opening-csv-file-with-numbers-and-strings#answer_174818

编辑：Stephen23 2015-4-11

在 MATLAB Online 中打开

This code reads the all eight lines of your sample file correctly, including those pesky missing data:

fid = fopen('123.csv','rt');
C = textscan(fid,'%f%f%f%f%f%f','TreatAsEmpty','.');
fclose(fid);

And we can check it in the command window:

>> cell2mat(C)
ans =
  1.99e+007           19            0            1        98793
  1.99e+007        18.75    -0.013158            1        98793
  1.99e+007        18.75            0            1        98793
  1.99e+007         18.5    -0.013333            1        98793
  1.99e+007       19.125     0.033784            1        98793
  1.99e+007          NaN     -0.03268            1        98793
  1.99e+007       18.125     -0.02027            1        98793
  1.99e+007       18.125            0            1        98793