Azzera filtri
Azzera filtri

concatenating with readtable function

7 visualizzazioni (ultimi 30 giorni)
Daniel Abraham
Daniel Abraham il 19 Lug 2021
Commentato: KSSV il 19 Lug 2021
Hello Everyone. Please I'm trying to readtables from a multiple xml files in a loop. Each xml file holds data for a time period.
Using the code below reads each xml file as a table
table1: readtable('filename.xml')
but I want to read all the xml files in the folder at once as a table so I can get to see all data at once. When I try to read random xml files as tables. It seems most have the same amount variables but some differ. I think for me, it's okay if the code can skip these files.
Thank you so much

Risposta accettata

KSSV
KSSV il 19 Lug 2021
xmlFiles = dir('*.xml') ;
N = length(xmlFiles) ;
T = cell(N,1) ;
for i = 1:N
T{i} = readtable(xmlFiles(i).name) ;
end
celldisp(T)
  2 Commenti
Daniel Abraham
Daniel Abraham il 19 Lug 2021
Thanks KSSV, it puts all the tables in a cell. That helps a lot!
Quick follow up, how does one concatenate all the simlar tables (similar variable names) in the cell as one table?
KSSV
KSSV il 19 Lug 2021
If the varable names are same and T1, T2 can be joined:
T12 = [T1; T2] ;
Also have a look on cat.

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Tables in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by