Поиск по блогу

четверг, 13 февраля 2014 г.

The groupby operation with Pandas

В видеоролике: groupby=split->analize->combine, потом загружаем список бейсболистов (год,имя, доход,амплуа, клуб), группируем его по годам (DataFrameGroupBy), сортируем каждый год по доходам, из каждого года выбираем игрока с максимальным доходом (generator object). Строим диаграмму Доход/год... Проверяем при этом команду импорта %pylab inline(Populating the interactive namespace from numpy and matplotlib)
Python for Data Analysis Lightning Tutorials Pandas Cookbook Series
Python for Data Analysis Lightning Tutorials is a series of tutorials in Data Analysis, Statistics, and Graphics using Python. The Pandas Cookbook series of tutorials provides recipes for common tasks and moves on to more advanced topics in statistics and time series analysis.
Created by Alfred Essa, Dec 22nd, 2013
Note: IPython Notebook and Data files can be found at my Github Site: http://github/alfredessa
In [1]:
from IPython.display import YouTubeVideo
YouTubeVideo('m7J5pERmjzk')
Out[1]:

Lesson 3.1a (Groupby)

In [2]:
from IPython.display import Image

3.1 Introduction

Step1 (Split): The groupby operation splits the dataframe into a group of dataframe based on some criteria. Note that the grouped object is not a dataframe. It has a dictionary-like structure and is also iterable.
In [5]:
Image(filename='C:/Users/kiss/Documents/GitHub/pdacookbook/images/groupby1.jpg',width=400)
Out[5]:
Step 2 (Analyze): Once we have a grouped object we can apply functions or run analysis to each group, set of groups, or the entire group.
In [6]:
Image(filename='C:/Users/kiss/Documents/GitHub/pdacookbook/images/groupby2.jpg',width=400)
Out[6]:
Step 3 (Combine): We can also combine the results of the analysis into a new data structure(s).
In [7]:
Image(filename='C:/Users/kiss/Documents/GitHub/pdacookbook/images/groupby3.jpg',width=400)
Out[7]:

3.11 Load Major League Baseball salaries dataset

In [9]:
 import pandas as pd
In [11]:
 mlb = pd.read_csv('C:/Users/kiss/Documents/GitHub/pdacookbook/data/mlbsalaries.csv')
In [14]:
 mlb.tail()
Out[14]:
Year Player Salary Position Team
19538 2011 Gustavo Molina 455000 Catcher New York Yankees
19539 2011 Ivan Nova 432900 Pitcher New York Yankees
19540 2011 Colin Curtis 420400 Outfielder New York Yankees
19541 2011 Eduardo Nunez 419300 Shortstop New York Yankees
19542 2011 Reegie Corona 414000 Second Baseman New York Yankees
5 rows × 5 columns

3.12 Groupby using Year column

In [17]:
 grouped = mlb.groupby('Year')
In [18]:
 type(grouped)
Out[18]:
pandas.core.groupby.DataFrameGroupBy
In [19]:
 for k,group in grouped:
        print k
        print group
1988
    Year             Player   Salary           Position                Team
0   1988          Mike Witt  1400000            Pitcher  Los Angeles Angels
1   1988    George Hendrick   989333         Outfielder  Los Angeles Angels
2   1988        Chili Davis   950000         Outfielder  Los Angeles Angels
3   1988      Brian Downing   900000  Designated Hitter  Los Angeles Angels
4   1988          Bob Boone   883000            Catcher  Los Angeles Angels
5   1988         Johnny Ray   857000     Second Baseman  Los Angeles Angels
6   1988          Dan Petry   785000            Pitcher  Los Angeles Angels
7   1988      Butch Wynegar   733333            Catcher  Los Angeles Angels
8   1988     Dick Schofield   552222          Shortstop  Los Angeles Angels
9   1988        Greg Minton   525000            Pitcher  Los Angeles Angels
10  1988  Tony Rafael Armas   425000         Outfielder  Los Angeles Angels
11  1988       Wally Joyner   340000      First Baseman  Los Angeles Angels
12  1988     Kirk McCaskill   262000            Pitcher  Los Angeles Angels
13  1988        Jack Howell   200000      Third Baseman  Los Angeles Angels
14  1988        Devon White   185000         Outfielder  Los Angeles Angels
15  1988      Willie Fraser   125000            Pitcher  Los Angeles Angels
16  1988      Mark McLemore   122500     Second Baseman  Los Angeles Angels
17  1988       Chuck Finley   111000            Pitcher  Los Angeles Angels
18  1988     Darrell Miller   107500            Catcher  Los Angeles Angels
19  1988       Jack Lazorko    97000            Pitcher  Los Angeles Angels
20  1988       Stew Cliburn    70000            Pitcher  Los Angeles Angels
21  1988        Thad Bosley    62500         Outfielder  Los Angeles Angels
22  1988        Terry Clark    62500            Pitcher  Los Angeles Angels
23  1988    Sherman Corbett    62500            Pitcher  Los Angeles Angels
24  1988         Jim Eppard    62500         Outfielder  Los Angeles Angels
25  1988       Bryan Harvey    62500            Pitcher  Los Angeles Angels
26  1988         Nolan Ryan  1200000            Pitcher      Houston Astros
27  1988         Dave Smith  1100000            Pitcher      Houston Astros
28  1988        Bob Knepper  1025000            Pitcher      Houston Astros
29  1988         Terry Puhl   950000         Outfielder      Houston Astros
30  1988     Rafael Ramirez   950000          Shortstop      Houston Astros
31  1988         Bill Doran   933000     Second Baseman      Houston Astros
32  1988         Brian Bass   880000         Outfielder      Houston Astros
33  1988       Danny Darwin   800000            Pitcher      Houston Astros
34  1988         Buddy Bell   790000      Third Baseman      Houston Astros
35  1988         Mike Scott   666667            Pitcher      Houston Astros
36  1988         Bob Forsch   650000            Pitcher      Houston Astros
37  1988    Joaquin Andujar   570000            Pitcher      Houston Astros
38  1988     Craig Reynolds   500000          Shortstop      Houston Astros
39  1988     Larry Andersen   475000            Pitcher      Houston Astros
40  1988         Alan Ashby   450000            Catcher      Houston Astros
41  1988        Glenn Davis   340000      First Baseman      Houston Astros
42  1988      Billy Hatcher   240000         Outfielder      Houston Astros
43  1988       Jim Deshaies   232500            Pitcher      Houston Astros
44  1988        Juan Agosto   192500            Pitcher      Houston Astros
45  1988      Jim Pankovits   150000     Second Baseman      Houston Astros
46  1988       Gerald Young    85000         Outfielder      Houston Astros
47  1988       Ken Caminiti    80000      Third Baseman      Houston Astros
48  1988          Ty Gainey    70000         Outfielder      Houston Astros
49  1988        John Fishel    62500         Outfielder      Houston Astros
50  1988       Alex Trevino    62500            Catcher      Houston Astros
51  1988    Carney Lansford  1535000      Third Baseman   Oakland Athletics
52  1988        Dave Parker  1000000         Outfielder   Oakland Athletics
53  1988          Bob Welch   937500            Pitcher   Oakland Athletics
54  1988     Rick Honeycutt   855000            Pitcher   Oakland Athletics
55  1988   Dennis Eckersley   700000            Pitcher   Oakland Athletics
56  1988       Dave Stewart   700000            Pitcher   Oakland Athletics
57  1988        Storm Davis   550000            Pitcher   Oakland Athletics
58  1988         Don Baylor   532050  Designated Hitter   Oakland Athletics
59  1988        Gene Nelson   470000            Pitcher   Oakland Athletics
     ...                ...      ...                ...                 ...

[686 rows x 5 columns]
1989
     Year               Player   Salary        Position                Team
686  1989            Mike Witt  1400000         Pitcher  Los Angeles Angels
687  1989          Chili Davis  1275000      Outfielder  Los Angeles Angels
688  1989        Brian Downing  1250000      Outfielder  Los Angeles Angels
689  1989        Bert Blyleven  1225000         Pitcher  Los Angeles Angels
690  1989        Lance Parrish  1000000         Catcher  Los Angeles Angels
691  1989  Claudell Washington   975000      Outfielder  Los Angeles Angels
692  1989         Wally Joyner   920000   First Baseman  Los Angeles Angels
693  1989       Dick Schofield   908333       Shortstop  Los Angeles Angels
694  1989           Johnny Ray   850000  Second Baseman  Los Angeles Angels
695  1989            Dan Petry   785000         Pitcher  Los Angeles Angels
696  1989          Greg Minton   630000         Pitcher  Los Angeles Angels
697  1989          Jack Howell   465000   Third Baseman  Los Angeles Angels
698  1989    Tony Rafael Armas   425000      Outfielder  Los Angeles Angels
699  1989       Kirk McCaskill   400000         Pitcher  Los Angeles Angels
700  1989       Bill Schroeder   372500         Catcher  Los Angeles Angels
701  1989          Devon White   320000      Outfielder  Los Angeles Angels
702  1989        Willie Fraser   200000         Pitcher  Los Angeles Angels
703  1989          Bob McClure   200000         Pitcher  Los Angeles Angels
704  1989         Chuck Finley   180000         Pitcher  Los Angeles Angels
705  1989         Bryan Harvey   170000         Pitcher  Los Angeles Angels
706  1989        Glenn Hoffman   160000  Second Baseman  Los Angeles Angels
707  1989        Mark McLemore   155000  Second Baseman  Los Angeles Angels
708  1989           Jim Eppard    91000      Outfielder  Los Angeles Angels
709  1989          Terry Clark    85000         Pitcher  Los Angeles Angels
710  1989           Jim Abbott    68000         Pitcher  Los Angeles Angels
711  1989        Kent Anderson    68000       Shortstop  Los Angeles Angels
712  1989       Dante Bichette    68000      Outfielder  Los Angeles Angels
713  1989       Vance Lovelace    68000         Pitcher  Los Angeles Angels
714  1989           Mike Scott  1300000         Pitcher      Houston Astros
715  1989           Jim Clancy  1150000         Pitcher      Houston Astros
716  1989           Dave Smith  1100000         Pitcher      Houston Astros
717  1989          Glenn Davis  1085000   First Baseman      Houston Astros
718  1989          Bob Knepper  1000000         Pitcher      Houston Astros
719  1989       Rafael Ramirez  1000000       Shortstop      Houston Astros
720  1989           Terry Puhl   950000      Outfielder      Houston Astros
721  1989           Brian Bass   940000      Outfielder      Houston Astros
722  1989           Bill Doran   933000  Second Baseman      Houston Astros
723  1989          Rick Rhoden   900000         Pitcher      Houston Astros
724  1989         Danny Darwin   775000         Pitcher      Houston Astros
725  1989           Alan Ashby   550000         Catcher      Houston Astros
726  1989        Billy Hatcher   495000      Outfielder      Houston Astros
727  1989          Juan Agosto   480000         Pitcher      Houston Astros
728  1989         Jim Deshaies   470000         Pitcher      Houston Astros
729  1989           Bob Forsch   450000         Pitcher      Houston Astros
730  1989       Craig Reynolds   450000       Shortstop      Houston Astros
731  1989       Larry Andersen   425000         Pitcher      Houston Astros
732  1989         Alex Trevino   350000         Catcher      Houston Astros
733  1989    Steve Lombardozzi   222500  Second Baseman      Houston Astros
734  1989       Dan Schatzeder   220000         Pitcher      Houston Astros
735  1989        Harry Spilman   150000   First Baseman      Houston Astros
736  1989         Gerald Young   150000      Outfielder      Houston Astros
737  1989           Dave Meads    92500         Pitcher      Houston Astros
738  1989         Ken Caminiti    83000   Third Baseman      Houston Astros
739  1989         Craig Biggio    78000         Catcher      Houston Astros
740  1989        Louie Meadows    72000      Outfielder      Houston Astros
741  1989       Dave Stapleton    72000         Pitcher      Houston Astros
742  1989        Blaise Ilsley    68000         Pitcher      Houston Astros
743  1989         Jose Canseco  1600000      Outfielder   Oakland Athletics
744  1989      Carney Lansford  1275000   Third Baseman   Oakland Athletics
745  1989            Bob Welch  1205333         Pitcher   Oakland Athletics
      ...                  ...      ...             ...                 ...

[710 rows x 5 columns]
1990
      Year               Player   Salary        Position                Team
1396  1990        Lance Parrish  1916667         Catcher  Los Angeles Angels
1397  1990        Mark Langston  1800000         Pitcher  Los Angeles Angels
1398  1990         Wally Joyner  1750000   First Baseman  Los Angeles Angels
1399  1990          Chili Davis  1375000      Outfielder  Los Angeles Angels
1400  1990            Mike Witt  1300000         Pitcher  Los Angeles Angels
1401  1990        Brian Downing  1250000      Outfielder  Los Angeles Angels
1402  1990        Bert Blyleven  1175000         Pitcher  Los Angeles Angels
1403  1990           Johnny Ray  1125000  Second Baseman  Los Angeles Angels
1404  1990       Dick Schofield   983333       Shortstop  Los Angeles Angels
1405  1990       Kirk McCaskill   967500         Pitcher  Los Angeles Angels
1406  1990          Greg Minton   850000         Pitcher  Los Angeles Angels
1407  1990          Bob McClure   825000         Pitcher  Los Angeles Angels
1408  1990         Chuck Finley   725000         Pitcher  Los Angeles Angels
1409  1990  Claudell Washington   675000      Outfielder  Los Angeles Angels
1410  1990          Jack Howell   652500   Third Baseman  Los Angeles Angels
1411  1990          Devon White   580000      Outfielder  Los Angeles Angels
1412  1990        Mike Smithson   480000         Pitcher  Los Angeles Angels
1413  1990         Scott Bailes   425000         Pitcher  Los Angeles Angels
1414  1990        Willie Fraser   410000         Pitcher  Los Angeles Angels
1415  1990       Bill Schroeder   407500         Catcher  Los Angeles Angels
1416  1990         Bryan Harvey   332500         Pitcher  Los Angeles Angels
1417  1990          Max Venable   200000      Outfielder  Los Angeles Angels
1418  1990           Jim Abbott   185000         Pitcher  Los Angeles Angels
1419  1990        Mark McLemore   175000  Second Baseman  Los Angeles Angels
1420  1990        Kent Anderson   105000       Shortstop  Los Angeles Angels
1421  1990       Dante Bichette   100000      Outfielder  Los Angeles Angels
1422  1990      Sherman Corbett   100000         Pitcher  Los Angeles Angels
1423  1990       Gary DiSarcina   100000       Shortstop  Los Angeles Angels
1424  1990             Mike Erb   100000         Pitcher  Los Angeles Angels
1425  1990         Mike Fetters   100000         Pitcher  Los Angeles Angels
1426  1990      Rich Monteleone   100000         Pitcher  Los Angeles Angels
1427  1990           John Orton   100000         Catcher  Los Angeles Angels
1428  1990      Jeff Richardson   100000         Pitcher  Los Angeles Angels
1429  1990           Bobby Rose   100000  Second Baseman  Los Angeles Angels
1430  1990          Lee Stevens   100000      Outfielder  Los Angeles Angels
1431  1990          Ron Tingley   100000         Catcher  Los Angeles Angels
1432  1990          Cliff Young   100000         Pitcher  Los Angeles Angels
1433  1990           Mike Scott  1987500         Pitcher      Houston Astros
1434  1990          Glenn Davis  1985000   First Baseman      Houston Astros
1435  1990         Danny Darwin  1200000         Pitcher      Houston Astros
1436  1990           Jim Clancy  1150000         Pitcher      Houston Astros
1437  1990           Dave Smith  1100000         Pitcher      Houston Astros
1438  1990         Jim Deshaies  1050000         Pitcher      Houston Astros
1439  1990       Rafael Ramirez  1000000       Shortstop      Houston Astros
1440  1990       Larry Andersen   965000         Pitcher      Houston Astros
1441  1990           Bill Doran   934000  Second Baseman      Houston Astros
1442  1990      Bill Gullickson   900000         Pitcher      Houston Astros
1443  1990          Juan Agosto   850000         Pitcher      Houston Astros
1444  1990           Terry Puhl   800000      Outfielder      Houston Astros
1445  1990         Glenn Wilson   750000      Outfielder      Houston Astros
1446  1990        Ken Oberkfell   625000   Third Baseman      Houston Astros
1447  1990       Dan Schatzeder   450000         Pitcher      Houston Astros
1448  1990         Alex Trevino   350000         Catcher      Houston Astros
1449  1990         Gerald Young   280000      Outfielder      Houston Astros
1450  1990         Craig Biggio   240000         Catcher      Houston Astros
1451  1990         Ken Caminiti   240000   Third Baseman      Houston Astros
1452  1990    Steve Lombardozzi   222500  Second Baseman      Houston Astros
1453  1990        Mark Portugal   202000         Pitcher      Houston Astros
1454  1990        Mark Davidson   125000      Outfielder      Houston Astros
1455  1990     Charlie Kerfield   122000         Pitcher      Houston Astros
       ...                  ...      ...             ...                 ...

