I have a dataset in a .csv file. It's a booking file from which I have to calculate monthly revenue. The contracts vary from 1 yr to 5 yr. I would like to create a report showing what customer has how much MRR for each quarter.
Variables in the dataset are - Customer Names, Sales Order Numbers, Booking Net, Contract Start Date and End date, FY and QTR.
New to Python so not able to understand much. Any help will be highly appreciated.
question from:https://stackoverflow.com/questions/66055120/calculate-mrr-from-a-dataset-using-python