Error while reading the .csv file

Question

Kumaresh Kumaresh 2024-11-28，7:42

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2169378-error-while-reading-the-csv-file

评论： Walter Roberson 2024-12-1，4:49

在 MATLAB Online 中打开

While reading the .txt files, the below code runs good. But when I read .csv files, I end up with the following error.

Error using fopen

File identifier must be an integer-valued scalar of type double.

Error in check (line 12)

fid = fopen(fn, 'r');

Can someone help me to resolve this part.

clear
clc
 
%f=dir('*.txt');                     % finding all txt files
f=dir('*.csv');                     % finding all csv files
n_snapshots=size(f,1);              % finding number of snapshots
 
for i=1:n_snapshots
    %fn=f(i).name;                   % for .txt file
    fn = readmatrix(f(i).name);      % for .csv file
    fid = fopen(fn, 'r');             % reading files
    % scaning files into 4 columns - gives in rows
    data=fscanf(fid, '%f %f %f %f' , [4, inf]);               
    % exporting columns
    x=data(4,:);
    y=data(3,:);
    v(i,:)=data(1,:);
    u(i,:)=data(2,:);
    fclose('all');
end 

Thank you

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2024-11-28，8:07

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2169378-error-while-reading-the-csv-file#answer_1551153

编辑：Stephen23 2024-11-28，8:17

在 MATLAB Online 中打开

Explanation: As its documentation makes clear, the first input to FOPEN must be the fiename. However, instead of calling it with a filename you call it with some matrix of data that you imported using READMATRIX. That will not work.

Solution: replace this

%fn=f(i).name;
fn = readmatrix(f(i).name);
fid = fopen(fn, 'r');

with

fid = fopen(f(i).name, 'r');

You should also replace

fclose('all');

with

fclose(fid);

But why are you calling FOPEN & FSCAN & FCLOSE when you could simply call READMATRIX ?

P = 'absolute or relative path to where the files are saved'; 
S = dir(fullfile(P,'*.csv'));
for k = 1:numel(S)
    F = fullfile(P,S(k).name);
    M = readmatrix(F, 'FileType','text');
    ...
end

CSV files are text files. There is no reason why you cannot use READMATRIX to import both .CSV and .TXT files. You should use READMATRIX unless there is a really good reason why you cannot use it.

9 个评论
显示 7更早的评论隐藏 7更早的评论

Kumaresh Kumaresh 2024-11-29，1:07

在 MATLAB Online 中打开

Thank you for your answer. With the software I work, I could able to export only .csv files. But my senior who work with experiments could able to extract .txt files and make use of below Matlab code for post-processing. With the corrections you mentioned, I still find a bug and I couldn't able to fix as I am not good in programming. I need to read 4 columns given in the attachment, but Matlab reads only 1 column:

Index in position 1 exceeds array bounds
(must not exceed 1).
Error in OOO_9004 (line 17)
    x=data(2,:);

Here is the complete code:

    clear
clc
 
%f=dir('*.txt');                     % finding all txt files
f=dir('*.csv');                     % finding all csv files
%f=dir('*.csv','Row_offset','column_offset');  
n_snapshots=size(f,1);              % finding number of snapshots
 
for i=1:n_snapshots
    %fn=f(i).name;                   % Listing filenames
    %fn = readmatrix(f(i).name);      % https://in.mathworks.com/matlabcentral/answers/2053302-how-to-import-multiple-csv-file-in-matlab
    fid=fopen(f(i).name, 'r');             % reading files
    %fid=input(fn, 'r');    
    % scaning files into 4 columns - gives in rows
    data=fscanf(fid, '%f %f %f %f' , [4, inf]);               
    % exporting columns
    x=data(4,:);
    y=data(3,:);
    v(i,:)=data(1,:);
    u(i,:)=data(2,:);
    fclose(fid);
end
 
% Correlation Matrix C
 
c1=v*v';
c2=u*u';
C=(c1+c2)/n_snapshots;
 
% Cbeta=lambdaB - eigenvalue problem
 
[beta,lmd]=svd(C);
 
% basis functions
 
phix=u'*beta;
phiy=v'*beta;
 
% normalization
 
Gridnumber=size(x,2);
for j=1:n_snapshots
    
    phinor=0;
    
    for i=1:Gridnumber
        phinor=phinor+power(phix(i,j),2)+power(phiy(i,j),2);
    end
    phinor=sqrt(phinor);
                
    phix(:,j)=phix(:,j)/phinor;
    phiy(:,j)=phix(:,j)/phinor;
    
end
 
TimCoeU=v*phix;
TimCoeV=u*phiy;
PrimitiveTimeCoefficientMatrix=TimCoeU+TimCoeV;
 
% Sorting
 
O=PrimitiveTimeCoefficientMatrix';
J=sort(O, 'descend');
TimeCoefficient=J';
Ensambleaverage=mean(TimeCoefficient);
TimeCoeffEnsambleaveAppend=[TimeCoefficient;Ensambleaverage];
 
%Extracting modes
 
