[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