[972 rows x 5 columns]
1991
      Year            Player   Salary        Position                Team
2368  1991     Mark Langston  3550000         Pitcher  Los Angeles Angels
2369  1991     Dave Winfield  3300000      Outfielder  Los Angeles Angels
2370  1991       Gary Gaetti  2700000   Third Baseman  Los Angeles Angels
2371  1991      Chuck Finley  2500000         Pitcher  Los Angeles Angels
2372  1991     Lance Parrish  2416667         Catcher  Los Angeles Angels
2373  1991      Wally Joyner  2100000   First Baseman  Los Angeles Angels
2374  1991    Kirk McCaskill  2100000         Pitcher  Los Angeles Angels
2375  1991     Bert Blyleven  2000000         Pitcher  Los Angeles Angels
2376  1991       Dave Parker  1600000      Outfielder  Los Angeles Angels
2377  1991    Dick Schofield  1483334       Shortstop  Los Angeles Angels
2378  1991      Bryan Harvey  1040000         Pitcher  Los Angeles Angels
2379  1991  Jeff D. Robinson  1000000         Pitcher  Los Angeles Angels
2380  1991      Luis Polonia   770000      Outfielder  Los Angeles Angels
2381  1991       Bob McClure   700000         Pitcher  Los Angeles Angels
2382  1991       Jack Howell   652500   Third Baseman  Los Angeles Angels
2383  1991     Mark Eichhorn   625000         Pitcher  Los Angeles Angels
2384  1991       Donnie Hill   500000  Second Baseman  Los Angeles Angels
2385  1991      Scott Bailes   425000         Pitcher  Los Angeles Angels
2386  1991       Max Venable   425000      Outfielder  Los Angeles Angels
2387  1991    Dave Gallagher   357500      Outfielder  Los Angeles Angels
2388  1991        Jim Abbott   312500         Pitcher  Los Angeles Angels
2389  1991      Junior Felix   310000      Outfielder  Los Angeles Angels
2390  1991   Floyd Bannister   250000         Pitcher  Los Angeles Angels
2391  1991      Mike Fetters   120000         Pitcher  Los Angeles Angels
2392  1991        John Orton   120000         Catcher  Los Angeles Angels
2393  1991         Luis Sojo   110000  Second Baseman  Los Angeles Angels
2394  1991        Bobby Rose   107500  Second Baseman  Los Angeles Angels
2395  1991       Cliff Young   105000         Pitcher  Los Angeles Angels
2396  1991       Scott Lewis   102500         Pitcher  Los Angeles Angels
2397  1991        Mike Scott  2412500         Pitcher      Houston Astros
2398  1991      Jim Deshaies  2100000         Pitcher      Houston Astros
2399  1991    Rafael Ramirez  1200000       Shortstop      Houston Astros
2400  1991     Mark Portugal   705000         Pitcher      Houston Astros
2401  1991     Ken Oberkfell   675000   First Baseman      Houston Astros
2402  1991      Ken Caminiti   665000   Third Baseman      Houston Astros
2403  1991      Craig Biggio   437500         Catcher      Houston Astros
2404  1991    Casey Candaele   350000  Second Baseman      Houston Astros
2405  1991      Gerald Young   340000      Outfielder      Houston Astros
2406  1991     Mark Davidson   300000      Outfielder      Houston Astros
2407  1991      Steve Finley   260000      Outfielder      Houston Astros
2408  1991      Eric Yelding   260000       Shortstop      Houston Astros
2409  1991     Pete Harnisch   210000         Pitcher      Houston Astros
2410  1991       Jimmy Jones   190000         Pitcher      Houston Astros
2411  1991    Curt Schilling   125000         Pitcher      Houston Astros
2412  1991      Carl Nichols   123500         Catcher      Houston Astros
2413  1991  Xavier Hernandez   122500         Pitcher      Houston Astros
2414  1991        Dave Rohde   118000  Second Baseman      Houston Astros
2415  1991      Eric Anthony   115000      Outfielder      Houston Astros
2416  1991      Javier Ortiz   115000      Outfielder      Houston Astros
2417  1991       Karl Rhodes   111000      Outfielder      Houston Astros
2418  1991          Al Osuna   106000         Pitcher      Houston Astros
2419  1991  Luis E. Gonzalez   105000      Outfielder      Houston Astros
2420  1991      Jeff Bagwell   100000   First Baseman      Houston Astros
2421  1991      Dwayne Henry   100000         Pitcher      Houston Astros
2422  1991       Darryl Kile   100000         Pitcher      Houston Astros
2423  1991    Jose Tolentino   100000   First Baseman      Houston Astros
2424  1991      Jose Canseco  3500000      Outfielder   Oakland Athletics
2425  1991      Dave Stewart  3500000         Pitcher   Oakland Athletics
2426  1991         Bob Welch  3450000         Pitcher   Oakland Athletics
2427  1991  Rickey Henderson  3250000      Outfielder   Oakland Athletics
       ...               ...      ...             ...                 ...

[720 rows x 5 columns]
1992
      Year            Player   Salary        Position                Team
3088  1992      Chuck Finley  4375000         Pitcher  Los Angeles Angels
3089  1992     Mark Langston  3550000         Pitcher  Los Angeles Angels
3090  1992      Bryan Harvey  3125000         Pitcher  Los Angeles Angels
3091  1992       Gary Gaetti  2700000   Third Baseman  Los Angeles Angels
3092  1992     Lance Parrish  2416667         Catcher  Los Angeles Angels
3093  1992      Hubie Brooks  2316687      Outfielder  Los Angeles Angels
3094  1992         Von Hayes  2200000      Outfielder  Los Angeles Angels
3095  1992        Jim Abbott  1850000         Pitcher  Los Angeles Angels
3096  1992     Mark Eichhorn  1750000         Pitcher  Los Angeles Angels
3097  1992      Luis Polonia  1650000      Outfielder  Los Angeles Angels
3098  1992    Dick Schofield  1500000       Shortstop  Los Angeles Angels
3099  1992        Chuck Crim  1100000         Pitcher  Los Angeles Angels
3100  1992      Don Robinson   900000         Pitcher  Los Angeles Angels
3101  1992       Alvin Davis   800000   First Baseman  Los Angeles Angels
3102  1992      Scott Bailes   600000         Pitcher  Los Angeles Angels
3103  1992      Junior Felix   590000      Outfielder  Los Angeles Angels
3104  1992   Mike Fitzgerald   350000         Catcher  Los Angeles Angels
3105  1992     Rene Gonzales   225000   Third Baseman  Los Angeles Angels
3106  1992       John Morris   200000      Outfielder  Los Angeles Angels
3107  1992         Luis Sojo   180000  Second Baseman  Los Angeles Angels
3108  1992       Ron Tingley   170000         Catcher  Los Angeles Angels
3109  1992        John Orton   130000         Catcher  Los Angeles Angels
3110  1992       Lee Stevens   130000   First Baseman  Los Angeles Angels
3111  1992     Chris Beasley   125000         Pitcher  Los Angeles Angels
3112  1992         Joe Grahe   125000         Pitcher  Los Angeles Angels
3113  1992        Bobby Rose   125000  Second Baseman  Los Angeles Angels
3114  1992       Scott Lewis   120000         Pitcher  Los Angeles Angels
3115  1992    Gary DiSarcina   117500       Shortstop  Los Angeles Angels
3116  1992       Chad Curtis   109000      Outfielder  Los Angeles Angels
3117  1992      Ken Caminiti  1500000   Third Baseman      Houston Astros
3118  1992      Craig Biggio  1375000  Second Baseman      Houston Astros
3119  1992     Mark Portugal  1250000         Pitcher      Houston Astros
3120  1992      Steve Finley  1120000      Outfielder      Houston Astros
3121  1992    Casey Candaele   905000       Shortstop      Houston Astros
3122  1992        Doug Jones   750000         Pitcher      Houston Astros
3123  1992   Pete Incaviglia   700000      Outfielder      Houston Astros
3124  1992        Rob Murphy   600000         Pitcher      Houston Astros
3125  1992     Pete Harnisch   455000         Pitcher      Houston Astros
3126  1992        Joe Boever   450000         Pitcher      Houston Astros
3127  1992       Jimmy Jones   450000         Pitcher      Houston Astros
3128  1992    Rafael Ramirez   400000       Shortstop      Houston Astros
3129  1992      Ernest Riles   400000       Shortstop      Houston Astros
3130  1992      Jeff Bagwell   350000   First Baseman      Houston Astros
3131  1992      Gerald Young   310000      Outfielder      Houston Astros
3132  1992     Denny Walling   300000  Second Baseman      Houston Astros
3133  1992  Luis E. Gonzalez   285000      Outfielder      Houston Astros
3134  1992          Al Osuna   235000         Pitcher      Houston Astros
3135  1992    Curt Schilling   205000         Pitcher      Houston Astros
3136  1992       Darryl Kile   190000         Pitcher      Houston Astros
3137  1992  Xavier Hernandez   175000         Pitcher      Houston Astros
3138  1992    Andujar Cedeno   132000       Shortstop      Houston Astros
3139  1992        Ryan Bowen   125000         Pitcher      Houston Astros
3140  1992   Eddie Taubensee   122000         Catcher      Houston Astros
3141  1992     Scott Servais   120000         Catcher      Houston Astros
3142  1992      Eric Anthony   115000      Outfielder      Houston Astros
3143  1992        Mike Simms   115000      Outfielder      Houston Astros
3144  1992     Juan Guerrero   109000       Shortstop      Houston Astros
3145  1992       Butch Henry   109000         Pitcher      Houston Astros
3146  1992      Jose Canseco  4300000      Outfielder   Oakland Athletics
3147  1992        Mike Moore  3500000         Pitcher   Oakland Athletics
       ...               ...      ...             ...                 ...

[753 rows x 5 columns]
1993
      Year            Player   Salary        Position                Team
3841  1993      Chuck Finley  5375000         Pitcher  Los Angeles Angels
3842  1993      Kelly Gruber  4333334   Third Baseman  Los Angeles Angels
3843  1993     Mark Langston  3550000         Pitcher  Los Angeles Angels
3844  1993       Gary Gaetti  3000000   Third Baseman  Los Angeles Angels
3845  1993      Luis Polonia  2475000      Outfielder  Los Angeles Angels
3846  1993       Chili Davis  1750000      Outfielder  Los Angeles Angels
3847  1993        Chuck Crim  1100000         Pitcher  Los Angeles Angels
3848  1993     Rene Gonzales   600000   Third Baseman  Los Angeles Angels
3849  1993       Stan Javier   600000      Outfielder  Los Angeles Angels
3850  1993        Steve Frey   525000         Pitcher  Los Angeles Angels
3851  1993        Greg Myers   525000         Catcher  Los Angeles Angels
3852  1993   Scott Sanderson   500000         Pitcher  Los Angeles Angels
3853  1993     Jerome Walton   450000      Outfielder  Los Angeles Angels
3854  1993    Gary DiSarcina   265000       Shortstop  Los Angeles Angels
3855  1993       Ron Tingley   262500         Catcher  Los Angeles Angels
3856  1993         Joe Grahe   230000         Pitcher  Los Angeles Angels
3857  1993       Chad Curtis   220000      Outfielder  Los Angeles Angels
3858  1993      John Farrell   200000         Pitcher  Los Angeles Angels
3859  1993      Julio Valera   190000         Pitcher  Los Angeles Angels
3860  1993        John Orton   160000         Catcher  Los Angeles Angels
3861  1993       Scott Lewis   140000         Pitcher  Los Angeles Angels
3862  1993     Jerry Nielsen   115000         Pitcher  Los Angeles Angels
3863  1993        Tim Salmon   115000      Outfielder  Los Angeles Angels
3864  1993     Damion Easley   112500  Second Baseman  Los Angeles Angels
3865  1993         J.T. Snow   110000   First Baseman  Los Angeles Angels
3866  1993     Mark Holzemer   109000         Pitcher  Los Angeles Angels
3867  1993     Torey Lovullo   109000  Second Baseman  Los Angeles Angels
3868  1993    Ty Van Burkleo   109000      Outfielder  Los Angeles Angels
3869  1993       Doug Drabek  4250000         Pitcher      Houston Astros
3870  1993     Greg Swindell  3750000         Pitcher      Houston Astros
3871  1993      Ken Caminiti  3150000   Third Baseman      Houston Astros
3872  1993      Craig Biggio  3050000  Second Baseman      Houston Astros
3873  1993      Steve Finley  2900000      Outfielder      Houston Astros
3874  1993        Doug Jones  2050000         Pitcher      Houston Astros
3875  1993     Mark Portugal  1875000         Pitcher      Houston Astros
3876  1993     Pete Harnisch  1725000         Pitcher      Houston Astros
3877  1993  Xavier Hernandez   900000         Pitcher      Houston Astros
3878  1993    Casey Candaele   775000  Second Baseman      Houston Astros
3879  1993      Jeff Bagwell   655000   First Baseman      Houston Astros
3880  1993        Brian Bass   500000      Outfielder      Houston Astros
3881  1993       Chris James   500000      Outfielder      Houston Astros
3882  1993        Jose Uribe   400000       Shortstop      Houston Astros
3883  1993      Eric Anthony   350000      Outfielder      Houston Astros
3884  1993         Tom Edens   325000         Pitcher      Houston Astros
3885  1993  Luis E. Gonzalez   325000      Outfielder      Houston Astros
3886  1993       Darryl Kile   247500         Pitcher      Houston Astros
3887  1993   Eddie Taubensee   162500         Catcher      Houston Astros
3888  1993     Scott Servais   156500         Catcher      Houston Astros
3889  1993         Eric Bell   145000         Pitcher      Houston Astros
3890  1993       Rick Parker   140000      Outfielder      Houston Astros
3891  1993    Brian Williams   140000         Pitcher      Houston Astros
3892  1993    Andujar Cedeno   135000       Shortstop      Houston Astros
3893  1993     Chris Donnels   130000   Third Baseman      Houston Astros
3894  1993       Karl Rhodes   118000      Outfielder      Houston Astros
3895  1993      Ruben Sierra  4200000      Outfielder   Oakland Athletics
3896  1993      Mark McGwire  4000000   First Baseman   Oakland Athletics
3897  1993  Dennis Eckersley  3750000         Pitcher   Oakland Athletics
3898  1993         Bob Welch  3450000         Pitcher   Oakland Athletics
3899  1993  Rickey Henderson  3250000      Outfielder   Oakland Athletics
3900  1993        Bobby Witt  3033334         Pitcher   Oakland Athletics
       ...               ...      ...             ...                 ...

[786 rows x 5 columns]
1994
      Year            Player   Salary        Position                Team
