def test_avg_with_sales_1_and_column_saleid(self):
'''Test avg with: avg(saleid)'''
R = Table.inputfromfile('test_csv/sales1.csv')
R1 = Table.avg(R, 'saleid')
self.assertIsNotNone(R1.table)
sum = 0
for row in R.table:
sum = sum + row['saleid']
avg = sum / len(R.table)
for row in R1.table:
self.assertIsNotNone(row['avg(saleid)'])
self.assertEqual(row['avg(saleid)'], avg)
