[R] New to R

David Winsemius dw|n@em|u@ @end|ng |rom comc@@t@net
Sat Sep 15 00:18:02 CEST 2018


> On Sep 14, 2018, at 2:15 PM, MacQueen, Don via R-help <r-help using r-project.org> wrote:
> 
> If l.out is not a data frame, what is it? A list? A matrix? Some other structure? Try

I thought it would be one of those variants of a zoo object. Matrix structure with specialized row.names that can handle time-date range operators.

Bert's advice to learn some basic R certainly makes sense. After fixing the two errors in the code and substituting a proper path I get:

str(l.out)
List of 2
 $ df.control:'data.frame':	3 obs. of  6 variables:
  ..$ ticker              : Factor w/ 3 levels "SPY","VCR","RPG": 1 2 3
  ..$ src                 : Factor w/ 1 level "yahoo": 1 1 1
  ..$ download.status     : Factor w/ 1 level "OK": 1 1 1
  ..$ total.obs           : int [1:3] 252 252 252
  ..$ perc.benchmark.dates: num [1:3] 1 1 1
  ..$ threshold.decision  : Factor w/ 1 level "KEEP": 1 1 1
 $ df.tickers:'data.frame':	756 obs. of  10 variables:
  ..$ price.open         : num [1:756] 250 249 250 250 250 ...
  ..$ price.high         : num [1:756] 250 249 250 250 250 ...
  ..$ price.low          : num [1:756] 250 249 249 250 249 ...
  ..$ price.close        : num [1:756] 250 249 250 250 250 ...
  ..$ volume             : num [1:756] 95446300 95432400 46235200 47108100 59574100 ...
  ..$ price.adjusted     : num [1:756] 245 246 246 247 247 ...
  ..$ ref.date           : Date[1:756], format: "2017-09-14" "2017-09-15" "2017-09-18" "2017-09-19" ...
  ..$ ticker             : chr [1:756] "SPY" "SPY" "SPY" "SPY" ...
  ..$ ret.adjusted.prices: num [1:756] NA 0.00135 0.00213 0.001 0.00036 ...
  ..$ ret.closing.prices : num [1:756] NA -0.0036 0.00213 0.001 0.00036 ...


So the data.frame would be:  l.out$df.tickers


It's got the data in a long-format arrangement:

table( l.out$df.tickers$ticker)

RPG SPY VCR 
252 252 252 
-- 
David.
> 
>  str(l.out)
>  class(l.out)
> 
> and see what you get.
> 
> Can't help you convert it to a data frame without knowing what it is.
> 
> After you have a data frame, then write.table(), write.csv(), or write.csv2() will "convert" it to a CSV (assuming that's what you meant by "CVS".
> 
> -Don
> 
> p.s. use reply-all if you want to add that extra information .
> 
> --
> Don MacQueen
> Lawrence Livermore National Laboratory
> 7000 East Ave., L-627
> Livermore, CA 94550
> 925-423-1062
> Lab cell 925-724-7509
> 
> 
> 
> On 9/14/18, 11:00 AM, "R-help on behalf of Jim Blackburn" <r-help-bounces using r-project.org on behalf of outlook_5DC74CB3034CB0A2 using outlook.com> wrote:
> 
>    I am newly subscribed to r-project.
> 
> 
>    I have recently plunged into R on a totally self-taught basis (may not have been the smartest decision!)
> 
> 
> 
>    I am attempting to download tickers as a time series.  I can successfully create RDA files but I want to convert them to CVS.  Following is the code I have created so far.
> 
> 
> 
>    if (!require(BatchGetSymbols)) install.packages('BatchGetSymbols')
> 
>    library(BatchGetSymbols)
> 
>    tickers <- c('SPY','VCR', 'RPG')
> 
>    first.date <- Sys.Date()-365
> 
>    last.date <- Sys.Date
> 
>    l.out <- BatchGetSymbols(tickers = tickers,
> 
>           first.date = first.date,
> 
>           last.date = last.date,
> 
>    cache.folder = file.path("c://Users/Owner/Documents/R",
> 
>    +    'BGS_Cache') )
> 
>    print(l.out$df.control)
> 
>    print(l.out$df.tickers)
> 
> 
> 
> 
> 
> 
> 
>    I can print(l.out) and see that it contains all the data, but it is not a data.frame
> 
> 
> 
>    Can anyone help with creating a data.frame and then converting to CSV?
> 
> 
> 
>    Any help is GREATLY appreciated!
> 
> 
> 
>    Thanks
> 
> 
> 
>    Jim
> 
> 
>    Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
> 
> 
>    	[[alternative HTML version deleted]]
> 
>    ______________________________________________
>    R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>    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.
> 
> 
> ______________________________________________
> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
> 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.

David Winsemius
Alameda, CA, USA

'Any technology distinguishable from magic is insufficiently advanced.'   -Gehm's Corollary to Clarke's Third Law




More information about the R-help mailing list