Get top 5 performers from team using pandas
I am new to both python and pandas, numpy etc. I am trying to do some data analysis on batsmen performances for a given team. I have successfully written python code to scrape data and store it in sqlite db in following format
PLAYER_ID RUNS BALLS_FACED STRIKE_RATE NAME MATCH_DATE
4327 9 13 69.23 <PERSON>, J 6/18/2015 0:00
4327 0 0 0 <PERSON>, J 6/19/2015 0:00
4327 3 5 60 <PERSON>, J 6/20/2015 0:00
4327 0 0 0 <PERSON>, J 6/21/2015 0:00
3475 0 0 0 <PERSON>, A R 8/2/2008 0:00
3475 5 7 71.43 <PERSON>, A R 8/3/2008 0:00
3475 2 2 100 <PERSON>, A R 8/4/2008 0:00
3475 0 0 0 <PERSON>, A R 8/5/2008 0:00
3475 0 0 0 <PERSON>, A R 6/8/2009 0:00
3475 12 6 200 <PERSON>, A R 6/10/2009 0:00
3475 20 12 166.67 <PERSON>, A R 6/11/2009 0:00
3475 2 3 66.67 <PERSON>, A R 6/14/2009 0:00
3475 2 2 100 <PERSON>, A R 6/15/2009 0:00
3475 0 0 0 <PERSON>, A R 2/1/2010 0:00
3475 15 13 115.38 <PERSON>, A R 2/9/2010 0:00
3475 2 4 50 <PERSON>, A R 2/11/2010 0:00
3475 65 44 147.73 <PERSON>, A R 2/13/2010 0:00
3475 28 22 127.27 <PERSON>, A R 2/13/2010 0:00
3475 2 4 50 <PERSON>, A R 4/30/2010 0:00
3475 0 0 0 <PERSON>, A R 5/4/2010 0:00
3475 14 11 127.27 <PERSON>, A R 2/22/2012 0:00
3475 0 0 0 <PERSON>, A R 3/14/2012 0:00
3475 22 13 169.23 <PERSON>, A R 3/18/2012 0:00
3475 1 7 14.29 <PERSON>, A R 7/18/2012 0:00
3475 0 0 0 <PERSON>, A R 7/20/2012 0:00
3475 15 14 107.14 <PERSON>, A R 9/19/2012 0:00
3475 0 0 0 <PERSON>, A R 9/24/2012 0:00
3475 0 0 0 <PERSON>, A R 11/16/2013 0:00
3475 1 1 100 <PERSON>, A R 11/30/2013 0:00
3475 0 0 0 <PERSON>, A R 2/19/2014 0:00
3475 8 6 133. 572