How to importing a CVS file with multiple tables?

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

How to importing a CVS file with multiple tables?

jcrosbie
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

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.....
Reply | Threaded
Open this post in threaded view
|

Re: How to importing a CVS file with multiple tables?

David Winsemius

On Mar 20, 2014, at 1:30 PM, jcrosbie wrote:

> 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?

Some of the features of this problem are similar to one I addressed on SO:

http://stackoverflow.com/questions/22001951/block-wise-ascii-text-file-as-input

I've seen postings and answers to similar problems on Rhelp but searching would be your responsibility:

http://markmail.org/search/?q=list%3Aorg.r-project.r-help

--
David.

>
> 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.

Nabble is NOT the R Archive

--

David Winsemius
Alameda, CA, USA

______________________________________________
[hidden email] 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.