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

2021 2 16
2 个回答
回答已采纳
更新时间：2022 11 22
17 次查看（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 中查找有关 Data Type Identification 的更多信息

产品

版本

R2020a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by