In Python using Pandas: Using the data frame below, make a print statement for these top 10 finishers, then report on the "player", "TEAM", "LEAGUE" and batting average "AVG". Add a rank column ordered 1 - 10, and sort output in descending order by "AVG". Please provide inputs/outputs as proof of functionality player YEAR TEAM LEAGUE HR RBI CS BB AVG PA 105922 anderti 1987 CHA AL 18 56 5 15 0.335 518 106722 marteke 1987 ARI NL 32 92 2 53 0.329 628 107415 yelicch 1987 MIL NL 44 97 2 80 0.329 580 106656 lemahdj 1987 NYA AL 26 102 2 46 0.327 655 107006 rendoan 1987 WAS NL 34 126 1 80 0.319 646 106766 mcneije 1987 NYN NL 23 75 6 35 0.318 567 105932 arenano 1987 COL NL 41 118 2 62 0.315 662 106804 moncayo 1987 CHA AL 25 79 3 40 0.315 559 106013 blackch 1987 COL NL 32 86 5 40 0.314 634 107015 reynobr 1987 PIT NL 16 68 2 46 0.314 546
In Python using Pandas: Using the data frame below, make a print statement for these top 10 finishers, then report on the "player", "TEAM", "LEAGUE" and batting average "AVG". Add a rank column ordered 1 - 10, and sort output in descending order by "AVG". Please provide inputs/outputs as proof of functionality player YEAR TEAM LEAGUE HR RBI CS BB AVG PA 105922 anderti 1987 CHA AL 18 56 5 15 0.335 518 106722 marteke 1987 ARI NL 32 92 2 53 0.329 628 107415 yelicch 1987 MIL NL 44 97 2 80 0.329 580 106656 lemahdj 1987 NYA AL 26 102 2 46 0.327 655 107006 rendoan 1987 WAS NL 34 126 1 80 0.319 646 106766 mcneije 1987 NYN NL 23 75 6 35 0.318 567 105932 arenano 1987 COL NL 41 118 2 62 0.315 662 106804 moncayo 1987 CHA AL 25 79 3 40 0.315 559 106013 blackch 1987 COL NL 32 86 5 40 0.314 634 107015 reynobr 1987 PIT NL 16 68 2 46 0.314 546
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
In Python using Pandas:
Using the data frame below, make a print statement for these top 10 finishers, then report on the "player", "TEAM", "LEAGUE" and batting average "AVG". Add a rank column ordered 1 - 10, and sort output in descending order by "AVG".
Please provide inputs/outputs as proof of functionality
player | YEAR | TEAM | LEAGUE | HR | RBI | CS | BB | AVG | PA | |
105922 | anderti | 1987 | CHA | AL | 18 | 56 | 5 | 15 | 0.335 | 518 |
106722 | marteke | 1987 | ARI | NL | 32 | 92 | 2 | 53 | 0.329 | 628 |
107415 | yelicch | 1987 | MIL | NL | 44 | 97 | 2 | 80 | 0.329 | 580 |
106656 | lemahdj | 1987 | NYA | AL | 26 | 102 | 2 | 46 | 0.327 | 655 |
107006 | rendoan | 1987 | WAS | NL | 34 | 126 | 1 | 80 | 0.319 | 646 |
106766 | mcneije | 1987 | NYN | NL | 23 | 75 | 6 | 35 | 0.318 | 567 |
105932 | arenano | 1987 | COL | NL | 41 | 118 | 2 | 62 | 0.315 | 662 |
106804 | moncayo | 1987 | CHA | AL | 25 | 79 | 3 | 40 | 0.315 | 559 |
106013 | blackch | 1987 | COL | NL | 32 | 86 | 5 | 40 | 0.314 | 634 |
107015 | reynobr | 1987 | PIT | NL | 16 | 68 | 2 | 46 | 0.314 | 546 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education