Have monthly data, need log of the difference. How?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Have monthly data, need log of the difference. How?

ellie
So I have monthly data in an excel file, but what I need to make my
calculations in the natural log of the difference. Is there a built in
function in R that will let me transform my data this way, or do I need to
do it in excel before importing the data to R?

Thanks!



--
Sent from: http://r.789695.n4.nabble.com/datatable-help-f2315188.html
_______________________________________________
datatable-help mailing list
[hidden email]
https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
Reply | Threaded
Open this post in threaded view
|

Re: Have monthly data, need log of the difference. How?

jholtman
You can probably do it in R.  Can you show an example of what you data looks like and then the type of transformation that you would like to do.


Jim Holtman
Data Munger Guru
 
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.

On Tue, Jan 30, 2018 at 9:17 AM, ellie <[hidden email]> wrote:
So I have monthly data in an excel file, but what I need to make my
calculations in the natural log of the difference. Is there a built in
function in R that will let me transform my data this way, or do I need to
do it in excel before importing the data to R?

Thanks!



--
Sent from: http://r.789695.n4.nabble.com/datatable-help-f2315188.html
_______________________________________________
datatable-help mailing list
[hidden email]
https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help


_______________________________________________
datatable-help mailing list
[hidden email]
https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help
Reply | Threaded
Open this post in threaded view
|

Re: Have monthly data, need log of the difference. How?

ellie
Thank you for replying! I'll try to attach an image of some of my data, so
you will see the structure. I want to run some regressions with the natural
log of the difference, so I guess the first step would be to extract the
change between each date? I'm almost completely new to R, and would
appreciate any tips on how to proceed.
<http://r.789695.n4.nabble.com/file/t386157/data-img.png>



--
Sent from: http://r.789695.n4.nabble.com/datatable-help-f2315188.html
_______________________________________________
datatable-help mailing list
[hidden email]
https://lists.r-forge.r-project.org/cgi-bin/mailman/listinfo/datatable-help