Exploratory
  • Introduction
  • Product Features
    • Summary View
    • Table View
    • Row Filter
    • Column Filter
    • Dashboard
    • Dashboard (日本語)
    • Note
    • Note (日本語)
    • Steps (Right-hand side)
    • Branch
    • Parameter
    • Parameter (日本語)
    • Export
    • Share
      • Share Type
      • Chart / Analytics
      • Data
      • Report (Note / Dashboard)
      • Notification
      • Version History
      • Restore Older Version
      • CSV API
    • Share (日本語)
      • 共有のタイプ
      • チャート / アナリティクス
      • データ
      • レポート (ノート / ダッシュボード)
      • 通知
      • バージョンの履歴
      • 古いバージョンの復元
      • CSV API
    • Schedule
      • Manage Schedules
      • Notification
      • Scheduling History
    • Schedule (日本語)
      • スケジュールの設定
      • 通知
      • スケジュールの履歴
    • Team
      • Manage Teams
    • Team (日本語)
      • チームの設定
    • Project
      • Import
      • Export
      • Search
  • Data Import
    • File Data
      • CSV / Delimited File
      • Amazon S3
      • Google Drive
      • Google Cloud Storage
      • Excel
      • JSON
      • Log File
      • Microsoft Azure
      • Stats - SAS / SPSS / STATA
      • RData / RDS
      • Parquet File
      • EDF - Exploratory
    • Database Data
      • SQL Troubleshooting
      • Create Connection
      • Amazon Athena
      • Amazon Aurora
      • Amazon Redshift
      • Amazon Redshift (日本語)
      • Google BigQuery
      • HP Vertica
      • MariaDB / MySQL DB
      • MariaDB / MySQL DB (日本語)
      • Microsoft Access
      • MongoDB
      • ODBC
      • Oracle
      • PostgreSQL
      • PostgreSQL (日本語)
      • Presto
      • Snowflake
      • SQLServer (DSN)
      • SQLServer
      • Teradata
      • Treasure Data
    • Cloud Apps Data
      • Create Connection
      • FRED - Federal Reserve of Economic Data
      • Github Issues
      • Google Analytics
      • Google Analytics (日本語)
      • Google Spreadsheet
      • Google Cloud Storage
      • Salesforce
      • Twitter Search
      • Stripe
      • Weather Data
      • Stock Price Data
    • Write R Script as Data
      • Currency Exchange Rate
    • Write R Script as Data (日本語)
    • Web Page Scraping
    • Text Input Data
    • Data Source Extension
      • Quandl
      • Holiday
      • RSS Data
    • Create Custom Data Source
  • Data Wrangling
    • Command Line mode for faster and more flexible data interaction in Exploratory
    • Select / Remove Columns
    • Reorder Columns
    • Create New Calculation
    • Create New Calculation for Multiple Columns
    • Summarize (Aggregate)
    • Group
    • Filter
    • Rename
    • Arrange (Sort)
    • Top / Bottom N
    • Join
    • Merge
    • Gather
    • Spread
    • Pivot
    • Expand
    • Complete
    • Separate
    • Unite
    • Bind Rows
    • Bind Columns
    • Keep Only Unique Rows
    • Keep Only Duplicated Rows
    • Slice
    • Drop NA
    • Sample
    • Impute NA
    • Fill
    • Create Buckets
    • Assign New Values to Existing Values - Recode
    • Assign New Values by Setting Conditions - Case When
    • Work with Categories
    • Data Type Conversion
    • Row as header
    • Ungroup
    • Unnest
    • Separate List Items into Columns (Unnest Wider)
    • Separate List Items into Rows (Unnest Longer)
    • Separate Address (Japan)
    • Hoist
    • Remove Empty Rows
    • Remove Empty Columns
    • Clean Column Names
    • Window Calculation
    • Window Calculation (日本語)
    • Add Row
    • Text Wrangling
    • Regular Expression Cheat Sheet
    • Regular Expression Cheat Sheet (日本語)
  • Visualization
    • Types
      • Pivot
      • Summarize Table
      • Table
      • Bar
      • Line
      • Area
      • Pie/Ring
      • Radar
      • Histogram
      • Density Plot
      • Scatter (No Aggregation)
      • Scatter (With Aggregation)
      • Boxplot
      • Violin
      • Error Bar
      • Error Bar (Summarized Data)
      • Map - Standard
      • Map - Extension
      • Map - Long/Lat
      • Map - Heatmap
      • Heatmap
      • Contour
      • Number
      • Word Cloud
      • Word Cloud (日本語)
    • Features
      • Trend Line
      • Reference Line
      • Repeat By
      • Window Calculation
      • Date/Time Aggregation
      • Show Range
      • Highlight
      • Change Marker
      • Multiple Y-Axis Columns
      • Layout Configuration
      • Column Configuration
      • Column Configuration Dialog
      • Color and Group Setting
      • Color and Group Setting (日本語)
      • Color Setting
      • User Color Palette Setting
      • Pin
      • Save as PNG/SVG
      • Save as Exploratory Data File
      • Share/Schedule
      • URL Link
      • Category (Binning)
      • Highlight
      • Limit Values
      • 'Others' Group
      • Edit Display Name
      • Missing Value Handling
      • Rename Column Names
      • Axis Setting
      • Axis Formatting
      • Show Detail
      • Fit to Screen (Table)
      • Number of Unique Values Check
      • Number of Unique Values Check (日本語)
  • Analytics
    • Correlation
    • Distance
    • K-Means Clustering
    • Principal Component Analysis
    • Factor Analysis
    • Correspondence Analysis
    • Linear Regression Analysis
    • Logistic Regression Analysis
    • Generalized Linear Models
    • Survival Curve
    • Cox Regression
    • Random Survival Forest
    • Decision Tree
    • Random Forest
    • XGBoost
    • Time Series Forecasting (Prophet)
    • Time Series Forecasting (ARIMA)
    • Time Series Clustering
    • Anomaly Detection
    • Word Count
    • Text Clustering with Topic Model (LDA)
    • Market Basket Analysis
    • T Test
    • T Test (Aggregated Data)
    • ANOVA
    • Wilcoxon Test
    • Kruskal-Wallis Test
    • Chi-Square Test
    • A/B Test
    • Normality Test
    • Prediction
    • Dictionaries for Text Analysis
  • Statistics
    • Correlation
    • Distance
    • Cosine Similarity
    • SVD
    • Multi Dimensional Scaling
    • T-test
    • F-test
    • Chi-square test
    • A/B Test (Bayesian)
  • Machine Learning
    • Linear Regression
    • Logistic Regression
    • GLM
    • Multinomial Logistic Regression
    • K-means Clustering
    • Random Forest
    • XGBoost
    • Forecasting
    • Time Series Clustering
    • Anomaly Detection
    • Survival Curve
    • Survival Model (Cox Regression)
    • Market Basket
    • Causal Impact
    • Evaluate Prediction - Regression
    • Evaluate Prediction - Binary
    • Calculate ROC
    • Evaluate Prediction - Multiclass
    • Prediction
    • Prediction - Binary Classification
    • Prediction - Survival Model
    • Simulate Survival Curve
    • Extract Summary of Fit
    • Extract Parameter Estimates
    • Run ANOVA Test
    • Fix Imbalanced Data (SMOTE)
  • Text Analysis
    • Tokenize Text
    • Create N-gram Tokens
    • Calculate tf-idf
    • Count Text Pairs
  • Extend with R
    • R Package Install
    • Custom R Script
    • Custom Model Function
  • Setup
    • Disable McAfee virus scan
    • Change Repository Location
    • Change Repository Location (日本語)
    • Holidays Data for Forecast
    • Possible Reasons for Install Error
    • Upgrade Microsoft .NET Framework
  • Diagnostics
    • Log file for debugging
    • Log file for debugging (日本語)
    • Startup Log file for debugging
    • Startup Log file for debugging (日本語)
    • Check version of Exploratory Desktop
    • How to Recover the History Data
  • Keyboard shortcuts
