Skip to content

Latest commit

 

History

History
130 lines (113 loc) · 7.31 KB

video-lessons.md

File metadata and controls

130 lines (113 loc) · 7.31 KB

Video lessons

Check out our YouTube channel for more videos.

<iframe src="https://www.youtube.com/embed/67LzPsdNrEc?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Interactive Data Visualization

An overview of some of the visualization capabilities of the Datagrok platform, including the concepts of views, viewers, selection, filter, and layouts.

<iframe src="https://www.youtube.com/embed/jHRpOnhBAz4?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Scripting viewers

Scripting viewers are usually written in R, Python, or Julia. While not as interactive as the core Datagrok viewers, they allow to easily use thousands of visualizations already developed for these languages.

<iframe src="https://www.youtube.com/embed/k1NVdTRpYOM?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Cheminformatics overview

This is an overview of the cheminformatics capabilities available in the Datagrok platform. During the interactive sessions, we will do the following:
• import molecules in the SMILES format
• take a closer look at the molecule-specific info panels, including 3D structure, SDF, toxicity prediction, drug likeness, CHEMBL substructure and similarity, identifier conversion, PubChem integration, predictive models, as well as usuing community-produced scripts as context info panels
• sketch new molecules
• retrieve molecules by name, or by other identifiers
• perform in-memory substructure search
• perform similarity and diversity analyses using different metrics and fingerprints
• calculate descriptors
• perform R-Group analysis
• visualize molecules on a scatter plot, bar chart, grid, form, and tile viewer
• learn how to write RDKit-based Python scripts that take molecules as inputs
• search for substructures in a database powered by a chemical cartridge
• reproduce above-mentioned steps by applying recorded macros

<iframe src="https://www.youtube.com/embed/YJmSvh3_uCM?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Database Exploration

We will learn how to create and share database connections, and interactively explore database content using a number of tools: • Property panel - for quick browsing • Visual query - for interactive aggregation and pivoting • Schema browser

<iframe src="https://www.youtube.com/embed/-yTTaS_WOU4?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Using formulas in calculated columns

Learn how to use Python, R, and JavaScript functions in formulas for calculating column values

<iframe src="https://www.youtube.com/embed/wCdzD64plEo?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Molecular similarity and diversity

Similar compounds have similar properties, so molecular similarity and molecular diversity techniques are important cheminformatics tools. In this video, we will learn how to interactively explore a dataset using these techniques.

<iframe src="https://www.youtube.com/embed/1EI1w2HECrM?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Aggregation

In this video, we will learn how to interactively aggregate data using the Datagrok platform.

<iframe src="https://www.youtube.com/embed/tVwpRB8fikQ?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Coffee Company

How do we choose the best location for a new coffee place, given the historical sales data? Datagrok to the rescue! In less than 20 minutes, we will achieve the following:
• retrieve historical data from the Postgres database
• explore, visualize, and clean it
• impute missing values
• extract census data from the long/lat coordinates
• perform multivariate analysis
• build multiple predictive models, and assess their performance
• build an interactive map for predicting sales
• deploy it as an app to all users in our company

<iframe src="https://www.youtube.com/embed/dlbK2Zo-eng?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Joining tables

In this video, we will join two tables by key columns, using different join types. Learn more

<iframe src="https://www.youtube.com/embed/rUHFwO1iQUg?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Comparing tables

Compare data snapshots using the Table Comparer tool. Learn more

<iframe src="https://www.youtube.com/embed/PDcXLMsu6UM?vq=hd1080&rel=0&color=white&autohide=0" width="512" height="288" frameborder="0"></iframe>

Debugging Javascript package in Datagrok

Learn how to create a javascript package, how to upload it and debug on the remote Datagrok server.