4627  1994      Chuck Finley  3875000         Pitcher  Los Angeles Angels
4628  1994     Mark Langston  3550000         Pitcher  Los Angeles Angels
4629  1994       Chili Davis  2400000      Outfielder  Los Angeles Angels
4630  1994       Joe Magrane  1500000         Pitcher  Los Angeles Angels
4631  1994        Spike Owen  1250000       Shortstop  Los Angeles Angels
4632  1994        Bo Jackson  1000000      Outfielder  Los Angeles Angels
4633  1994         Joe Grahe   925000         Pitcher  Los Angeles Angels
4634  1994        Greg Myers   700000         Catcher  Los Angeles Angels
4635  1994      Dwight Smith   700000      Outfielder  Los Angeles Angels
4636  1994       Chad Curtis   600000      Outfielder  Los Angeles Angels
4637  1994        Tim Salmon   600000      Outfielder  Los Angeles Angels
4638  1994    Gary DiSarcina   400000       Shortstop  Los Angeles Angels
4639  1994       John Dopson   400000         Pitcher  Los Angeles Angels
4640  1994    Craig Lefferts   400000         Pitcher  Los Angeles Angels
4641  1994     Bob Patterson   400000         Pitcher  Los Angeles Angels
4642  1994       Mark Leiter   300000         Pitcher  Los Angeles Angels
4643  1994        Rex Hudler   275000  Second Baseman  Los Angeles Angels
4644  1994   Harold Reynolds   230000  Second Baseman  Los Angeles Angels
4645  1994       Bill Sampen   225000         Pitcher  Los Angeles Angels
4646  1994     Damion Easley   170000       Shortstop  Los Angeles Angels
4647  1994       Scott Lewis   155000         Pitcher  Los Angeles Angels
4648  1994      Mike Butcher   150000         Pitcher  Los Angeles Angels
4649  1994     Eduardo Perez   135000   First Baseman  Los Angeles Angels
4650  1994      Chris Turner   125000         Catcher  Los Angeles Angels
4651  1994       Jim Edmonds   117500      Outfielder  Los Angeles Angels
4652  1994     Phil Leftwich   109000         Pitcher  Los Angeles Angels
4653  1994       Doug Drabek  4250000         Pitcher      Houston Astros
4654  1994     Greg Swindell  3750000         Pitcher      Houston Astros
4655  1994      Craig Biggio  3350000  Second Baseman      Houston Astros
4656  1994     Pete Harnisch  3205000         Pitcher      Houston Astros
4657  1994      Ken Caminiti  3200000   Third Baseman      Houston Astros
4658  1994      Steve Finley  3050000      Outfielder      Houston Astros
4659  1994    Mitch Williams  2500000         Pitcher      Houston Astros
4660  1994      Jeff Bagwell  2400000   First Baseman      Houston Astros
4661  1994  Luis E. Gonzalez  1630000      Outfielder      Houston Astros
4662  1994       Mike Felder   850000      Outfielder      Houston Astros
4663  1994       Darryl Kile   477500         Pitcher      Houston Astros
4664  1994         Tom Edens   475000         Pitcher      Houston Astros
4665  1994        Brian Bass   400000      Outfielder      Houston Astros
4666  1994    Andujar Cedeno   340000       Shortstop      Houston Astros
4667  1994         Sid Bream   300000   First Baseman      Houston Astros
4668  1994   Eddie Taubensee   275000         Catcher      Houston Astros
4669  1994     Scott Servais   272500         Catcher      Houston Astros
4670  1994    Brian Williams   190000         Pitcher      Houston Astros
4671  1994     Chris Donnels   170000   Third Baseman      Houston Astros
4672  1994  Andy Stankiewicz   138000       Shortstop      Houston Astros
4673  1994        Todd Jones   135000         Pitcher      Houston Astros
4674  1994  Braulio Castillo   120000      Outfielder      Houston Astros
4675  1994    Shane Reynolds   117500         Pitcher      Houston Astros
4676  1994      Tony Eusebio   114000         Catcher      Houston Astros
4677  1994      Mike Hampton   114000         Pitcher      Houston Astros
4678  1994      James Mouton   109000  Second Baseman      Houston Astros
4679  1994  Roberto Petagine   109000   First Baseman      Houston Astros
4680  1994  Rickey Henderson  4800000      Outfielder   Oakland Athletics
4681  1994      Ruben Sierra  4700000      Outfielder   Oakland Athletics
4682  1994  Dennis Eckersley  3750000         Pitcher   Oakland Athletics
4683  1994         Bob Welch  3450000         Pitcher   Oakland Athletics
4684  1994        Bobby Witt  3250000         Pitcher   Oakland Athletics
4685  1994      Mark McGwire  3000000   First Baseman   Oakland Athletics
4686  1994   Terry Steinbach  2800000         Catcher   Oakland Athletics
       ...               ...      ...             ...                 ...

[748 rows x 5 columns]
1995
      Year                Player   Salary           Position  \
5375  1995         Mark Langston  5000000            Pitcher   
5376  1995          Chuck Finley  4875000            Pitcher   
5377  1995         Tony Phillips  4366667         Outfielder   
5378  1995           Chili Davis  3800000  Designated Hitter   
5379  1995            Spike Owen  3500000          Shortstop   
5380  1995             Lee Smith  1900000            Pitcher   
5381  1995        Gary DiSarcina   900000          Shortstop   
5382  1995            Tim Salmon   900000         Outfielder   
5383  1995            Greg Myers   800000            Catcher   
5384  1995            Rex Hudler   300000     Second Baseman   
5385  1995         Bob Patterson   225000            Pitcher   
5386  1995          Shawn Boskie   200000            Pitcher   
5387  1995       Scott Sanderson   200000            Pitcher   
5388  1995             J.T. Snow   200000      First Baseman   
5389  1995         Damion Easley   170000     Second Baseman   
5390  1995         Andy Allanson   150000            Catcher   
5391  1995         Mike Bielecki   150000            Pitcher   
5392  1995          Mike Butcher   150000            Pitcher   
5393  1995    Carlos A. Martinez   150000      First Baseman   
5394  1995         Phil Leftwich   135000            Pitcher   
5395  1995  Brian James Anderson   120000            Pitcher   
5396  1995         Russ Springer   120000            Pitcher   
5397  1995           Jim Edmonds   117500         Outfielder   
5398  1995       Garret Anderson   109000         Outfielder   
5399  1995        Jorge Fabregas   109000            Catcher   
5400  1995            Mike James   109000            Pitcher   
5401  1995      Orlando Palmeiro   109000         Outfielder   
5402  1995         Troy Percival   109000            Pitcher   
5403  1995          Jeff Bagwell  6875000      First Baseman   
5404  1995           Doug Drabek  5000000            Pitcher   
5405  1995          Craig Biggio  4600000     Second Baseman   
5406  1995         Greg Swindell  4450000            Pitcher   
5407  1995         Phil Plantier  2000000         Outfielder   
5408  1995          Rick Wilkins  1475000            Catcher   
5409  1995            Derek Bell  1450000         Outfielder   
5410  1995           Darryl Kile  1272500            Pitcher   
5411  1995       Brian L. Hunter   740000         Outfielder   
5412  1995         Craig Shipley   562500          Shortstop   
5413  1995         Milt Thompson   525000         Outfielder   
5414  1995           Derrick May   325000         Outfielder   
5415  1995          Dave Magadan   275000      Third Baseman   
5416  1995            John Hudek   185000            Pitcher   
5417  1995        John Cangelosi   175000         Outfielder   
5418  1995            Todd Jones   175000            Pitcher   
5419  1995     Pedro A. Martinez   175000            Pitcher   
5420  1995        Shane Reynolds   175000            Pitcher   
5421  1995          Doug Brocail   150000            Pitcher   
5422  1995          Tony Eusebio   150000            Catcher   
5423  1995            Jim Mouton   145000         Outfielder   
5424  1995      Andy Stankiewicz   145000          Shortstop   
5425  1995          Mike Hampton   135000            Pitcher   
5426  1995            Dave Veres   125000            Pitcher   
5427  1995        Orlando Miller   115000          Shortstop   
5428  1995           Ross Powell   115000            Pitcher   
5429  1995         Jim Dougherty   109000            Pitcher   
5430  1995          Mark McGwire  6900000      First Baseman   
5431  1995          Ruben Sierra  6200000         Outfielder   
5432  1995       Terry Steinbach  4200000            Catcher   
5433  1995      Rickey Henderson  3800000         Outfielder   
5434  1995           Ron Darling  3000000            Pitcher   
       ...                   ...      ...                ...   

                    Team  
5375  Los Angeles Angels  
5376  Los Angeles Angels  
5377  Los Angeles Angels  
5378  Los Angeles Angels  
5379  Los Angeles Angels  
5380  Los Angeles Angels  
5381  Los Angeles Angels  
5382  Los Angeles Angels  
5383  Los Angeles Angels  
5384  Los Angeles Angels  
5385  Los Angeles Angels  
5386  Los Angeles Angels  
5387  Los Angeles Angels  
5388  Los Angeles Angels  
5389  Los Angeles Angels  
5390  Los Angeles Angels  
5391  Los Angeles Angels  
5392  Los Angeles Angels  
5393  Los Angeles Angels  
5394  Los Angeles Angels  
5395  Los Angeles Angels  
5396  Los Angeles Angels  
5397  Los Angeles Angels  
5398  Los Angeles Angels  
5399  Los Angeles Angels  
5400  Los Angeles Angels  
5401  Los Angeles Angels  
5402  Los Angeles Angels  
5403      Houston Astros  
5404      Houston Astros  
5405      Houston Astros  
5406      Houston Astros  
5407      Houston Astros  
5408      Houston Astros  
5409      Houston Astros  
5410      Houston Astros  
5411      Houston Astros  
5412      Houston Astros  
5413      Houston Astros  
5414      Houston Astros  
5415      Houston Astros  
5416      Houston Astros  
5417      Houston Astros  
5418      Houston Astros  
5419      Houston Astros  
5420      Houston Astros  
5421      Houston Astros  
5422      Houston Astros  
5423      Houston Astros  
5424      Houston Astros  
5425      Houston Astros  
5426      Houston Astros  
5427      Houston Astros  
5428      Houston Astros  
5429      Houston Astros  
5430   Oakland Athletics  
5431   Oakland Athletics  
5432   Oakland Athletics  
5433   Oakland Athletics  
5434   Oakland Athletics  
                     ...  

[805 rows x 5 columns]
1996
      Year           Player   Salary           Position                Team
6180  1996    Mark Langston  5000000            Pitcher  Los Angeles Angels
6181  1996      Chili Davis  3800000  Designated Hitter  Los Angeles Angels
6182  1996     Chuck Finley  3000000            Pitcher  Los Angeles Angels
6183  1996       Tim Salmon  2500000         Outfielder  Los Angeles Angels
6184  1996       Jim Abbott  2200000            Pitcher  Los Angeles Angels
6185  1996        Lee Smith  2100000            Pitcher  Los Angeles Angels
6186  1996   Gary DiSarcina  1600000          Shortstop  Los Angeles Angels
6187  1996    Randy Velarde   800000          Shortstop  Los Angeles Angels
6188  1996        J.T. Snow   700000      First Baseman  Los Angeles Angels
6189  1996      Jim Edmonds   550000         Outfielder  Los Angeles Angels
6190  1996     Bryan Harvey   500000            Pitcher  Los Angeles Angels
6191  1996      Tim Wallach   400000      Third Baseman  Los Angeles Angels
6192  1996    Troy Percival   330000            Pitcher  Los Angeles Angels
6193  1996    Damion Easley   305000     Second Baseman  Los Angeles Angels
6194  1996      Jack Howell   300000      Third Baseman  Los Angeles Angels
6195  1996       Rex Hudler   300000     Second Baseman  Los Angeles Angels
6196  1996  Garret Anderson   250000         Outfielder  Los Angeles Angels
6197  1996   Dick Schofield   250000          Shortstop  Los Angeles Angels
6198  1996      Don Slaught   250000            Catcher  Los Angeles Angels
6199  1996  Steve Ontiveros   225000            Pitcher  Los Angeles Angels
6200  1996     Mike Aldrete   200000      First Baseman  Los Angeles Angels
6201  1996     Shawn Boskie   200000            Pitcher  Los Angeles Angels
6202  1996  Scott Sanderson   200000            Pitcher  Los Angeles Angels
6203  1996   Jorge Fabregas   175000            Catcher  Los Angeles Angels
6204  1996    Mark Eichhorn   160000            Pitcher  Los Angeles Angels
6205  1996       Mike James   150000            Pitcher  Los Angeles Angels
6206  1996    Mark Holzemer   117500            Pitcher  Los Angeles Angels
6207  1996    Ken Edenfield   112000            Pitcher  Los Angeles Angels
6208  1996     George Arias   109000      Third Baseman  Los Angeles Angels
6209  1996    Tim Harkrider   109000          Shortstop  Los Angeles Angels
6210  1996      Doug Drabek  5050000            Pitcher      Houston Astros
6211  1996     Jeff Bagwell  4875000      First Baseman      Houston Astros
6212  1996    Greg Swindell  4450000            Pitcher      Houston Astros
6213  1996       Derek Bell  2600000         Outfielder      Houston Astros
6214  1996     Craig Biggio  2000000     Second Baseman      Houston Astros
6215  1996     Rick Wilkins  1550000            Catcher      Houston Astros
6216  1996       Sean Berry   995000      Third Baseman      Houston Astros
6217  1996      Darryl Kile   750000            Pitcher      Houston Astros
6218  1996      Derrick May   750000         Outfielder      Houston Astros
6219  1996   Shane Reynolds   330000            Pitcher      Houston Astros
6220  1996      Bill Spiers   325000     Second Baseman      Houston Astros
6221  1996     Tony Eusebio   300000            Catcher      Houston Astros
6222  1996       Todd Jones   300000            Pitcher      Houston Astros
6223  1996   John Cangelosi   280000         Outfielder      Houston Astros
6224  1996     Mike Hampton   275000            Pitcher      Houston Astros
6225  1996    Anthony Young   275000            Pitcher      Houston Astros
6226  1996  Ricky Gutierrez   235000          Shortstop      Houston Astros
6227  1996     Doug Brocail   220000            Pitcher      Houston Astros
6228  1996       John Hudek   210000            Pitcher      Houston Astros
6229  1996   Orlando Miller   205000          Shortstop      Houston Astros
6230  1996     James Mouton   196000         Outfielder      Houston Astros
6231  1996  Brian L. Hunter   180000         Outfielder      Houston Astros
6232  1996      Jeff Tabaka   165000            Pitcher      Houston Astros
6233  1996       Mike Simms   160000         Outfielder      Houston Astros
6234  1996     Alvin Morman   109000            Pitcher      Houston Astros
6235  1996       Mark Small   109000            Pitcher      Houston Astros
6236  1996     Mark McGwire  7000000      First Baseman   Oakland Athletics
6237  1996  Terry Steinbach  4200000            Catcher   Oakland Athletics
6238  1996     Mike Bordick  1850000          Shortstop   Oakland Athletics
6239  1996  Geronimo Berroa  1150000         Outfielder   Oakland Athletics
       ...              ...      ...                ...                 ...

[768 rows x 5 columns]
1997
      Year               Player   Salary        Position                Team
