Tutorials
Learn the Grammar of Data Science
Data Source
Lesson 1
07:24
Scraping Table Data from Web Sites
This video is about how to scrape table data from web sites and clean up the dirty data for further analysis in Exploratory.
Lesson 1
06:39
Working with JSON data
This video is about how quickly you can wrangle with JSON data and explore the data in Exploratory.
Lesson 1
03:13
Querying & Extracting Twitter Data
This video is about how you can query and extract Twitter data in Exploratory.
Data Wrangling
Lesson 1
01:47
Selecting or Dropping Columns
This video is about how to select or drop columns in Exploratory.
Lesson 2
02:47
Creating New Columns
This video is about how to create new columns with expressions. You can also find how to convert the existing column data type.
Lesson 3
03:44
Filtering Data
This video is about how to filter data in Exploratory. You can also find how to create your own custom filtering logic in a simple and flexible way.
Lesson 4
00:56
Sorting Data
This video is about how to sort data by Arrange command.
Lesson 5
02:57
Summarzing (Aggregating) Data
This video is about how to summarzing (or aggregate) data by grouping the data in Exploratory.
Lesson 6
03:59
Join Multiple Data Sets
This video is about how to join multiple data sets (data frames) in four different ways, Left / Right / Full / Inner Join in Exploratory.
Lesson 7
01:18
Top N / Bottom N
This video is about how to get top N (e.g. top 10) or bottom N data quickly in Exploratory.
Lesson 8
03:19
Filtering Data by Join
This video is about how to filter data by using Anti or Semi Join commands in Exploratory.
Lesson 9
02:30
Merging (Combining) Multiple Data Sets
This video is about how to merge multiple data frames by using bind_rows, union, intersect, and setdiff commands in Exploratory.
Lesson 10
00:31
Cleaning Up Column Names
This video is about how to get top N (e.g. top 10) or bottom N data quickly in Exploratory.
Lesson 11
00:59
Separating a Column to Multiple Rows
This video is about how to filter data by using Anti or Semi Join commands in Exploratory.
Lesson 12
00:59
Separating a Column to Multiple Columns
This video is about how to separate column values into multiple columns in Exploratory.
Lesson 13
01:59
Concatenating Multiple Column Values into One
This video is about how to concatenate multiple columns values and how to parse text to convert it to Date / Time data type.
Lesson 14
03:34
Gather / Unpivot - Transforming Wide Data to Long Data
This video is about how to transform wide data to long data form in Exploratory.
Lesson 15
02:30
Spread / Pivot - Transform Long Data to Wide Data
This video is about how to use Spread command to transform data from Long (Tidy) form to Wide form in Exploratory.
Lesson 16
00:31
Removing Empty Rows
This video is about how to remove empty or NA rows in Exploratory.
Lesson 17
01:18
Converting Text to Numeric
This video is about how to extract numeric part of the data and convert it to Numeric data type in Exploratory.
Lesson 18
01:26
Removing Rows Based On Row Number
This video is about how to remove or keep rows based on the row numbers.
Lesson 19
01:06
Converting Data Types Automatically for All Columns
This video is about how to evaluate the data and convert all the columns to appropriate data types in Exploratory.
Lesson
02:13
Gathering (Unpivoting) Variable Columns
This video is about how to 'gather' or 'unpivot' all the numerical variable columns so that you can see their data together and compare them side by side.
Lesson
01:38
Inspecting Duplicated Rows
This video is about how you can inspect 'dupicated rows' with 'get_dupes' command in Exploratory.
Lesson
04:42
Scaling or Normalizing All Numeric Columns
This video is about how to scale all the numeric columns (variables) in a single operation and use small multiple chart to compare them side by side in a quick and simple way.
Lesson
01:15
Applying a Same Function to Multiple Columns Together
This video is about how you can apply a same function to multiple columns together in a single operation by using 'mutate_if' command in Exploratory.
Product Features
Lesson
01:17
Copying Steps From One Data Frame to Another
This video is about how to copy the data wrangling steps from one data frame to another data frame to reproduce the same data transformation in Exploratory.
Lesson
03:37
Introduction to Chart Pinning
Chart Pinning in Exploratory makes your visual data exploration more effective and flexible. This video is going to demonstrate what is Chart Pinning and when you want to use it.
Lesson
02:18
How to Use Command Line Mode
This video demonstrates how you can get into the command line mode or convert existing UI tokens to commands to make your data interaction faster and more flexible.
Lesson
01:58
Moving Steps Before or After
This video is about how to move one ore more steps to a different point of the data wrangling pipeline in Exploratory.
Lesson
00:48
Disabling Step(s)
This video is about how to temporarily disable data wrangling step(s) without deleting it in Exploratory.
Lesson
00:25
Deleting Multiple Steps Together
This video is about how to delete multiple data wrangling steps together in Exploratory.
Visualization
Lesson 1
04:26
Introduction to Map with GeoJSON
This video will walk you through how to bring your own custom GeoJSON file and use it to visualize geographical data effectively on Map in Exploratory.
Analytics
Lesson 1
04:06
Clustering Analysis
This video is about how to use K-means Clustering to segment the data based on categories or variables in Exploratory.
Lesson 1
03:02
Correlation Analysis
This video is about how you can quickly calculate correlations among categories or among variables in Exploratory.
Lesson 1
03:58
Analyzing Twitter Text Data
This video is about how you can quickly analyze twitter text data by tokenizing the tweets, removing 'stopwords', and finding out what combinations of the words are used together more often than the others.
Analysis Use Cases
Loading