1- max_date remains constant so how come "max_date-x.min()" while grouping by customer would give you total age of customer? max_date is not last date of purchase for customer. 2- The date columns you have calculated is in fact the time period between first transaction of customer and the 12-09-2011. Good job though
Great vid Absent Data! Reminds me a bit of the RFM analysis you did in the past. Super helpful as always!
Yes, RFM is the basis for the alot of CLTV calculations. Great observations. I am glad you like the video!
man cheers from egypt your awesome
1- max_date remains constant so how come "max_date-x.min()" while grouping by customer would give you total age of customer? max_date is not last date of purchase for customer.
2- The date columns you have calculated is in fact the time period between first transaction of customer and the 12-09-2011.
Good job though
can you share the github link for this and the dataset please?
sure its the ecommerce dataset on this page: absentdata.com/data-analysis/where-to-find-data/