Removing the first row in data with multiple headers

17 次查看（过去 30 天）
Kimmery Migel
Kimmery Migel 2020-7-16
评论： Kimmery Migel 2020-7-17
I have a text file that has 5 rows of headers. I'm using readtable but I want the second row of headers to be the table headers. How can I remove the first row of the header so readtable uses the second row. I have to do this for about 55 files, and am comfortable making it a loop, I just can't get rid of the first row.
sample file is too large to upload, even wem compressed. It can be found here: https://www.dropbox.com/s/vwc9bucdpyrxarg/s03_lab_base.c3d.txt?dl=0
thanks!

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

采纳的回答

jonas
jonas 2020-7-16
As per isakson said, use detectimportoptions to fine-tune your table import.
fname = 's03_lab_base.c3d.txt';
opts = detectImportOptions(fname,'VariableNamesLine',2);
T = readtable(fname,opts)

更多回答（0 个）

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by