Pandas install on ERPnext VM

[Azhar_Umar]

@aakvatech Can you help me define columns and data for my little project here?

Trying to create Script Report using Pandas

I am trying to create a script report that will show me a week-wise summary of payment requests per supplier, using Pandas. I have written the following code to get get the output in Pandas DataFrame: import frappe import pandas as pd from erpnext.accounts.utils import get_balance_on def test(): pass def execute(filters=None): pr = frappe.db.get_list("Payment Request",filters={"docstatus":1,"status":"Initiated","party_type":"Supplier"},fields=["name", "transaction_date", "payment_re…