Help removing columns from csv file

Question

Jimes Tooper 2011-11-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/22710-help-removing-columns-from-csv-file

Hey all,

I'm new to matlab and need some quick help manipulating csv files. I have giant (1 million rows plus) csv files with 6 columns, and I need to run PSDs on only two of the columns of data. I want to extract the two specific columns of data from the big csv, put them into variables or separate csvs, and use them for calculations. Right now I'm wrestling with textscan because there are headers in these files and some of the columns contain text.

Sample of data:

Ct*0.00127405S  A1(g)  A2(g)  A3(g)  SN  FCTR  
0.027  -0.022  0.985  95  41  [Crc OK]
0.027  -0.022  0.985  95  42  [Crc OK]
0.027  -0.022  0.984  95  43  [Crc OK]
0.027  -0.021  0.982  95  44  [Crc OK]
0.027  -0.022  0.983  95  45  [Crc OK]

thank you! JT

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

请先登录，再进行评论。

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

Answer 1

John 2011-11-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/22710-help-removing-columns-from-csv-file#answer_29865

在 MATLAB Online 中打开

If you want to load in the data and pull out the third and fourth columns (just as an example) I'd do the following:

[num txt raw] = xlsread('Book1.csv');
data = cell2mat(raw(2:end,[3 4]));
csvwrite('test.csv',data)

This will pull the data out and save it into a new csv file, you could also try,

[num txt raw] = xlsread('Book1.csv');
data = num(2:end,[3 4]);
csvwrite('test.csv',data)

If you dont want to mess with cell arrays, hope it helps.

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

John 2011-11-30

Forgot about that, thanks, if youre on mac you might want to try csvread() although this only can only import numerical data (no strings in the file).

John 2011-11-30