Instacart Market Basket Analysis

Instacart is an American company that provides grocery delivery and pick-up service. The Company operates in the U.S and Canada. Instacart offers its services via a website and mobile app. Unlike another E-commerce website providing products directly from Seller to Customer. Instacart allows users to buy products from participating vendors. And this shopping is done by a Personal Shopper.

Task: The task here is to build a model that predicts where the user order’s the product again or not


  1. Business problem

1. Business Problem

Instacart is an American company that operates a grocery delivery and pick-up service in the United States and Canada. The company offers its services via a website and mobile app. In 2017 the company hosted a Kaggle competition and also provided the data of the Instacart users (fully anonymized). The main objective of this problem is which products the user purchase again. The problem is different from the Recommendation system because, In this problem, we will predict if the users reorder the products or not based on the prior(previous orders) order.

2. Data source

Instacart has open-sourced this data in Kaggle for the competition

3. Data overview

From the data source you can download the data. It has seven files

  1. Aisles.csv : It has aisle name and aisle_id(primary_key)

4. Mapping to ML problem:

So as by going through the Business problem and Data it is a kind of recommendation problem. We will be building a model with a classification problem. Using this we can predict which products can be reordered or not. Finally, we can create a list of products that may be reordered

Metric: Mean_f1_score

Here the mean_f1 is the f1_score is calculated for each order and taken an average

5. EDA

Based on the prior order data here is the plot products using word_cloud

In the figure above the size of the products tells that how many times the product is reordered

As we can see above that the products related to banana-like organic banana, a bag of organic bananas are mostly bought from instacart

Top 100 products purchased in instacart

As from above plot we can see that top 3 products are Banana, Bag of organic banana and organic strawberry

Department frequency of reorders

From the above plot as we can see that produce has high frequency of purchase

Reorder_ratio of day_of_week
Reorder_ratio of ahour

From above two plots of reorder_ratio of hour and day we can see that peek shopping hours are between day and time 9:00 to 16:00 time and peek shopping day’s are Saturday and Sunday.

The top 50 products purchased in weekly bias(7days)
Top 50 products purchased monthly (30days)

From the above plots of monthly and weekly we can see the top 50 products purchased

For In_depth EDA you can go to my GITHUB repository

6. Feature Engineering

Before feature engineering, I have added a product Name, ID, Department, Aisle as ‘None’ to the list of products because if any order of the users is empty(Sum of all products reordered==0) then we will append a product ‘None’ for that particular order and value for will be reorderdered=1. so that if the user didn’t order any products we can easily predict None.

I have tried with my own features and some are taken from blogs and Kaggle discussions. These features are calculated only based on prior_data did not include train and test_data

  1. User_product_ratio


What is the reorder_ratio of the particular product with respect to all the products? It is calculated as no of times the product reordered by no of total reorders.

Day_week_Reordered ratio:

What is the reordered ratio of that particular day with respect to all the days? It is calculated as the total number of reorders of that particular day divided by the total no of orders of all days

Hour_of_day Reordered ratio:

What is the reordered ratio of the particular hour with respect to all the hours?. Calculated as same as day_week_ratio

Day_since_prior_order Reordered Ratio:

The reordered ratio of that particular since the prior day with respect to all the days. It is calculated as The total no of reorder’s of particular Days_since order by total no of orders

Product_day_week Reorder_ratio:

The reordered ratio of a product for that particular day. It is the total no of reorders of that product for that particular day by a total no of reorders of that day only.

Product_Hour_of day Reorder_ratio:

The reordered ratio of that particular hour of the days. Calculated same as above

User_hour_Reordered Ratio:

what is the reordered ratio of the user for that particular hour?. It is calculated as the reordered sum of that particular hour by the total no of reordered of the day

User_day Reordered Ratio:

What is reordered ratio of the user for that particular day


How many days have been passed since the user has purchased the product


How many time’s user purchased the product

Word2Vec of product+Dep+Aisle

By combining the product, Department, and aisle we have done Word2Vec using a spacy library with default or pre-trained models (en_core_web_sm) which is of 90_dimension Vectors

import spacy
nlp = spacy.load(“en_core_web_sm”)
vectars = []
for i in tqdm(all_items.concat):

Converting day and hours to cyclic Features:


