Created on Cognitive Class Labs

100%

Created on Cognitive Class Labs

✓ Published0🌍 Public

Last edited May 31, 2019

Created on May 31, 2019

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.

AI-generated description

Similar vizzes

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

89% 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

82% 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

74% 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

65% match

Loading thumbnail…

Created on Cognitive Class Labs

DDAVINDER

65% 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 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

59% match

Loading thumbnail…

Created on Cognitive Class Labs

This example shows how to build predictive models for car pricing using the Python data science stack. The notebook loads an automobile dataset from IBM Cloud Object Storage into a pandas DataFrame, then imports pandas, NumPy, and Matplotlib for analysis. It demonstrates model development techniques for estimating vehicle prices based on features like horsepower, engine size, and fuel efficiency. The code prepares data by normalizing columns and creating binary indicators, showcasing a practical workflow for regression modeling in an educational notebook environment.

DDAVINDER

58% match