How do I find the count of a particular column, based on another column(date) using pandas?
Try this:

df['CountSoldbyMonth'] = df.groupby(['Date','Model']).transform('count')


You don't need to select the third column as you only need the counts of groupby items.