This blog post explains known issues and workarounds for the issue related to SQL query to import data from Databases
This post explains a way to export your Boxplot stats number as Excel / CSV.
This post explains a way to perform One-Hot Encoding for Categorical Columns
This post explains how to merge multiple data frames into single data frame.
It explains how to replace existing column values with new values
This blog post explains how to extract a range of text from using positin.
Finding locaitons from logitude/latitude data using boundary data with GeoJSON
This blog explains a way to create a new column based on existing column and conditions.
Explains How to Check Whether the Value is NA or Not.
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!
Finding locations from longitude/latitude data by using Google Maps APIs.
Introducing how to transform the Long data to the Wide data with Spread Command.
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
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.
Learn how you can find the time zone used for your data and how to convert and fix the time zone.
You will learn how to use R's quantile function to calculate the percentile with Group By and Summarize steps.
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
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.
This article describes how to order a column based on the data in the other column.
This blog explains how to setup a default timezone for query result for timestamp column.
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.
You will learn how to convert Excel numeric dates used in the column names to Date data.
No search result found