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.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
