How can I Insert a CSV filename into my array

Question

AR 2016-11-2

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/310214-how-can-i-insert-a-csv-filename-into-my-array

回答： Walter Roberson 2016-11-2

Need help with preparing data.

I'm creating an array by appending 500 csv files of daily stock data (varying rows), each with 7-columns using with code below.

How can I create an 8th column with the filename (or just part of the filename) so I can later identify which file belongs with which rows of data?

Thanks.

dname='C:\project\';
alldata=[];
files=dir([dname,'*.csv']);
for i=1:length(files);
    csvdata=csvread([dname,files(i).name]);
    alldata=[alldata;csvdata];
end

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-11-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/310214-how-can-i-insert-a-csv-filename-into-my-array#answer_241647

You cannot. csvread() only reads numeric data, so your arrays would be numeric. You cannot store character strings in numeric arrays.

You can create separate variables.
You can switch to a cell array -- num2cell() the numeric data and then horzcat() on the cell array of strings
You can use array2table() to convert to a table() data structure and then add the file names as a column of that.