Thursday, 28 March 2013

Super Player Database

I've been working with clever folks over at InsideFPL.com who have been able to help out and do useful things with the data I have.

This actually cuts the workload for me down a huge amount, rather than update 25 odd datasources and update 20+ pages with images and manually coding it I'll be able to get back to spending my time on analysis and focusing on what the data means rather than just presenting it.

Also on InsideFPL the data can made to update in real time (e.g. price) The database can be used to look at teams, player or by position and is fully sortable on every column (click the column headers.

In the next week or two I'll be updating the table structure to include basic perforamnce data for each player (e.g. S, SoT) and Projection Data.

One thing that would really help me is to let me know in the comments section what kind of data you want at your fingertips (e.g. points per last 6 games, average F.SCore last 6 games??) and what data is better tucked away a little, in a second tab. List everything, nothing is impossible :)

I've provided a quick glimpse below for just a few players and I've had to make it smaller to fit it in. Head over to InsideFPL.com/fpldata to check out the full database and please leave any comments here and suggsted data or improvements!

Last 6 GW Full Season
PosTeam £m %O PSG A PTSPTS/GW P90 F.SCORE/GW F90 PS G A PTS P90 F.SCORE
Robin Van PersieFWDMan Utd13.7384(1)12285, 12, 4, 5, null, 26.76.6, 5.6, 2.8, 5.4, null, 5.75.225(4)1981947.15.9
Theo WalcottMIDArsenal9175(0)02236, 7, 2, 5, null, 34.85.1, 10, 8.2, 3.4, null, 3.2618(7)1191527.45.2
Dimitar BerbatovFWDFulham6.974(0)30280, 2, 9, 8, null, 97null, 2.3, 7, 7.5, null, 3.85.224(0)1131255.15.1
Marouane FellainiMIDEverton7.5275(0)323715, 1, 2, 12, null, 77.311, 3, 2.4, 7.6, null, 4.55.724(0)11515066.3
Pablo ZabaletaDEFMan City6.2125(0)01171, 4, 5, 6, null, 13.33, 3.2, 5.3, 9.8, null, 6.15.524(0)221034.25.2
Daniel SturridgeFWDLiverpool7.464(0)11225, 10, 0, 0, 2, 55.86.5, null, 11.9, null, 4.9, 5.37.27(0)31508.26.7
Luis SuárezFWDLiverpool11.2416(0)41472, 15, 0, 17, 12, 186.6, 5.8, 8.7, 8.6, 4.6, 4.16.429(0)2141916.37.5

4 comments:

  1. Looks like a great resource, can't wait to use it. The headers could really do with having tooltips telling you what they are to avoid confusion though (e.g. P could also be points and S also shots). The "Show x entries" option wasn't working for me either. As for what data I'd like to see included, Bonus Points and Clean Sheets (for defenders) would probably be useful along with Goals and Assists.

    Another option that would be useful would be the ability to filter, e.g. minimum of 5 played in last 6GW, though I understand this would be quite a big task.

    ReplyDelete
  2. Thanks man, really useful feedback. Tooltips to the headers will be added next week. The show all entries thing won't work as there are only 7 players in this sample. Go to insidefpl to see the full table. Filtering by range or greater/less than is tricky but is on the wish list already.

    ReplyDelete
  3. Bp and cs def doable too, try for these next week

    ReplyDelete
  4. Seems like your already on top of things! Thanks for this info, having Price and Ownership in a simple table is something that's sorely missing from most databases and will be a massive help in my own spreadhseets

    ReplyDelete