title: How to create a line graph with 3 column data set?
body: <p>I have a three column data source from a csv. I have used read.csv to import it into R. The data set looks like the following.</p>
  <pre><code>      LRV Variance      Date
     1: 101    4.541  9/1/2020
     2: 101    0.000  9/2/2020
     3: 101    8.992  9/3/2020
     4: 101   23.233  9/4/2020
     5: 101    6.347  9/5/2020
    ---                       
  1696: 150    4.516 9/30/2020
  1697: 150    0.000 10/1/2020
  1698: 150    0.000 10/2/2020
  </code></pre>
  <p>I am trying to generate a line graph with the x axis as Date, Y axis as Variance, and the plot points/line representing each LRV.</p>
  <p>I tried using ggplot to do this.</p>
  <pre><code>ggplot(mydata, aes(Date, Variance, colour = LRV)) + geom_point() + geom_path()
  </code></pre>
  <p>But this ends up plotting a line within each day instead of each LRV.
  <a href="https://i.stack.imgur.com/o4pnz.png" rel="nofollow noreferrer">Here's the output</a></p>