Read multiple CSV file with header and datetime
1 view (last 30 days)
Show older comments
Hello,
i have multiple CSV files with 2 header lines (some files missing header) and first column being datetime. I would like to import files based on filename filter. I did this by creating a datastore and using "readall" command. is there a better way to do this?
Thanks for your input!
Best regards,
R
0 Comments
Answers (1)
Chandu
on 15 Mar 2022
Hi,
Multiple CSV files can be imported into MATLAB workspace using a loop and textscan MATLAB function can be used for filtering. textscan will let you specify 'HeaderLines' to skip over the header. Refer the following script,
for i = 1: numfids
f = fopen (strcat (strDir, fnames(i).name);
X = textscan (f,'%s%f','Delimiter',',','HeaderLines',1);
fclose(f);
end
X would be a cell array of parsed columns (note this code reads the timestamp as a string). Refer textscan MathWorks Documentation for more help.
0 Comments
See Also
Categories
Find more on String Parsing in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!