readtable working differently for different files

Question

Louise Wilson 2021-6-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/850430-readtable-working-differently-for-different-files

评论： Louise Wilson 2021-6-8

I have a bunch of spreadsheets which all have the same format. However, when I read them in, they appear differently...

folder=('H:\SoundTrap\Boats\Manual Vessel Detections');
d=dir(fullfile(folder,'*.csv'));
site=('Goat');
for i=1:height(d)
    
    idx=contains(d(i).name,site);
    
    if idx==1
        out{i}=readtable(fullfile(folder,d(i).name));
    end
    
end

For some reason, one of the files is read using a different delimeter? So the columns are incorrectly split. How can I rectify this? I have tried detect import options and 'Format' '%s%s%s' to no avail. Perhaps I am using these incorrectly though. The desired format is the one below:

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

Stephen23 2021-6-8

@Louise Wilson: please upload two or more sample flles (ones which import differently) by clicking the paperclip button.

Louise Wilson 2021-6-8

Thank you both, sorry for failing to do this in the first instance! I have attached two .csv files here. 001 is the file which is currently loading in as I would like it to.

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2021-6-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/850430-readtable-working-differently-for-different-files#answer_719490

在 MATLAB Online 中打开

T1 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/645435/001_GoatIsland_5100_manualVesselDetections.csv', 'delimiter', ',');
T1(1:10,:)
ans = 10×2 table
               Filename               BoatPresence
    ______________________________    ____________

    {'5100.190610124350_2min.png'}         1      
    {'5100.190610152350_2min.png'}         1      
    {'5100.190610170350_2min.png'}         0      
    {'5100.190610182350_2min.png'}         1      
    {'5100.190610205350_2min.png'}         1      
    {'5100.190610214350_2min.png'}         1      
    {'5100.190610230350_2min.png'}         1      
    {'5100.190611003350_2min.png'}         1      
    {'5100.190611030350_2min.png'}         1      
    {'5100.190611041350_2min.png'}         0      
T2 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/645440/009_GoatIsland_5100_manualVesselDetections.csv', 'delimiter', ',');
T2(1:10,:)
ans = 10×3 table
               Filename               BoatPresence       Var3   
    ______________________________    ____________    __________

    {'5100.200316151440_2min.png'}         0          {0×0 char}
    {'5100.200316165440_2min.png'}         0          {0×0 char}
    {'5100.200316190440_2min.png'}         0          {0×0 char}
    {'5100.200316195440_2min.png'}         0          {0×0 char}
    {'5100.200316212440_2min.png'}         0          {0×0 char}
    {'5100.200317001441_2min.png'}         1          {0×0 char}
    {'5100.200317004441_2min.png'}         0          {0×0 char}
    {'5100.200317025441_2min.png'}         0          {0×0 char}
    {'5100.200317041441_2min.png'}         0          {0×0 char}
    {'5100.200317071441_2min.png'}         0          {0×0 char}