How to import multiple csv files into one and read it from certain folder?
14 次查看(过去 30 天)
显示 更早的评论
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
1 个评论
Anil Kumar
2019-2-18
Did you finally solved this task of importing?
Could you please share your knowledge of how did you that before?
采纳的回答
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
3 个评论
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
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
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
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.
5 个评论
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.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Debugging and Analysis 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!