Creating a datastore from multiple .csv files with different variables

6 次查看（过去 30 天）
Matthijs Priester
Matthijs Priester 2017-2-14
评论： Stephen23 2017-4-10
I have several dozen big data .csv files containing of three collumns; Date, time and a value. The date and time collumns are the same for every .csv file, but the value collumn is different and contains a different variable for each file.
I would like to make a datastore which combines all these .csv files, thus containing the date (first collumn), the time (second collumn) and the nth collumns containing the n number of variable values (n depending on amount of .csv files).
This can then be converted into a tall array for easy data handling purposes.
Does anyone have an idea how to make this happen? Or maybe a better solution for this problem? I tried making multiple datasets and combining these into one tall array, but this is not possible.
Thanks in advance!

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

采纳的回答

Mujahid Sultan
Mujahid Sultan 2017-4-10
location1 = fullfile('matlabroot','/home/user/filelocation'); ds = datastore({location1},'Type','csv',... 'FileExtensions',{'.txt','.csv','.xls'});
this will read all the files sequentially, then you can combine the values column.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by