SQLite cursus Udemy

100%

SQLite cursus Udemy

✓ Published0🌍 Public

Last edited Jul 29, 2019

Created on Jul 28, 2019

This example demonstrates how to manage SQLite databases through Python, contrasting two distinct approaches. It shows the creation, insertion, and querying of database tables using both the SQLAlchemy ORM and the raw `sqlite3` module. The code highlights SQLAlchemy’s declarative table definitions, `db.insert()` for record insertion, and `pd.read_sql_query` to load query results into a pandas DataFrame. It also presents `sqlite3` with cursor-based operations like `execute()` for CRUD functions and parameterized queries for email lookups. The visualization is purely programmatic, with no graphical output, focusing instead on code patterns for database interaction.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist e9eac02df35654daa5d0

This example demonstrates a minimal data pipeline that reads JSON data and inserts it into a local SQLite database. The script, `jsonToSqlite.py`, loads a JSON file containing a list of objects, extracts the first object’s `"foo"` and `"bar"` fields, and writes those two values as a single row into a table named `table_name`. It uses the standard `json` module for parsing and `sqlite3` for database operations, creating a table and inserting the data with a parameterized `execute` call. The visualization shows only the code structure, not a graphical output, highlighting the simple ETL pattern of extracting, transforming, and loading data.

CCBasis

60% match

Loading thumbnail…

Created on Cognitive Class Labs

This notebook demonstrates how to access and query a Db2 database from JupyterLab using the SQL magic extension (`ipython-sql`). It shows the process of loading the SQL extension, connecting to a database via a SQLAlchemy connection string (using the `ibm_db_sa` dialect), and executing SQL commands. The example includes a connection attempt with provided credentials and illustrates error handling when the connection string is malformed. The code relies on `%load_ext sql`, `%sql` for single-line queries, and `%%sql` for cell-level SQL operations.

DDAVINDER

55% match

Loading thumbnail…

Get Yahoo!Finance data on ScraperWiki

This example shows how to pull historical stock price data from Yahoo! Finance and store it in a SQLite database. The code uses pandas’ `DataReader` with the `yahoo` API to fetch daily trading data for a given ticker symbol over a specified date range. It then resets the DataFrame index, converts the date column to ISO format, and writes the result to a table using `pandas.io.sql.write_frame` with a SQLite connection. The script demonstrates a straightforward data pipeline from an online financial API to local relational storage, using only the pandas and sqlite3 libraries.

IIanHopkinson

51% match

Loading thumbnail…

Udemy Courses Information

This example summarizes the contents of a Udemy courses dataset by displaying the file size, row count, and column count in large text. It loads a CSV file from a GitHub gist using `d3.csv` and formats the raw data with `d3.tsvFormat` to compute the kilobyte size. The visualization explicitly demonstrates both the primary `d3.csv` approach and commented-out alternatives using `fetch` with async/await and nested promises. The dataset originates from Kaggle and covers four course subjects.

DdaojunL

49% match

Loading thumbnail…

Created on Cognitive Class Labs

This example demonstrates the basics of tuples in Python, including indexing, slicing, and sorting operations, using a dataset of album recommendations from friends. The notebook presents a table containing album attributes like artist, release year, genre, and sales figures, then applies tuple methods to access and manipulate the data. The visualization relies on the cognitiveclass.ai platform, with the code written in a Jupyter notebook and rendered through WebGL for interactive display. A quiz section reinforces the concepts covered, and the tutorial is designed to be completed in about 15 minutes.

DDAVINDER

49% match

Loading thumbnail…

Created on Cognitive Class Labs

This notebook demonstrates Python dictionary operations through a series of executed cells. It shows how to create dictionaries with various key types—strings, tuples, and mixed values—and access values by key. The code uses standard Python dictionary syntax, including colon-separated key-value pairs and curly-brace notation, with examples from an album release-year dataset. The rendered markdown includes instructional text and images, while the executable code cells run in a Jupyter environment on Cognitive Class Labs.

DDAVINDER

49% match

Loading thumbnail…

Created on Cognitive Class Labs

This example demonstrates how to load three Chicago public datasets—socioeconomic indicators, public school performance, and crime reports—from CSV files into a Db2 database using the `ibm_db` API, then query them with SQL. It uses the `pandas` library to read the CSV data and the `ibm_db` connection functions to create and populate tables. The notebook guides through understanding the datasets, downloading them, and storing them in database tables, with the SQL queries highlighting relationships between community areas, schools, and crime incidents.

DDAVINDER

48% match

Loading thumbnail…

Script for updating a database of the Citibike JSON feed

This example demonstrates a script that keeps a Citibike station and bike database current by parsing the live Citibike JSON feed. It shows how to update PostgreSQL records through Django models, capturing the feed’s execution time as separate date and time fields. The code uses the `requests` library to fetch the JSON, `datetime` to reformat timestamps, and Django’s `get_or_create` to add or retrieve station and bike entries. It also handles station ID changes by matching on station names, ensuring consistent data linkage across updates.

JJoshAddington

48% match