How to skip last n rows while reading a csv file using readtable?
44 views (last 30 days)
Show older comments
Rahul Bhadani
on 16 Feb 2021
Commented: Walter Roberson
on 22 Nov 2022
I have a csv file that I want to read as table in MATLAB using readtable command. However, I know that last few lines are corrupted or not reliable and I want to skip them. How can I do that using readtable. Note that a similar function is available in python's panda package for read.csv by supplying skipfooter.
0 Comments
Accepted Answer
Rahul Bhadani
on 16 Feb 2021
1 Comment
Venkatkumar M
on 22 Nov 2022
How to skip first 20 rows in the csv file?
Could you please give some answer?
More Answers (1)
KALYAN ACHARJYA
on 16 Feb 2021
Edited: KALYAN ACHARJYA
on 16 Feb 2021
This way?
data_table=readtable('filename');
%want to remove n rows from last
n=;...?
data=data_table(1:end-n,:)
4 Comments
Venkatkumar M
on 22 Nov 2022
How to skip first 20 rows in the csv file?
Could you please give some answer?
Walter Roberson
on 22 Nov 2022
data_table = readtable('filenameGoesHere', 'HeaderLines', 20);
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!