6948  1997         Chuck Finley  4000000         Pitcher  Los Angeles Angels
6949  1997        Mark Langston  4000000         Pitcher  Los Angeles Angels
6950  1997           Tim Salmon  3500000      Outfielder  Los Angeles Angels
6951  1997       Gary DiSarcina  2600000       Shortstop  Los Angeles Angels
6952  1997          Jim Edmonds  2100000      Outfielder  Los Angeles Angels
6953  1997         Dave Hollins  1900000   Third Baseman  Los Angeles Angels
6954  1997          Jim Leyritz  1686672         Catcher  Los Angeles Angels
6955  1997         Mark Gubicza  1600000         Pitcher  Los Angeles Angels
6956  1997         Allen Watson  1200000         Pitcher  Los Angeles Angels
6957  1997        Chuck McElroy   817000         Pitcher  Los Angeles Angels
6958  1997        Randy Velarde   800000  Second Baseman  Los Angeles Angels
6959  1997         Eddie Murray   750000   First Baseman  Los Angeles Angels
6960  1997        Troy Percival   550000         Pitcher  Los Angeles Angels
6961  1997      Garret Anderson   500000      Outfielder  Los Angeles Angels
6962  1997        Craig Grebeck   400000       Shortstop  Los Angeles Angels
6963  1997          Jack Howell   400000   Third Baseman  Los Angeles Angels
6964  1997          Luis Alicea   350000  Second Baseman  Los Angeles Angels
6965  1997  Shigetoshi Hasegawa   300000         Pitcher  Los Angeles Angels
6966  1997           Mike James   280000         Pitcher  Los Angeles Angels
6967  1997       Jorge Fabregas   270000         Catcher  Los Angeles Angels
6968  1997      Dennis Springer   180000         Pitcher  Los Angeles Angels
6969  1997         Darin Erstad   175000      Outfielder  Los Angeles Angels
6970  1997           Mike Holtz   160000         Pitcher  Los Angeles Angels
6971  1997     Orlando Palmeiro   160000      Outfielder  Los Angeles Angels
6972  1997        Jason Dickson   157000         Pitcher  Los Angeles Angels
6973  1997           Pep Harris   155000         Pitcher  Los Angeles Angels
6974  1997         Chris Turner   155000         Catcher  Los Angeles Angels
6975  1997      Steve Ontiveros   154000         Pitcher  Los Angeles Angels
6976  1997          Todd Greene   153000         Catcher  Los Angeles Angels
6977  1997         Jeff Bagwell  8015000   First Baseman      Houston Astros
6978  1997         Craig Biggio  6180000  Second Baseman      Houston Astros
6979  1997           Derek Bell  3250000      Outfielder      Houston Astros
6980  1997           Sean Berry  2200000   Third Baseman      Houston Astros
6981  1997       Shane Reynolds  2000000         Pitcher      Houston Astros
6982  1997          Darryl Kile  1700000         Pitcher      Houston Astros
6983  1997         Mike Hampton  1300000         Pitcher      Houston Astros
6984  1997          Brad Ausmus  1075000         Catcher      Houston Astros
6985  1997     Luis E. Gonzalez  1000000      Outfielder      Houston Astros
6986  1997        Thomas Howard   750000      Outfielder      Houston Astros
6987  1997          Pat Listach   750000       Shortstop      Houston Astros
6988  1997         Tony Eusebio   650000         Catcher      Houston Astros
6989  1997          Bill Spiers   600000  Second Baseman      Houston Astros
6990  1997      Ricky Gutierrez   420000       Shortstop      Houston Astros
6991  1997         James Mouton   415000      Outfielder      Houston Astros
6992  1997        Sid Fernandez   375000         Pitcher      Houston Astros
6993  1997           John Hudek   375000         Pitcher      Houston Astros
6994  1997        Russ Springer   325000         Pitcher      Houston Astros
6995  1997            Tim Bogar   275000       Shortstop      Houston Astros
6996  1997         Billy Wagner   185000         Pitcher      Houston Astros
6997  1997            Jose Lima   170000         Pitcher      Houston Astros
6998  1997         Ramon Garcia   160000         Pitcher      Houston Astros
6999  1997           Tom Martin   155000         Pitcher      Houston Astros
7000  1997       Ray Montgomery   155000      Outfielder      Houston Astros
7001  1997           Mark Small   155000         Pitcher      Houston Astros
7002  1997          Bobby Abreu   150000      Outfielder      Houston Astros
7003  1997           Chris Holt   150000         Pitcher      Houston Astros
7004  1997         Mark McGwire  7100000   First Baseman   Oakland Athletics
7005  1997         Jose Canseco  4500000      Outfielder   Oakland Athletics
7006  1997      Geronimo Berroa  3300000      Outfielder   Oakland Athletics
7007  1997        Scott Brosius  2550000   Third Baseman   Oakland Athletics
       ...                  ...      ...             ...                 ...

[773 rows x 5 columns]
1998
      Year               Player   Salary        Position                Team
7721  1998         Chuck Finley  5000000         Pitcher  Los Angeles Angels
7722  1998             Ken Hill  5000000         Pitcher  Los Angeles Angels
7723  1998           Tim Salmon  5000000      Outfielder  Los Angeles Angels
7724  1998         Allen Watson  2900000         Pitcher  Los Angeles Angels
7725  1998          Jim Edmonds  2800000      Outfielder  Los Angeles Angels
7726  1998        Cecil Fielder  2800000   First Baseman  Los Angeles Angels
7727  1998       Gary DiSarcina  2700000       Shortstop  Los Angeles Angels
7728  1998         Dave Hollins  1900000   Third Baseman  Los Angeles Angels
7729  1998      Garret Anderson  1400000      Outfielder  Los Angeles Angels
7730  1998        Omar Olivares  1150000         Pitcher  Los Angeles Angels
7731  1998        Jack McDowell  1000000         Pitcher  Los Angeles Angels
7732  1998        Troy Percival   950000         Pitcher  Los Angeles Angels
7733  1998        Randy Velarde   850000  Second Baseman  Los Angeles Angels
7734  1998           Mike James   700000         Pitcher  Los Angeles Angels
7735  1998         Darin Erstad   500000   First Baseman  Los Angeles Angels
7736  1998         Matt Walbeck   475000         Catcher  Los Angeles Angels
7737  1998      Norberto Martin   425000       Shortstop  Los Angeles Angels
7738  1998         Rich Delucia   400000         Pitcher  Los Angeles Angels
7739  1998  Shigetoshi Hasegawa   325000         Pitcher  Los Angeles Angels
7740  1998        Jason Dickson   295000         Pitcher  Los Angeles Angels
7741  1998           Pep Harris   226500         Pitcher  Los Angeles Angels
7742  1998           Mike Holtz   226500         Pitcher  Los Angeles Angels
7743  1998        Damon Mashore   210000      Outfielder  Los Angeles Angels
7744  1998           Phil Nevin   210000   Third Baseman  Los Angeles Angels
7745  1998          Todd Greene   200000         Catcher  Los Angeles Angels
7746  1998      Robert Eenhoorn   182500       Shortstop  Los Angeles Angels
7747  1998        Carlos Garcia   182500  Second Baseman  Los Angeles Angels
7748  1998   Angelo Encarnacion   180000         Catcher  Los Angeles Angels
7749  1998        Frank Bollick   178000   Third Baseman  Los Angeles Angels
7750  1998      Chris Pritchett   171000   First Baseman  Los Angeles Angels
7751  1998         Jeff Bagwell  7945000   First Baseman      Houston Astros
7752  1998         Craig Biggio  6120000  Second Baseman      Houston Astros
7753  1998          Moises Alou  5000000      Outfielder      Houston Astros
7754  1998           Derek Bell  4250000      Outfielder      Houston Astros
7755  1998       Shane Reynolds  3000000         Pitcher      Houston Astros
7756  1998         Mike Hampton  2250000         Pitcher      Houston Astros
7757  1998          Brad Ausmus  1500000         Catcher      Houston Astros
7758  1998          Bill Spiers  1400000   Third Baseman      Houston Astros
7759  1998           Sean Berry  1000000   Third Baseman      Houston Astros
7760  1998         Carl Everett   950000      Outfielder      Houston Astros
7761  1998      Ricky Gutierrez   800000       Shortstop      Houston Astros
7762  1998            Tim Bogar   725000       Shortstop      Houston Astros
7763  1998           Dave Clark   700000      Outfielder      Houston Astros
7764  1998         Tony Eusebio   700000         Catcher      Houston Astros
7765  1998           Doug Henry   650000         Pitcher      Houston Astros
7766  1998        Mike Magnante   600000         Pitcher      Houston Astros
7767  1998          Jack Howell   500000   Third Baseman      Houston Astros
7768  1998         Sean Bergman   425000         Pitcher      Houston Astros
7769  1998         Billy Wagner   280000         Pitcher      Houston Astros
7770  1998           Chris Holt   269000         Pitcher      Houston Astros
7771  1998         Ramon Garcia   260000         Pitcher      Houston Astros
7772  1998            Jose Lima   240000         Pitcher      Houston Astros
7773  1998       Ray Montgomery   185000      Outfielder      Houston Astros
7774  1998       C.J. Nitkowski   185000         Pitcher      Houston Astros
7775  1998         Jose Cabrera   180000         Pitcher      Houston Astros
7776  1998        Trever Miller   175000         Pitcher      Houston Astros
7777  1998          John Halama   170000         Pitcher      Houston Astros
7778  1998      Richard Hidalgo   170000      Outfielder      Houston Astros
7779  1998         Kenny Rogers  5000000         Pitcher   Oakland Athletics
7780  1998        Tom Candiotti  2850000         Pitcher   Oakland Athletics
       ...                  ...      ...             ...                 ...

[846 rows x 5 columns]
1999
      Year               Player   Salary        Position                Team
8567  1999            Mo Vaughn  7166666   First Baseman  Los Angeles Angels
8568  1999         Chuck Finley  5800000         Pitcher  Los Angeles Angels
8569  1999             Ken Hill  5500000         Pitcher  Los Angeles Angels
8570  1999           Tim Salmon  5500000      Outfielder  Los Angeles Angels
8571  1999          Tim Belcher  4650000         Pitcher  Los Angeles Angels
8572  1999          Jim Edmonds  3550000      Outfielder  Los Angeles Angels
8573  1999       Gary DiSarcina  3125000       Shortstop  Los Angeles Angels
8574  1999      Garret Anderson  2200000      Outfielder  Los Angeles Angels
8575  1999        Troy Percival  1975000         Pitcher  Los Angeles Angels
8576  1999         Steve Sparks  1387500         Pitcher  Los Angeles Angels
8577  1999  Shigetoshi Hasegawa   900000         Pitcher  Los Angeles Angels
8578  1999       Mark Petkovsek   850000         Pitcher  Los Angeles Angels
8579  1999         Matt Walbeck   825000         Catcher  Los Angeles Angels
8580  1999           Mike James   805000         Pitcher  Los Angeles Angels
8581  1999         Darin Erstad   800000   First Baseman  Los Angeles Angels
8582  1999        Mike Magnante   775000         Pitcher  Los Angeles Angels
8583  1999        Jason Dickson   375000         Pitcher  Los Angeles Angels
8584  1999           Pep Harris   305000         Pitcher  Los Angeles Angels
8585  1999           Mike Holtz   290000         Pitcher  Los Angeles Angels
8586  1999           Jeff Huson   280000  Second Baseman  Los Angeles Angels
8587  1999     Orlando Palmeiro   276000      Outfielder  Los Angeles Angels
8588  1999            Matt Luke   250000      Outfielder  Los Angeles Angels
8589  1999          Andy Sheets   230000       Shortstop  Los Angeles Angels
8590  1999          Todd Greene   225000         Catcher  Los Angeles Angels
8591  1999      Jarrod Washburn   217500         Pitcher  Los Angeles Angels
8592  1999      Justin Baughman   215000       Shortstop  Los Angeles Angels
8593  1999           Troy Glaus   212500   Third Baseman  Los Angeles Angels
8594  1999          Alan Levine   208000         Pitcher  Los Angeles Angels
8595  1999       Mike Colangelo   200000      Outfielder  Los Angeles Angels
8596  1999      Trent Dumington   200000       Shortstop  Los Angeles Angels
8597  1999        Bengie Molina   200000         Catcher  Los Angeles Angels
8598  1999          Ramon Ortiz   200000         Pitcher  Los Angeles Angels
8599  1999             Lou Pote   200000         Pitcher  Los Angeles Angels
8600  1999         Jeff Bagwell  6500000   First Baseman      Houston Astros
8601  1999         Craig Biggio  6060000  Second Baseman      Houston Astros
8602  1999          Moises Alou  5000000      Outfielder      Houston Astros
8603  1999           Derek Bell  4500000      Outfielder      Houston Astros
8604  1999         Ken Caminiti  4500000   Third Baseman      Houston Astros
8605  1999       Shane Reynolds  4475000         Pitcher      Houston Astros
8606  1999         Mike Hampton  4125000         Pitcher      Houston Astros
8607  1999         Carl Everett  2500000      Outfielder      Houston Astros
8608  1999            Jose Lima  2250000         Pitcher      Houston Astros
8609  1999         Billy Wagner  2250000         Pitcher      Houston Astros
8610  1999      Ricky Gutierrez  2212500       Shortstop      Houston Astros
8611  1999          Stan Javier  1750000      Outfielder      Houston Astros
8612  1999          Bill Spiers  1600000   Third Baseman      Houston Astros
8613  1999         Tony Eusebio   900000         Catcher      Houston Astros
8614  1999           Jay Powell   800000         Pitcher      Houston Astros
8615  1999           Doug Henry   725000         Pitcher      Houston Astros
8616  1999            Tim Bogar   700000       Shortstop      Houston Astros
8617  1999          Jack Howell   550000   Third Baseman      Houston Astros
8618  1999          Matt Mieske   500000      Outfielder      Houston Astros
8619  1999       Brian Williams   375000         Pitcher      Houston Astros
8620  1999           Chris Holt   279000         Pitcher      Houston Astros
8621  1999            Alex Diaz   275000      Outfielder      Houston Astros
8622  1999        Ryan Thompson   275000      Outfielder      Houston Astros
8623  1999      Richard Hidalgo   260000      Outfielder      Houston Astros
8624  1999        Trever Miller   247500         Pitcher      Houston Astros
8625  1999            Paul Bako   230000         Catcher      Houston Astros
8626  1999        Scott Elarton   230000         Pitcher      Houston Astros
       ...                  ...      ...             ...                 ...

[919 rows x 5 columns]
2000
      Year               Player    Salary           Position  \
9486  2000            Mo Vaughn  11166667      First Baseman   
9487  2000           Tim Salmon   6000000         Outfielder   
9488  2000             Ken Hill   5600000            Pitcher   
9489  2000          Tim Belcher   4600000            Pitcher   
9490  2000     Kent Bottenfield   4000000            Pitcher   
9491  2000      Garret Anderson   3250000         Outfielder   
9492  2000       Gary DiSarcina   3225000          Shortstop   
9493  2000         Darin Erstad   2500000         Outfielder   
9494  2000        Troy Percival   2350000            Pitcher   
9495  2000       Mark Petkovsek   1512500            Pitcher   
9496  2000         Matt Walbeck    925000            Catcher   
9497  2000  Shigetoshi Hasegawa    900000            Pitcher   
9498  2000         Kent Mercker    850000            Pitcher   
9499  2000        Scott Spiezio    600000     Second Baseman   
9500  2000     Orlando Palmeiro    550000         Outfielder   
9501  2000        Jason Dickson    375000            Pitcher   
9502  2000           Troy Glaus    275000      Third Baseman   
9503  2000          Alan Levine    275000            Pitcher   
9504  2000            Benji Gil    225000          Shortstop   
9505  2000      Jarrod Washburn    225000            Pitcher   
9506  2000      Edgard Clemente    215000         Outfielder   
9507  2000          Mike Fyhrie    210000            Pitcher   
9508  2000        Bengie Molina    210000            Catcher   
9509  2000    Scott Schoeneweis    210000            Pitcher   
9510  2000          Ramon Ortiz    207500            Pitcher   
9511  2000             Lou Pote    207500            Pitcher   
9512  2000         Adam Kennedy    202500     Second Baseman   
9513  2000       Mike Colangelo    200000         Outfielder   
9514  2000          Tom Turnbow    200000            Pitcher   
9515  2000         Craig Biggio   6750000     Second Baseman   
9516  2000       Shane Reynolds   6666667            Pitcher   
9517  2000         Jeff Bagwell   6500000      First Baseman   
9518  2000            Jose Lima   6250000            Pitcher   
9519  2000          Moises Alou   5250000         Outfielder   
9520  2000         Ken Caminiti   4500000      Third Baseman   
9521  2000         Billy Wagner   3200000            Pitcher   
9522  2000         Roger Cedeno   2400000         Outfielder   
9523  2000          Bill Spiers   1700000     Second Baseman   
9524  2000           Jay Powell   1250000            Pitcher   
9525  2000           Chris Holt   1205000            Pitcher   
9526  2000         Tony Eusebio   1100000            Catcher   
9527  2000           Doug Henry    800000            Pitcher   
9528  2000            Tim Bogar    700000          Shortstop   
9529  2000          Matt Mieske    700000         Outfielder   
9530  2000        Dwight Gooden    500000            Pitcher   
9531  2000         Yorkis Perez    500000            Pitcher   
9532  2000          Mike Maddux    350000            Pitcher   
9533  2000        Scott Elarton    300000            Pitcher   
9534  2000         Russ Johnson    260000     Second Baseman   
9535  2000          Glen Barker    255000         Outfielder   
9536  2000         Jose Cabrera    252500            Pitcher   
9537  2000        Octavio Dotel    240000            Pitcher   
9538  2000          Daryle Ward    237500         Outfielder   
9539  2000       Mitch Meluskey    215000            Catcher   
9540  2000         Kevin Appier   5600000            Pitcher   
9541  2000        Omar Olivares   4000000            Pitcher   
9542  2000         Jason Giambi   3103333      First Baseman   
9543  2000          Matt Stairs   3050000         Outfielder   
9544  2000        Randy Velarde   3050000     Second Baseman   
9545  2000            John Jaha   2750000  Designated Hitter   
       ...                  ...       ...                ...   

                    Team  
