Customer-Retention-Revenue-Health-Dashboard-SQL-Python-

import pandas as pd import numpy as np

np.random.seed(42)

Create customers

n_customers = 200

customers = pd.DataFrame({ "customer_id": range(1, n_customers + 1), "company_name": [f"Company_{i}" for i in range(1, n_customers + 1)], "industry": np.random.choice(["Tech", "Finance", "Retail", "Healthcare"], n_customers), "signup_month": np.random.randint(1, 13, n_customers) })

Create subscriptions

subscriptions = pd.DataFrame({ "subscription_id": range(1, n_customers + 1), "customer_id": customers["customer_id"], "monthly_revenue": np.random.randint(50, 500, n_customers), "churned": np.random.choice([0, 1], n_customers, p=[0.75, 0.25]) })

customers.to_csv("customers.csv", index=False) subscriptions.to_csv("subscriptions.csv", index=False)

print("Data generated successfully.")