[R] How to importing a CVS file with multiple tables?
jcrosbie
james at crosb.ie
Thu Mar 20 21:30:49 CET 2014
I'm trying to figure out how to import data into a dataframe in R.
The table I'm trying to import is:
HistoricalTradingReportServlet.csv
<http://r.789695.n4.nabble.com/file/n4687246/HistoricalTradingReportServlet.csv>
I would like to add two more column for each block of data to have the
HourEnding and date beside the data.
How would I go about importing a table like this into R?
line 1) is blank
line 2) is blank
line 3) Historical Bid data for: March 19, 2013. In Hour Ending 01
line 4) is blank
line 5 -infomratiom) Price after Last Restatement MW after Last Restatement
Price Previous Day's Bid MW Previous Day's Bid
line 6) is blank
line 7) is blank
line 8-infomratiom) Historical Offer data for: March 19, 2013. In Hour
Ending 01
line 9) is blank
line 10-header) Price after Last Restatement MW after Last Restatement
Price Previous Day's Offer MW Previous Day's Offer
...........Data.....
[next table
line 1) is blank
line 2) Historical Bid data for: March 19, 2013. In Hour Ending 01
line 3) is blank
line 4 -infomratiom) Price after Last Restatement MW after Last Restatement
Price Previous Day's Bid MW Previous Day's Bid
line 5) is blank
line 6) is blank
line 7-infomratiom) Historical Offer data for: March 19, 2013. In Hour
Ending 01
line 8) is blank
line 9-header) iPrice after Last Restatement MW after Last Restatement
Price Previous Day's Offer MW Previous Day's Offer
...........Data.....
--
View this message in context: http://r.789695.n4.nabble.com/How-to-importing-a-CVS-file-with-multiple-tables-tp4687246.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list