dgorissen / pycel

A library for compiling excel spreadsheets to python code & visualizing them as a graph
GNU General Public License v3.0
573 stars 152 forks source link

Create an optimization function which processes the graph and convert… #144

Open tarkmeper opened 2 years ago

tarkmeper commented 2 years ago

This pull request isn't in any way ready for merging but is more of an idea I'd like to get feedback on and if this is something you'd consider for inclusion in Pycel before putting in more effort to get it into that shape.

The code creates an optimized version of the logic based on the desired inputs/outputs. It traverses the graph and merges all the python_code text into a single function that is dynamically created and returned. Very simple functions can also be optimized with Numba to allow for compiler optimizations.

On my computer on a simple test case:

Todos:

dgorissen commented 2 years ago

Very cool. Looks useful to me though I no longer have the bandwidth to actively review and test pycel contributions in detail. @stephenrauch has been closer to the repo and logic so can let him wade in.

amankagarwal commented 1 year ago

Looks very cool @tarkmeper - was wondering if you ever got this working end-to-end, would love to try it out!