Hierarchical consolidation in Python

ap501228 at gmail.com ap501228 at gmail.com
Thu Sep 18 10:57:17 CEST 2014


I am looking for some tips as to how Python could be used to solve a simple business problem involving consolidation of financial data across a company  with a number of business units rolling up to a department and departments rolling up to the whole organization.

Company = Department(1)+Department(2)+...Department (N)
Department(1)= Unit(1,1)+Unit(1,2)+...+Unit(1,K)
...
Department(N)= Unit(N,1)+Unit(N,2)+..+Unit(N,K)

Suppose,for each unit, Unit(i,j) we have a time series of 3 variables:

Income(i,j) , Expenses(i,j) and Surplus(i,j) = Income(i,j)- Expenses(i,j) 

Required to find:

(1)Income, Expenses and Surplus consolidated for all units within a Department; and
(2)Income, Expenses and Surplus consolidated for all departments within the company.

I would welcome any help in expressing this problem directly in Python. Also, are there any Python modules or packages that enable problems of this type to be solved. Thanks in advance for any help.



More information about the Python-list mailing list