Skip to main content
SimilarExport ZIP
100%

Created on Cognitive Class Labs

✓ Published0🌍 Public
DDAVINDER
Last edited May 31, 2019
Created on May 31, 2019

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.

AI-generated description

Similar vizzes

Loading thumbnail…

Created on Cognitive Class Labs

A Jupyter notebook demonstrates how to connect to an IBM Db2 database on the cloud using Python. It shows the sequential steps of importing the `ibm_db` library, defining connection credentials for a dashDB instance, and constructing a DSN connection string with the driver, hostname, port, protocol, and user credentials. The rendered DSN output, including the hardcoded host and password, is displayed. The notebook relies on the `ibm_db` API, which uses the IBM Data Server Driver for ODBC and CLI, to establish the database connection.

DDAVINDER
82% match
Loading thumbnail…

Created on Cognitive Class Labs

This example demonstrates how to connect to an IBM Db2 on Cloud database using Python and the `ibm_db` API. It shows the step-by-step process of importing the library, establishing a connection with credentials, creating a table, inserting data, and querying the result set into a pandas DataFrame. The notebook is written as an instructional lab from Cognitive Class, using a gist source, and runs entirely within Jupyter cells on IBM's cloud platform.

DDAVINDER
80% 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
75% match
Loading thumbnail…

Created on Cognitive Class Labs

This example demonstrates basic Python programming concepts taught in a Cognitive Class Labs notebook, including printing output, writing comments, and introducing data types like integers and floats. The notebook uses markdown cells for instructional text and code cells that execute `print()` statements to display results, such as "Hello, Python!". The material is sourced from a gist and covers foundational syntax, expressions, and variables, with exercises for learners. No data-visualization libraries are used; the focus is on interactive coding practice within the Jupyter notebook environment.

DDAVINDER
60% match
Loading thumbnail…

Created on Cognitive Class Labs

This example demonstrates the process of data wrangling on an automobile dataset using Python. It shows how to import data from a URL into a Pandas DataFrame, assign descriptive column headers, and prepare the data for analysis. The notebook uses Pandas for data manipulation and matplotlib for potential visualization. The dataset is sourced from an IBM-hosted CSV file, and the code handles tasks such as reading the data and setting up the structure for further cleaning and transformation.

DDAVINDER
59% match
Loading thumbnail…

Created on Cognitive Class Labs

This example demonstrates the process of data wrangling on an automobile dataset using Python. It shows how to import data from a URL into a Pandas DataFrame, assign descriptive column headers, and prepare the data for analysis. The notebook uses Pandas for data manipulation and matplotlib for potential visualization. The dataset is sourced from an IBM-hosted CSV file, and the code handles tasks such as reading the data and setting up the structure for further cleaning and transformation.

DDAVINDER
59% 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
58% match
Loading thumbnail…

Created on Cognitive Class Labs

This notebook from a Cognitive Class Labs course demonstrates Python string operations, including indexing, negative indexing, slicing, stride, concatenation, escape sequences, and string methods. The examples show how to define strings with single or double quotes, combine spaces, digits, and special characters, and apply methods like `upper()`, `replace()`, and `find()`. The code is executed in Jupyter cells, with outputs displayed inline as executed results, and the notebook is sourced from a gist authored by DAVINDERYADAVRJIT.

DDAVINDER
55% match