Projects using Notch

Projects using NotchProjects using Notch

Premium Social Media Design for Women's Beauty Brand

1

19

Cover image for import pandas as pd

# Load

import pandas as pd # Load messy e-commerce data df = pd.read_excel('ecommerce_products.xlsx') # 1. Remove duplicates df = df.drop_duplicates() # 2. Clean price column (remove $ sign) df['Price'] = df['Price'].replace('[\$,]', '', regex=True).astype(float) # 3. Standardize category names df['Category'] = df['Category'].str.title() # 4. Fill missing stock with 0 df['Stock'] = df['Stock'].fillna(0) # 5. Save clean file df.to_excel('clean_products.xlsx', index=False) print(f"Done! Cleaned {len(df)} products.")

0

52

Cover image for Virtual Assistant

Virtual Assistant

0

3

Cover image for Sneakers and curated Streetwear

Sneakers and curated Streetwear

1

3