Site Search
Search results
Migrating from Excel to Python and MongoDB in LUX-ZEPLIN
Migrating from Excel to Python and MongoDB in LUX-ZEPLIN … Mike Jackson , Software Architect In Using Excel for data storage and analysis in LUX-ZEPLIN , I summarised how Excel is both used and managed within the LUX-ZEPLIN …
Read moreTips for porting formulae from Excel into code
Tips for porting formulae from Excel into code Posted by s.aragon on 10 … 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 …
Read moreA journey of reproducibility from Excel to Pandas
A journey of reproducibility from Excel to Pandas Posted by s.hettrick on 6 … in reproducing analysis that was originally conducted in Excel, and it’s testament to the power of a tweet that’s … to what they know and - like so many researchers - I knew Excel. The analysis took a few days of fairly laborious …
Read morePresentations on Excel meets Lambda now available
Presentations on Excel meets Lambda now available Posted by … we have various presentations introducing LAMBDA in Excel. LAMBDA is a new feature of Microsoft Excel that allows you to define custom functions using …
Read moreResources for using spreadsheets in research and moving onto other tools
… episode wrong tools cost lives discusses: ‘Microsoft Excel is great for business accounts… but maybe don’t … version of the off-the-shelf spreadsheet software Microsoft Excel. The result was disastrous.’ Watch this … the programming possibilities opened up by LAMBDA in Excel - new feature that allows you to define custom …
Read moreAzure training in Manchester and online Excel in Research training
Azure training in Manchester and online Excel in Research training Posted by … event . There will also be a live webinar on using Excel for Research on 26 February 2014 - register for free …
Read moreWorkshops and presentations
… Presentations Excel meets Lambda Andy Gordon from Microsoft … the programming possibilities opened up by LAMBDA in Excel – the world’s most widely used programming …
Read moreProgramme for the Research Software Camp: Beyond the spreadsheet
… the Camp 26 October 10:00 AM Excel meets Lambda – Andy Gordon, Jack Williams, and …
Read moreTop tips on software for data visualisation
… and easier to try out new packages. 2. Break away from Excel! Excel is great for quick plots and interactivity, but not so …
Read moreIntroducing pydbgen: A random dataframe/database table generator
… object, or as a SQLite table in a database file, or in a MS Excel file. How to install it? It’s (current … Image by Tirthajyoti Sarkar. How to generate an Excel file? Similar to above, just use the following code to generate an Excel file with random data. Note the 'simple_phone' set is …
Read more