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
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.
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.Last updated