Tips for porting formulae from Excel into code

Porting formulaeBy Mike Jackson, Software Architect

As part of my open call consultancy for LUX-ZEPLIN (LZ), I looked at how LZ could migrate their data and computation from Excel to MongoDB and Python. There are many resources with valuable advice on cleaning data in Excel into a form suitable for analysis using Python, R or other data analysis packages. Unfortunately, how to handle formulae and cross-references is little discussed.

Based on my experiences, I have written a guide on “Tips for porting formulae from Excel into code” in which I provide some (hopefully) helpful hints on how to identify and highlight formulae and cross-references, which can help when porting these to Python or R, and to restructure tables so that raw data is contiguous, and so is easy read by data analysis packages or to export into a database or files. Feedback, suggestions and additional advice is more than welcome.

Feel free to add these as comments!


Posted by s.aragon on 10 October 2017 - 10:29am

Submitted by play game on 13 October 2017 - 9:42am


It is the best game forever in the amazing tank trouble game for you my friends so create the best score on the online i like to play this online it is the most intersting site in the game world i trust you create the high score thanks for the play this online.

I use the G8 and are practicing estimates 1 buildings from the original estimation file excel.

When you enter the paraphrase mass of items, their copy from excel file to the G8, the font is corrupt.

The font of flie excel estimation is VnTime.

Note that just failed to copy from excel into Vietnamese font also knocked out the G8 still read normal. Used in the download Installer 4.0.

I tried copy and then turn quickly transcoding of Unikey 4.0 still fails font.

nodejs quiz

Add new comment

The content of this field is kept private and will not be shown publicly.
By submitting this form, you accept the Mollom privacy policy.