如何读入数据不在同一行的txt文件？

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

The U.S. Gasoline Market, 52 Yearly Observations, 1953-2004
Source: These data were compiled by Professor Chris Bell, Department of Economics, University of North Carolina, Asheville. Sources: www.bea.gov and www.bls.gov

    * Year = Year, 1953-2004,
    * GasExp = Total U.S. gasoline expenditure,
    * Pop = U.S. total population in thousands
    * GasP = Price index for gasoline,
    * Income = Per capita disposable income,
    * Pnc = Price index for new cars,
    * Puc = Price index for used cars,
    * Ppt = Price index for public transportation,
    * Pd = Aggregate price index for consumer durables,
    * Pn = Aggregate price index for consumer nondurables,
    * Ps = Aggregate price index for consumer services.



Year,GasExp,Pop,Gasp,Income,PNC,PUC,PPT,PD,PN,PS
   1953.00       7.40000       159565.       16.6680       8883.00   
   47.2000       26.7000       16.8000       37.7000       29.7000   
   19.4000   

以上为数据截取，
> read.table("C:/Users/forYear/Documents/R/工作/2014Homework1_datasets/Gasoline.txt", header = FALSE, sep = "", skip = 18)
>Error in scan(file, what, nmax, sep, dec, quote, skip, nlines, na.strings,  :
  line 3 did not have 5 elements

因为11个变量，在txt里分为了三行排列，所以不能使用上述命令，应该怎么解决这一个问题

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏2 回帖

关键词：读入数据 txt observations Transportat expenditure 如何

建议上传部分文件哈

jiangbeilu 发表于 2016-2-5 20:49
建议上传部分文件哈

Gasoline.txt (8.91 KB)

2016-2-6 11:37:05 上传

rawlines <- readLines(file(".../Gasoline.txt"))
rawlines2 = rawlines[19:length(rawlines)]

names = unlist(strsplit(rawlines[18], ","))

lines <- paste(rawlines2[c(TRUE, FALSE, FALSE)], rawlines2[c(FALSE, TRUE, FALSE)],
               rawlines2[c(FALSE, FALSE, TRUE)], collapse = "\n")
data <- read.table(text = lines, na.string = "*")

names(data) = names

使用 infile v1 v2 v3 "路径" 格式输入，希望能帮到你，可用help infile 查看

ryoeng 发表于 2016-2-6 16:03

你好，我暂时还没有论坛币，能给我传一下 Gasoline.txt 这个数据吗？
qq 584062295

支持支持，学习了