import pandas as pd
stock = pd.read_excel('/datasets/stock.xlsx', sheet_name='storehouse')
#print(stock)
xiaomi = stock[stock['item'] == 'Смартфон Xiaomi Redmi 6A 16GB']['count'].sum()
#print(xiaomi)
huawei = stock[stock['item'] == 'Смартфон HUAWEI P30 lite']['count'].sum()
#print(huawei)
#stock = stock.drop_duplicates('item').reset_index(drop=True)
print(stock.drop_duplicates('item'))