12311k

Untitled

Mar 3rd, 2020
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. import pandas as pd
  2. stock = pd.read_excel('/datasets/stock.xlsx', sheet_name='storehouse')
  3. xiaomi = stock[stock['item'] == 'Смартфон Xiaomi Redmi 6A 16GB']['count'].sum()
  4. huawei = stock[stock['item'] == 'Смартфон HUAWEI P30 lite']['count'].sum()
  5. stock['item'] = stock['item'].drop_duplicates()
  6. print(stock)
Add Comment
Please, Sign In to add comment