Define SciPyR Models

Infoveave supports custom analysis with Python, on the SciPyR workbench to run large statistical models. The SciPyR workbench makes it easier and more accurate to build out custom analysis over the Infoveave Datasources.

Steps to use SciPyR workbench

Access SciPyR Workbook

To perform SciPyR analysis in Infoveave, follow these steps

1. 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.
2. To create a new SciPyR book based on Python, click on New SciPyR Book. The Add SciPyR Book dialog box will display.

Select Python Workbook

Initiate the creation of a new Python Workbook by providing a unique name.

1. Assign a Name for SciPyR Workbook.
2. Click on Save to start creating your custom analysis in Infoveave. This will directly take you to the SciPyR workbook.
3. Upon opening the SciPyR Workbook, you can begin writing your Python program directly in the Workbook.
4. To start writing your Python program, select the default cell and start writing your Python program.
5. To expand your analysis, add new cells by simply clicking the plus icon near the drop-down.
6. Use the drop-down menu in the Workbook to select Code when writing Python code and Markdown when adding headings or titles.

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.

Tip

Use the Activity panel to not only keep track of the progress but also enables easy referencing and access to specific code segments as activities.

Note

• When you add a title using Markdown in the SciPyR Workbook, it will be automatically saved as a activity under the Activity Panel.
• During Python coding, any comments you include in the code will also be automatically added as a activity in the Activity Panel.

Connect to Datasource for Exploratory Data Analysis

Integrate SQL queries written over Datasources in Infoveave, to your analysis through the Insert Query feature.

To insert SQL queries on DataSources into the SciPyR Workbook, follow the below steps

1. Click on the Insert Query icon in the SciPyR Workbook.
2. From the dropdown menu, select the desired data source that contains the SQL data.
3. Write the SQL query you need in the provided workspace area.
4. Click on the Play icon to execute the SQL query and see the results.
5. 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.

To edit the inserted query

Click on Edit Query icon .

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

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.

Build Model & Generate Insights

Customize your analysis by adding, editing, and running cells, focusing on building your machine learning model within the SciPyR Workbook. Utilize the flexibility of manipulating cells to refine and tailor your analysis, leading to the generation of valuable insights from the data.

1. Customize the analysis by adding and editing cells within the SciPyR Workbook.
2. Incorporate Python code specific to your analysis requirement.
3. Execute individual cells, by simply select the cell and click on the Run icon .
4. You can also run the entire set of cells together by clicking the icon, to execute the complete analysis.
5. To refresh the kernel, click on the icon.
6. To save the SciPyR as a PDF file in the local storage, click on View PDF button.
7. To save the analysis, click Save. 8* Go to Analysis SciPyR to see the saved analysis.

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.

Note

• The Edit query option is functional only when a query has been inserted into the specific cell.
• The Activity Panel in Infoveave displays a list of all activities that you have configured within the workbook.
• Each activity is represented by a title or heading, which can be added using the “Markdown” option in the Workbook.
• The Setup Panel shows the information about the packages installed and the variables present in the Workbook.
• You can view the tables generated (if any) from variables section.