SciPyR (Custom) Analysis
Contents
Overview
Infoveave offers advanced analytics with custom analysis, to design unique analyses using programming language Python. This capability enables you to run large statistical models and enhance various operational components, making it easier to build plans, strategies, and campaigns with greater accuracy and foresight.
Note
- Use the search option to look for any existing SciPyR analysis.
- Use the Filter by Datasource/Mode option to filter the SciPyR analysis based on the Datasource or production mode.
- To switch the view between Card View and List View, click on the respective icons near to the search bar.
- To create a New Folder in the SciPyR click on the Folder icon.
- To download the list of all existing SciPyR analysis, click on the Download icon. It delivers the details on (• Entity Id Name • Description • Content Tags • Created By • Created By User • Created On • Folder • Datasource Id • Datasource Name • Is Folder Public)
SciPyR Layout
The SciPyR Workbook empowers you to explore complex data sets, build predictive models, and conduct data-driven decision-making.
The SciPyR Workbook in Infoveave is divided into three main sections:
- Task Panel: The Task Panel provides a list of all the tasks that have been configured in the workbook. It serves as a navigation tool, allowing you to easily switch between different tasks created within the workbook. Each task represents a specific action or process in the analysis.
- Workbook: The Workbook section is where you conduct your custom analysis. It provides you with the flexibility to choose between two modes: Markdown and Code. In the Markdown mode, you can Markdown to add explanations, descriptions, and annotations to your analysis. In the Code mode, you can write and execute code using R and Python, which enables you to perform sophisticated statistical modeling and data analysis.
- Setup Panel: The Setup Panel offers valuable information about the installed packages and the details of variables present in the workbook. This helps you understand the environment and resources available for your analysis.
Create Custom Analysis
Steps to use SciPyR workbench
To perform SciPyR analysis in Infoveave, follow these steps:
- Access the SciPyR Analysis section by clicking on Analysis SciPyR.
- You will see a list of all SciPyR analysis, including those created by you or shared with you.
- To create a new SciPyR book based on Python, click on New SciPyR Book. The Add Book dialog box will display.
- Assign a Name for SciPyR Workbook.
- Click on Save to start creating your custom analysis in Infoveave. This will directly take you to the SciPyR workbench.
Note
- You can select the checkbox option on Optional Upload of Jupyter Book to upload a Jupyter notebook file directly.
- For Jupyter Notebook uploads, it's essential to note that Infoveave only accepts .ipynb files.
- When using the Jupyter Notebook the workspace will be loaded with the content.
- Upon opening the SciPyR Workbook, you can begin writing your Python program directly in the Workbook.
- To start writing your Python program, select the default cell and start writing your Python program.
- To expand your analysis, add new cells by simply clicking the plus icon near the drop-down.
- Use the drop-down menu in the Workbook to select “Code” when writing Python code and “Markdown” when adding headings or titles.
Note
- When you add a title using Markdown in the SciPyR Workbook, it will be automatically saved as a task under the Task Panel.
- During Python coding, any comments you include in the code will also be automatically added as a task in the Task Panel.
Tip
- Use the Task panel to not only keep track of the progress but also enables easy referencing and access to specific code segments as tasks.
- To insert SQL queries on datasources into the SciPyR Workbook, follow the below steps:
-
- Click on the ‘Insert Query‘ icon in the SciPyR Workbook.
- From the dropdown menu, select the desired data source that contains the SQL data.
- Write the SQL query you need in the provided workspace area.
- Click on the ‘Play’ icon to execute the SQL query and see the results.
- If you want to insert the query to the SciPyR Workbook, click the ‘Save‘ button after executing the query. This will insert the query and its results into the Workbook for further analysis and reporting.
Note
When you utilize the "Insert Query" feature to add a query into the SciPyR Workbook, it will be automatically inserted in the following syntax:
df = infoveave.query("34e44add-3bae-4ae6-a096-9888c52ada29") df: This is the variable name chosen to store the data retrieved from the query. It stands for "DataFrame," which is a data structure used in Python to store tabular data.infoveave: This is an object or module in Python that provides access to the Infoveave platform's functionalities, including data querying.query: This is a method or function within theinfoveavemodule that is used to execute a data query. It takes the query address as an argument."34e44add-3bae-4ae6-a096-9888c52ada29": This is the unique address or identifier of the specific query within Infoveave. It acts as a reference to locate and fetch the desired data from the dataset associated with that query.
infoveave.query() function is called with the query address as an argument. Infoveave then retrieves the data associated with that query and stores it in the variable df as a DataFrame, which can be further manipulated and analyzed using Python's data analysis libraries.
Tip
- The "Date" option in the Insert Query dialog box will appear based on the structure of your query. If your query includes date-related data, you'll be able to select the "Date" option to handle date values appropriately within the SciPyR Workbook
- To execute individual cells, simply select the cell and click on the Run icon .
- You can also run the entire set of cells together by clicking the icon, to execute the complete analysis.
- To refresh the kernel, click on the icon.
-
- You have the flexibility to add cells above or below existing ones, move cells around, copy/duplicate cells, and delete cells to customize your analysis as needed.
- To access the Task panel, click on the Task panel icon.
-
- The Task Panel in Infoveave displays a list of all tasks that you have configured within the workbook.
- Each task is represented by a title or heading, which can be added using the “Markdown” option in the Workbook.
- To access the Setup panel, click on the Setup panel icon.
- The Setup Panel in Infoveave presents important details related to the SciPyR Workbook. Here, you can find information about the packages installed and the variables present in the Workbook.
- You can also view the tables generated (if any) from variables section.
- To save the analysis, click Save.
- Got to Analysis SciPyR Analysis to see the saved analysis.
