i am trying to display the max date of a month where the snow on ground value is greater than zero. Here is the head of the data frame. It has every days reading for all of 2018.

This is what i have been able to get so far:

[![enter image description here](https://i.stack.imgur.com/StTw3.png)](https://i.stack.imgur.com/StTw3.png)

Date with minimum snow​
=======================

```
dfsmin = df.rename(columns={'Snow on Grnd (cm)':'Snow_on_Grnd_cm'}, inplace=True)
​
dfs_minsnow_date1 = df.loc[df.groupby('Month').Snow_on_Grnd_cm.idxmin(),:]
​
dfs_minsow_date_noround = dfs_minsnow_date1[['Month', 'Day', 'Snow_on_Grnd_cm']]     
​
dfs_minsow_date = dfs_minsow_date_noround.round(1)
​
d ={1:'January',2:'February',3:'March',4:'April',5:'May',6:'June',7:'July',8:'August',9:'September',10:'October',11:'November',12:'December'}
​
dfs_minsow_date.Month = dfs_minsow_date.Month.map(d)
​
dfs_minsow_date.set_index('Month')
​
dfs_minsow_date.transpose()

```

Output

```
[![Output:][1]][1]

```

[![enter image description here](https://i.stack.imgur.com/jPMeE.png)](https://i.stack.imgur.com/jPMeE.png)

EDIT: thank you for the reputation points, pictures uploaded!