Importing csv files properly

Question

Struggling in MATLAB 2021-7-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/880818-importing-csv-files-properly

评论： Star Strider 2021-7-27

test1.csv

I am trying to import a csv file which contains 'comma'(,) inside 'quotation' marks(" ") in some cells. Here is one example.

RAB13,"RAB13, member RAS oncogene family",3.042175424,0.009699723

How can I NOT split the data at ',' if they are inside quotation? The csv is attached. Any help is appreciated!

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

请先登录，再进行评论。

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

Answer 1

Simon Chan 2021-7-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/880818-importing-csv-files-properly#answer_748868

在 MATLAB Online 中打开

You may use readcell and the output is a cell array.

The first row shows the header and the rest of the rows contains the requried data:

rawdata = readcell('test1.csv');
header = rawdata(1,:);                  % Extract the header
data = rawdata(2:end,:);

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

请先登录，再进行评论。

Answer 2

Star Strider 2021-7-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/880818-importing-csv-files-properly#answer_748903

在 MATLAB Online 中打开

Import it as a table, using readtable —

T1 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/687498/test1.csv', 'VariableNamingRule','preserve')
T1 = 3×4 table
    Gene.symbol                             Gene.title                               logFC     adj.P.Val
    ___________    _____________________________________________________________    _______    _________

    {'CEACAM6'}    {'carcinoembryonic antigen related cell adhesion molecule 6'}     5.4297    0.0086381
    {'RAB13'  }    {'RAB13, member RAS oncogene family'                        }     3.0422    0.0096997
    {'TMOD3'  }    {'tropomodulin 3'                                           }    -1.7502    0.0096997

2 个评论
显示无隐藏无

Peter Perkins 2021-7-27

Add "TextType","string" to that readtable call and you have a winner!

Star Strider 2021-7-27

在 MATLAB Online 中打开

Following up on that ...

T1 = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/687498/test1.csv', 'VariableNamingRule','preserve', 'TextType','string')
T1 = 3×4 table
    Gene.symbol                            Gene.title                              logFC     adj.P.Val
    ___________    ___________________________________________________________    _______    _________

     "CEACAM6"     "carcinoembryonic antigen related cell adhesion molecule 6"     5.4297    0.0086381
     "RAB13"       "RAB13, member RAS oncogene family"                             3.0422    0.0096997
     "TMOD3"       "tropomodulin 3"                                               -1.7502    0.0096997