I need to calculate the shareholding ratio of state-owned capital behind tens of thousands of enterprises which have multi-tiered ownership structure. Can Python accurately and efficiently achieve the results I want? If not, what other methods can achieve? I would appreciate valuable and constructive suggestions from experts.
(Example: 1. A and B hold 32.28% and 3.01% of C respectively; 2. D holds 100% of B; 3. State-owned enterprises E and F hold 90.01% and 9.99% of D respectively; 4. D and F hold 75% and 25% of A respectively; 5. B holds 100% of F. What is the final combined shareholding of E and F?)
The above example is just a textual expression. I have a more concise Excel file with the equity structure of each company.

If python or other software can solve the problem I raised, please give the corresponding solution and code.