Does Speed Matter in ECommerce QVC Temple Analytics

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. Data. Frame. corr method was used to calculate these correlation values

CONCLUSION

Results