-2 points
hmmm, sorting by country CA and pasting into a spreadsheet:
- 408 lines in total
- each line containing an individual order of 1-28 items
- I don’t think this data shows how many of each item is ordered, only the name of each
- 86 unique email addresses (did zero cleanup here and I see there are duplicates due to spelling errors and the same name/address using multiple email addresses)
- of unique email addresses, here are the top cities with # of recipients: Montréal 8, Calgary 7, Québec 5, Toronto 4, Edmonton 3, Sherbrooke 3, Winnipeg 3 (I did some very simple data cleanup such as consolidating spelling variations. but I didn’t do things like group suburbs into larger metro areas)
- Sorting the unique email addresses by postal code sort of lets you eyeball geography a bit better… by this view and all others my impression that the province of Quebec is very well represented
- A small number of people are buying a lot of stuff. I am guessing the person who’s email address contains blondie69 in Toronto is a distributor or something. They have been ordering many copies of the same items over long time. Most of them are to J.J on Jane St but a couple are to G.H on Emmet Ave. Their order is usually 3-4 items.
- The individual email address with the most lines (54) has user name fumeurchronic and has their items mailed to an address on Place Basile-Patenaude, Montreal. Unlike blondie69, fumeurchronic has very few duplicate orders. I think this person is a real fan and collector
- Another way to group the information would be by area code on the phone number
