FIX THIS CODE Using python Application CODE: import csv playersList = [] with open('Players.csv') as f: rows = csv.DictReader(f) for r in rows: playersList.append(r) teamsList = [] with open('Teams.csv') as f: rows = csv.DictReader(f) for r in rows: teamsList.append(r) plays=len(playersList) for i in range(plays): if playersList[i]['team']=='Argentina' and int(playerlist[i]['minutes played'])<200 and int(playersList[i] ['shots'])>20: print(playersList[i]['last name']) c0=0 c1=0 c2=0 for i in range(len(teamsList)): if int(teamsList[i]['redCards'])==0: c0=c0+1 if int(teamsList[i]['redCards'])==1: c1=c1+1 if int(teamsList[i]['redCards'])==2: c2=c2+1 print("Number of teams with zero redcards:",c0) print("Number of teams with zero redcards:",c1) print("Number of teams with zero redcards:",c2) ratio=0 for i in range(len(teamsList)): if int(teamsList[i]['games']>3) and if int(teamsList[i]['goalsFor'])/int(teamsList[i]['goalsAgainst'])3) and if int(teamsList[i]['goalsFor'])/int(teamsList[i]['goalsAgainst'])==ratio: print(teamsList[i]['teams']) ind=0 avg=-99999 for i in range(len(teamsList)): if int(teamsList[i]['goalFor'])//int(teamsList[i]['games'])>avg: avg=int(teamsList[i]['goalFor'])//int(teamsList[i]['games'] ind=i print('The team with highest goalsFor per game on average:') for i in range(len(teamsList)): if int(teamsList[i]['goalFor'])//int(teamsList[i]['games'])==avg: print(teamsList[i]['team']) ind1=0 avg1=-99999 for i in range(len(teamsList)): if int(teamsList[i]['passes'])//int(teamsList[i]['games'])>avg1: avg1=int(teamsList[i]['passes'])//int(teamsList[i]['games'] ind1=i print('The team with highest total passed per game on average:') for i in range(len(teamsList)): if int(teamsList[i]['passes'])//int(teamsList[i]['games'])==avg1: print(teamsList[i]['name']) avg3=sum(playersList[:]['passes'])/len(playersList[:]['passes']) for i in range(len(playersList)): if playersList[i]['passes']>avg3: print(playersList[i]['position'])

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
icon
Related questions
Question

FIX THIS CODE

Using python Application

CODE:

import csv

playersList = []

with open('Players.csv') as f:

rows = csv.DictReader(f)

for r in rows:

playersList.append(r)

teamsList = []

with open('Teams.csv') as f:

rows = csv.DictReader(f)

for r in rows:

teamsList.append(r)

plays=len(playersList)

for i in range(plays):

if playersList[i]['team']=='Argentina' and int(playerlist[i]['minutes played'])<200 and int(playersList[i]

['shots'])>20:

print(playersList[i]['last name'])

c0=0

c1=0

c2=0

for i in range(len(teamsList)):

if int(teamsList[i]['redCards'])==0:

c0=c0+1

if int(teamsList[i]['redCards'])==1:

c1=c1+1

if int(teamsList[i]['redCards'])==2:

c2=c2+1

print("Number of teams with zero redcards:",c0)

print("Number of teams with zero redcards:",c1)

print("Number of teams with zero redcards:",c2)

ratio=0

for i in range(len(teamsList)):

if int(teamsList[i]['games']>3) and if int(teamsList[i]['goalsFor'])/int(teamsList[i]['goalsAgainst'])<ratio:

ratio=int(teamsList[i]['goalsFor'])/int(teamsList[i]['goalsAgainst'])<ratio

print('team with lowest ratio')

for i in range(len(teamsList)):

if int(teamsList[i]['games']>3) and if int(teamsList[i]['goalsFor'])/int(teamsList[i]['goalsAgainst'])==ratio:

print(teamsList[i]['teams'])

ind=0

avg=-99999

for i in range(len(teamsList)):

if int(teamsList[i]['goalFor'])//int(teamsList[i]['games'])>avg:

avg=int(teamsList[i]['goalFor'])//int(teamsList[i]['games']

ind=i

print('The team with highest goalsFor per game on average:')

for i in range(len(teamsList)):

if int(teamsList[i]['goalFor'])//int(teamsList[i]['games'])==avg:

print(teamsList[i]['team'])

ind1=0

avg1=-99999

for i in range(len(teamsList)):

if int(teamsList[i]['passes'])//int(teamsList[i]['games'])>avg1:

avg1=int(teamsList[i]['passes'])//int(teamsList[i]['games']

ind1=i

print('The team with highest total passed per game on average:')

for i in range(len(teamsList)):

if int(teamsList[i]['passes'])//int(teamsList[i]['games'])==avg1:

print(teamsList[i]['name'])

avg3=sum(playersList[:]['passes'])/len(playersList[:]['passes'])

for i in range(len(playersList)):

if playersList[i]['passes']>avg3:

print(playersList[i]['position'])

Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Concept of Threads
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education