saurTarento / analytics

0 stars 0 forks source link

Story - 2 : Write a script in python to update only those whose flag value is 1 #5

Open saurTarento opened 5 months ago

saurTarento commented 5 months ago

Create a column in customers table of enum type and insert bult products data

-- Products table JSON SAMPLE DATA: [ {"product_id": 1, "product_name": "Laptop", "category": "Electronics", "price": 899.99}, {"product_id": 2, "product_name": "Smartphone", "category": "H {"product_id": 3, "product_name": "Coffee Maker", "category": "Appliances", "price": 69.99}, {"product_id": 4, "product_name": "Running Shoes", "category": "Clothing", "price": 79.95}, {"product_id": 5, "product_name": "Bookshelf", "category": "Furniture", "price": 129.99}, {"product_id": 6, "product_name": "Digital Camera", "category": "Electronics", "price": 349.75}, {"product_id": 7, "product_name": "Toaster Oven", "category": "Appliances", "price": 54.50}, {"product_id": 8, "product_name": "Hiking Backpack", "category": "Outdoor", "price": 89.99}, {"product_id": 9, "product_name": "Desk Chair", "category": "Furniture", "price": 149.95}, {"product_id": 10, "product_name": "Wireless Earbuds", "category": "Electronics", "price": 79.99} ]

sonali3003 commented 5 months ago

i am facing in this script. It's showing error. error.docx

rajiv-mobilutionit commented 5 months ago

Its the error of existing category.Crosscheck code