“Everyone likes the convenience of online shopping, and no online store is more popular than Amazon.com. Now imagine if you could get just about anything on Amazon.com for free. How would your life change? This has been my life for the past two months after I became a professional undercover Amazon.com reviewer. In the process, I gained a lot of insight into how global markets work, why everything seems to be made in China and applied what I learned in school about game theory scenarios to my new career.”
Situation: I’m running a contest and I have an introduction slide for each participant in a separate deck. I want the slides to show up in the random order from when it was created. More generically, you have a Powerpoint deck and you want the whole thing resorted into a random order. Here is a link to an article that provides instructions and code to do that.
Here is a Powerpoint file with the code embedded as an example.
Note that this will shuffle allthe slides in a file.
This will work using the current version of Powerpoint on both Mac and Windows (2016).
This method will randomize your slides without having duplicates.
If you have a bunch of slides and you want them to appear in a random sequence but don’t care if there are repeats, check out this article.
Here is a Powerpoint file with the macro already created.
Easy way to use Google geocoding through Excel:
A very simple example for doing a shortest path query using Neo4j. Written by Khalid Abuhakmeh on his blog.
Overall the blog “Life is Short – You Need Python” is really informative. Lot of great tips and tricks. He’s posted a simple case of parsing XML in python as an example. PDF: Simple and easy XML parsing with lxml _ life is short – you need Python!
Article on several different ways to connect R-project to Excel, published on The R Trader Blog.
An Introductory guide to the XML package for R-Project, written by Duncan Temple Lang
Besides the XML package, Omega Project for Statistical computing has a number of other R-Project packages that look very interesting, like KML, Python, and WordPress packages.
Code example of how to get the current directory, change directories, and set the output to someplace specific – designed to work on both windows and unix.
# Finds the directory that a program was run from, change the directory
# and creates an output file within a subdirectory. This code is designed
# to run on both mac and windows.
# what is the current working directory? notice the difference when running
# from unix/mac verses windows
# change the current working directory. use forward slash regardless of unix
# or windows
# create a file in a subdirectory from the current working directory
# this method makes the results operating system agnostic
# each entry in the parameters is the next directory level, ending with the
# file name os.path.join inserts the appropriate separators
file_path = os.path.join(wd,"xml","output.xml")
# file is now open as 'f'