4.2.7

import pandas as pd
stock = pd.read_excel('/datasets/stock.xlsx', sheet_name='storehouse')

xiaomi = stock[stock['item'].str.contains('Xiaomi Redmi')]['count'].sum()
#print(xiaomi)
huawei = stock[stock['item'].str.contains('HUAWEI')]['count'].sum()
#print(huawei)
stock['item'] = stock['item'].drop_duplicates()
stock = stock.dropna().reset_index(drop=True)
stock.loc[0, 'count'] = xiaomi
stock.loc[3, 'count'] = huawei
print(stock)