header row causes issues in readtable
조회 수: 225 (최근 30일)
이전 댓글 표시
Hello I am stumped
I have a pile of files like the attached. They are tab delimited even though they are .csv files.
If I remove the header I can use readtable just fine but I can't figure out how to import the data using readTable without manually deleating the header from each file...
The header and data has the same number of columns.
Otherwise I can't figure out a reasonable way to import them.
To be honest, I don't care about even having the right variable names but I can't work around it.
댓글 수: 3
채택된 답변
Walter Roberson
2020년 5월 13일
T = readtable('testfile.csv', 'ReadVariableNames', false, 'HeaderLines', 1);
Or, R2019b or later,
T = readtable('testfile.csv', 'PreserveVariableNames', true);
Note that the code guesses 'MM/dd/uuuu HH:mm' format instead of 'dd/MM/uuuu HH:mm' . If there were enough input in a column that it could figure it out then it would not have to guess. You can force a particular interpretation by using detectImportOptions and using setvaroptions() of 'InputFormat' and then passing the options to readtable()
댓글 수: 0
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
제품
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!