Does Speed Matter in E-Commerce? QVC Temple

Transcript:Does Speed Matter in E-Commerce? QVC Temple:
Does Speed Matter in E-Commerce? QVC Temple Analytics Challenge Ismail Hawk-Bey, Ryan Lattieri, John Do, Nsimba Zebedi Do Customers that receive their product sooner purchase more than customers with longer delivery times? YES Working with Smaller Data Working with the provided smaller data set allowed us to test our solutions faster. Larger data sets were massive Filtering through data Spreadsheets given had many details irrelevant to analysis. Filtering allows for quicker run time Easier to read and recognize important factors Determining What’s Necessary By keeping track of the party ID, we can keep track of how many orders this party placed Having the order date and delivery confirmation date is an obvious factor between their total orders METHOD 1 Person Class and opening the workbook Person class contains data for number of orders, order dates, delivery dates, and time between each order and delivery. Openpyxl was used to work with the excel files. Iterating through workbook and saving data Algorithm used to calculate time between orders and data for persons objects. Order dates and time between each order Left hand column shows the dates that each order was placed. The right hand column shows the time between each order. A zero denotes that the package was ordered at the same time. METHOD 2 Python Packages used Pandas Seaborn Organizing and Cleaning of Data Rows were removed that contained a blank cell for the column Column Delivery Confirmation Date. Organized the rows based on the Order Date column. Organizing and Cleaning of Data Finding the time of Delivery for each order Finding the average delivery days for each Party ID Analysis Pearson Correlation Spearman Correlation Pandas.DataFrame.corr method was used to calculate these correlation values CONCLUSION Results