9486  Los Angeles Angels  
9487  Los Angeles Angels  
9488  Los Angeles Angels  
9489  Los Angeles Angels  
9490  Los Angeles Angels  
9491  Los Angeles Angels  
9492  Los Angeles Angels  
9493  Los Angeles Angels  
9494  Los Angeles Angels  
9495  Los Angeles Angels  
9496  Los Angeles Angels  
9497  Los Angeles Angels  
9498  Los Angeles Angels  
9499  Los Angeles Angels  
9500  Los Angeles Angels  
9501  Los Angeles Angels  
9502  Los Angeles Angels  
9503  Los Angeles Angels  
9504  Los Angeles Angels  
9505  Los Angeles Angels  
9506  Los Angeles Angels  
9507  Los Angeles Angels  
9508  Los Angeles Angels  
9509  Los Angeles Angels  
9510  Los Angeles Angels  
9511  Los Angeles Angels  
9512  Los Angeles Angels  
9513  Los Angeles Angels  
9514  Los Angeles Angels  
9515      Houston Astros  
9516      Houston Astros  
9517      Houston Astros  
9518      Houston Astros  
9519      Houston Astros  
9520      Houston Astros  
9521      Houston Astros  
9522      Houston Astros  
9523      Houston Astros  
9524      Houston Astros  
9525      Houston Astros  
9526      Houston Astros  
9527      Houston Astros  
9528      Houston Astros  
9529      Houston Astros  
9530      Houston Astros  
9531      Houston Astros  
9532      Houston Astros  
9533      Houston Astros  
9534      Houston Astros  
9535      Houston Astros  
9536      Houston Astros  
9537      Houston Astros  
9538      Houston Astros  
9539      Houston Astros  
9540   Oakland Athletics  
9541   Oakland Athletics  
9542   Oakland Athletics  
9543   Oakland Athletics  
9544   Oakland Athletics  
9545   Oakland Athletics  
                     ...  

[843 rows x 5 columns]
2001
       Year               Player    Salary        Position                Team
10329  2001            Mo Vaughn  13166668   First Baseman  Los Angeles Angels
10330  2001           Tim Salmon   6500000      Outfielder  Los Angeles Angels
10331  2001      Garret Anderson   4500000      Outfielder  Los Angeles Angels
10332  2001         Darin Erstad   3450000      Outfielder  Los Angeles Angels
10333  2001        Troy Percival   3400000         Pitcher  Los Angeles Angels
10334  2001        Ismael Valdez   2500000         Pitcher  Los Angeles Angels
10335  2001             Pat Rapp   2000000         Pitcher  Los Angeles Angels
10336  2001  Shigetoshi Hasegawa   1500000         Pitcher  Los Angeles Angels
10337  2001       Glenallen Hill   1500000      Outfielder  Los Angeles Angels
10338  2001           Troy Glaus   1250000   Third Baseman  Los Angeles Angels
10339  2001        Scott Spiezio   1125000  Second Baseman  Los Angeles Angels
10340  2001     Orlando Palmeiro    900000      Outfielder  Los Angeles Angels
10341  2001          Alan Levine    715000         Pitcher  Los Angeles Angels
10342  2001           Mike Holtz    705000         Pitcher  Los Angeles Angels
10343  2001       Jorge Fabregas    500000         Catcher  Los Angeles Angels
10344  2001            Benji Gil    350000       Shortstop  Los Angeles Angels
10345  2001        Bengie Molina    350000         Catcher  Los Angeles Angels
10346  2001       Gary DiSarcina    320000       Shortstop  Los Angeles Angels
10347  2001         Adam Kennedy    280000  Second Baseman  Los Angeles Angels
10348  2001    Scott Schoeneweis    275000         Pitcher  Los Angeles Angels
10349  2001        Kimera Bartee    270000      Outfielder  Los Angeles Angels
10350  2001      Jarrod Washburn    270000         Pitcher  Los Angeles Angels
10351  2001          Ramon Ortiz    250000         Pitcher  Los Angeles Angels
10352  2001          Jose Nieves    232000       Shortstop  Los Angeles Angels
10353  2001             Lou Pote    215000         Pitcher  Los Angeles Angels
10354  2001            Matt Wise    207500         Pitcher  Los Angeles Angels
10355  2001            Ben Weber    203500         Pitcher  Los Angeles Angels
10356  2001         Shawn Wooten    200500         Catcher  Los Angeles Angels
10357  2001       David Eckstein    200000  Second Baseman  Los Angeles Angels
10358  2001         Rendy Espina    200000         Pitcher  Los Angeles Angels
10359  2001         Wally Joyner    200000   First Baseman  Los Angeles Angels
10360  2001         Craig Biggio   7750000  Second Baseman      Houston Astros
10361  2001       Shane Reynolds   7166667         Pitcher      Houston Astros
10362  2001         Jeff Bagwell   6500000   First Baseman      Houston Astros
10363  2001            Jose Lima   6250000         Pitcher      Houston Astros
10364  2001          Moises Alou   5250000      Outfielder      Houston Astros
10365  2001         Billy Wagner   5000000         Pitcher      Houston Astros
10366  2001          Brad Ausmus   4250000         Catcher      Houston Astros
10367  2001      Richard Hidalgo   3500000      Outfielder      Houston Astros
10368  2001         Doug Brocail   2300000         Pitcher      Houston Astros
10369  2001     Kent Bottenfield   2000000         Pitcher      Houston Astros
10370  2001          Bill Spiers   1700000  Second Baseman      Houston Astros
10371  2001           Jay Powell   1600000         Pitcher      Houston Astros
10372  2001        Jose Vizcaino   1500000       Shortstop      Houston Astros
10373  2001         Tony Eusebio   1300000         Catcher      Houston Astros
10374  2001         Mike Jackson    750000         Pitcher      Houston Astros
10375  2001        Charlie Hayes    500000   First Baseman      Houston Astros
10376  2001        Scott Elarton    400000         Pitcher      Houston Astros
10377  2001        Lance Berkman    305000      Outfielder      Houston Astros
10378  2001        Octavio Dotel    305000         Pitcher      Houston Astros
10379  2001          Daryle Ward    287500      Outfielder      Houston Astros
10380  2001         Jose Cabrera    285000         Pitcher      Houston Astros
10381  2001          Nelson Cruz    285000         Pitcher      Houston Astros
10382  2001          Glen Barker    270000      Outfielder      Houston Astros
10383  2001           Julio Lugo    245000       Shortstop      Houston Astros
10384  2001          Wade Miller    241000         Pitcher      Houston Astros
10385  2001          Chris Truby    237500   Third Baseman      Houston Astros
10386  2001       Wayne Franklin    210000         Pitcher      Houston Astros
10387  2001         Johnny Damon   7100000      Outfielder   Oakland Athletics
10388  2001         Jason Giambi   4103333   First Baseman   Oakland Athletics
        ...                  ...       ...             ...                 ...

[857 rows x 5 columns]
2002
       Year             Player    Salary           Position  \
11186  2002         Tim Salmon   9650000         Outfielder   
11187  2002       Kevin Appier   9500000            Pitcher   
11188  2002         Aaron Sele   7166667            Pitcher   
11189  2002       Darin Erstad   6250000         Outfielder   
11190  2002      Troy Percival   5250000            Pitcher   
11191  2002    Garret Anderson   5000000         Outfielder   
11192  2002       Brad Fullmer   4000000  Designated Hitter   
11193  2002         Troy Glaus   4000000      Third Baseman   
11194  2002      Scott Spiezio   2275000      First Baseman   
11195  2002        Alan Levine   1325000            Pitcher   
11196  2002        Dennis Cook   1250000            Pitcher   
11197  2002   Orlando Palmeiro   1000000         Outfielder   
11198  2002        Ramon Ortiz    575000            Pitcher   
11199  2002     Jorge Fabregas    500000            Catcher   
11200  2002          Benji Gil    400000            Catcher   
11201  2002       Adam Kennedy    375000     Second Baseman   
11202  2002      Bengie Molina    350000            Catcher   
11203  2002    Jarrod Washburn    350000            Pitcher   
11204  2002  Scott Schoeneweis    325000            Pitcher   
11205  2002         Donne Wall    300000            Pitcher   
11206  2002     David Eckstein    280000          Shortstop   
11207  2002           Lou Pote    255000            Pitcher   
11208  2002       Shawn Wooten    250000            Catcher   
11209  2002        Jose Nieves    240000          Shortstop   
11210  2002          Ben Weber    240000            Pitcher   
11211  2002       Jeff DaVanon    207500         Outfielder   
11212  2002   Mark Lukasiewicz    207500            Pitcher   
11213  2002        Steve Green    200000            Pitcher   
11214  2002       Jeff Bagwell  11000000      First Baseman   
11215  2002       Craig Biggio   8750000     Second Baseman   
11216  2002       Billy Wagner   8000000            Pitcher   
11217  2002     Shane Reynolds   7666667            Pitcher   
11218  2002        Dave Mlicki   6200000            Pitcher   
11219  2002    Richard Hidalgo   5500000         Outfielder   
11220  2002        Brad Ausmus   5000000            Catcher   
11221  2002      Jose Vizcaino   1700000          Shortstop   
11222  2002         Gregg Zaun   1150000            Catcher   
11223  2002     Orlando Merced   1050000         Outfielder   
11224  2002    Brian L. Hunter   1000000         Outfielder   
11225  2002       T.J. Mathews   1000000            Pitcher   
11226  2002       Doug Brocail    750000            Pitcher   
11227  2002      Lance Berkman    500000         Outfielder   
11228  2002  Hipolito Pichardo    500000            Pitcher   
11229  2002      Octavio Dotel    435000            Pitcher   
11230  2002        Nelson Cruz    375000            Pitcher   
11231  2002        Daryle Ward    375000         Outfielder   
11232  2002       Adam Everett    366750          Shortstop   
11233  2002        Wade Miller    350000            Pitcher   
11234  2002         Julio Lugo    325000          Shortstop   
11235  2002         Geoff Blum    315000      Third Baseman   
11236  2002         Roy Oswalt    300000            Pitcher   
11237  2002    Scott Linebrink    230000            Pitcher   
11238  2002   Carlos Hernandez    210000            Pitcher   
11239  2002     Morgan Ensberg    200000      Third Baseman   
11240  2002        Ricky Stone    200000            Pitcher   
11241  2002       Jermaine Dye   7166667         Outfielder   
11242  2002      David Justice   7000000         Outfielder   
11243  2002      Miguel Tejada   3625000          Shortstop   
11244  2002         Cory Lidle   2550000            Pitcher   
11245  2002         Billy Koch   2433333            Pitcher   
        ...                ...       ...                ...   

                     Team  
11186  Los Angeles Angels  
11187  Los Angeles Angels  
11188  Los Angeles Angels  
11189  Los Angeles Angels  
11190  Los Angeles Angels  
11191  Los Angeles Angels  
11192  Los Angeles Angels  
11193  Los Angeles Angels  
11194  Los Angeles Angels  
11195  Los Angeles Angels  
11196  Los Angeles Angels  
11197  Los Angeles Angels  
11198  Los Angeles Angels  
11199  Los Angeles Angels  
11200  Los Angeles Angels  
11201  Los Angeles Angels  
11202  Los Angeles Angels  
11203  Los Angeles Angels  
11204  Los Angeles Angels  
11205  Los Angeles Angels  
11206  Los Angeles Angels  
11207  Los Angeles Angels  
11208  Los Angeles Angels  
11209  Los Angeles Angels  
11210  Los Angeles Angels  
11211  Los Angeles Angels  
11212  Los Angeles Angels  
11213  Los Angeles Angels  
11214      Houston Astros  
11215      Houston Astros  
11216      Houston Astros  
11217      Houston Astros  
11218      Houston Astros  
11219      Houston Astros  
11220      Houston Astros  
11221      Houston Astros  
11222      Houston Astros  
11223      Houston Astros  
11224      Houston Astros  
11225      Houston Astros  
11226      Houston Astros  
11227      Houston Astros  
11228      Houston Astros  
11229      Houston Astros  
11230      Houston Astros  
11231      Houston Astros  
11232      Houston Astros  
11233      Houston Astros  
11234      Houston Astros  
11235      Houston Astros  
11236      Houston Astros  
11237      Houston Astros  
11238      Houston Astros  
11239      Houston Astros  
11240      Houston Astros  
11241   Oakland Athletics  
11242   Oakland Athletics  
11243   Oakland Athletics  
11244   Oakland Athletics  
11245   Oakland Athletics  
                      ...  

[849 rows x 5 columns]
2003
       Year               Player    Salary        Position                Team
