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)
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
Unlock instant AI solutions
Tap the button
to generate a solution
