import pandas
import math
import statistics
import xlrd
read = pandas.read_excel('food.xlsx')
print(read)
print(read['TotalPrice'][23])
print(read.tail(7))
print(read.describe())
avg = 0
for i in read['TotalPrice'][8:14]:
    avg += i
print(avg / len(read['TotalPrice'][8:14]))
print(min(read['Quantity'][48:54]))
print(read.sort_values('Product', ascending=False))
print(read.iloc[15:41].sort_values('Product', ascending=False))
print(read.iloc[60:64].sort_values('Product', ascending=True))
print(read.iloc[60:64].sort_values('City', ascending=False))
print(read.iloc[60:64].sort_values('City', ascending=True))
print(read.iloc[60:64].sort_values('Product', ascending=False))
print(read.iloc[60:64].sort_values(['Product', 'City'], ascending=True))
print(pandas.read_excel('food.xlsx', 'family'))
df = pandas.read_excel('food.xlsx', sheet_name='family')

print(df.sort_values('Члены семьи', ascending=True))
print(sum(df['Возраст']) / len(df['Возраст']))