How to analyse hundreads of excel files (milliseconds data) with Matlab with timeseries?

I am doing data analysis with timeseries by using matlab with excel files. I have hundreads of csv files which I have to change into "xlsx" files and analyse with matlab by using timeseries. Are there any shortcut for loading the files and writing timeseries function for those hundreads of excel files? Please help me.

Answer 1

[Cris LaPierre]

I would use a filedatastore to load all the data into a single variable (doesn't matter if they are csv or xlsx). You can see an example of how to use one to do this in this video from the Data Processing with MATLAB specialization on Coursera.

Here is the final code from that example. You can modify this to work for your data.

flightsDataStore = fileDatastore("flights*.csv","ReadFcn",@importFlightsData,"UniformRead",true);
flightsAll = readall(flightsDataStore)

Once complete, all the data from all files matching the pattern "flights*.csv" are loaded into the variable flightsAll.

[uzzi]

Is it like storing all the csv files under one folder and loading the folder?

[Cris LaPierre]

It's doing nothing to the location of your files.

[uzzi]

okay. Thank you very much for the video. It is very helpful.

[uzzi]

I'd like to ask one more thing. Does it work with "asc" files as well? or should I convert "asc" files to "csv" files?

[Cris LaPierre]

I've never worked with ASC files, so can't say for certain, but as long as you can write an import function that can load your files, then yes, it is possible.

You may be interested in this Answer:

https://www.mathworks.com/matlabcentral/answers/218219-reading-and-analysis-of-asc-files

[uzzi]

Thank you so much for all of your replies.

Answer 2

[Image Analyst]

See the FAQ:

https://matlab.fandom.com/wiki/FAQ#How_can_I_process_a_sequence_of_files?

[uzzi]

Thanks. I will take a look into it.