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.
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.