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!
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.
This post introduces you how to use K-Means Clustering feature under Analytics view to gain more insights from the clustering result. You can find the relationships among the categories and among the variables with various charts that are automatically generated under Analytics view.
Date / Time Aggregation Aggregation Methods Multiple Lines by Color Multiple Lines by Multiple Columns Multiple Charts by Category (Subplot) Trend Line Reference Line Window Calculation Methods Missing Values Handling
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.
