Skip to content

Azure Data Studio notebook of F1 Statistics using the Erdgast API

License

Notifications You must be signed in to change notification settings

SPWareing/F1_statistics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

F1 Statistics

As an alternative to generating statistics using Python and Pandas, this notebook is driven by SQL queries using the Erdgast API and Azure Data Studio. As such the notebook needs to be viewed in Azure Data Studio as only raw code will be visible on GitHub.

For a quick view there is my article on LinkedIn

This database has been built using Azure cloud services. It is an Azure SQL Database and forms part of my study for the DP 300 Exam. All queries are written in T-SQL

Photo by Abed Ismail on Unsplash


Statistics List

1. Who is the most sucessful driver in a season?

2. What about the most successful constructor

3. Championships thrown away on the final race

4. Winning from the back

5. Percentage Likelihood of Winning By Qualifying Position

6. The effect of the undercut

7. It's all about consistency

8. The lack of consistency

9. Championships by Country; including most chamionships by a driver


Example SQL Code:

SELECT grid as [Grid Position],
	ROUND(CAST(count(*) AS FLOAT)/ (SELECT count(*) from form.results WHERE position = 1)*100,2) AS [Percentage Chance]
FROM form.results
WHERE position = 1
GROUP BY grid
ORDER by grid ASC;

TO DO LIST

  • Add SQL Scripts Folder
  • Python Notebook

Your Repository's Stats

About

Azure Data Studio notebook of F1 Statistics using the Erdgast API

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published