numenorian
New member
Hey everyone,
Recently I found out if you've been scanning your PC points card at Superstore, they've made available older receipts that you can browse and see how much you paid for it.
Available is the price per unit and the price.
Unfortunately this data is not in a download friendly form, so I painstakingly copy-pasted it all by date order into one text file and made a python script to read it all, and analyze it.
Long-story-short, I managed get some trip totals and item totals and put them all in an excel sheet. This sheet is too big for google where I planned to host it, if anyone can host it I'll gladly send it.
Some highlights:
No, things haven't gotten more expensive. As crazy and counter intuitive as it seems, the data doesn't back this up.
You can see some samples of these historical prices over the last 3.5 years that I've been scanning my card in this imgur link, and if someone has a good place to host the full file, I'll be happy to share it.
BTW, that big $500 trip on the totals is a TV, not groceries. No tax event!.
Funny enough, I also decided to look at the average expense per 3-month span and that did go up during the beginning of the pandemic... but our budget shows a massive drop on our restaurant budget, which is probably why our groceries went up in that span. And as you can see in the graph, as the restrictions are gradually lifted, our average grocery trip slowly goes down.
So... are groceries really more expensive? As much as I wanted to say yes, I can't see it in the data.
Can anyone see something I couldn't?
Edit: The full file has>400 277 items that I've bought at last twice in that span of time, the sample plots are just any times I've bought at least 30 times, it'd be an absurd amount of plots otherwise.
Edit 2: If you want to see a specific item, there's a chance I may have bought it. Let me know in the comments and I'll see if I can produce it and post it.
Edit 3: 277 items Things I bought twice or more
Edit 4: @binh04101988 posted all the work on github, you can find it publicly available here
Recently I found out if you've been scanning your PC points card at Superstore, they've made available older receipts that you can browse and see how much you paid for it.
Available is the price per unit and the price.
Unfortunately this data is not in a download friendly form, so I painstakingly copy-pasted it all by date order into one text file and made a python script to read it all, and analyze it.
Long-story-short, I managed get some trip totals and item totals and put them all in an excel sheet. This sheet is too big for google where I planned to host it, if anyone can host it I'll gladly send it.
Some highlights:
No, things haven't gotten more expensive. As crazy and counter intuitive as it seems, the data doesn't back this up.
You can see some samples of these historical prices over the last 3.5 years that I've been scanning my card in this imgur link, and if someone has a good place to host the full file, I'll be happy to share it.
BTW, that big $500 trip on the totals is a TV, not groceries. No tax event!.
Funny enough, I also decided to look at the average expense per 3-month span and that did go up during the beginning of the pandemic... but our budget shows a massive drop on our restaurant budget, which is probably why our groceries went up in that span. And as you can see in the graph, as the restrictions are gradually lifted, our average grocery trip slowly goes down.
So... are groceries really more expensive? As much as I wanted to say yes, I can't see it in the data.
Can anyone see something I couldn't?
Edit: The full file has
Edit 2: If you want to see a specific item, there's a chance I may have bought it. Let me know in the comments and I'll see if I can produce it and post it.
Edit 3: 277 items Things I bought twice or more
Edit 4: @binh04101988 posted all the work on github, you can find it publicly available here