hi I have data that looks like this:
name date_recorded
al 1/1/2011
al 1/3/2012
al 11/30/2013
al 4/08/2014
al 5/06/2017
I want to add a new column called "prior_records" that tells me how many records are recorded prior to the row in question. it is ordered from oldest date to most recent
name date_recorded prior_records
al 1/1/2011 0
al 1/3/2012 1
al 11/30/2013 2
al 4/08/2014 3
al 5/06/2017 4
is there an easy way to do this? note I have many people, Al is just one example