12035  2003         Kevin Appier  11500000         Pitcher  Los Angeles Angels
12036  2003           Tim Salmon   9900000      Outfielder  Los Angeles Angels
12037  2003           Aaron Sele   8166667         Pitcher  Los Angeles Angels
12038  2003        Troy Percival   7833333         Pitcher  Los Angeles Angels
12039  2003         Darin Erstad   7250000      Outfielder  Los Angeles Angels
12040  2003           Troy Glaus   7250000   Third Baseman  Los Angeles Angels
12041  2003      Garret Anderson   5350000      Outfielder  Los Angeles Angels
12042  2003        Scott Spiezio   4250000   First Baseman  Los Angeles Angels
12043  2003      Jarrod Washburn   3875000         Pitcher  Los Angeles Angels
12044  2003         Adam Kennedy   2270000  Second Baseman  Los Angeles Angels
12045  2003          Ramon Ortiz   2266667         Pitcher  Los Angeles Angels
12046  2003        Bengie Molina   1425000         Catcher  Los Angeles Angels
12047  2003    Scott Schoeneweis   1425000         Pitcher  Los Angeles Angels
12048  2003         Brad Fullmer   1000000   First Baseman  Los Angeles Angels
12049  2003           Eric Owens    925000      Outfielder  Los Angeles Angels
12050  2003            Benji Gil    725000       Shortstop  Los Angeles Angels
12051  2003       David Eckstein    425000       Shortstop  Los Angeles Angels
12052  2003            Ben Weber    375000         Pitcher  Los Angeles Angels
12053  2003         Shawn Wooten    337500         Catcher  Los Angeles Angels
12054  2003     Brendan Donnelly    325000         Pitcher  Los Angeles Angels
12055  2003          Jose Molina    320000         Catcher  Los Angeles Angels
12056  2003          John Lackey    315000         Pitcher  Los Angeles Angels
12057  2003  Francisco Rodriguez    312500         Pitcher  Los Angeles Angels
12058  2003         Scot Shields    305000         Pitcher  Los Angeles Angels
12059  2003      Mickey Callaway    302500         Pitcher  Los Angeles Angels
12060  2003            Matt Wise    302500         Pitcher  Los Angeles Angels
12061  2003        Julio Ramirez    300000      Outfielder  Los Angeles Angels
12062  2003         Jeff Bagwell  13000000   First Baseman      Houston Astros
12063  2003         Craig Biggio   9750000      Outfielder      Houston Astros
12064  2003      Richard Hidalgo   8500000      Outfielder      Houston Astros
12065  2003         Billy Wagner   8000000         Pitcher      Houston Astros
12066  2003            Jeff Kent   7500000  Second Baseman      Houston Astros
12067  2003          Brad Ausmus   5500000         Catcher      Houston Astros
12068  2003        Lance Berkman   3500000      Outfielder      Houston Astros
12069  2003        Jose Vizcaino   2000000       Shortstop      Houston Astros
12070  2003       Orlando Merced   1700000      Outfielder      Houston Astros
12071  2003        Octavio Dotel   1600000         Pitcher      Houston Astros
12072  2003           Julio Lugo   1575000       Shortstop      Houston Astros
12073  2003           Geoff Blum   1500000       Shortstop      Houston Astros
12074  2003      Brian L. Hunter   1200000      Outfielder      Houston Astros
12075  2003           Gregg Zaun   1200000         Catcher      Houston Astros
12076  2003           Bruce Chen    550000         Pitcher      Houston Astros
12077  2003          Wade Miller    525000         Pitcher      Houston Astros
12078  2003        Brian Moehler    500000         Pitcher      Houston Astros
12079  2003           Roy Oswalt    500000         Pitcher      Houston Astros
12080  2003          Ricky Stone    325000         Pitcher      Houston Astros
12081  2003     Carlos Hernandez    310000         Pitcher      Houston Astros
12082  2003           Pete Munro    305000         Pitcher      Houston Astros
12083  2003          Raul Chavez    300000         Catcher      Houston Astros
12084  2003       Morgan Ensberg    300000   Third Baseman      Houston Astros
12085  2003           Brad Lidge    300000         Pitcher      Houston Astros
12086  2003          Tim Redding    300000         Pitcher      Houston Astros
12087  2003    Jeriome Robertson    300000         Pitcher      Houston Astros
12088  2003         Jermaine Dye  11666667      Outfielder   Oakland Athletics
12089  2003         Keith Foulke   6000000         Pitcher   Oakland Athletics
12090  2003        Miguel Tejada   5125000       Shortstop   Oakland Athletics
12091  2003          Eric Chavez   3675000   Third Baseman   Oakland Athletics
12092  2003            Jim Mecir   3216667         Pitcher   Oakland Athletics
12093  2003           Tim Hudson   2700000         Pitcher   Oakland Athletics
12094  2003          Mark Mulder   2650000         Pitcher   Oakland Athletics
        ...                  ...       ...             ...                 ...

[826 rows x 5 columns]
2004
       Year               Player    Salary           Position  \
12861  2004        Bartolo Colon  11000000            Pitcher   
12862  2004    Vladimir Guerrero  11000000         Outfielder   
12863  2004           Troy Glaus   9900000      Third Baseman   
12864  2004           Tim Salmon   9900000  Designated Hitter   
12865  2004           Aaron Sele   8666667            Pitcher   
12866  2004        Troy Percival   7833333            Pitcher   
12867  2004         Darin Erstad   7750000      First Baseman   
12868  2004      Garret Anderson   6200000         Outfielder   
12869  2004       Kelvim Escobar   5750000            Pitcher   
12870  2004      Jarrod Washburn   5450000            Pitcher   
12871  2004          Ramon Ortiz   3266667            Pitcher   
12872  2004         Adam Kennedy   2500000     Second Baseman   
12873  2004         Jose Guillen   2200000         Outfielder   
12874  2004       David Eckstein   2150000          Shortstop   
12875  2004        Bengie Molina   2025000            Catcher   
12876  2004            Ben Weber    900000            Pitcher   
12877  2004         Shane Halter    575000          Shortstop   
12878  2004         Jeff DaVanon    375000         Outfielder   
12879  2004     Brendan Donnelly    375000            Pitcher   
12880  2004          John Lackey    375000            Pitcher   
12881  2004  Francisco Rodriguez    375000            Pitcher   
12882  2004         Scot Shields    375000            Pitcher   
12883  2004          Jose Molina    335000            Catcher   
12884  2004            Josh Paul    335000            Catcher   
12885  2004        Chone Figgins    320000          Shortstop   
12886  2004          Kevin Gregg    301500            Pitcher   
12887  2004           Greg Jones    301500            Pitcher   
12888  2004         Jeff Bagwell  16000000      First Baseman   
12889  2004      Richard Hidalgo  12500000         Outfielder   
12890  2004            Jeff Kent  10000000     Second Baseman   
12891  2004        Lance Berkman   6500000         Outfielder   
12892  2004        Andy Pettitte   5500000            Pitcher   
12893  2004        Roger Clemens   5000000            Pitcher   
12894  2004          Wade Miller   3400000            Pitcher   
12895  2004           Roy Oswalt   3250000            Pitcher   
12896  2004         Craig Biggio   3000000         Outfielder   
12897  2004        Octavio Dotel   2800000            Pitcher   
12898  2004        Jose Vizcaino   1200000          Shortstop   
12899  2004          Brad Ausmus   1000000            Catcher   
12900  2004     Orlando Palmeiro    750000         Outfielder   
12901  2004           Dan Miceli    600000            Pitcher   
12902  2004          Tim Redding    395000            Pitcher   
12903  2004          Ricky Stone    395000            Pitcher   
12904  2004    Brandon Duckworth    390000            Pitcher   
12905  2004       Morgan Ensberg    380000      Third Baseman   
12906  2004         Adam Everett    370000          Shortstop   
12907  2004           Brad Lidge    360000            Pitcher   
12908  2004            Mike Lamb    352000      Third Baseman   
12909  2004      Jared Fernandez    325000            Pitcher   
12910  2004          Raul Chavez    315000            Catcher   
12911  2004       Eric Bruntlett    307500          Shortstop   
12912  2004           Jason Lane    307500         Outfielder   
12913  2004         Jermaine Dye  11666667         Outfielder   
12914  2004          Mark Kotsay   5500000         Outfielder   
12915  2004          Eric Chavez   5325000      Third Baseman   
12916  2004           Tim Hudson   5000000            Pitcher   
12917  2004          Mark Mulder   4450000            Pitcher   
12918  2004            Jim Mecir   3300000            Pitcher   
12919  2004        Damian Miller   3000000            Catcher   
12920  2004           Barry Zito   3000000            Pitcher   
        ...                  ...       ...                ...   

                     Team  
12861  Los Angeles Angels  
12862  Los Angeles Angels  
12863  Los Angeles Angels  
12864  Los Angeles Angels  
12865  Los Angeles Angels  
12866  Los Angeles Angels  
12867  Los Angeles Angels  
12868  Los Angeles Angels  
12869  Los Angeles Angels  
12870  Los Angeles Angels  
12871  Los Angeles Angels  
12872  Los Angeles Angels  
12873  Los Angeles Angels  
12874  Los Angeles Angels  
12875  Los Angeles Angels  
12876  Los Angeles Angels  
12877  Los Angeles Angels  
12878  Los Angeles Angels  
12879  Los Angeles Angels  
12880  Los Angeles Angels  
12881  Los Angeles Angels  
12882  Los Angeles Angels  
12883  Los Angeles Angels  
12884  Los Angeles Angels  
12885  Los Angeles Angels  
12886  Los Angeles Angels  
12887  Los Angeles Angels  
12888      Houston Astros  
12889      Houston Astros  
12890      Houston Astros  
12891      Houston Astros  
12892      Houston Astros  
12893      Houston Astros  
12894      Houston Astros  
12895      Houston Astros  
12896      Houston Astros  
12897      Houston Astros  
12898      Houston Astros  
12899      Houston Astros  
12900      Houston Astros  
12901      Houston Astros  
12902      Houston Astros  
12903      Houston Astros  
12904      Houston Astros  
12905      Houston Astros  
12906      Houston Astros  
12907      Houston Astros  
12908      Houston Astros  
12909      Houston Astros  
12910      Houston Astros  
12911      Houston Astros  
12912      Houston Astros  
12913   Oakland Athletics  
12914   Oakland Athletics  
12915   Oakland Athletics  
12916   Oakland Athletics  
12917   Oakland Athletics  
12918   Oakland Athletics  
12919   Oakland Athletics  
12920   Oakland Athletics  
                      ...  

[833 rows x 5 columns]
2005
       Year               Player    Salary           Position  \
13694  2005    Vladimir Guerrero  12500000         Outfielder   
13695  2005        Bartolo Colon  10000000            Pitcher   
13696  2005      Garret Anderson   9600000         Outfielder   
13697  2005         Darin Erstad   8250000      First Baseman   
13698  2005      Jarrod Washburn   6500000            Pitcher   
13699  2005       Kelvim Escobar   6250000            Pitcher   
13700  2005      Orlando Cabrera   6000000          Shortstop   
13701  2005         Steve Finley   6000000         Outfielder   
13702  2005            Paul Byrd   5000000            Pitcher   
13703  2005         Matt Hensley   3175000            Pitcher   
13704  2005         Adam Kennedy   3000000     Second Baseman   
13705  2005        Bengie Molina   3000000            Catcher   
13706  2005          Esteban Yan   1000000            Pitcher   
13707  2005         Jeff DaVanon    925000         Outfielder   
13708  2005         Scot Shields    925000            Pitcher   
13709  2005          Jose Molina    725000            Catcher   
13710  2005          Lou Merloni    500000     Second Baseman   
13711  2005            Josh Paul    450000            Catcher   
13712  2005          John Lackey    440000            Pitcher   
13713  2005  Francisco Rodriguez    440000            Pitcher   
13714  2005     Brendan Donnelly    420000            Pitcher   
13715  2005        Chone Figgins    390000     Second Baseman   
13716  2005          Juan Rivera    390000         Outfielder   
13717  2005          Kevin Gregg    360000            Pitcher   
13718  2005         Robb Quinlan    360000      Third Baseman   
13719  2005           Bret Prinz    342322            Pitcher   
13720  2005       Maicer Izturis    317000          Shortstop   
13721  2005           Jake Woods    316000            Pitcher   
13722  2005         Jeff Bagwell  18000000      First Baseman   
13723  2005        Roger Clemens  18000000            Pitcher   
13724  2005        Lance Berkman  10500000         Outfielder   
13725  2005        Andy Pettitte   8500000            Pitcher   
13726  2005           Roy Oswalt   5900000            Pitcher   
13727  2005          Brad Ausmus   3000000            Catcher   
13728  2005         Craig Biggio   3000000         Outfielder   
13729  2005            Mike Lamb   1300000      Third Baseman   
13730  2005        Jose Vizcaino   1250000          Shortstop   
13731  2005     Orlando Palmeiro    800000         Outfielder   
13732  2005          John Franco    700000            Pitcher   
13733  2005        Russ Springer    550000            Pitcher   
13734  2005    Brandon Duckworth    500000            Pitcher   
13735  2005           Brad Lidge    500000            Pitcher   
13736  2005       Morgan Ensberg    450000      Third Baseman   
13737  2005         Adam Everett    445000          Shortstop   
13738  2005        Chad Harville    365000            Pitcher   
13739  2005          Dan Wheeler    365000            Pitcher   
13740  2005          Raul Chavez    360000            Catcher   
13741  2005        Brandon Backe    350000            Pitcher   
13742  2005           Jason Lane    345000         Outfielder   
13743  2005       Eric Bruntlett    335000          Shortstop   
13744  2005          Chris Burke    316000     Second Baseman   
13745  2005          Chad Qualls    316000            Pitcher   
13746  2005           Luke Scott    316000         Outfielder   
13747  2005        Willy Taveras    316000         Outfielder   
13748  2005        Jason Kendall  10571429            Catcher   
13749  2005          Eric Chavez   8500000      Third Baseman   
13750  2005          Mark Kotsay   6500000         Outfielder   
13751  2005           Barry Zito   5600000            Pitcher   
13752  2005        Octavio Dotel   4750000            Pitcher   
13753  2005       Erubiel Durazo   4700000  Designated Hitter   
        ...                  ...       ...                ...   

                     Team  
13694  Los Angeles Angels  
13695  Los Angeles Angels  
13696  Los Angeles Angels  
13697  Los Angeles Angels  
13698  Los Angeles Angels  
13699  Los Angeles Angels  
13700  Los Angeles Angels  
13701  Los Angeles Angels  
13702  Los Angeles Angels  
13703  Los Angeles Angels  
13704  Los Angeles Angels  
13705  Los Angeles Angels  
13706  Los Angeles Angels  
13707  Los Angeles Angels  
13708  Los Angeles Angels  
13709  Los Angeles Angels  
13710  Los Angeles Angels  
13711  Los Angeles Angels  
13712  Los Angeles Angels  
13713  Los Angeles Angels  
13714  Los Angeles Angels  
13715  Los Angeles Angels  
13716  Los Angeles Angels  
13717  Los Angeles Angels  
13718  Los Angeles Angels  
13719  Los Angeles Angels  
13720  Los Angeles Angels  
13721  Los Angeles Angels  
13722      Houston Astros  
13723      Houston Astros  
13724      Houston Astros  
13725      Houston Astros  
13726      Houston Astros  
13727      Houston Astros  
13728      Houston Astros  
13729      Houston Astros  
13730      Houston Astros  
13731      Houston Astros  
13732      Houston Astros  
13733      Houston Astros  
13734      Houston Astros  
13735      Houston Astros  
13736      Houston Astros  
13737      Houston Astros  
13738      Houston Astros  
13739      Houston Astros  
13740      Houston Astros  
13741      Houston Astros  
13742      Houston Astros  
13743      Houston Astros  
13744      Houston Astros  
13745      Houston Astros  
13746      Houston Astros  
13747      Houston Astros  
13748   Oakland Athletics  
13749   Oakland Athletics  
13750   Oakland Athletics  
13751   Oakland Athletics  
13752   Oakland Athletics  
13753   Oakland Athletics  
                      ...  

[831 rows x 5 columns]
2006
       Year               Player    Salary        Position                Team
