Importing folder of .csv files and saving them as variables with different names.

2 次查看（过去 30 天）
BOB
BOB 2014-5-14
编辑： Karen DSouza 2018-7-17
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

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

回答（1 个）

Azzi Abdelmalek
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 个评论
显示 4更早的评论
Karen DSouza
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 中查找有关 Workspace Variables and MAT-Files 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by