As shown in the above figure we can see that the day features are converted to cyclic. The reason why we should convert to cyclic I will tell with example ‘The distance between hour 23rd and hour 0th is greater the distance between the hour 21 and 23 as shown in Before cyclic conversion, But after converting them into cyclic features we can see that distance between 23rd and 0th hour is less than the 21st and 23rd hour.’ So we will convert these hour and day features to cyclic

df['hr_sin'] = np.sin(*(2.*np.pi/24))
df['hr_cos'] = np.cos(*(2.*np.pi/24))
df['day_sin'] = np.sin((*(2.*np.pi/12))
df['day_cos'] = np.cos((*(2.*np.pi/12))

Weighted features with respect to 7,14,30 days prior

Giving more weights particularly to these days because the user mostly shops on the weekdays (7 days) monthly(30_days) and 14 days.

data['weight7days_sin_since_prod']=(1.01 + np.sin(2*np.pi*(data['pro']/7)))/2
data['weight7days_cos_since_prod']=(1.01 + np.cos(2*np.pi*(data['pro']/7)))/2
#similarly for 30 and 14 days

7. Splitting Data into Train_Test Split:

Taking all the products in prior orders of all the users and merging with orders_products train data and filling reordered column nill values with zero. And merging with feature files

prior_ = prior_data.merge(orders[['user_id','order_id','eval_set']],on='order_id',how='left')
prior_ = prior_.drop_duplicates()
train=prior_.merge(train_data[['user_id','order_id','order_number',' order_dow','order_hour_of_day','days_since_prior_order']],on='user_id').drop_duplicates()

Test_data: Taking all the prior products of the user of test data and merging with features files

test_order = orders[orders.eval_set=='test']
test_order = test_order.drop(['eval_set'],axis=1)
temp = prior_data[['user_id','product_id']].drop_duplicates()
test_data = test_order.merge(temp,on='user_id')

Here fill all the Nan values with Zero, because for the first order of the user the days since the prior product is given Nan value so we fill with Zero

8. Modeling:

For cross-validation the training data is divided with users, There are totally 1,31,209 users in the data so I have divided the data based on users 101209 for training and 30,000 users for cross-validation.

For modeling, I tried Logistic_regression,SVM,DecisionTree,RandomForest, and Lightgbm in these algorithms I found Lightgbm works better and very fast so I Used Lightgbm and used RandomSearch for hyperparameter tunning

{'class_weight': {0: 1, 1: 10},
'learning_rate': 0.1,
'max_depth': 10,
'n_estimators': 300,
'num_leaves': 62}

After getting the Best params I tried giving more estimators and the cv result also increased. So my final params I used are


These params gave me the f1_score of 0.4273138591291579 for CV(cross-validation_data)

Feature_importances after Modelling with lgbm

Featue importaces

After the best model I got, I saved my model and ran it with test data to get the results. For submitting on Kaggle I created a function to merge all the products as a list

def sub(result):
'''If any order_id has no products we explicitly give None vale and submit'''
sub = pd.DataFrame()
sub['order_id'] = Test.order_id
sub['products'] = Test.product_id
sub['reordered'] = result
temp = sub.groupby('order_id').agg({'reordered':'sum'}).reset_index()
temp = temp[temp.reordered==0]
if len(temp)!=0:
temp['reordered'] = ['None' for i in range(0,len(temp))]
temp.columns = ['order_id','products']
sub = sub[sub.reordered==1]
sub = sub.sort_values(by ='order_id')
sub.products = sub.products.astype('str')
sub = sub.groupby('order_id')['products'].apply(' '.join).reset_index()
sub = sub[sub.reordered==1]
sub = sub.sort_values(by ='order_id')
sub.products = sub.products.astype('str')
sub = sub.groupby('order_id')['products'].apply(' '.join).reset_index()

My Kaggle submission score

9. Deployment

I have used Flask for Deployment this Ml Model

10. Conclusion

As from the above Screenshots of kaggle, we can see that I am able to predict the products for the given orders with the mean _f1_score of 0.38 which places me in the top 15 percentile of the competition

11. Future works:

In the future, I wanted to do with some neural networks

create a separate model to predict ‘None’ value because I have seen some discussions and blogs who have trained separate model for predicting None have got a good score

Create more features with the add_to_cart feature which I haven’t tried in this project

12. References

To check out my entire work you can visit my Github Repository

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store