Created on Cognitive Class Labs

100%

Created on Cognitive Class Labs

✓ Published0🌍 Public

Last edited May 31, 2019

Created on May 31, 2019

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.

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

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

75% match

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

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

68% match

Loading thumbnail…

Created on Cognitive Class Labs

DDAVINDER

68% match

Loading thumbnail…

Loading CSV Data with D3

This example demonstrates loading and parsing a CSV file with D3.js v3, displaying financial time-series data from the Federal Deposit Insurance Corporation (FDIC) for Chicago banks from 1966 to 2000. The visualization uses d3.csv to load ChicagoFDIC.csv and render the values as an interactive line chart or table. The dataset contains annual metrics such as total assets, total loans and leases, and investment securities, all formatted with commas (e.g., "9,092,998"). The example highlights D3's core data-handling capabilities: asynchronously fetching external data, parsing numeric strings, and binding the resulting JavaScript objects to DOM elements for dynamic visualization.

AAbechtel

66% match

Loading thumbnail…

Loading CSV Data with D3

This example demonstrates how to load and parse a CSV file with D3.js, mapping each row to a JavaScript object. The ChicagoFDIC.csv dataset contains annual banking figures from 1966 to 2000, including columns for investment securities, real estate loans, total assets, and net interest income. Using d3.csv, the data is loaded asynchronously and rendered into an HTML table. The values, which include commas in the raw data, are parsed as numeric strings so they can be used in calculations or visual encodings. This example shows the foundational step in D3 of ingesting external data, with the table providing a clean tabular view of the parsed dataset before any chart is drawn.

AAbechtel

65% match

Loading thumbnail…

Loading CSV Data with D3

This example demonstrates how to load a CSV file into a web page using D3 v3’s `d3.csv` method. The page displays a static SVG canvas containing a blue line, a red rectangle, and a violet circle, while the CSV data for Chicago’s socioeconomic indicators is parsed into an array of JavaScript objects and logged to the browser console. No chart is rendered; the focus is solely on verifying successful asynchronous data loading and transformation.

JJasonMcGregor

64% match