Forecasting by ID and Product in R [closed]

by

I would begin by visualizing my data to get some intuitions , detect patterns and choose the best model. R is really great for this. Here I am using ggplot2 but you can do the same thing using lattice. For example :

dat$DATE <- as.Date(dat$DATE,format="%d/%m/%Y")
library(ggplot2)
ggplot(dat,aes(x=DATE,y=Rev,group=ProdCode,color=ProdCode)) + 
  geom_line() + 
  facet_grid(~ID) +
  geom_smooth(method='lm')

enter image description here

Here dat are :

dat <- read.table(text="DATE    ID  ProdCode    Rev
08/01/2012   1-100FDK    B51    0.22
09/01/2012   1-100FDK    B51    10.17
10/01/2012   1-100FDK    B51    39.73
11/01/2012   1-100FDK    B51    78.77
12/01/2012   1-100FDK    B51    167.66
08/01/2012   1-100FDK    B53    387.82
09/01/2012   1-100FDK    B53    321.58
10/01/2012   1-100FDK    B53    261.9
11/01/2012   1-100FDK    B53    259.84
12/01/2012   1-100FDK    B53    269.84
08/01/2012   1-200FFK    A54    194.42
09/01/2012   1-200FFK    A54    225.1
10/01/2012   1-200FFK    A54    269.42
11/01/2012   1-200FFK    A54    321.14
12/01/2012   1-200FFK    A54    429.11",
         header=TRUE)

More Related Contents:

  1. how to apply a function on a data set?
  2. Error in : object of type ‘closure’ is not subsettable
  3. How do I save warnings and errors as output from a function?
  4. Fastest way to add rows for missing time steps?
  5. Applying a function to every row of a table using dplyr?
  6. Reverse stacked bar order
  7. Aggregate multiple columns at once [duplicate]
  8. What is meaning of first tilde in purrr::map
  9. Place a legend for each facet_wrap grid in ggplot2
  10. Import text file as single character string
  11. How to load packages in R automatically?
  12. R tick data : merging date and time into a single object
  13. Non-standard evaluation (NSE) in dplyr’s filter_ & pulling data from MySQL
  14. R Shiny: reactiveValues vs reactive
  15. Add a “rank” column to a data frame
  16. Creating a summary statistical table from a data frame
  17. Find the intersection of overlapping ranges in two tables using data.table function foverlaps
  18. How to make graphics with transparent background in R using ggplot2?
  19. Referring to data.table columns by names saved in variables
  20. What is integer overflow in R and how can it happen?
  21. How to extract Month from date in R
  22. R semicolon delimited a column into rows
  23. ggplot2 does not appear to work when inside a function R [duplicate]
  24. R: Obtaining Rules from a Function
  25. Convert a dataframe to a vector (by rows)
  26. Get all the rows with rownames starting with ABC111
  27. assigning by reference into loaded package datasets
  28. Shiny Dashboard – display a dedicated “loading..” page until initial loading of the data is done
  29. New R-Studio version 0.98.932 deletes .md file – how to prevent?
  30. group by two columns in ggplot2

Leave a Comment