如何阅读标题但也跳过行 - read.table()? [英] How can I read the header but also skip lines - read.table()?

问题描述

数据.txt:

Index;Time;
1;2345;
2;1423;
3;5123;

代码:

dat <- read.table('data.txt', skip = 1, nrows = 2, header =TRUE, sep =';')

结果:

  X1 X2345
1  2  1423
2  3  5123

我希望header是Index和Time，如下:

I expect the header to be Index and Time, as follows:

  Index Time
1   2   1423
2   3   5123

我该怎么做?

推荐答案

恐怕没有直接的方法可以实现这一点.要么阅读整个表格，然后删除不需要的行，要么在表格中阅读两次并稍后分配标题:

I am afraid, that there is no direct way to achieve this. Either you read the entire table and remove afterwards the lines you don't want or you read in the table twice and assign the header later:

header <- read.table('data.txt', nrows = 1, header = FALSE, sep =';', stringsAsFactors = FALSE)
dat    <- read.table('data.txt', skip = 2, header = FALSE, sep =';')
colnames( dat ) <- unlist(header)

这篇关于如何阅读标题但也跳过行 - read.table()?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！