Posts

Showing posts with the label python SQL database

Create IMDb Database with Python

Create IMDb Database with Python Making an IMDb Database with Python We will use the sqlite3 library in Python to create a database which holds the available data from the IMDb datasets. The IMDb datasets are available here . The descriptions are available here . All of these files are TSVs (tab separated value) as opposed to CSVs. Also, I will omit the file "title.akas.tsv.gz" because I find that its contents are superfluous for this project. Its columns are in the table below. Note that titleId and ordering form a composite key. Name titleId ordering title region language types attributes isOriginalTitle Description IMDb identifier for each title. (tt#######) (TEXT) Distinguishes a different translation of the title. (TEXT) Title of the translation. (TEXT) Country code. (ISO 3166-1 alpha-2) (TEXT) TBD (TEXT) TBD (TEXT)