Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

***Python**** #Last problem, you wrote a function that generated the all- #time win-loss-tie record for Georgia Tech against any other #team. # #That dataset had

***Python****

#Last problem, you wrote a function that generated the all- #time win-loss-tie record for Georgia Tech against any other #team. # #That dataset had a lot of other information in it. Let's #use it to answer some more questions. As a reminder, the #data will be a CSV file, meaning that each line will be a #comma-separated list of values. Each line will describe one #game. # #The columns, from left-to-right, are: # # - Date: the date of the game, in Year-Month-Day format. # - Opponent: the name of the opposing team # - Location: Home, Away, or Neutral # - Points For: Points scored by Georgia Tech # - Points Against: Points scored by the opponent

#This line will open the file: record_file = open('../resource/lib/public/georgia_tech_football.csv', 'r')

#Here, add any code you want to allow you to answer the #questions asked below over on edX. This is just a sandbox #for you to explore the dataset: nothing is required for #submission here.

Who was the first team Georgia Tech ever played against? unanswered

How many points has Georgia Tech scored all-time against Auburn? unanswered

How many points has Auburn scored all-time against Georgia Tech? unanswered

What is Georgia Tech's all-time record in home games? Enter your response in the same style as the previous problem's output, Wins-Losses-Ties; for example, 100-50-25. unanswered

What was Georgia Tech's record in all games played in the 2009 calendar year? Enter your response in the same style as the previous problem's output, Wins-Losses-Ties; for example, 100-50-25. unanswered

What is Georgia Tech's all-time record in the month of October? Enter your response in the same style as the previous problem's output, Wins-Losses-Ties; for example, 100-50-25. unanswered

Georgia Tech played in the SEC from 1933 to 1963. What was its record during this time? Enter your response in the same style as the previous problem's output, Wins-Losses-Ties; for example, 100-50-25. unanswered

Against what team has Georgia Tech scored the most points? unanswered

What is one of the two teams that Georgia Tech has played, and yet has never scored any points against? Name either team. unanswered

How many teams has played Georgia Tech and never scored a point? unanswered

Against what team does Georgia Tech have the highest scoring differential (points for minus points against) all-time? unanswered

Among teams that Georgia Tech has played at least 5 times, against which team does Georgia Tech have the highest average score differential (points for minus points against, divided by number of games)?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Databases questions