Finding the best boot for you. Is this idea doable?

Options
2»

Comments

  • FrankieG
    FrankieG Abingdon MD Posts: 9,100
    Uh oh... It's not worth it to crash your computer..
    2003: 7/14 NJ ... 2006: 6/1 NJ, 6/3 NJ ... 2007: 8/5 IL ... 2008: 6/24 NY, 6/25 NY, 8/7 EV NJ ... 2009: 10/27 PA, 10/28 PA, 10/30 PA, 10/31 PA
    2010: 5/20 NY, 5/21 NY ... 2011: 6/21 EV NY, 9/3 WI, 9/4 WI ... 2012: 9/2 PA, 9/22 GA ... 2013: 10/18 NY, 10/19 NY, 10/21 PA, 10/22 PA, 10/27 MD
    2015: 9/23 NY, 9/26 NY ... 2016: 4/28 PA, 4/29 PA, 5/1 NY, 5/2 NY, 6/11 TN, 8/7 MA, 11/4 TOTD PA, 11/5 TOTD PA ... 2018: 8/10 WA
    2022: 9/14 NJ ... 2024: 5/28 WA, 9/7 PA, 9/9 PA ---- http://imgur.com/a/nk0s7
  • BHealy
    BHealy Flagstaff, Arizona Posts: 466
    I think it was an update that got pushed through and messed it up. It actually seems better now.
  • Roeland
    Roeland Posts: 177
    BHealy said:

    FrankY59 said:

    BHealy said:

    I run statistics analyses at work, and I had thought about running something like a "cluster analysis" that would show (visually) how similar/different each set list is from others. That would help you pick a few bootlegs from each tour that were different from each other.....it would take a bit of work to set it up though..I don't know if it would be helpful or not.

    I love math. How can I help?!

    I need to get all the songs in a matrix with the shows listed along one axis, and all the songs along the other axis and a "0" or "1" to signify whether the song was played or not at that show. That's what been holding me back!
    Here you go :): http://www.pjdb.net/grid.php

    FrankieG said:

    I did this awhile ago, but definitely room for improvement. Brute force excel method is very slow: http://community.pearljam.com/discussion/217259/perfect-pj-bootleg-finder-excel-sheet#latest

    Check my post in that thread, you can do that easily and almost instanteneously through a pivot table. You're trying to reinvent the wheel now which makes Excel very slow.
  • BHealy
    BHealy Flagstaff, Arizona Posts: 466
    Thanks! I got a zero/1 grid from Paranoidboy, and I'll work with it this weekend, assuming my computer doesn't take a crap again.
  • BHealy
    BHealy Flagstaff, Arizona Posts: 466
    Sorry I haven't had a chance to work on this guys, I haven't forgotten.

Categories