How to skip last n rows while reading a csv file using readtable?

2021 2 16
2 个回答
回答已采纳
更新时间：2022 11 22
15 次查看（30 天）

0 个投票

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.

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

 采纳的回答

Rahul Bhadani
Rahul Bhadani 2021-2-16

0 个投票

I was overthinking. It is very simple to do actually.
T= readtable(csvfile,'PreserveVariableNames',true);
n_skip = 5;
T = T(1:end-n_skip,:);

更多回答（1 个）

KALYAN ACHARJYA
KALYAN ACHARJYA 2021-2-16
编辑：KALYAN ACHARJYA 2021-2-16

1 个投票

This way?
data_table=readtable('filename');
%want to remove n rows from last
n=;...?
data=data_table(1:end-n,:)

类别

在 帮助中心 和 File Exchange 中查找有关 MATLAB 的更多信息

产品

版本

R2020a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by