No announcement yet.
  • Filter
  • Time
  • Show
Clear All
new posts

  • test post for forum question

    Hi everyone,

    I am trying to graph a time series with a dataset that has about two-thousand observations.

    The problem I am running into is that first of all there are duplicate dates (which I was able to drop but I would much prefer to average the values corresponding to said duplicated dates)

    And also that there is a subject column in the Excel spreadsheet and I would like to plot each individual subject, but I'm not sure how.

    For example:
    Subject Date Value
    2 20172 0.95
    2 20172 0.83
    3 20183 1
    3 20189 0.7
    I was hoping I could end up with a plot with a ton of lines corresponding to each subject with the values (averaged on duplicate dates) over time.

    -Emily Huang