Importing folder of .csv files and saving them as variables with different names.
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Risposte (1)
Azzi Abdelmalek
il 14 Mag 2014
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 Commenti
Karen DSouza
il 17 Lug 2018
Modificato: Karen DSouza
il 17 Lug 2018
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!
Vedere anche
Categorie
Scopri di più su Large Files and Big Data in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!