Solve the following problem using python and jupyter notebook, plus matplotlib. You have two datasets regarding information on each cup soccer team in the World Cups: Year 2002:Position,Team,Games Played,Win,Draw,Loss,Goals For,Goals Against,Goal Difference,Points.1,Brazil,7,7,0,0,18,4,14,212,Germany,7,5,1,1,14,3,11,163,Turkey,7,4,1,2,10,6,4,134,South Korea,7,3,3,2,2,2,8,6,2,115,Spain,5,3,2,0,10,5,5,116,England,5,2,2,1,6,3,3,87,Senegal,5,2,2,1,7,6,1,88,United States,5,2,1,2,7,7,0,79,Japan,4,2,1,1,5,3,2,710,Denmark,4,2,1,1,5,5,0,7 Year 2022: Position,Team,Games Played,Win,Draw,Loss,Goals For,Goals Against,Goal Difference,Points.1,Argentina,7,6,0,1,15,8,7,182,France,7,5,0,2,16,8,8,153,Croatia,7,4,2,1,8,7,1,144,Morocco,7,4,1,2,6,5,1,135,England,5,3,1,1,13,4,9,106,Netherlands,5,3,1,1,10,4,6,107,Portugal,5,3,0,2,12,6,6,98,Brazil,5,3,0,2,8,3,5,99,Japan,4,2,0,2,5,4,1,610,Senegal,4,2,0,2,5,7,-2,6 You are requested to perform: A) Remove rows with null data from both datasetsB) Apply a filter using a function that shows only the teams with 3 losses, for the 2022 World Cup.C) Create a bar chart showing the 20 highest scoring teams for the 2002 and 2022 World Cups.D) Export and save both datasets (without nulls)
Solve the following problem using python and jupyter notebook, plus matplotlib.
You have two datasets regarding information on each cup soccer team in the World Cups:
Year 2002:
Position,Team,Games Played,Win,Draw,Loss,Goals For,Goals Against,Goal Difference,Points.
1,Brazil,7,7,0,0,18,4,14,21
2,Germany,7,5,1,1,14,3,11,16
3,Turkey,7,4,1,2,10,6,4,13
4,South Korea,7,3,3,2,2,2,8,6,2,11
5,Spain,5,3,2,0,10,5,5,11
6,England,5,2,2,1,6,3,3,8
7,Senegal,5,2,2,1,7,6,1,8
8,United States,5,2,1,2,7,7,0,7
9,Japan,4,2,1,1,5,3,2,7
10,Denmark,4,2,1,1,5,5,0,7
Year 2022:
Position,Team,Games Played,Win,Draw,Loss,Goals For,Goals Against,Goal Difference,Points.
1,Argentina,7,6,0,1,15,8,7,18
2,France,7,5,0,2,16,8,8,15
3,Croatia,7,4,2,1,8,7,1,14
4,Morocco,7,4,1,2,6,5,1,13
5,England,5,3,1,1,13,4,9,10
6,Netherlands,5,3,1,1,10,4,6,10
7,Portugal,5,3,0,2,12,6,6,9
8,Brazil,5,3,0,2,8,3,5,9
9,Japan,4,2,0,2,5,4,1,6
10,Senegal,4,2,0,2,5,7,-2,6
You are requested to perform:
A) Remove rows with null data from both datasets
B) Apply a filter using a function that shows only the teams with 3 losses, for the 2022 World Cup.
C) Create a bar chart showing the 20 highest scoring teams for the 2002 and 2022 World Cups.
D) Export and save both datasets (without nulls)
Unlock instant AI solutions
Tap the button
to generate a solution
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)