14525  2006        Bartolo Colon  14000000         Pitcher  Los Angeles Angels
14526  2006    Vladimir Guerrero  13500000      Outfielder  Los Angeles Angels
14527  2006      Garret Anderson  10600000      Outfielder  Los Angeles Angels
14528  2006         Darin Erstad   8750000   First Baseman  Los Angeles Angels
14529  2006          Jeff Weaver   8325000         Pitcher  Los Angeles Angels
14530  2006      Edgardo Alfonzo   8000000   Third Baseman  Los Angeles Angels
14531  2006      Orlando Cabrera   7500000       Shortstop  Los Angeles Angels
14532  2006       Kelvim Escobar   6750000         Pitcher  Los Angeles Angels
14533  2006  Francisco Rodriguez   3775000         Pitcher  Los Angeles Angels
14534  2006         Adam Kennedy   3350000  Second Baseman  Los Angeles Angels
14535  2006          John Lackey   3340000         Pitcher  Los Angeles Angels
14536  2006      Hector Carrasco   2600000         Pitcher  Los Angeles Angels
14537  2006        Chone Figgins   2250000   Third Baseman  Los Angeles Angels
14538  2006          J.C. Romero   2200000         Pitcher  Los Angeles Angels
14539  2006         Scot Shields   2100000         Pitcher  Los Angeles Angels
14540  2006          Juan Rivera   1250000      Outfielder  Los Angeles Angels
14541  2006          Esteban Yan   1250000         Pitcher  Los Angeles Angels
14542  2006     Brendan Donnelly    950000         Pitcher  Los Angeles Angels
14543  2006          Jose Molina    850000         Catcher  Los Angeles Angels
14544  2006           Tim Salmon    400000      Outfielder  Los Angeles Angels
14545  2006         Robb Quinlan    365000   Third Baseman  Los Angeles Angels
14546  2006       Maicer Izturis    350000       Shortstop  Los Angeles Angels
14547  2006        Ervin Santana    350000         Pitcher  Los Angeles Angels
14548  2006       Casey Kotchman    340000   First Baseman  Los Angeles Angels
14549  2006          Jeff Mathis    327000         Catcher  Los Angeles Angels
14550  2006         Jeff Bagwell  19369019   First Baseman      Houston Astros
14551  2006        Andy Pettitte  16428416         Pitcher      Houston Astros
14552  2006        Lance Berkman  14500000   First Baseman      Houston Astros
14553  2006           Roy Oswalt  11000000         Pitcher      Houston Astros
14554  2006         Craig Biggio   4000000  Second Baseman      Houston Astros
14555  2006       Preston Wilson   4000000      Outfielder      Houston Astros
14556  2006           Brad Lidge   3975000         Pitcher      Houston Astros
14557  2006          Brad Ausmus   3857068         Catcher      Houston Astros
14558  2006       Morgan Ensberg   3800000   Third Baseman      Houston Astros
14559  2006         Adam Everett   1900000       Shortstop      Houston Astros
14560  2006            Mike Lamb   1700000   First Baseman      Houston Astros
14561  2006        Trever Miller   1300000         Pitcher      Houston Astros
14562  2006     Orlando Palmeiro    950000      Outfielder      Houston Astros
14563  2006          Dan Wheeler    930000         Pitcher      Houston Astros
14564  2006        Russ Springer    750000         Pitcher      Houston Astros
14565  2006           Jason Lane    450000      Outfielder      Houston Astros
14566  2006        Brandon Backe    442500         Pitcher      Houston Astros
14567  2006        Willy Taveras    400000      Outfielder      Houston Astros
14568  2006          Chad Qualls    376000         Pitcher      Houston Astros
14569  2006       Eric Bruntlett    365000       Shortstop      Houston Astros
14570  2006           Mike Gallo    365000         Pitcher      Houston Astros
14571  2006          Chris Burke    362500  Second Baseman      Houston Astros
14572  2006          Eric Munson    350000   Third Baseman      Houston Astros
14573  2006      Taylor Buchholz    327000         Pitcher      Houston Astros
14574  2006       Fernando Nieve    327000         Pitcher      Houston Astros
14575  2006      Wandy Rodriguez    327000         Pitcher      Houston Astros
14576  2006        Jason Kendall  11492454         Catcher   Oakland Athletics
14577  2006          Eric Chavez   9500000   Third Baseman   Oakland Athletics
14578  2006           Barry Zito   7900000         Pitcher   Oakland Athletics
14579  2006          Mark Kotsay   7000000      Outfielder   Oakland Athletics
14580  2006       Esteban Loaiza   6000000         Pitcher   Oakland Athletics
14581  2006           Jay Payton   4000000      Outfielder   Oakland Athletics
14582  2006       Milton Bradley   3000000      Outfielder   Oakland Athletics
14583  2006          Joe Kennedy   2400000         Pitcher   Oakland Athletics
14584  2006           Mark Ellis   2250000       Shortstop   Oakland Athletics
        ...                  ...       ...             ...                 ...

[823 rows x 5 columns]
2007
       Year               Player    Salary           Position  \
15348  2007        Bartolo Colon  16000000            Pitcher   
15349  2007    Vladimir Guerrero  14500000         Outfielder   
15350  2007      Garret Anderson  11600000         Outfielder   
15351  2007       Kelvim Escobar   9000000            Pitcher   
15352  2007      Orlando Cabrera   8500000          Shortstop   
15353  2007  Francisco Rodriguez   7000000            Pitcher   
15354  2007        Gary Matthews   6400000         Outfielder   
15355  2007     Shea Hillenbrand   6000000      First Baseman   
15356  2007          John Lackey   5833333            Pitcher   
15357  2007        Justin Speier   3750000            Pitcher   
15358  2007        Chone Figgins   3500000      Third Baseman   
15359  2007         Scot Shields   3400000            Pitcher   
15360  2007      Hector Carrasco   3000000            Pitcher   
15361  2007          Juan Rivera   2025000         Outfielder   
15362  2007        Darren Oliver   1500000            Pitcher   
15363  2007          Jose Molina   1350000            Catcher   
15364  2007         Robb Quinlan    800000      First Baseman   
15365  2007       Maicer Izturis    440000          Shortstop   
15366  2007        Ervin Santana    425000            Pitcher   
15367  2007       Howie Kendrick    395000     Second Baseman   
15368  2007          Mike Napoli    395000            Catcher   
15369  2007         Jered Weaver    385000            Pitcher   
15370  2007          Erick Aybar    382500      Third Baseman   
15371  2007       Casey Kotchman    382500      First Baseman   
15372  2007     Dallas McPherson    382500      First Baseman   
15373  2007         Tommy Murphy    382500         Outfielder   
15374  2007       Reggie Willits    382500         Outfielder   
15375  2007       Dustin Moseley    380500            Pitcher   
15376  2007      Chris Bootcheck    380000            Pitcher   
15377  2007         Joe Saunders    380000            Pitcher   
15378  2007        Lance Berkman  14500000      First Baseman   
15379  2007           Roy Oswalt  13000000            Pitcher   
15380  2007           Carlos Lee  11500000         Outfielder   
15381  2007       Woody Williams   6000000            Pitcher   
15382  2007       Jason Jennings   5500000            Pitcher   
15383  2007           Brad Lidge   5350000            Pitcher   
15384  2007         Craig Biggio   5150000     Second Baseman   
15385  2007       Morgan Ensberg   4350000      Third Baseman   
15386  2007          Brad Ausmus   4000000            Catcher   
15387  2007         Adam Everett   2800000          Shortstop   
15388  2007            Mike Lamb   2700000      First Baseman   
15389  2007         Mark Loretta   2500000     Second Baseman   
15390  2007          Dan Wheeler   2100000            Pitcher   
15391  2007        Trever Miller   1300000            Pitcher   
15392  2007           Jason Lane   1050000         Outfielder   
15393  2007     Orlando Palmeiro    950000         Outfielder   
15394  2007           Rick White    600000            Pitcher   
15395  2007       Dave Borkowski    575000            Pitcher   
15396  2007        Brandon Backe    545000            Pitcher   
15397  2007        Brian Moehler    500000            Pitcher   
15398  2007          Chad Qualls    441000            Pitcher   
15399  2007          Chris Burke    415000     Second Baseman   
15400  2007      Wandy Rodriguez    406000            Pitcher   
15401  2007    Humberto Quintero    385000            Catcher   
15402  2007           Luke Scott    382000         Outfielder   
15403  2007       Hector Gimenez    380000            Catcher   
15404  2007        Chris Sampson    380000            Pitcher   
15405  2007        Jason Kendall  12858194            Catcher   
15406  2007          Eric Chavez   9500000      Third Baseman   
15407  2007          Mike Piazza   8500000  Designated Hitter   
        ...                  ...       ...                ...   

                     Team  
15348  Los Angeles Angels  
15349  Los Angeles Angels  
15350  Los Angeles Angels  
15351  Los Angeles Angels  
15352  Los Angeles Angels  
15353  Los Angeles Angels  
15354  Los Angeles Angels  
15355  Los Angeles Angels  
15356  Los Angeles Angels  
15357  Los Angeles Angels  
15358  Los Angeles Angels  
15359  Los Angeles Angels  
15360  Los Angeles Angels  
15361  Los Angeles Angels  
15362  Los Angeles Angels  
15363  Los Angeles Angels  
15364  Los Angeles Angels  
15365  Los Angeles Angels  
15366  Los Angeles Angels  
15367  Los Angeles Angels  
15368  Los Angeles Angels  
15369  Los Angeles Angels  
15370  Los Angeles Angels  
15371  Los Angeles Angels  
15372  Los Angeles Angels  
15373  Los Angeles Angels  
15374  Los Angeles Angels  
15375  Los Angeles Angels  
15376  Los Angeles Angels  
15377  Los Angeles Angels  
15378      Houston Astros  
15379      Houston Astros  
15380      Houston Astros  
15381      Houston Astros  
15382      Houston Astros  
15383      Houston Astros  
15384      Houston Astros  
15385      Houston Astros  
15386      Houston Astros  
15387      Houston Astros  
15388      Houston Astros  
15389      Houston Astros  
15390      Houston Astros  
15391      Houston Astros  
15392      Houston Astros  
15393      Houston Astros  
15394      Houston Astros  
15395      Houston Astros  
15396      Houston Astros  
15397      Houston Astros  
15398      Houston Astros  
15399      Houston Astros  
15400      Houston Astros  
15401      Houston Astros  
15402      Houston Astros  
15403      Houston Astros  
15404      Houston Astros  
15405   Oakland Athletics  
15406   Oakland Athletics  
15407   Oakland Athletics  
                      ...  

[848 rows x 5 columns]
2008
       Year               Player    Salary        Position                Team
16196  2008         Torii Hunter  16500000      Outfielder  Los Angeles Angels
16197  2008    Vladimir Guerrero  15500000      Outfielder  Los Angeles Angels
16198  2008      Garret Anderson  12600000      Outfielder  Los Angeles Angels
16199  2008          Jon Garland  12000000         Pitcher  Los Angeles Angels
16200  2008  Francisco Rodriguez  10000000         Pitcher  Los Angeles Angels
16201  2008       Kelvim Escobar   9500000         Pitcher  Los Angeles Angels
16202  2008        Gary Matthews   9400000      Outfielder  Los Angeles Angels
16203  2008          John Lackey   7333333         Pitcher  Los Angeles Angels
16204  2008        Chone Figgins   4750000   Third Baseman  Los Angeles Angels
16205  2008         Scot Shields   4250000         Pitcher  Los Angeles Angels
16206  2008        Justin Speier   4250000         Pitcher  Los Angeles Angels
16207  2008          Juan Rivera   2025000      Outfielder  Los Angeles Angels
16208  2008        Darren Oliver   2000000         Pitcher  Los Angeles Angels
16209  2008       Casey Kotchman   1450000   First Baseman  Los Angeles Angels
16210  2008       Maicer Izturis   1200000       Shortstop  Los Angeles Angels
16211  2008         Robb Quinlan   1050000   First Baseman  Los Angeles Angels
16212  2008         Jered Weaver    435000         Pitcher  Los Angeles Angels
16213  2008       Howie Kendrick    432500  Second Baseman  Los Angeles Angels
16214  2008       Reggie Willits    432500      Outfielder  Los Angeles Angels
16215  2008          Mike Napoli    425000         Catcher  Los Angeles Angels
16216  2008         Joe Saunders    425000         Pitcher  Los Angeles Angels
16217  2008       Dustin Moseley    420000         Pitcher  Los Angeles Angels
16218  2008        Ervin Santana    420000         Pitcher  Los Angeles Angels
16219  2008          Erick Aybar    415000       Shortstop  Los Angeles Angels
16220  2008      Chris Bootcheck    415000         Pitcher  Los Angeles Angels
16221  2008          Jeff Mathis    415000         Catcher  Los Angeles Angels
16222  2008         Jason Bulger    392000         Pitcher  Los Angeles Angels
16223  2008     Rich G. Thompson    391000         Pitcher  Los Angeles Angels
16224  2008         Darren O'Day    390000         Pitcher  Los Angeles Angels
16225  2008        Miguel Tejada  14811414       Shortstop      Houston Astros
16226  2008        Lance Berkman  14500000   First Baseman      Houston Astros
16227  2008           Roy Oswalt  13000000         Pitcher      Houston Astros
16228  2008           Carlos Lee  12500000      Outfielder      Houston Astros
16229  2008         Kazuo Matsui   5500000  Second Baseman      Houston Astros
16230  2008        Jose Valverde   4700000         Pitcher      Houston Astros
16231  2008         Ty Wigginton   4350000   Third Baseman      Houston Astros
16232  2008         Mark Loretta   2750000  Second Baseman      Houston Astros
16233  2008         Doug Brocail   2500000         Pitcher      Houston Astros
16234  2008          Brad Ausmus   2000000         Catcher      Houston Astros
16235  2008         Shawn Chacon   2000000         Pitcher      Houston Astros
16236  2008          Geoff Geary   1125000         Pitcher      Houston Astros
16237  2008     Oscar Villarreal   1125000         Pitcher      Houston Astros
16238  2008           Geoff Blum   1100000  Second Baseman      Houston Astros
16239  2008         Darin Erstad   1000000   First Baseman      Houston Astros
16240  2008        Brandon Backe    800000         Pitcher      Houston Astros
16241  2008       Dave Borkowski    800000         Pitcher      Houston Astros
16242  2008        Jose Cruz Jr.    650000      Outfielder      Houston Astros
16243  2008        Brian Moehler    500000         Pitcher      Houston Astros
16244  2008      Wandy Rodriguez    451000         Pitcher      Houston Astros
16245  2008    Humberto Quintero    405000         Catcher      Houston Astros
16246  2008        Chris Sampson    401000         Pitcher      Houston Astros
16247  2008        Michael Bourn    396000      Outfielder      Houston Astros
16248  2008         Hunter Pence    396000      Outfielder      Houston Astros
16249  2008       Felipe Paulino    390000         Pitcher      Houston Astros
16250  2008          J.R. Towles    390000         Catcher      Houston Astros
16251  2008        Wesley Wright    390000         Pitcher      Houston Astros
16252  2008          Eric Chavez  11500000   Third Baseman   Oakland Athletics
16253  2008           Mark Ellis   5000000  Second Baseman   Oakland Athletics
16254  2008          Rich Harden   4750000         Pitcher   Oakland Athletics
16255  2008          Joe Blanton   3700000         Pitcher   Oakland Athletics
        ...                  ...       ...             ...                 ...

[858 rows x 5 columns]
2009
       Year             Player    Salary        Position                Team
