Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions 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
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education