Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
.ipynb_checkpoints
Basics.ipynb
README.md
appearance_type.csv
game_log.csv
game_log_fields.txt
mlb.db
park_codes.csv
person_codes.csv
schema-screenshot.png
team_codes.csv

README.md

Desigining and Creating a Database

In this mini-project, we will be working with a file of Major League Baseball games from Retrosheet.

We will design and create a Database with normalised tables by compiling data from various sources.

Github Repo | Notebook Preview (nbviewer)


Following Packages and Concepts are used:

  • Pandas - DataFrame (Consolidating Data)
  • SQLite3 - Database
  • SQL - SELECT, FROM, CREATE, JOIN, ALTER, UPDATE, INSERT, UNION, DROP, CASE, WHEN, THEN, LIMIT, GROUP BY

Schema
Schema

You can’t perform that action at this time.