• 100javelinas [none/use name]
    link
    fedilink
    English
    21 year ago

    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