This project is based on Insta cart data set. The data source is https://www.kaggle.com/c/instacart-market-basket-analysis/data. As this was a huge data set consisting of 3 million orders. There were around 10 products in one order, so the total rows the order file was around 30 million. So, I connected this file to Oracle database and then access the data set with the help of SQL queries. The results were visualized using matplotlib liabrary of the python. This dataset consist of the below files.

#This-project-is-based-on-Insta-cart-data-set.-The-data-source-is-

Aisles.csv- Aisle id and the name of the aisle

Department.csv-Department name and its corresponding id.

Products.csv- Product id, Product name and its corresponding department and aisle

Orders.csv- Orderid, userid, odernumber, which day of the week order was place and which hour of the day it was placed.

Order_Product table- details of 3 million orders, One order was having approximate 10 product in it.

For the demo purpose we have kept the limit. As this data set is very large it will take a lot of time to upload it into Oracle data base.

#For-the-demo-purpose-we-have-kept-the-limit.-As-this-data-set-is-very-large-it-will-take-a-lot-of-time-to-upload-it-into-Oracle-data-base.

Create Tables

#Create-Tables

Insert Data

#Insert-Data

Create Table

#Create-Table

Insert Data

#Insert-Data

Create Table

#Create-Table

Insert Data

#Insert-Data

Create Table

#Create-Table

Insert Data

#Insert-Data

Create Table

#Create-Table

Insert Data

#Insert-Data

Data Visualization

#Data-Visualization
Loading output library...
Loading output library...