Reading data from csv with non uniform formatting

Question

AG15 2023-4-24

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1952389-reading-data-from-csv-with-non-uniform-formatting

评论： Cris LaPierre 2023-4-24

sample.csv

Hi,

I am trying to read data from a cvs file (sample attached) with uneven formatting where there are a few sentences and lines with missing data points. I have been reading the file and then getting the row number for each time the column with is different to extract the data. I am trying to read ( and remove) the sentences and also remove the partially complete rows and creating one array from the remaining data. Is there any better way of doing this withouth having to check which row is incomplete? Any suggestions would be very helpful.

Thank you

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

AG15 2023-4-24

Thank you

Cris LaPierre 2023-4-24

Yes. If you are new to tables, see this page on how to access data in tables.

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2023-4-24

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1952389-reading-data-from-csv-with-non-uniform-formatting#answer_1222264

在 MATLAB Online 中打开

sample.csv

I would use readtable with the settings to 'omitrow' when data is missing.

T = readtable('sample.csv','MissingRule','omitrow')
T = 11×5 table
    Var1     Var2    Var3    Var4    Var5
    _____    ____    ____    ____    ____

    {'A'}     1       2       3       4  
    {'B'}     1       2       3       4  
    {'C'}     1       2       3       4  
    {'D'}     1       2       3       4  
    {'A'}     1       2       3       4  
    {'B'}     1       2       3       4  
    {'C'}     1       2       3       4  
    {'A'}     1       2       3       4  
    {'D'}     1       2       3       4  
    {'C'}     1       2       3       4  
    {'E'}     1       2       3       4  