Tutorials
Learn Data Science without Programming
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 0
05:48
Convert Numeric Values to Categories (Binning)
This video is about how to create categories (or buckets) for numeric data type columns with Exploratory's simple UI experience.
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
04:33
Introduction to Summarizing (Aggregating) Data
This video is about how to summarize (aggregate) data quickly and flexibly in Exploratory. It also covers how to use Window Calculations based on the grouped data.
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
02:09
Transform between Wide Data and Long Data with Gather (Un-Pivot) & Spread
This video is about how you can quickly transform data between Long and Wide formats.
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.
Lesson 1
02:00 read
This post will walk you through what are the differences among the four join types (left, right, full, inner) and how you can use them effectively in Exploratory.
Lesson 1
05:00 read
This post will walk you through how to filter the data based on another data set by using semi_join and anti_join commands in Exploratory.
Product Features
Lesson
13:16
Getting Started Tutorial Video
This video demonstrates how you can get started with Exploratory.
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.
Lesson 1
04:00 read
Chart Pinning in Exploratory makes your visual data exploration more effective and flexible. This post is going to walk you through two use cases where Chart Pinning comes in super handy.
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.
Lesson 1
02:00 read
Heatmap can be super useful when you want to see which intersections of the categorical values have higher concentration of the data compared to the others.
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:47
Introduction to Correlation Analysis
This video is about how you can quickly run correlation algorithms to find correlations among variables and categories 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