I was wondering about the relationship between the numbers.
I understand that num of visits = num of cart + num of no_cart.
However after I calculate the num of visits (after the merge) as 2052, num of no_cart as 1652, I got 162 when calculating the num of the people putting stuff in the cart (in step 6). Shouldn’t it be 400 (2052-1652)?
When I went back to check len(visits), it came out as 2000, which is even more confusing. When calculating the num of visits, I used left merge, which includes all the data in visits. How can the numbers be different?
This is my code. I would really appreiciate the help!