How to open .CSV file ?

Question

Vishnu Dhakad 2018-6-13

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405450-how-to-open-csv-file

回答： Walter Roberson 2018-6-15

ABCD.CSV

I want to open CSV file. (please find the attachment)

in the CSV file, I have date and time in the different column but I want to combine in one column. I have read with following code but I getting an error.

fbc = fopen('ABCD.CSV');

BC = textscan(fbc, '"%.f-%3.s-%.f", "%.f:%.f", %.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f,%.f');

fclose(fbc);

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

KSSV 2018-6-13

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405450-how-to-open-csv-file#answer_324495

在 MATLAB Online 中打开

[num,txt,raw] = xlsread('ABCD.csv') ;

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Vishnu Dhakad 2018-6-15

编辑：Vishnu Dhakad 2018-6-15

Thank you, sir

but time is showing in decimal, how to correct into normal?

I want to use the function fopen and textscan.

Can you explain to me how to use this type of function?

请先登录，再进行评论。

Answer 2

Walter Roberson 2018-6-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/405450-how-to-open-csv-file#answer_324789

在 MATLAB Online 中打开

fmt = ['%{dd-MMM-yy}D%{HH:mm}D', repmat('%f', 1, 50)];
fbc = fopen('ABCD.CSV', 'r', 'n', 'UTF8');
BC = textscan(fbc, fmt, 'Delimiter', ',', 'CollectOutput', 1);
fclose(fbc);
dt = BC{1}+(BC{2}-dateshift(BC{2},'start','day'));
dt.Format = 'default';
numbers = BC{3};