concatenating with readtable function

7 Ansichten (letzte 30 Tage)
Daniel Abraham
Daniel Abraham am 19 Jul. 2021
Kommentiert: KSSV am 19 Jul. 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

Akzeptierte Antwort

KSSV
KSSV am 19 Jul. 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 Kommentare
Daniel Abraham
Daniel Abraham am 19 Jul. 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 am 19 Jul. 2021
If the varable names are same and T1, T2 can be joined:
T12 = [T1; T2] ;
Also have a look on cat.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Tables finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by