Question: 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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Mr. Chai has been trading for some years as a wine merchant. The following list of balances has been extracted from his ledger as at 30 April 20X7, the end of his most recent financial year. Ghc...

Q:

Lab 4.3 - Python Code (Optional) Critical Review In Python, you use the while statement to write a condition-controlled loop. The loop has two parts: (1) a condition that is tested for a true or...

Q:

Comment these two posts say why you are agree and ask some question to make the conversation flow Post 1 POST 1 Explain when to use these different types of loops. To explain, a loop is a repetitive...

Q:

Question 1 In Python, what do while loops do ? 1 point while loops tell the computer to repeatedly execute a set of instructions while a condition is true. while loops instruct the computer to...

Q:

Language: Python Software: Processing Question 3 (9 points): Purpose: Practice using loops and simple information visualization Degree of Difficulty: Moderate For this question, you will create a...

Q:

Hello, have posted this question multiple times, hopeuflly can be done this time. Need python code for question 2, please write your own unique code and not copy/paste from my other question I have...

Q:

Python Pandas Series/Dataframe Question (No loops, No If statement, No List Comprehension) Use the pandas read_csv function to read in the teams and win/loss information. Be sure to label both the...

Q:

USING PYTHON PROGRAMMING AND WHILE LOOPS, DO NOT USE BREAK,PASS AND CONTINUE, FOR LOOPS. Write a program that asks the user to enter a nu mber, and then checks different properties of the number...

Q:

Hello, I need help with this code please. The language is PYTHON. Wk 2 - Using Loops in Python (due Mon] Assignment Content You recently graduated college and you are applying for a programming job...

Q:

PYTHON Coding Help! (While Loops With Input Validation) I Need Help Coding This Program. Instructions Are Below. Include Code In The Answer! A) Keep Both The Outer And Inner While Loops To Provide...

Q:

USING PYTHON PROGRAMMING AND WHILE LOOPS. PLEASE DO NOT USE BREAK , RETURN, PASS, CONTINUE, FOR LOOPS Write a program that, within main() , asks the user for 1. The number of words they want to enter...

Q:

A pure ALOHA network transmits 400-bit frames on a shared channel of 200 kbps. What is the throughput if the system (all stations together) 7produces 500 frames per second 48 @ 38 28 18

Q:

Figure displays two circuits with a charged capacitor that is to be discharged through a resistor when a switch is closed. In Figure a, R 1 = 20.0? and C 1 = 5.00?F. In Figure b, R 2 = 10.0? and C 2...

Q:

Exercise 6-48 Weighted Average Method, Unit Costs, Valuing Inventories Byford Inc. produces a product that passes through two processes. During November, equivalent units were calculated using the...

Q:

Suppose the real risk-free rate is 3.50% and the future rate of inflation is expected to be constant at 2.20%. What rate of return would you expect on a 1-year Treasury security, assuming the pure...

Q:

A Think about the unique language of your job or of the discipline in which you are majoring. Have you picked up any jargon that might seem confusing to someone outside the field?

Q:

1. A friend asks what youd like to do tonight. A. Oh, whatever you want. B. I heard about a party on Garden Street. C. Id like to rent Juno and make Indian food.

Q:

C What kinds of jargon have you been exposed to via television, film, and novels? Do you find some medical jargon familiar having watched many seasons of House or Greys Anatomy? Do you feel at ease...