Hi

My data include comany name, industry, score, the first time they registered for assessment and the year of assessment. For example, 1000friends & La Casa de Carlota first resigered for assessment in 2015 and got a score of 82.2 and re-resigered in 2017 and got 91.9.

The database include more than 2000 companies and 5000 observations.

I would like to draw some graphs which show

(1) the first-resigered in horizontal (2005, 2006,.... 2019) and the number of companies in the vertical
(2) the first-resigered in horizontal (2005, 2006,.... 2019) and the average score in the vertical

Thank you very much


company_name industry score first_registered year
.Testpeople 37 80.5 2015 2015
.org/advisors 47 130.4 2017 2017
100 Percent Wine 27 115.3 2015 2015
1000friends & La Casa de Carlota 45 91.9 2015 2017
1000friends & La Casa de Carlota 45 82.2 2015 2015
1001PACT 40 111.2 2015 2015
100km Foods Inc. 27 109.8 2012 2014
100km Foods Inc. 27 108.9 2012 2015
100km Foods Inc. 27 108.6 2012 2012
100km Foods Inc. 27 115.6 2012 2016
1051 by GOODONYA® 27 84.2 2013 2017
1051 by GOODONYA® 27 84.2 2013 2013
1051 by GOODONYA® 27 87.2 2013 2015
… … … … …