Untitled

import pandas as pd

# Data for the agents
data = {
    "Agent": ["Nikhil", "Manasi"],
    "Leads Assigned": [500, 500],  # assuming both got 500 leads for comparison
    "Sign-ups": [6, 6],
    "Deposits": [1, 2]
}

# Create DataFrame
df = pd.DataFrame(data)

# Calculate conversion rates
df["Sign-up Conversion %"] = (df["Sign-ups"] / df["Leads Assigned"] * 100).round(2)
df["Deposit Conversion %"] = (df["Deposits"] / df["Leads Assigned"] * 100).round(2)
df["Deposit-to-Signup %"] = (df["Deposits"] / df["Sign-ups"] * 100).round(2)

import caas_jupyter_tools
caas_jupyter_tools.display_dataframe_to_user("Lead Conversion Sheet", df)