17054  2009       Torii Hunter  18000000      Outfielder  Los Angeles Angels
17055  2009  Vladimir Guerrero  15000000      Outfielder  Los Angeles Angels
17056  2009      Gary Matthews  10400000      Outfielder  Los Angeles Angels
17057  2009     Kelvim Escobar  10000000         Pitcher  Los Angeles Angels
17058  2009        John Lackey  10000000         Pitcher  Los Angeles Angels
17059  2009      Brian Fuentes   8500000         Pitcher  Los Angeles Angels
17060  2009      Chone Figgins   5775000   Third Baseman  Los Angeles Angels
17061  2009        Bobby Abreu   5000000      Outfielder  Los Angeles Angels
17062  2009       Scot Shields   5000000         Pitcher  Los Angeles Angels
17063  2009      Justin Speier   4750000         Pitcher  Los Angeles Angels
17064  2009      Ervin Santana   3800000         Pitcher  Los Angeles Angels
17065  2009      Darren Oliver   3665000         Pitcher  Los Angeles Angels
17066  2009        Juan Rivera   3250000      Outfielder  Los Angeles Angels
17067  2009        Mike Napoli   2000000         Catcher  Los Angeles Angels
17068  2009     Maicer Izturis   1600000       Shortstop  Los Angeles Angels
17069  2009    Kendrys Morales   1100000   First Baseman  Los Angeles Angels
17070  2009       Robb Quinlan   1100000   First Baseman  Los Angeles Angels
17071  2009       Joe Saunders    475000         Pitcher  Los Angeles Angels
17072  2009     Howie Kendrick    465000  Second Baseman  Los Angeles Angels
17073  2009       Jered Weaver    465000         Pitcher  Los Angeles Angels
17074  2009        Erick Aybar    460000       Shortstop  Los Angeles Angels
17075  2009        Jeff Mathis    450000         Catcher  Los Angeles Angels
17076  2009     Dustin Moseley    435000         Pitcher  Los Angeles Angels
17077  2009     Jose Arredondo    410000         Pitcher  Los Angeles Angels
17078  2009         Shane Loux    405000         Pitcher  Los Angeles Angels
17079  2009       Jason Bulger    403000         Pitcher  Los Angeles Angels
17080  2009       Kevin Jepsen    401000         Pitcher  Los Angeles Angels
17081  2009      Nick Adenhart    400000         Pitcher  Los Angeles Angels
17082  2009         Carlos Lee  19000000      Outfielder      Houston Astros
17083  2009      Miguel Tejada  14811414       Shortstop      Houston Astros
17084  2009      Lance Berkman  14500000   First Baseman      Houston Astros
17085  2009         Roy Oswalt  14000000         Pitcher      Houston Astros
17086  2009      Jose Valverde   8000000         Pitcher      Houston Astros
17087  2009       Kazuo Matsui   5500000  Second Baseman      Houston Astros
17088  2009     LaTroy Hawkins   3500000         Pitcher      Houston Astros
17089  2009    Wandy Rodriguez   2600000         Pitcher      Houston Astros
17090  2009       Doug Brocail   2500000         Pitcher      Houston Astros
17091  2009      Brian Moehler   2300000         Pitcher      Houston Astros
17092  2009       Mike Hampton   2000000         Pitcher      Houston Astros
17093  2009       Darin Erstad   1750000      Outfielder      Houston Astros
17094  2009        Geoff Geary   1700000         Pitcher      Houston Astros
17095  2009      Brandon Backe   1550000         Pitcher      Houston Astros
17096  2009     Ivan Rodriguez   1500000         Catcher      Houston Astros
17097  2009         Geoff Blum   1250000  Second Baseman      Houston Astros
17098  2009         Tim Byrdak   1000000         Pitcher      Houston Astros
17099  2009        Aaron Boone    750000   First Baseman      Houston Astros
17100  2009     Jason Michaels    750000      Outfielder      Houston Astros
17101  2009         Russ Ortiz    750000         Pitcher      Houston Astros
17102  2009  Humberto Quintero    610000         Catcher      Houston Astros
17103  2009        Jason Smith    500000       Infielder      Houston Astros
17104  2009      Chris Sampson    449000         Pitcher      Houston Astros
17105  2009       Hunter Pence    439000      Outfielder      Houston Astros
17106  2009      Michael Bourn    434500      Outfielder      Houston Astros
17107  2009     Jeff Keppinger    427500       Shortstop      Houston Astros
17108  2009      Wesley Wright    425000         Pitcher      Houston Astros
17109  2009      Matt Holliday  13500000      Outfielder   Oakland Athletics
17110  2009        Eric Chavez  11500000   Third Baseman   Oakland Athletics
17111  2009       Bobby Crosby   5300000       Shortstop   Oakland Athletics
17112  2009         Mark Ellis   5000000  Second Baseman   Oakland Athletics
17113  2009    Orlando Cabrera   4000000       Shortstop   Oakland Athletics
        ...                ...       ...             ...                 ...

[818 rows x 5 columns]
2010
       Year             Player    Salary        Position                Team
17872  2010       Torii Hunter  18500000      Outfielder  Los Angeles Angels
17873  2010        Bobby Abreu   9000000      Outfielder  Los Angeles Angels
17874  2010      Brian Fuentes   9000000         Pitcher  Los Angeles Angels
17875  2010       Scott Kazmir   8000000         Pitcher  Los Angeles Angels
17876  2010       Joel Pineiro   8000000         Pitcher  Los Angeles Angels
17877  2010      Hideki Matsui   6000000      Outfielder  Los Angeles Angels
17878  2010      Ervin Santana   6000000         Pitcher  Los Angeles Angels
17879  2010    Fernando Rodney   5500000         Pitcher  Los Angeles Angels
17880  2010       Scot Shields   5350000         Pitcher  Los Angeles Angels
17881  2010       Jered Weaver   4265000         Pitcher  Los Angeles Angels
17882  2010        Juan Rivera   4250000      Outfielder  Los Angeles Angels
17883  2010       Joe Saunders   3700000         Pitcher  Los Angeles Angels
17884  2010        Mike Napoli   3600000         Catcher  Los Angeles Angels
17885  2010     Maicer Izturis   2766666       Shortstop  Los Angeles Angels
17886  2010        Erick Aybar   2050000       Shortstop  Los Angeles Angels
17887  2010     Howie Kendrick   1750000  Second Baseman  Los Angeles Angels
17888  2010        Jeff Mathis   1300000         Catcher  Los Angeles Angels
17889  2010    Kendrys Morales   1200000   First Baseman  Los Angeles Angels
17890  2010     Reggie Willits    625000      Outfielder  Los Angeles Angels
17891  2010       Brian Stokes    435000         Pitcher  Los Angeles Angels
17892  2010         Jon Palmer    420000         Pitcher  Los Angeles Angels
17893  2010       Jason Bulger    418000         Pitcher  Los Angeles Angels
17894  2010       Kevin Jepsen    415000         Pitcher  Los Angeles Angels
17895  2010       Brandan Wood    410000       Shortstop  Los Angeles Angels
17896  2010        Terry Evans    405000      Outfielder  Los Angeles Angels
17897  2010         Ryan Budde    402200         Catcher  Los Angeles Angels
17898  2010      Robert Wilson    402000         Catcher  Los Angeles Angels
17899  2010     Anthony Ortega    400000         Pitcher  Los Angeles Angels
17900  2010       Chris Pettit    400000      Outfielder  Los Angeles Angels
17901  2010         Carlos Lee  19000000      Outfielder      Houston Astros
17902  2010         Roy Oswalt  15000000         Pitcher      Houston Astros
17903  2010      Lance Berkman  14500000   First Baseman      Houston Astros
17904  2010       Kazuo Matsui   5500000  Second Baseman      Houston Astros
17905  2010    Wandy Rodriguez   5000000         Pitcher      Houston Astros
17906  2010        Pedro Feliz   4500000   Third Baseman      Houston Astros
17907  2010       Brandon Lyon   4250000         Pitcher      Houston Astros
17908  2010       Hunter Pence   3500000      Outfielder      Houston Astros
17909  2010        Brett Myers   3100000         Pitcher      Houston Astros
17910  2010      Brian Moehler   3000000         Pitcher      Houston Astros
17911  2010      Michael Bourn   2400000      Outfielder      Houston Astros
17912  2010     Matt Lindstrom   1625000         Pitcher      Houston Astros
17913  2010         Tim Byrdak   1600000         Pitcher      Houston Astros
17914  2010         Geoff Blum   1500000  Second Baseman      Houston Astros
17915  2010     Jeff Keppinger   1150000       Shortstop      Houston Astros
17916  2010      Chris Sampson    815000         Pitcher      Houston Astros
17917  2010     Jason Michaels    800000      Outfielder      Houston Astros
17918  2010  Humberto Quintero    750000         Catcher      Houston Astros
17919  2010      Cory Sullivan    700000      Outfielder      Houston Astros
17920  2010      Jeff Fulchino    425000         Pitcher      Houston Astros
17921  2010      Alberto Arias    415500         Pitcher      Houston Astros
17922  2010     Felipe Paulino    415000         Pitcher      Houston Astros
17923  2010        J.R. Towles    406500         Catcher      Houston Astros
17924  2010       Sam Gervacio    402500         Pitcher      Houston Astros
17925  2010         Bud Norris    401000         Pitcher      Houston Astros
17926  2010     Yorman Bazardo    400000         Pitcher      Houston Astros
17927  2010   Chris D. Johnson    400000   Third Baseman      Houston Astros
17928  2010     Tommy Manzella    400000       Shortstop      Houston Astros
17929  2010        Eric Chavez  12500000   Third Baseman   Oakland Athletics
17930  2010         Ben Sheets  10000000         Pitcher   Oakland Athletics
17931  2010         Mark Ellis   5500000  Second Baseman   Oakland Athletics
        ...                ...       ...             ...                 ...

[828 rows x 5 columns]
2011
       Year              Player    Salary        Position                Team
18700  2011        Vernon Wells  26187500      Outfielder  Los Angeles Angels
18701  2011        Torii Hunter  18500000      Outfielder  Los Angeles Angels
18702  2011           Dan Haren  12750000         Pitcher  Los Angeles Angels
18703  2011        Scott Kazmir  12000000         Pitcher  Los Angeles Angels
18704  2011         Bobby Abreu   9000000      Outfielder  Los Angeles Angels
18705  2011        Joel Pineiro   8000000         Pitcher  Los Angeles Angels
18706  2011       Ervin Santana   8000000         Pitcher  Los Angeles Angels
18707  2011        Jered Weaver   7365000         Pitcher  Los Angeles Angels
18708  2011     Fernando Rodney   5500000         Pitcher  Los Angeles Angels
18709  2011         Scott Downs   5000000         Pitcher  Los Angeles Angels
18710  2011  Hisanori Takahashi   3800000         Pitcher  Los Angeles Angels
18711  2011      Howie Kendrick   3300000  Second Baseman  Los Angeles Angels
18712  2011      Maicer Izturis   3266666  Second Baseman  Los Angeles Angels
18713  2011         Erick Aybar   3000000       Shortstop  Los Angeles Angels
18714  2011     Kendrys Morales   2975000   First Baseman  Los Angeles Angels
18715  2011    Alberto Callaspo   2000000   First Baseman  Los Angeles Angels
18716  2011         Jeff Mathis   1700000         Catcher  Los Angeles Angels
18717  2011      Reggie Willits    775000      Outfielder  Los Angeles Angels
18718  2011        Kevin Jepsen    435000         Pitcher  Los Angeles Angels
18719  2011        Jason Bulger    423000         Pitcher  Los Angeles Angels
18720  2011        Brandon Wood    420000   Third Baseman  Los Angeles Angels
18721  2011       Rich Thompson    418000         Pitcher  Los Angeles Angels
18722  2011        Bobby Wilson    416000         Catcher  Los Angeles Angels
18723  2011       Peter Bourjos    414000      Outfielder  Los Angeles Angels
18724  2011      Bobby Cassevah    414000         Pitcher  Los Angeles Angels
18725  2011         Hank Conger    414000         Catcher  Los Angeles Angels
18726  2011        Michael Kohn    414000         Pitcher  Los Angeles Angels
18727  2011        Chris Pettit    414000      Outfielder  Los Angeles Angels
18728  2011     Freddy Sandoval    414000   Third Baseman  Los Angeles Angels
18729  2011         Mark Trumbo    414000   First Baseman  Los Angeles Angels
18730  2011       Jordan Walden    414000         Pitcher  Los Angeles Angels
18731  2011          Carlos Lee  19000000      Outfielder      Houston Astros
18732  2011         Brett Myers   8000000         Pitcher      Houston Astros
18733  2011     Wandy Rodriguez   7500000         Pitcher      Houston Astros
18734  2011        Hunter Pence   6900000      Outfielder      Houston Astros
18735  2011        Brandon Lyon   5250000         Pitcher      Houston Astros
18736  2011       Michael Bourn   4400000      Outfielder      Houston Astros
18737  2011        Clint Barmes   3925000  Second Baseman      Houston Astros
18738  2011           Bill Hall   3000000      Outfielder      Houston Astros
18739  2011      Jeff Keppinger   2300000  Second Baseman      Houston Astros
18740  2011   Humberto Quintero   1000000         Catcher      Houston Astros
18741  2011     Nelson Figueroa    900000         Pitcher      Houston Astros
18742  2011      Jason Michaels    900000      Outfielder      Houston Astros
18743  2011  Ryan Rowland-Smith    725000         Pitcher      Houston Astros
18744  2011           J.A. Happ    474000         Pitcher      Houston Astros
18745  2011       Jeff Fulchino    467000         Pitcher      Houston Astros
18746  2011        Wilton Lopez    442000         Pitcher      Houston Astros
18747  2011       Alberto Arias    439500         Pitcher      Houston Astros
18748  2011          Bud Norris    437500         Pitcher      Houston Astros
18749  2011       Angel Sanchez    432500       Shortstop      Houston Astros
18750  2011    Chris D. Johnson    424000   Third Baseman      Houston Astros
18751  2011         J.R. Towles    424000         Catcher      Houston Astros
18752  2011     Jason Bourgeois    423000      Outfielder      Houston Astros
18753  2011        Jason Castro    421500         Catcher      Houston Astros
18754  2011          Matt Downs    421000  Second Baseman      Houston Astros
18755  2011       Mark Melancon    421000         Pitcher      Houston Astros
18756  2011       Fernando Abad    418000         Pitcher      Houston Astros
18757  2011       Brett Wallace    418000   First Baseman      Houston Astros
18758  2011  Enerio Del Rosario    417000         Pitcher      Houston Astros
18759  2011    Aneury Rodriguez    414000         Pitcher      Houston Astros
        ...                 ...       ...             ...                 ...

[843 rows x 5 columns]

3.13 Extract highest-paid player from each group (i.e. year)

In [20]:
# generator comprehension for retrieving highest paid player by year
t = (group.sort_index(by='Salary', ascending=False)[:1] for yr,group in grouped)
In [26]:
t
Out[26]:
<generator object <genexpr> at 0x000000000B4AB1F8>

3.14 Create new dataframe with list of highest-paid players by year

In [27]:
#create empty dataframe for populating
topsalaries = pd.DataFrame()
 
In [28]:
for line in t:
    topsalaries = topsalaries.append(line)
In [29]:
topsalaries
Out[29]:
Player Position Salary Team Year
321 Gary Carter Catcher 2360714 New York Mets 1988
908 Orel Hershiser Pitcher 2766666 Los Angeles Dodgers 1989
1580 Robin Yount Outfielder 3200000 Milwaukee Brewers 1990
2590 Darryl Strawberry Outfielder 3800000 Los Angeles Dodgers 1991
3441 Bobby Bonilla Outfielder 6100000 New York Mets 1992
4214 Bobby Bonilla Outfielder 6200000 New York Mets 1993
4977 Bobby Bonilla Third Baseman 6300000 New York Mets 1994
6068 Cecil Fielder First Baseman 9237500 Detroit Tigers 1995
6840 Cecil Fielder First Baseman 9237500 Detroit Tigers 1996
7666 Albert Belle Outfielder 10000000 Chicago White Sox 1997
8090 Gary Sheffield Outfielder 10000000 Florida Marlins 1998
9067 Albert Belle Outfielder 11949794 Baltimore Orioles 1999
9743 Kevin J. Brown Pitcher 15714286 Los Angeles Dodgers 2000
10903 Alex Rodriguez Shortstop 22000000 Texas Rangers 2001
11752 Alex Rodriguez Shortstop 22000000 Texas Rangers 2002
12589 Alex Rodriguez Shortstop 22000000 Texas Rangers 2003
13497 Manny Ramirez Outfielder 22500000 Boston Red Sox 2004
14499 Alex Rodriguez Third Baseman 26000000 New York Yankees 2005
15320 Alex Rodriguez Third Baseman 21680727 New York Yankees 2006
16167 Jason Giambi Designated Hitter 23428571 New York Yankees 2007
17023 Alex Rodriguez Third Baseman 28000000 New York Yankees 2008
17846 Alex Rodriguez Third Baseman 33000000 New York Yankees 2009
18675 Alex Rodriguez Third Baseman 33000000 New York Yankees 2010
19513 Alex Rodriguez Third Baseman 32000000 New York Yankees 2011
24 rows × 5 columns

3.15 Create series of topsalaries and perform plots

In [30]:
ts = topsalaries[['Year','Salary']]
In [31]:
ts = ts.set_index('Year')
In [33]:
%pylab inline
Populating the interactive namespace from numpy and matplotlib

In [34]:
ts.plot()
Out[34]:
<matplotlib.axes.AxesSubplot at 0xd039048>
In [35]:
grouped['Salary'].median().plot()
Out[35]:
<matplotlib.axes.AxesSubplot at 0xd046be0>


Посты чуть ниже также могут вас заинтересовать

Комментариев нет:

Отправить комментарий