ANALYZE is one of EDA function series. It is built based on Sweetviz which is an open source Python library that generates beautiful, high-density visualizations to kickstart EDA (Exploratory Data Analysis) with a single line of code. Output is a fully self-contained HTML application.
AXCEL.VIZ.ANALYZE(data_primary, [data_secondary], [target], [skip], [set_category], [set_text], [set_numerical], [title], [deployment])
The AXCEL.VIZ.ANALYZE function syntax has the following arguments:
data_primary Required. This is the primary data which is supposed to be analyzed.
data_secondaty Optional. This is optional. If it is provided, the function analyzes and compares two datasets.
target Optional. In case the secondary data is provided and target value is defined, the function conducts its analysis based on target variable.
skip Optional. It is a vector of variable names which you would like the function to skip for analysis.
set_category Optional. It is a vector of variable names which you would like the function consider them as categorical values.
set_text Optional. It is a vector of variable names which you would like the function consider them as string or text values.
set_numercial Optional. It is a vector of variable names which you would like the function consider them as numerical values.
title Optional. By default, there is no title in the report. Otherwise, you can explicitly define the title of your graph.
deployment Optional. It is the deployment in project/name or owner/project/name format. You need to create a project by logging into your console (https://console.axcel.io) -> Project -> Create Project. After that you can use the project name in your deployment. Please note project and visualization names contain small letters and numbers only. If a project is shared with you, you should use the username of the owner in your deployment. Please visit visualization projects and sharing to learn more about this powerful feature.
when you type =AXCEL.VIZ.ANALYZE in an Excel cell, the IntelliSense guides you through required and optional (shown in  brackets) inputs. Here are examples.
Please note that since the execution time of this function is sometimes longer than 1 minute and some browsers or Excel in Mac terminate the connection after this time, this function runs asynchronously. It means that the function responds immediately but the process continues in the backend. The final result shows in the console in the task pans or in the plot area if deployment is not chosen.
In cell A1, you can run:
which pulls mtcars dataset. After that you can run:
Which produces this interactive report which you can expand it in your browser as follows:
Now, let’s split mtcars into two datasets and compare them by running this command:
=AXCEL.VIZ.ANALYZE(A1:K15,A17:K35, “mpg”,,,,,”MTCARS COMPARE”)
Here is the result expanded in the browser:
You can add deployment, to add this report for sharing and collaboration in your projects in your console.
See also Visualization Projects and Sharing