Untitled
unknown
plain_text
4 years ago
327 B
4
Indexable
import pandas as pd stock = pd.read_excel('/datasets/stock.xlsx', sheet_name='storehouse') xiaomi = stock[stock['item'] == 'Смартфон Xiaomi Redmi 6A 16GB']['count'].sum() huawei = stock[stock['item'] == 'Смартфон HUAWEI P30 lite']['count'].sum() stock['item'] = stock['item'].drop_duplicates() print(stock)
Editor is loading...