Utility

This tab allows to create and list the python scripts (.py files) that can be imported to your notebook.

Check out this walk-through on how to import a Utility scrip file to the DS Lab Project.

Importing a Utility Script file

Importing a Utility Script

• Navigate to the Utility tab for a Project.

• Click the Add Script option.

• The Add utility script page opens.

• Select the Import Utility option.

• Provide a Name for the Utility script.

• Provide description for the Utility script.

• Use the Choose File option to import a Utility file from the system.

• After the file gets imported from the system, the file name appears next to the Choose File option.

• The Save option will be enabled, click the Save option.

• A notification message appears.

• The imported script gets added under the Utility tab.

Importing the Utility Script inside a Notebook

• Copy a utility script name using the Utility list.

• Navigate to the Notebook tab.

• Upload a Notebook or create a new Notebook and Navigate to the Notebook page.

• Add a Code cell.

• Write code to import data with specific class.

• Provide the Utility script as the resource to get data.

• Specify the variables to get the class and get the data in the next code cell.

• Provide print function to see the data.

• Run all the cells.

• You can get the output below.​

Updating the Utility Script

• Navigate to the Utility tab.

• Select an uploaded utility script from the list.

• Click the Edit icon.

• The Update Utility Script page opens displaying the utility script content.

• Click the Validate option.

• The Logs will be displayed in the Logs space.

• Click the Update option.

• A success message appears.

• The selected Utility script gets updated.

the Utility Script get updated.

Please Note:

• The name of the selected utility script cannot be changed by using the update option.

• Refer the Data Science Lab Quick Start Flow page to get an overview of the Data Science Lab module in nutshell.

• The user can also import a Utility file by using the Utility option provided inside a Notebook. Refer the Utility Notebook Operation page to understand it in details.

Sample Utility Script

Please use the below-given sample Utility script to explore and use the Utility option provided in the Data Science Lab.

# importing employee.py as a module in DS Lab Notebook.

import employee
import time
import logging
import pandas as pd
from pymongo import MongoClient

def run_scripts(conn_str, database, collection):
    conn_str = conn_str
    database = database
    collection = collection
    client = MongoClient(conn_str)
    db = client[database]
    collection = db[collection]
    res = employee.emp_data()
    
    for i in res:
        salary = i.get('salary', 0)
        i['status'] = 'rich' if salary > 50000 else ('middle_class' if 25000 < salary < 50000 else 'poor')
        logging.info(i)
        print(i)
    collection.insert_many(res)
    print(f"Inserted {len(res)} rows into MongoDB")
    logging.info(f"Inserted {len(res)} rows into MongoDB")
    
#The variable 'res' in this script holds the results derived from the code written in the utility file.