Powered by GitBook
On this page
  • Row Filter
  • Column Filter
  • Regular Mode
  • How to Use
  • Summary Panel
  • Select Columns
  • Search Columns
  • Highlight Mode
  • How to Use
  • Exit Highlight Mode
  • Correlation Mode
  • How to Use
  • Change Sample Size
  • Change Range Type
  • Change Sort Order
  • Create Analytics/Chart
  • Create Analytics with Multiple Predictor Variables
  • Exit Correlation Mode

Was this helpful?

  1. Product Features

Summary View

PreviousProduct FeaturesNextTable View

Last updated 2 years ago

Was this helpful?

At the Summary View, you can view the summary information of the selected data frame.

Row Filter

You can filter rows by the condition on Summary View. See for more details.

Column Filter

You can filter columns by the condition on Summary View. See for more details.

Regular Mode

You can view the summary of columns in the selected data frame.

How to Use

You can click "Summary" tab from the top tab menus.

Summary Panel

Header

The header area shows the column name and its data type.

Column Menu

You can click the downward button to see the column menu. It shows a list of operations you can perform against this column.

Chart

The chart area shows the data distribution of this column in a bar chart. The chart type changes depending on the data type of the column.

Metrics

The metrics area shows the metrics of the column. It shows different metrics depending on the data type of the column.

