Data Cleaning

Here is a sample of the cleaned SHIRTS data set for women:

Link to full cleaned data set

To clean this data set, I dropped the “X”, “Link”, and “Product_Image” columns since these columns are not relevant to my analysis. The Price column from the original data set was in Rupees currency, so I converted this column to USD.
View code here

I can use this code for the other Zara data sets, as they contain relatively similar data.

Link to cleaned News API data set