How to access the data of the column on which some groupby operation has been carried out?
As county is not a key when you make the new dataframe so you can't access it.
So you just need to reset index so that county can be accessed when required.
df = pd.DataFrame(california_venues.groupby('county').count().reset_index())