Importing folder of .csv files and saving them as variables with different names.
5 ビュー (過去 30 日間)
古いコメントを表示
I have a folder of 90 .csv files and i want to bring them all into matlab one after the other and save them as vairables and each one have a different name.
Can somebody give me some template code to do this please.
Thanks
0 件のコメント
回答 (1 件)
Azzi Abdelmalek
2014 年 5 月 14 日
d='E:\matlab' % your folder
f=dir([d '\*.csv'])
for k=1:numel(f)
data{k}=xlsread(f{k}.name);
end
If you want the data from the third file:
data{3}
Do not use a variable for each file.
6 件のコメント
Chugh
2018 年 5 月 23 日
Hi, Did you get an answer for your question? I am also searching for the same.
Karen DSouza
2018 年 7 月 17 日
編集済み: Karen DSouza
2018 年 7 月 17 日
What would be the easiest way about horizontally concatenating data tables saved in a cell array like above? I don't want to hard code it because the length of the cell array is subject to change. Essentially from above I have a resulting 1 * 8 cell array with tables of varying # of cols but same amount of rows. I wish to combine all the data from these files by the function join using the column "ID".
Thanks!
参考
カテゴリ
Help Center および File Exchange で Large Files and Big Data についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!