# Predict 1st day of 147th week

#1

Hi,

I have a problem and need your suggestion,

I am working in a retail data, and want to predict the behavior of the customer. The data contains information about the customer who visits the shopping center, it only contains the customer unique identifier and the customer visits for 146 weeks so for each record I have visitor Id and visits, the visits contain numbers such as 1 5 30 …etc , 1 is the first day of the first week which is Monday then 5 means Friday, then 30 means Tuesday for the fourth week and etc.

What I am trying to do is to predict the first day of the visit for the next 147th week. Can you please help me in breaking the problem

The data format columns (visitor_id, visits)
1, 30 84 126 135 137 179 242 342 426 456 460 462 483 594 600 604 704 723 744 787 804 886 924 928 946 954
2, 24 53 75 134 158 192 194 211 213 238 251 305 404 418 458 476 493 571 619 731 739 759 761 847 883 943 962 981 983
.
.
So on

Thanks & Regards,
Eliyaz Shaik

#2

Hi, as per this sample data, it seems that we have only total visits made by the customers. Where is information about the weeks?

#3

I think : 2, 24 53 75 134 158 … 983 , are the days of the whole retail visitors they shop in.
I mean visitor1 visits in day1, visitor30 visits in day24(24/7 = 3 weeks and 3 days which means Tuesday in the week #c4 and so on.
Column visits is : # of days since start of retails shopping
visits for week 147th is 147 * 7.

#4

I think : 2, 24 53 75 134 158 … 983 , are the days of the whole retail visitors they shop in.
I mean visitor1 visits in day1, visitor30 visits in day24(24/7 = 3 weeks and 3 days which means Tuesday in the week #c4 and so on.
Column visits is : # of days since start of retails shopping
visits for week 147th is 147 * 7.

It’s easy what you need to do is some feature engineering and everything will become easy.
You need to break your visits column into : visits days(sun,mon,tues, etc…) by that you can capture what customers have the same days the shop in so when you train a model on them you will be able to know what will happen in 147th week( the day # 1029).
You can group them by 7 days and you may capture some behaviors.