How to import multiple csv files into one and read it from certain folder?

15 次查看（过去 30 天）
Kasih Ditaningtyas Sari Pratiwi
评论： Daniel Pare 2020-6-25
I am a newbie in matlab programming. I have a problem in coding to import multiple csv files into one from certain folder:
myDir = uigetdir; %gets directory
myFiles = dir(fullfile(myDir,'*.csv'); %gets all csv files in struct
That is the code. But it only shows the name of csv files, not read the content of the data. Could you please help me to find the code to read all the csv files into one file?
Thank you very much for your help

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

采纳的回答

Jeremy Hughes
Jeremy Hughes 2017-10-20
You can use tabularTextDatatstore to collect the CSV files and read them into one table
>> ds = tabularTextDatastore(filepath,'FileExtensions','.csv')
>> T = readall(ds)
Or if the data is too big, read "chunks"
while hasdata(ds)
T = read(ds);
end
See the documentation for tabularTextDatastore for more info.
  3 个评论
显示 1更早的评论
Adhi Ariawan
Adhi Ariawan 2017-11-23
编辑：Adhi Ariawan 2017-11-23
Hi Jeremy, for filepath inside the function, I should change that to the csv directory I'm trying to import right? Do I need to put quotation mark for the path?
I'm trying to run this code but it gives me error.
ds = tabularTextDatastore(
'E:\\Matlab\Project1','FileExtensions','.csv','SelectedVariableNames',{'date','win','team','opposing_team'});
T = read(ds)
Daniel Pare
Daniel Pare 2020-6-25
That command works great for me. I was able to import 98 csv files into one big table for my project.
In the command :
ds = tabularTextDatastore(filepath,'FileExtensions','.csv')
the parameter (filepath) was somthing like 'C:\project_data\imported_data_*'
Where the files name are : imported_data_01.csv to imported_data_99.csv
You can also look at all the list od the files importes by doing:
ds.Files

请先登录，再进行评论。

更多回答（1 个）

KL
KL 2017-10-20
编辑：KL 2017-10-20
You're only getting the list of files in the folder. You need to import them using csvread
https://www.mathworks.com/help/matlab/ref/csvread.html
For example,
fileNames = {myfiles.name};
for k = 1:numel(fileNames)
data{k} = csvread(fileNames{k});
%%do whatever you want
end
Handling with multiple files is discussed extensively already. Just look it up on this forum. Here are some obvious links.
https://www.mathworks.com/help/matlab/import_export/process-a-sequence-of-files.html
http://matlab.wikia.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F
  5 个评论
显示 3更早的评论
KL
KL 2017-10-20
Well, just trying out random things without knowing how it actually works will hardly be productive. It's not that hard.
fileNames = {myFiles.name}; %previously it was myfiles
my code was just an example! myFiles is the variable name you use in your two lines of code. ANd that line of code extract only the filenames from the myFiles struct.
Then I have a for loop to iterate through each file, import them and store it in a variable.
Read aboout for loops here: https://www.mathworks.com/help/matlab/matlab_prog/loop-control-statements.html
data{k} = csvread(fileNames{k});
The above line is the one that reads each csv file and stores the contents in a variable called data. Once the for loop is finished, all your data will be inside this variable called data. Later you can use this variable to create a new csv file, i.e, that contain all the "merged data".
just try and import 1 csv file first! Read the links I gave you.
Kasih Ditaningtyas Sari Pratiwi
Kasih Ditaningtyas Sari Pratiwi 2017-10-20
I got an error :(. I have read the information you've given but I got something like the image I attached. I really have no idea about how to import this file :((((

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Environment and Settings 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by