Bazimo_Get_export_Lots.ipynb

Kernel: Python 3

Bazimo - Get export Lots

Give Feedback | Bug report

Tags: #bazimo #pm #naas_drivers #asset #scheduler #naas #csv #operations #automation

Author: Florent Ravenel

Last update: 2023-04-12 (Created: 2022-03-02)

Description: This notebook allows you to quickly and easily export large amounts of data.

Input

Import library

from naas_drivers import bazimo
import naas

Setup Bazimo

# Credentials
bazimo_email = "bazimo_email"
bazimo_pwd = "bazimo_pwd"

# Export name
bazimo_export = "Lots"

# Export output
csv_output = f"Export_{bazimo_export}.csv"

Schedule your notebook

# Get your data updated everyday 15 min from 9 to 20 during week days.
naas.scheduler.add(cron="*/15 9-20 * * 1-5")

# -> Uncomment this line and run the cell to delete your scheduler
# naas.scheduler.delete()

Model

Get export

df_bazimo = bazimo.connect(bazimo_email, bazimo_pwd).exports.get(bazimo_export)
df_bazimo

Output

Save dataframe in csv

df_bazimo.to_csv(csv_output)

Share your dataframe with naas

-> You can integrate the link below into your Excel spreasheet. Check the procedure here

naas.asset.add(csv_output)

# -> Uncomment this line and run the cell to delete your asset
# naas.asset.delete(csv_output)