for a=1:n_snapshots
    FilNamPhi=1000+a;
    PhiOut = fopen([num2str(FilNamPhi), '.txt'], 'wt');
    fprintf(PhiOut,'');
    phia =[x;y;phix(:,a)';phiy(:,a)'];
    fprintf(PhiOut, '%20.9f %20.9f %20.9f %20.9f\n',phia);
    fclose(PhiOut);
end
 
xlswrite('TimeCoefficient.xlsx', TimeCoefficient);
dlmwrite('Ensambleaverage.txt', Ensambleaverage);
dlmwrite('TimeCoeffEnsambleaveAppend.txt', TimeCoeffEnsambleaveAppend);
 

Kindly check it. Thank you

Kumaresh Kumaresh 2024-11-29，5:47

编辑：Kumaresh Kumaresh 2024-11-29，5:48

在 MATLAB Online 中打开

Thank you for your answer. Sorry for the typo error message. To keep it simple, the following code works for .txt file. Can you guide me, how to make it work for .csv file.

clear
clc
 
f=dir('*.txt');                     % finding all txt files
%f=dir('*.csv');                     % finding all csv files
n_snapshots=size(f,1);              % finding number of snapshots
 
for i=1:n_snapshots
    fn=f(i).name;                   % Listing filenames
    %fn = readmatrix(f(i).name);      % https://in.mathworks.com/matlabcentral/answers/2053302-how-to-import-multiple-csv-file-in-matlab
    %fid=fopen(f(i).name, 'r');             % reading files
    fid=fopen(fn, 'r');             % reading files
    %fid=input(fn, 'r');    
    % scaning files into 4 columns - gives in rows
    data=fscanf(fid, '%f %f %f %f' , [4, inf]);
    %data = fgetl(fid);
    % exporting columns
    x=data(4,:);
    y=data(3,:);
    v(i,:)=data(1,:);
    u(i,:)=data(2,:);
    fclose(fid);
end
 
% Correlation Matrix C
 
c1=v*v';
c2=u*u';
C=(c1+c2)/n_snapshots;
 
% Cbeta=lambdaB - eigenvalue problem
 
[beta,lmd]=svd(C);
 
% basis functions
 
phix=u'*beta;
phiy=v'*beta;
 
% normalization
 
Gridnumber=size(x,2);
for j=1:n_snapshots
    
    phinor=0;
    
    for i=1:Gridnumber
        phinor=phinor+power(phix(i,j),2)+power(phiy(i,j),2);
    end
    phinor=sqrt(phinor);
                
    phix(:,j)=phix(:,j)/phinor;
    phiy(:,j)=phix(:,j)/phinor;
    
end
 
TimCoeU=v*phix;
TimCoeV=u*phiy;
PrimitiveTimeCoefficientMatrix=TimCoeU+TimCoeV;
 
% Sorting
 
O=PrimitiveTimeCoefficientMatrix';
J=sort(O, 'descend');
TimeCoefficient=J';
Ensambleaverage=mean(TimeCoefficient);
TimeCoeffEnsambleaveAppend=[TimeCoefficient;Ensambleaverage];
 
%Extracting modes
 
for a=1:n_snapshots
    FilNamPhi=1000+a;
    PhiOut = fopen([num2str(FilNamPhi), '.txt'], 'wt');
    fprintf(PhiOut,'');
    phia =[x;y;phix(:,a)';phiy(:,a)'];
    fprintf(PhiOut, '%20.9f %20.9f %20.9f %20.9f\n',phia);
    fclose(PhiOut);
end
 
xlswrite('TimeCoefficient.xlsx', TimeCoefficient);
dlmwrite('Ensambleaverage.txt', Ensambleaverage);
dlmwrite('TimeCoeffEnsambleaveAppend.txt', TimeCoeffEnsambleaveAppend);
 

Thank you

Kumaresh Kumaresh 2024-12-1，2:54

Thank you.

Is there any other way you can recommend to resolve this issue in current MATLAB version ?

Walter Roberson 2024-12-1，4:49

R2019a to present: recommend you use readmatrix()

R2013b to R2018b: recommend you use readtable() followed by array2table()

Older but not super-super-super old versions of MATLAB: use fileread() on the file. Examine the character vector you get back to figure out how many lines of headers there are. Use textscan() on the character vector with 'HeaderLines' option telling it how many header lines to skip.

Super-super-super but not Super-super-super-super old versions of MATLAB: fopen() and use fgetl() to fetch lines and examine them, eventually finding the first numeric line. sscanf() to get the numeric content of that line. fscanf() the rest of the file to get the remaining numeric lines.

MATLAB 1.x and MATLAB 2.x: I don't know, those releases did not even have character vectors; I would need access to terribly old documentation to figure it out.

I simplified the lineage here. There were some versions in there that supported textread() before textscan() existed.

请先登录，再进行评论。

Error while reading the .csv file

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

回答（1 个）

9 个评论
显示 7更早的评论隐藏 7更早的评论

另请参阅

类别

标签

Community Treasure Hunt

Error while reading the .csv file

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

回答（1 个）

9 个评论 显示 7更早的评论隐藏 7更早的评论

另请参阅

类别

标签

Community Treasure Hunt

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

9 个评论
显示 7更早的评论隐藏 7更早的评论