househusbend Feb 18th, 2020 83 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. import pandas as pd
  2. stock = pd.read_excel('/datasets/stock.xlsx', sheet_name='storehouse')
  3. #print(stock)
  4. xiaomi = stock[stock['item'] == 'Смартфон Xiaomi Redmi 6A 16GB']['count'].sum()
  5. #print(xiaomi)
  6. huawei = stock[stock['item'] == 'Смартфон HUAWEI P30 lite']['count'].sum()
  7. #print(huawei)
  8. #stock = stock.drop_duplicates('item').reset_index(drop=True)
  9. print(stock.drop_duplicates('item'))
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand