test post for forum question

[Emily Huang]

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.

Thanks,
-Emily Huang