Clean and Standardize E-Commerce Product Data with PandasClean and Standardize E-Commerce Product Data with Pandas
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Joshua's avatar
Joshua nneji
• Oct 4
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.")
Data AnalysisData EngineeringVirtual AssistanceGmailGoogle Workspace StudioNotch
Post image
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started