Create Chart

You can click this button to view the chart in the chart view.

Select Columns

You can select a column by clicking a panel. You can also choose multiple panels by Shift+Click or Control(Command)+Click.

After selecting columns, you can open the column menu and select an operation to perform the operation to multiple columns at a time.

Search Columns

You can search columns by clicking the "Search" icon and entering a text to the search field.

Highlight Mode

In Highlight mode, you can highlight the distribution of data that you are interested in.

How to Use

Click "Highlight" button in Regular mode.

Set the condition that you want highlight in the dialog.

You can see the data that meet the condition is highlighted in Blue color in charts.

You can click "% Ratio" to see the distribution in percentage.

Exit Highlight Mode

You can click "Close" button to exit the Highlight mode.

Correlation Mode

In Correlation mode, you can see the correlations between the target column and the other columns.

How to Use

Click "Correlate" button in Regular mode.

Select a column that you want to see the correlations with other columns. You can choose either a numeric column or a logical column.

You can see the correlations between the target column and the other columns.

Change Sample Size

If your data has a lot of rows, it automatically apply the data sampling for performance. If you want to change the sample size, select the size from the "Sample" pulldown menu.

Change Range Type

You can choose the range type for the error bars from "Range" pulldown menu. The options vary depending the data type of the target column.

Numeric target column:

  • 95% Conf. Interval

  • 99% Conf. Interval

  • 1 Standard Deviation

  • 2 Standard Deviation

  • 3 Standard Deviation

  • Interquartile Range (IQR)

Logical target column:

  • 95% Conf. Interval

  • 99% Conf. Interval

Change Sort Order

You can sort columns by the metric values. You can choose which metric for sorting from "Sort" pulldown menu. The options vary depending the data type of the target column.

Numeric target column:

  • R Squared

  • Correlation

  • P Value

Logical target column:

  • AUC

  • P Value

Create Analytics/Chart

You can create an Analytics or a Chart from the column header menu. Available Analytics and Chart types vary depending the data type of the target column and the comparing column.

Numeric target column

Chart

  • Bar

  • Error Bar

  • Line

  • Scatter (Only if a comparing column is Numeric or Date)

Analytics

  • Linear Regression

  • Decision Tree

  • Random Forest

  • XGBoost

Statistical Tests

  • T Test (Only if a comparing column has 2 unique values)

  • ANOVA (Only if a comparing column has 2 unique values)

  • Wilcoxon Test

  • Kruskal-Wallis Test

Logical target column

Chart

  • Bar

  • Error Bar

  • Line

Analytics

  • Logistic Regression

  • Decision Tree

  • Random Forest

  • XGBoost

Statistical Tests

  • Chi-Square Test

Create Analytics with Multiple Predictor Variables

You can create an Analytics with multiple predictor variables from Summary View by the following steps.

  • Choose columns for predictor variables by control(command)+click or shift+click.

  • Select an Analytics type from the column header menu.

Available Analytics types vary depending the data type of the target column.

Numeric target column

  • Linear Regression

  • Decision Tree

  • Random Forest

  • XGBoost

Logical target column

  • Logistic Regression

  • Decision Tree

  • Random Forest

  • XGBoost

Exit Correlation Mode

You can click "Close" button to exit the Correlation mode.

Row Filter
Column Filter