Hi
How do I find resources that help me learn to use pre-aggregated data?
I'm new to RStudio and I've been trying to do some basic stuff. I have the R for Data Science book that I'm working through but I'm struggling with pre-aggregated data. For instance the UK government drug data most conveniently available at openprescribing,net
I've found the stat=identity argument in ggplot that allows me to tell it that the y axis should use my pre-aggregated numbers but apart from that I struggle. All the training seems to assume individual observation based data. When I search for blogs and write-ups terms like aggregate give me the aggregate function/method rather than the stuff I need.
Does anyone know of beginner resources targeted at pre-aggregated or could just help me with a couple of search terms that might give some results.
For reference my background is SQL, Business Objects and SPSS in the early 1990s.
thanks
Jon