How can I apply the 'tq_transmute' function to my data?

[vitoria]

Hey! I'm new on R and everytime I aplly this fuction to get the assets weekly return from the monthly return that I already have, a error appears and I think it is because my data period it is separate by year and month colunes... but I'm not so sure about this and I don't know how to change the period from two colunes of year and month to just one colune with the normal date...

[andresrcs]

Hi!

To help us help you, could you please prepare a reproducible example (reprex) illustrating your issue? Please have a look at this guide, to see how to create one:

FAQ: How to do a minimal reproducible example ( reprex ) for beginners

A minimal reproducible example consists of the following items: A minimal dataset, necessary to reproduce the issue The minimal runnable code necessary to reproduce the issue, which can be run on the given dataset, and including the necessary information on the used packages. Let's quickly go over each one of these with examples: Minimal Dataset (Sample Data) You need to provide a data frame that is small enough to be (reasonably) pasted on a post, but big enough to reproduce your issue. Let's say, as an example, that you are working with the iris data frame head(iris) #> Sepal.Length Sepal.Width Petal.Length Petal.Width Species #> 1 5.1 3.5 1.4 0.…

[vitoria]

so I read this guide but I'm still not abble to do the "reprex"
Can I post here a print from my R studio screen to help you understand my question?

[andresrcs]

Ideally, no. Screenshots are considered a bad practice here, post formatted code instead. Here is how to do it:

FAQ: How to format your code

Formatting Code: the Basics All code or console output you include in your posts should be formatted properly. Luckily, this is very easy to do! Just use the code formatting button at the top of the post editing box: [image] Select some code Click the </> button! The code formatting button automatically adds special Markdown formatting symbols to whatever you selected. If you check the preview pane to the right of your post, you'll see that the forum software now outputs nicely formatted code . [04] The code formatting button is pretty smart! It can tell the difference between snippets of code that are part of a sentence and blocks of code that stand alone. …

Although, if you don't have another option, they are better than nothing.

[vitoria]

ok... I think I did it! Here is a example of my data frame and the function from tidyquant (tq_transmute) that I apply to it

ticker <- c("AALR3")
year<- c(2017)
month<- c(1,2,3,4,5,6)
price <- c(13.747508,12.564078,15.414171,18.323436,17.485173,17.297797)
monthly_return<- c(-0.048464171,-0.086083238,0.226844580,0.188739634,-0.045748134,-0.010716279)

data<- data.frame(ticker,year,month,price,monthly_return)

#Executing the function to get the weekly return

library (tidyquant)

weekly_retun <- data %>% 
  tq_transmute(
    select = monthly_return,           
    mutate_fun = periodReturn,   
    period = "weekly",      
    col_rename = "weekly_return") 

And always I run this code I see this error:

Error in loadNamespace(j <- i[[1L]], c(lib.loc, .libPaths()), versionCheck = vI[[j]]) : 
  namespace ‘tibble’ 3.1.6 is already loaded, but >= 3.1.7 is required

Sorry for the bad code and bad English but I hope it was understandable

[andresrcs]

@vitoria

namespace ‘tibble’ 3.1.6 is already loaded, but >= 3.1.7 is required

This specific error message is asking you to update the tibble package. Restart your R session and try to update it with this command:

install.packages("tibble")

Do you get any error messages while doing so?

@vitoria

I think it is because my data period it is separate by year and month colunes...

This is true though, the periodReturn function requires a date column. You can construct a proper date column this way although I'm not sure it produces the expected output.

weekly_retun <- data %>%
    mutate(date = ymd(paste(year, month, "1", sep = "-"))) %>% 
    tq_transmute(
        select = monthly_return,           
        mutate_fun = periodReturn,   
        period = "weekly",      
        col_rename = "weekly_return") 

[vitoria]

ok... I just run this code to change the date but the same error appeared
Anyways, thank you so much for the help

[andresrcs]

@vitoria

I just run this code to change the date but the same error appeared

If you are getting the exact same error, then you haven't updated the tibble package successfully. Please post the complete console output you get when you run this command so I can help you with that.

install.packages("tibble")

[M_AcostaCH]

@vitoria

‘tibble’ 3.1.6 is already loaded, but >= 3.1.7 is required

Try to upload this libarary. Check information about remotes

install.packages('remotes')

library(remotes)
#Current Version Installed
packageVersion("tibble") 
[1] "3.1.6"

#Installing version 3.1.7
remotes::install_version("tibble", version = "3.1.7")

#Check the installed version of the upload package
packageVersion("tibble")  
[1] ‘3.1.7’

Next restart and run the script.

[vitoria]

I did this but the R studio returns a warning message:

Warning messages:
1: In missing_devel_warning(pkgdir) :
  Package tibble has compiled code, but no suitable compiler(s) were found. Installation will likely fail.
  Install Rtools (https://cran.r-project.org/bin/windows/Rtools/).Then use the pkgbuild package, or make sure that Rtools in the PATH.

[vitoria]

it seems that I must install R tools because when I run the code to install the tibble package the R studio shows the follow warning message:
Warning messages: 1: In missing_devel_warning(pkgdir) : Package tibble has compiled code, but no suitable compiler(s) were found. Installation will likely fail. Install Rtools (https://cran.r-project.org/bin/windows/Rtools/).Then use the pkgbuild package, or make sure that Rtools in the PATH.

sorry, I kinda lost about this

[andresrcs]

Probably you need to install RTools but I can't tell for sure since you haven't posted the complete console output and I don't have enough information to work with.

[M_AcostaCH]

@vitoria

Install Rtools

Like said @andresrcs , you need install Rtools.
The video is spanish but work well.

https://www.youtube.com/watch?v=eNwxCHKLkOs