How to extract the column_13 from 79 csv files and save into the new csv file

Question

muhammad choudhry 2022-6-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1742410-how-to-extract-the-column_13-from-79-csv-files-and-save-into-the-new-csv-file

编辑： Geoff Hayes 2022-6-17

Hi,

How to extract the column_13 from 79 csv files and save it in a separate csv file so the new csv file will have 79 column of column_13 from each file. I am able to read column_13 from one file but not sure how to extract from all the files and save it in a separate file.

Code Tried so far:

dataFolder = 'F:\3-PIV_Experimental_Data\Calculations_TurbulentIntensity\line_Data\Elliptical_Side_LSB\Length\DesignPoint\110_outlet';
list = dir(fullfile(P,'*.csv'));
for kk = 1:numel(list)
    data = readtable(...
        fullfile(list(kk).folder, list(kk).name));
    extract = (data{:,13});
end

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

请先登录，再进行评论。

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

Answer 1

Geoff Hayes 2022-6-17

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1742410-how-to-extract-the-column_13-from-79-csv-files-and-save-into-the-new-csv-file#answer_987550

在 MATLAB Online 中打开

@muhammad choudhry - create a cell array to store the 13th column from each file. For example,

extractedData = cell(numel(list),1);
for kk = 1:numel(list)
  data = readtable(...
      fullfile(list(kk).folder, list(kk).name));
  extractedData{kk} = data{:,13};
end