Python's Pandas/Series Question (Loops and Ifs Statements are NOT ALLOWED here).

The file baseball.csv (pasted below) contains a list of baseball players, their team, number of at bats, and hits. In baseball, a player's batting average is calculated by the formula:

hits/at bats

Write a function named highest_avg that determines the highest batting average and returns the record of the player (or players) that have that average. Note that, by tradition, batting averages are calculated to only 3 decimal places (i.e. .327). Here is a sample call:

In [1]: highest_avg('baseball.csv') Out[1]: name team at bats hits avg 32 Buster Posey Giants 530 178 0.336.

The file baseball.csv is pasted below:

A. J. Pierzynski	White Sox	479	133
Aaron Hill	Diamondbacks	609	184
Adam Dunn	White Sox	539	110
Adam Jones	Orioles	648	186
Adam LaRoche	Nationals	571	155
Adrian Beltre	Rangers	604	194
Adrian Gonzalez	Dodgers	629	188
AJ Ellis	Dodgers	423	114
Albert Pujols	Angels	607	173
Alberto Callaspo	Angels	457	115
Alcides Escobar	Royals	605	177
Alejandro De Aza	White Sox	524	147
Alex Gordon	Royals	642	189
Alex Rios	White Sox	605	184
Alex Rodriguez	Yankees	463	126
Alexei Ramirez	White Sox	593	157
Alfonso Soriano	Cubs	561	147
Allen Craig	Cardinals	469	144
Andre Ethier	Dodgers	556	158
Andrew McCutchen	Pirates	593	194
Angel Pagan	Giants	605	174
Aramis Ramirez	Brewers	570	171
Asdrubal Cabrera	Indians	555	150
Austin Jackson	Tigers	543	163
B. J. Upton	Rays	573	141
Ben Revere	Twins	511	150
Ben Zobrist	Rays	560	151
Billy Butler	Royals	614	192
Brandon Phillips	Reds	580	163
Brennan Boesch	Tigers	470	113
Brett Lawrie	Blue Jays	494	135
Bryce Harper	Nationals	533	144
Buster Posey	Giants	530	178
Cameron Maybin	Padres	507	123
Carlos Beltran	Cardinals	547	147
Carlos Gonzalez	Rockies	518	157
Carlos Lee	Marlins	550	145
Carlos Pena	Rays	497	98
Carlos Santana	Indians	507	128
Chase Headley	Padres	604	173
Chris Davis	Orioles	515	139
Chris Johnson	Diamondbacks	488	137
Coco Crisp	Athletics	455	118
Cody Ross	Red Sox	476	127
Colby Rasmus	Blue Jays	565	126
Corey Hart	Brewers	562	152
Curtis Granderson	Yankees	596	138
Dan Uggla	Braves	523	115
Daniel Murphy	Mets	571	166
Danny Espinosa	Nationals	594	147
Darwin Barney	Cubs	548	139
David DeJesus	Cubs	506	133
David Freese	Cardinals	501	147
David Murphy	Rangers	457	139
David Wright	Mets	581	178
Dayan Viciedo	White Sox	505	129
Delmon Young	Tigers	574	153
Denard Span	Twins	516	146
Derek Jeter	Yankees	683	216
Desmond Jennings	Rays	505	124
Dexter Fowler	Rockies	454	136
Drew Stubbs	Reds	493	105
Dustin Ackley	Mariners	607	137
Dustin Pedroia	Red Sox	563	163
Edwin Encarnacion	Blue Jays	542	152
Elvis Andrus	Rangers	629	180
Eric Hosmer	Royals	535	124
Erick Aybar	Angels	517	150
Freddie Freeman	Braves	540	140
Garrett Jones	Pirates	475	130
Gordon Beckham	White Sox	525	123
Hanley Ramirez	Dodgers	604	155
Howard Kendrick	Angels	550	158
Hunter Pence	Giants	617	156
Ian Desmond	Nationals	513	150
Ian Kinsler	Rangers	655	168
Ichiro Suzuki	Yankees	629	178
Ike Davis	Mets	519	118
J. J. Hardy	Orioles	663	158
Jamey Carroll	Twins	470	126
Jason Heyward	Braves	587	158
Jason Kipnis	Indians	591	152
Jason Kubel	Diamondbacks	506	128
Jay Bruce	Reds	560	141
Jeff Francoeur	Royals	561	132
Jemile Weeks	Athletics	444	98
Jesus Montero	Mariners	515	134
Jhonny Peralta	Tigers	531	127
Jimmy Rollins	Phillies	632	158
Joe Mauer	Twins	545	174
Jon Jay	Cardinals	443	135
Jordan Pacheco	Rockies	475	147
Jose Altuve	Astros	576	167
Jose Reyes	Marlins	642	184
Josh Hamilton	Rangers	562	160
Josh Reddick	Athletics	611	148
Josh Willingham	Twins	519	135
Justin Morneau	Twins	505	135
Justin Smoak	Mariners	483	105
Justin Upton	Diamondbacks	554	155
Kelly Johnson	Blue Jays	507	114
Kendrys Morales	Angels	484	132
Kevin Youkilis	White Sox	438	103
Kyle Seager	Mariners	594	154
Marco Scutaro	Giants	620	190
Mark Reynolds	Orioles	457	101
Mark Teixeira	Yankees	451	113
Mark Trumbo	Angels	544	146
Martin Prado	Braves	617	186
Matt Holliday	Cardinals	599	177
Matt Wieters	Orioles	526	131
Michael Bourn	Braves	624	171
Michael Brantley	Indians	552	159
Michael Saunders	Mariners	507	125
Michael Young	Rangers	611	169
Miguel Cabrera	Tigers	622	205
Miguel Montero	Diamondbacks	486	139
Mike Aviles	Red Sox	512	128
Mike Moustakas	Royals	563	136
Mike Trout	Angels	559	182
Neil Walker	Pirates	472	132
Nelson Cruz	Rangers	585	152
Nick Swisher	Yankees	537	146
Norichika Aoki	Brewers	520	150
Omar Infante	Tigers	554	152
Paul Goldschmidt	Diamondbacks	514	147
Paul Konerko	White Sox	533	159
Pedro Alvarez	Pirates	525	128
Prince Fielder	Tigers	581	182
Rafael Furcal	Cardinals	477	126
Rickie Weeks	Brewers	588	135
Robinson Cano	Yankees	627	196
Ryan Braun	Brewers	598	191
Ryan Doumit	Twins	484	133
Ryan Zimmerman	Nationals	578	163
Shane Victorino	Dodgers	595	152
Shin-Soo Choo	Indians	598	169
Starlin Castro	Cubs	646	183
Torii Hunter	Angels	534	167
Yadier Molina	Cardinals	505	159
Yoenis Cespedes	Athletics	487	142
Yonder Alonso	Padres	549	150
Yunel Escobar	Blue Jays	558	141
Zack Cozart	Reds	561	138

Point of Stress: This is a Python question requiring the use of Pandas Series or DataFrame (please loops are not allowed - zero score for using loops). Please attach a print screen in addition to the codes to show the scripts ran properly and as intended.