concatenating with readtable function

5 次查看（过去 30 天）
Daniel Abraham
Daniel Abraham 2021-7-19
评论： KSSV 2021-7-19
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

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

采纳的回答

KSSV
KSSV 2021-7-19
xmlFiles = dir('*.xml') ;
N = length(xmlFiles) ;
T = cell(N,1) ;
for i = 1:N
T{i} = readtable(xmlFiles(i).name) ;
end
celldisp(T)
  2 个评论
Daniel Abraham
Daniel Abraham 2021-7-19
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 2021-7-19
If the varable names are same and T1, T2 can be joined:
T12 = [T1; T2] ;
Also have a look on cat.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Structures 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by