Skip to content

Latest commit

 

History

History
31 lines (21 loc) · 1.15 KB

README.md

File metadata and controls

31 lines (21 loc) · 1.15 KB

Intro to SQL

Code Hub Decodering

This repo contains code and information for the Intro to SQL talks hosted by CodeHub. If you'd like to learn more or have questions, please join our Discord server.

load_imdb.py

This script will load and clean data from the IMDb TSV files, before outputting it to either a CSV file or a SQLite database.

You can download the TSV from IMDb Non-Commercial Datasets

Command-line arguments

usage: load_imdb.py [-h] [--output_format {csv,sqlite}] [--db_file DB_FILE] [--output_dir OUTPUT_DIR] input_dir

Process TSV files from IMDb and save to CSV or SQLite.

positional arguments:
  input_dir             Directory that contains the input TSV files

options:
  -h, --help            show this help message and exit
  --output_format {csv,sqlite}
                        Output format: csv or sqlite
  --db_file DB_FILE     Path to the SQLite database file (required if output is sqlite)
  --output_dir OUTPUT_DIR
                        Path to the output CSV file (required if output is csv)