Welcome to the Hardcore Husky Forums. Folks who are well-known in Cyberland and not that dumb.

Geeky Recruiting Data Shit

24

Comments

  • FremontTroll
    FremontTroll Member Posts: 4,744
    You can clearly see the inflation in the grading system. Everyone other than Cal and the Arizona schools trending up.
  • AIRWOLF
    AIRWOLF Member Posts: 1,840
    Dardanus said:

    Pretty good start @AIRWOLF. Couple things I would consider:

    1. Sort/order by star ranking (best to worst), not alphabetical. The idea is you want to show the important information in order.

    2. The message you send with a line chart is greatly affected by aspect ratio. There is no perfect ratio, but generally 2:1 (w:h) is about right. In this case, a 0.2 star ranking change is a steep increase or decrease. Columns or bars might be a better choice.

    3. Are you trying to emphasize the trend over time, or compare average ranking of each school? Comparing rank of each school can be done much simpler (11 bars ordered by avg rank over this time period, Cal excluded of course).
    Comparing the trend of multiple items can be difficult in a limited space. A good method is to put all lines on a single chart, with a selected school using their color, all other schools being gray/semi-transparent in the background. Your visualization tool might not do this, though.

    4. Be careful web-scraping TBS stuff. My cousin had the FBI knock on his door for similar activity. Not good.

    Do you even Tableau, bro?

    Seriously though, thanks. I have tons more I need to do with this, but I am a retard with this software.

    A lot of it is stuff I have done in Excel before, just not over as long a time period.

    I really am doing this first and foremost to learn how to use the stupid software. Simple things like changing the colors of the lines and formatting things are easy once you know how to do them, but they are not easy when you don't.
  • AIRWOLF
    AIRWOLF Member Posts: 1,840

    You can clearly see the inflation in the grading system. Everyone other than Cal and the Arizona schools trending up.

    Yeah. There is certainly grade inflation going on. The Sum total of the average Stars for the Top 100 teams has risen steadily over time.

    I am going to work in a viz (look at me using serious geek lingo) on that too.
  • AEB
    AEB Member Posts: 3,023
    AIRWOLF said:

    Dardanus said:

    Pretty good start @AIRWOLF. Couple things I would consider:

    1. Sort/order by star ranking (best to worst), not alphabetical. The idea is you want to show the important information in order.

    2. The message you send with a line chart is greatly affected by aspect ratio. There is no perfect ratio, but generally 2:1 (w:h) is about right. In this case, a 0.2 star ranking change is a steep increase or decrease. Columns or bars might be a better choice.

    3. Are you trying to emphasize the trend over time, or compare average ranking of each school? Comparing rank of each school can be done much simpler (11 bars ordered by avg rank over this time period, Cal excluded of course).
    Comparing the trend of multiple items can be difficult in a limited space. A good method is to put all lines on a single chart, with a selected school using their color, all other schools being gray/semi-transparent in the background. Your visualization tool might not do this, though.

    4. Be careful web-scraping TBS stuff. My cousin had the FBI knock on his door for similar activity. Not good.

    Do you even Tableau, bro?

    Seriously though, thanks. I have tons more I need to do with this, but I am a retard with this software.

    A lot of it is stuff I have done in Excel before, just not over as long a time period.

    I really am doing this first and foremost to learn how to use the stupid software. Simple things like changing the colors of the lines and formatting things are easy once you know how to do them, but they are not easy when you don't.
    We understand better than most... It’s hard
  • Muttzen
    Muttzen Member Posts: 1,015
    Chinspiring. Time to gogo data science.
  • Muttzen
    Muttzen Member Posts: 1,015
    Created a shitty heatmap with dendrograms, interpolating the missing games so we get to play EVERYONE.

    Rows are offense, columns are defense.

    Spoilers: we lose to USC and are a tossup with dickrod thanks to our shitty offense. Our defense is clustered similarly to USC and Stanford, our offense is similar to that of ASU.


    image
  • Dardanus
    Dardanus Member Posts: 2,623
    AIRWOLF said:

    Dardanus said:

    Pretty good start @AIRWOLF. Couple things I would consider:

    1. Sort/order by star ranking (best to worst), not alphabetical. The idea is you want to show the important information in order.

    2. The message you send with a line chart is greatly affected by aspect ratio. There is no perfect ratio, but generally 2:1 (w:h) is about right. In this case, a 0.2 star ranking change is a steep increase or decrease. Columns or bars might be a better choice.

    3. Are you trying to emphasize the trend over time, or compare average ranking of each school? Comparing rank of each school can be done much simpler (11 bars ordered by avg rank over this time period, Cal excluded of course).
    Comparing the trend of multiple items can be difficult in a limited space. A good method is to put all lines on a single chart, with a selected school using their color, all other schools being gray/semi-transparent in the background. Your visualization tool might not do this, though.

    4. Be careful web-scraping TBS stuff. My cousin had the FBI knock on his door for similar activity. Not good.

    Do you even Tableau, bro?

    Seriously though, thanks. I have tons more I need to do with this, but I am a retard with this software.

    A lot of it is stuff I have done in Excel before, just not over as long a time period.

    I really am doing this first and foremost to learn how to use the stupid software. Simple things like changing the colors of the lines and formatting things are easy once you know how to do them, but they are not easy when you don't.
    Yep, Tableau is great. It can definitely create the dynamic line chart. This poast may help (the "data-ink" concept is what I was trying to get at).