Untitled
Anonymous
plain_text
01/13/2024 7:19 AM
704 B
15
Indexable
import pandas as pd
df_stock = pd.read_csv('/datasets/phone_stock.csv')
df_stock['item_lowercase'] = df_stock['item'].str.lower()
apple = df_stock[df_stock['item_lowercase'] == 'apple iphone xr 64gb']['count'].sum()
samsung = df_stock[df_stock['item_lowercase'] == 'samsung galaxy a30 32gb']['count'].sum()
df_stock = df_stock.drop_duplicates(subset=['item_lowercase'], drop=Truej, reset_index())
#df_stock = df_stock.drop_duplicates(subset=['item_lowercase'], drop=reset_index())
print(df_stock.head())# write your code hereEditor is loading...
Leave a Comment