How To

English | 日本語
All
Getting Started
Data Source
Visualization
Data Wrangling
Analytics
Reporting
SQL Troubleshooting
This blog post explains known issues and workarounds for the issue related to SQL query to import data from Databases
How-to Team Exploratory Data Source Amazon Athena Sql Data Wrangling Troubleshoot
How to export Boxplot statistics information as Excel / CSV
This post explains a way to export your Boxplot stats number as Excel / CSV.
How-to Data Wrangling Team Exploratory Boxplot Export Excel Csv
How to perform One-Hot Encoding for Categorical Columns
This post explains a way to perform One-Hot Encoding for Categorical Columns
Team Exploratory Data Wrangling How-to One-hot Encoding
How to merge multiple data frames
This post explains how to merge multiple data frames into single data frame.
Team Exploratory Merge Data Wrangling How-to Data Frame
How to replace existing column values with new values
It explains how to replace existing column values with new values
Data Wrangling Team Exploratory Recode How-to
How to extract text from certain position
This blog post explains how to extract a range of text from using positin.
Team Exploratory How-to Data Wrangling Extract Text
Reverse Geocoding Part 1 — Using Boundary Data with GeoJSON
Finding locaitons from logitude/latitude data using boundary data with GeoJSON
Team Exploratory Visualization Data Wrangling How-to
How to create a new column based on existing column and conditions
This blog explains a way to create a new column based on existing column and conditions.
Data Wrangling Team Exploratory How-to Case_when
How to extract text between parentheses
This blog post explains how to extract text between parentheses
Team Exploratory How-to Data Wrangling Extract Text Regular Expression
How to Winsorize Numeric Values
How-to Team Exploratory Data Wrangling Normalize Outlier
How to Check Whether the Value is NA or Not.
Explains How to Check Whether the Value is NA or Not.
Team Exploratory How-to Data Wrangling
Calculating Dates Between Orders
Team Exploratory How-to Data Wrangling Date Summarize Window Calculation
Exploratory v5.0 Released!
Learn what's new in Exploratory v5.0! New UI & Design, new data wrangling UIs, Decision Tree, Market Basket Analysis, K-Means Clustering, Chart Pinning, and more!
Team Exploratory How-to Data Wrangling Visualization Analytics Dashboard
An Introduction to Parameter in Exploratory
Team Exploratory How-to Parameter Data Wrangling Dashboard
Geocoding US Address Data with Zipcode package
Team Exploratory Geocode Map Join Data Wrangling How-to Unique Row Text
Reverse Geocoding Part 2 — Using Google Maps APIs
Finding locations from longitude/latitude data by using Google Maps APIs.
Team Exploratory Visualization Data Wrangling How-to
How to Create Table 1 Summary Information
Team Exploratory How-to Data Wrangling Tableone
How to Create a Pivot Data
Team Exploratory Data Wrangling Pivot How-to
Create Weighted Histogram Manually
Team Exploratory How-to Data Wrangling Visualization Histogram Binning
How to Count Number of Rows for Each Categorical Value
Team Exploratory How-to Data Wrangling Group_by Summarize
How to Transform Long Data to Wide Data with Spread Command
Introducing how to transform the Long data to the Wide data with Spread Command.
Team Exploratory How-to Data Wrangling
Manually Changing The Pivot Table Column Order The Way You Want
Team Exploratory Data Wrangling Factor How-to
Percent Total Calculation for Each Group or for All
Team Exploratory Data Wrangling Window Calculation How-to
Visualizing a Dramatic Increase of Opioid Addicted Mothers Giving Birth
Team Exploratory Opioid Epidemic Visualization Data Wrangling How-to
Importing and Visualizing Central Bank Historical Interest Rates with BIS
In this post, you will learn how to:

1. Install BIS Package
2. Write R Script with BIS Package to Download Data
3. Clean Up Data to Convert Text to Date
4. Visualize Data
5. Categorize Numeric Values / Create Bins
6. Handle Missing Values in Chart
Team Exploratory Visualization Data Wrangling Data Source How-to
Places Anthony Bourdain Traveled To
Separate to Columns, Country Mapping with countrycode function, Unite Multiple Columns, Recode Country Names, Fixing Title name with if_else function, Visualizing Map with LInes, etc.
Team Exploratory Data Wrangling Visualization Map How-to
An Introduction to Timezone Support in Exploratory
Learn how you can find the time zone used for your data and how to convert and fix the time zone.
Team Exploratory How-to Data Wrangling Time Zone
How to Calculate Cumulative Sum Only for the First 5 Years
Team Exploratory How-to Data Wrangling Window Calculation
How to concatenate values from multiple columns when there is NA
Team Exploratory How-to Data Wrangling Missing Value
Renaming Column Names for Multiple Columns Together
Team Exploratory How-to Data Wrangling
Applying Filter Condition to Multiple Columns Together with filter_at/filter_if Commands
Team Exploratory How-to Data Wrangling
How to Calculate Percentilefor Each Group
You will learn how to use R's quantile function to calculate the percentile with Group By and Summarize steps.
Team Exploratory How-to Data Wrangling
How to Calculate Percentile Ranks in Exploratory
Team Exploratory How-to Data Wrangling
5 Most Common Data Wrangling Operations with Date & Time Data
In this post, you will learn how to do the following tasks in Exploratory:

1. Convert Characters to Date & Time
2. Extract Date & Time Attributes like January, Monday, etc.
3. Calculate Duration Between Two Different Dates
4. Filter Data based on Date & Time Values
5. Round Date & Time Values
Team Exploratory Data Wrangling How-to
Cohort Analysis by Pivot Table and Layer Cake Graph
How-to Team Exploratory Data Wrangling Analytics
Add Total Column and Total Row to Table Data
I'll explain two ways to add Total Column and Total Row. One is to use Pivot Table under Viz, and another is to create a data wrangling step to calculate them and make that as part of he base data itself.
Team Exploratory Data Wrangling How-to
How to order a column based on the data in the other column
This article describes how to order a column based on the data in the other column.
How-to Team Exploratory Data Wrangling
How to setup default timezone for SQL query result for timestamp column
This blog explains how to setup a default timezone for query result for timestamp column.
How-to Team Exploratory Data Wrangling Timezone Data Source Postgresql
Clean Column Names default beavior is changed in Exploratory Desktop v4.4
This blog post explains the Clean Column Names default beavior changes made for v4.4 and also explains a way to use old way of column name clean up.
How-to Team Exploratory Data Wrangling
Getting Each Customer's Last Order Date
Team Exploratory How-to Data Wrangling
How to convert Excel Numeric Dates to Date Data Type in Exploratory?
You will learn how to convert Excel numeric dates used in the column names to Date data.
How-to Team Exploratory Data Wrangling Excel
No search result found