Plotting time-series with Date labels on x-axis

Question

I know that this question might be a cliche  but I m having hard time doing it   I ve data set in the following format        Date            Visits      11 1 2010       696537     11 2 2010       718748     11 3 2010       799355     11 4 2010       805800     11 5 2010       701262     11 6 2010       531579     11 7 2010       690068     11 8 2010       756947     11 9 2010       718757     11 10 2010      701768     11 11 2010      820113     11 12 2010      645259   I want to create a time-series plot  with x-axis representing time  amp  y-axis vists  Also  I want to mark the x-axis with date  The code I was using is the following   dm newday   as POSIXct strptime dm Day  format   Y- m- d    plot as Date dm day  dm visits  axis Date 1 Day at seq as Date  2010 10 30    as Date  2011 01 29   by  days

User · Answer

I like using the ggplot2 for this sort of thing   df Date  lt - as Date  df Date    m  d  Y   require ggplot2  ggplot  data   df  aes  Date  Visits      geom line

User · Answer

I like ggplot too   Here s one example   df1   data frame  date id   c  2017-08-01    2017-08-02    2017-08-03    2017-08-04              nation   c  China    USA    China    USA     value   c 4 0  5 0  6 0  5 5    ggplot df1  aes date id  value  group nation  colour nation   geom line   xlab label  dates   ylab label  value

User · Answer

It s possible in ggplot and you can use scale date for this task   library ggplot2     Lines  lt -  Date            Visits     11 1 2010   696537     11 2 2010   718748     11 3 2010   799355     11 4 2010   805800     11 5 2010   701262     11 6 2010   531579     11 7 2010   690068     11 8 2010   756947     11 9 2010   718757     11 10 2010  701768     11 11 2010  820113     11 12 2010  645259      dm  lt - read table textConnection Lines   header   TRUE      dm  lt - mutate dm  Date   as Date dm Date    m  d  Y        ggplot data   dm  aes Date  Visits          geom line          scale x date format     b  d   major     1 day

User · Answer

You can rotate the dates by hacking axis notations with text    Lines  lt -  Date            Visits 11 1 2010   696537 11 2 2010   718748 11 3 2010   799355 11 4 2010   805800 11 5 2010   701262 11 6 2010   531579 11 7 2010   690068 11 8 2010   756947 11 9 2010   718757 11 10 2010  701768 11 11 2010  820113 11 12 2010  645259   dm  lt - read table textConnection Lines   header   TRUE  dm Date  lt - as Date dm Date    m  d  Y   plot Visits   Date  dm  xaxt    n   type    l   axis 1 at NULL  labels F  text x   dm Date  par  usr   3   97  labels   paste dm Date       srt   45  pos   1  xpd   TRUE cex  7

User · Answer

Your code has lots of errors     You are mixing up dm Day and dm day  Probably not the same thing Your column headings are Date and Visits  So you would access them  I m guessing  as dm Date and dm Visits In the date field you have  Y- m- d this should be  m  d  Y   The following code should plot what you want   dm newday   as Date dm Date    m  d  Y   plot dm newday  dm Visits

User · Answer

1  Since the times are dates be sure to use  quot Date quot  class  not  quot POSIXct quot  or  quot POSIXlt quot    See R News 4 1 for advice and try this where Lines is defined in the Note at the end   No packages are used here  dm  lt - read table text   Lines  header   TRUE  dm Date  lt - as Date dm Date   quot  m  d  Y quot   plot Visits   Date  dm  xaxt    quot n quot   type    quot l quot   axis 1  dm Date  format dm Date   quot  b  d quot    cex axis    7   The use of text   Lines is just to keep the example self-contained and in reality it would be replaced with something like  quot myfile dat quot      continued after image   2  Since this is a time series you may wish to use a time series representation giving slightly simpler code  library zoo   z  lt - read zoo text   Lines  header   TRUE  format    quot  m  d  Y quot   plot z  xaxt    quot n quot   axis 1  dm Date  format dm Date   quot  b  d quot    cex axis    7   Depending on what you want the plot to look like it may be sufficient just to use plot Visits   Date  dm  in the first case or plot z  in the second case suppressing the axis command entirely   It could also be done using xyplot zoo library lattice  xyplot z   or autoplot zoo  library ggplot2  autoplot z   Note  Lines  lt -  quot Date            Visits 11 1 2010   696537 11 2 2010   718748 11 3 2010   799355 11 4 2010   805800 11 5 2010   701262 11 6 2010   531579 11 7 2010   690068 11 8 2010   756947 11 9 2010   718757 11 10 2010  701768 11 11 2010  820113 11 12 2010  645259 quot

[r] Plotting time-series with Date labels on x-axis

Examples related to r

Examples related to plot