plotting smooth line through all data points

by

A polynomial interpolation in the sense that you are using it is probably not the best idea, if you want it to go through all of your points. You have 24 points, which would need a polynomial of order 23, if it should go through all the points. I can’t seem to use poly with degree 23, but using a lesser degree is already enough to show you, why this won’t work:

ggplot(d) + 
  geom_point(aes(x = hour, y = impressions, colour = cvr), size = 3) +
  stat_smooth(aes(x = hour, y = impressions), method = "lm",
              formula = y ~ poly(x, 21), se = FALSE) +
  coord_cartesian(ylim = c(0, 1.5e7))

enter image description here

This does more or less go through all the points (and it would indeed, if I managed to use an even higher order polynomial), but otherwise it’s probably not the kind of smooth curve you want.
A better option is to use interpolation with splines. This is also an interpolation that uses polynomials, but instead of using just one (as you tried), it uses many. They are enforced to go through all the data points in such a way that your curve is continuous.

As far as I know, this can’t be done directly with ggplot, but it can be done using ggalt::geom_xspline.

Here I show a base solution, where the spline interpolation is produced in a separate step:

spline_int <- as.data.frame(spline(d$hour, d$impressions))

You need as.data.frame because spline returns a list. Now You can use that new data in the plot with geom_line():

ggplot(d) + 
  geom_point(aes(x = hour, y = impressions, colour = cvr), size = 3) +
  geom_line(data = spline_int, aes(x = x, y = y))

enter image description here

More Related Contents:

  1. Remove ‘a’ from legend when using aesthetics and geom_text
  2. ggplot2 – bar plot with both stack and dodge
  3. Generate multiple graphics from within an R function
  4. Creating arbitrary panes in ggplot2
  5. How can I make consistent-width plots in ggplot (with legends)?
  6. Change bar plot colour in geom_bar with ggplot2 in r
  7. How can I change the Y-axis figures into percentages in a barplot?
  8. Formatting dates on X axis in ggplot2
  9. How to draw stacked bars in ggplot2 that show percentages based on group?
  10. Use stat_summary to annotate plot with number of observations
  11. Eliminating NAs from a ggplot
  12. ggplot2: How to specify multiple fill colors for points that are connected by lines of different colors
  13. Remove grid, background color, and top and right borders from ggplot2
  14. Setting y axis breaks in ggplot
  15. R knitr Markdown: Output Plots within For Loop
  16. Generate paired stacked bar charts in ggplot (using position_dodge only on some variables)
  17. heatmap with values (ggplot2)
  18. How to choose variable to display in tooltip when using ggplotly?
  19. Create heatmap with values from matrix in ggplot2
  20. facet_wrap add geom_hline
  21. Improve centering county names ggplot & maps
  22. Using different scales as fill based on factor
  23. Bars in geom_bar have unwanted different widths when using facet_wrap
  24. beautiful Pie Charts with R
  25. Generate ggplot2 boxplot with different colours for multiple groups
  26. Color one point and add an annotation in ggplot2?
  27. Preserve proportion of graphs using grid.arrange
  28. Remove unused factor levels from a ggplot bar plot
  29. How to display emojis in ggplot2 using emo package in R?
  30. adding x and y axis labels in ggplot2

Leave a Comment