python 3.x - Scatter plots from averaging a columns values -

i'm working 2 columns csv file: month_num , freight_in_(tonnes)

i'm attempting plot average value of freight each month 1987 2016. can show each months average freight in, in table format i'm struggling show in scatter plot.

here current code.

from matplotlib import pyplot plt  import pandas pd  df = pd.read_csv('citypairs.csv')  month = df.groupby(['month_num'])['freight_in_(tonnes)'] month.mean()  plt.scatter(df['month_num'], df['freight_in_(tonnes)']) plt.show() 

try this: df.groupby(['month_num']).mean().reset_index().plot(kind='scatter',x='month_num',y='freight_in_(tonnes)')