Data Analysis and Visualisations Tasks Visualization 1 How many circuits are available per Country? Visualization 2...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Data Analysis and Visualisations Tasks Visualization 1 How many circuits are available per Country? Visualization 2 What is the number of races per season? Visualization 3 . What is the number of constructors per nationality? Visualization 4 How many points has each constructor scored? In how many races does each constructor participates? Visualization 5 What is the trend of fastest lap times over the years per circuit? Please consider a reasonable number of circuits only. Data Gathering An SQLITE database is required to create the following relationships and data required see figure-1 for the data analysis and visualisation Tasks 1-7. Tasks results . . . constructors drivers 1. You are required to develop a module-based Python solution that creates and populates F1Results DB by importing the relevant csv files, 7 in total. To do this you need to take the following steps [Total 20 Marks] . Ta Figure-1: F1Results DB Create a Module named F1DB, contained in the Package F1; . Identify and justify the main functions required to create and populate the F1 Results DB; pitstops circuits 2. Develop a module to query the F1 Results DB as required for the data analysis Tasks 1-5. To do this you need to take the following steps [Total 20 Marks] lapTimes 4. Create a file named Main.ipynb then Implement in Python the identified functions as part of the F1DB Module; Implement in Python the identified functions as part of the QueryF1DB Module; Create a Module named QueryF1DB, contained in the Package F1; Identify and justify the main functions to support the queries required by the data analysis and visualisation Tasks 1-5; (7 marks) (8 marks) 3. Develop a module to define the appropriate plot/diagram for the visualisation Tasks 1-5. To do this you need to take the following steps [Total 20 Marks] (5 marks) Import the Modules F1DB, QueryF1DB, VisQueryF1DB; Display the results in the form of plots/diagrams for Tasks 1-5; (5 marks) (7 marks) (8 marks) Create a Module named VisQueryF1DB, contained in the Package F1; Identify and justify the main functions to support the plots/diagrams required by the data visualisation Tasks 1-5; Implement in Python the identified functions as part of the VisQueryF1DB Module; (5 marks) (7 marks) (8 marks) [Total 10 Marks] (5 marks) (5 marks) Data Analysis and Visualisations Tasks Visualization 1 How many circuits are available per Country? Visualization 2 What is the number of races per season? Visualization 3 . What is the number of constructors per nationality? Visualization 4 How many points has each constructor scored? In how many races does each constructor participates? Visualization 5 What is the trend of fastest lap times over the years per circuit? Please consider a reasonable number of circuits only. Data Gathering An SQLITE database is required to create the following relationships and data required see figure-1 for the data analysis and visualisation Tasks 1-7. Tasks results . . . constructors drivers 1. You are required to develop a module-based Python solution that creates and populates F1Results DB by importing the relevant csv files, 7 in total. To do this you need to take the following steps [Total 20 Marks] . Ta Figure-1: F1Results DB Create a Module named F1DB, contained in the Package F1; . Identify and justify the main functions required to create and populate the F1 Results DB; pitstops circuits 2. Develop a module to query the F1 Results DB as required for the data analysis Tasks 1-5. To do this you need to take the following steps [Total 20 Marks] lapTimes 4. Create a file named Main.ipynb then Implement in Python the identified functions as part of the F1DB Module; Implement in Python the identified functions as part of the QueryF1DB Module; Create a Module named QueryF1DB, contained in the Package F1; Identify and justify the main functions to support the queries required by the data analysis and visualisation Tasks 1-5; (7 marks) (8 marks) 3. Develop a module to define the appropriate plot/diagram for the visualisation Tasks 1-5. To do this you need to take the following steps [Total 20 Marks] (5 marks) Import the Modules F1DB, QueryF1DB, VisQueryF1DB; Display the results in the form of plots/diagrams for Tasks 1-5; (5 marks) (7 marks) (8 marks) Create a Module named VisQueryF1DB, contained in the Package F1; Identify and justify the main functions to support the plots/diagrams required by the data visualisation Tasks 1-5; Implement in Python the identified functions as part of the VisQueryF1DB Module; (5 marks) (7 marks) (8 marks) [Total 10 Marks] (5 marks) (5 marks)
Expert Answer:
Related Book For
Posted Date:
Students also viewed these programming questions
-
answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
Partners have fiduciary obligations to each other. Explain what this means and give examples.
-
How does lifestyle relate to problem recognition?
-
Determine the tax liability, marginal tax rate, and average tax rate (rounded to two decimal places) in each of the following cases. Use the tax tables to determine tax liability. a. Single taxpayer,...
-
Determine whether the events are independent or dependent. 1. Selecting a king (A) from a standard deck of 52 playing cards, not replacing it, and then selecting a queen (B) from the deck 2. Tossing...
-
On December 1, Jasmin Ernst organized Ernst Consulting. On December 3, the owner contributed $84,000 in assets in exchange for its common stock to launch the business. On December 31, the companys...
-
In the "Stakeholder Analysis in Projects" article this week, the authors Jepsen and Eskerod (2008) found that the "guidelines provided in current literature are far too general to be useful for...
-
You own a flooring company that sells the following items. Product Premium Carpet Basic Carpet Luxury Vinyl Flooring Standard Vinyl Flooring Delivery Fee Installation Price $4.00 / square ft....
-
The graph of y= g(a) is given below. Answer each of the questions below the graph, using interval notation. Answer DNE if there is no interval. 11 -10 -9 -65 A) Where is g(z) increasing? B) Where is...
-
What is the present value of $3,525 per year, at a discount rate of 10 percent, if the first payment is received 7 years from now and the last payment is received 25 years from now? (Do not round...
-
Richardson Environmental Services Ltd. provides reclamation advice to clients, related to either well sites or pump stations. The company's budgeted income statement for the year ended December 31,...
-
Suppose a market featuring two goods that differ in quality. Good 1 is of quality s and good 2 is of quality $2, with $2> 51. There is a mass of n = 1 consumers, of different types, identified by a...
-
A useful device in thinking about any implementation programme is the change curve which represents a journey on which employees need to be taken if a change is to lead to actions and be successful....
-
Use the following information to answer question 3 and 4 Suppose that the current spot exchange rate is 0.80/$ and the bank quoted forward exchange rate is 0.7813/$. The one-year interest rate is...
-
Wham Products, a maker of specialty products, is currently manufacturing and selling a product called Gory Goo. A discount department store, J-Mart, has made a one-time offer to purchase 53,000 units...
-
You have accepted the engagement of auditing the financial statements of the C. Reis Company, a small manufacturing firm that has been your auditee for several years. Because you were busy writing...
-
Would you expect the demand curve for a firm in a monopolistically competitive industry to be more or less elastic in the long run after competitor entry has eliminated economic profits?
-
According to the Coase Theorem, resource allocation will be efficient so long as transaction costs remain low and property rights can be freely assigned and exchanged. A. Does the Coase Theorem imply...
-
A review of industry wide data for the jelly and jam manufacturing industry suggests the following industry supply function: Q = -59,000,000 + 500,000P - 125,000P L - 500,000P K + 2,000,000W, Where Q...
-
Remmers Travel Agency purchased land for 85,000 cash on December 10, 2025. At December 31, 2025, the lands value has increased to 93,000. What amount should be reported for land on Remmers statement...
-
As of December 31, 2025, Stoneland AG has assets of 3,500 and equity of 2,000. What are the liabilities for Stoneland AG as of December 31, 2025? a. 1,500. b. 1,000. c. 2,500. d. 2,000.
-
Performing services on account will have the following effects on the components of the basic accounting equation: a. increase assets and decrease equity. b. increase assets and increase equity. c....
Study smarter with the SolutionInn App