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. -- https://mail.python.org/mailman/listinfo/python-list
