Removing the first row in data with multiple headers
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Kimmery Migel
le 16 Juil 2020
Commenté : Kimmery Migel
le 17 Juil 2020
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!
2 commentaires
per isakson
le 16 Juil 2020
Location Properties:
DataLines: [2 Inf]
VariableNamesLine: 1
Réponse acceptée
jonas
le 16 Juil 2020
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)
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur String dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!