在R中导入拆分的csv文件

Question

我有一个csv文件，如下所示：

Point            Site Energy Savings (%/yr) Annualized Energy Related Costs ($/yr)
Optimal Point 0        0                        1822.880005
Optimal Point 1        14.39999962              1608.069946
Optimal Point 2        20.65999985              1596.76001
Optimal Point 3        26.05999947              1639.98999
Optimal Point 4        34.54999924              1786.359985


Point            Site Energy Savings (%/yr) Annualized Energy Related Costs ($/yr)
Reference              0                        1822.880005
Iter 1, Pt 1           6.929999828              1818.089966
Iter 1, Pt 2           8.170000076              1863.180054
Iter 1, Pt 3           4.159999847              1845.390015

我试着将它读入R，在散点图中绘制第二列和第三列，但是read.csv因为双重标题而感到困惑。你知道怎么把它读入R跳过第二个标题吗？

我希望在R中显示以下内容：

Point                Site Energy Savings (%/yr) Annualized Energy Related Costs ($/yr)
Optimal Point 0      0                           1822.880005
Optimal Point 1      14.39999962                 1608.069946
Optimal Point 2      20.65999985                 1596.76001
Optimal Point 3      26.05999947                 1639.98999
Reference            0                           1822.880005
Iter 1, Pt 1         6.929999828                 1818.089966
Iter 1, Pt 2         8.170000076                 1863.180054
Iter 1, Pt 3         4.159999847                 1845.390015

Answer 1

我会这样做：

# read in first 5 rows only
a <- read.csv(file, nrows=5, header=TRUE) 

# read in the last rows skipping the first 5 row data set 
b <- read.csv(file, skip=6, header=TRUE)   

rbind(a,b) # put them back together