How to merge several Excel files with large datasets in MATLAB

4 vues (au cours des 30 derniers jours)
Saara-Liis Lutsar
Saara-Liis Lutsar le 9 Fév 2021
Modifié(e) : darova le 9 Fév 2021
How do I merge several (9) Excel files into one MATLAB file? I have data in columns from different stations where rows are time data. The nine files are for each year. The columns (stations) match in most files, so I want them to be in one column from different years. The columns (stations) which do not have data in some years, should still be included but then with no numerical data, but shouldn't be in the way for statistical analysis.

Connectez-vous pour répondre à cette question.

Réponses (1)

darova
darova le 9 Fév 2021
Modifié(e) : darova le 9 Fév 2021
  • Use dir to create list of file names in current directory
  • Use for loop to read each file and get the data

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by