Python for Spreadsheet Manipulation 102 - Hands-On Training for Salesforce Admins
Thanks for coding for THREE HOURS with me in temperatures barely above zero!
Table of Contents
My philosophy still stands: PLEASE get Python up and running on your computer.
You have enough experience now to give Python a try before you forget … but it’s not safe to punch your business data into an online “IDE” like Repl.it or CodeBunk, so please install a way to write and run Python on your own computer!
- Your homework is to get an “IDE” set up and to copy/paste the “Hello World” program and the “read a CSV file off the internet and print stuff out about it” program onto YOUR computer, running them from there.
As soon as you have both of those code snippets up and running, the world is at your fingertips!
Tweet me when you get it – #AwesomeAdmin & #YayUs !
- For Windows computers on which I have “admin” rights to properly install software, I’ve really enjoyed working with “Anaconda,” which both installs Python plus its “Pandas” plugin on your computer (so that an IDE’s “run button” actually does something – your computer doesn’t come “out of the box” understanding Python code) and installs the “Spyder” IDE (the actual text-editor-with-run-button).
- For Windows computers on which I don’t have permission to install software, I’ve made good use of these directions for installing WinPython. Note that without administrator rights, you might not be able to update certain components of Windows to support the latest version of WinPython, which I address in the directions, but older versions of WinPython make your computer only understand commands from older versions of Python and its Pandas plugin, which might leave you Googling for how things “used to be done” in cases where the way Python code is written has gotten simpler and easier to use as time goes on.
- Some people also like PyCharm. (Definitely seems available for Windows & Mac…)
- Linux / Mac: I … don’t have either of those. Try Anaconda – it seems to be available for both.
DM me on Twitter if you get stuck.
Exercises We Did
Click here for the “Exercises” instructions
Click here to download a PDF of the slides
The links have changed! The links in the session recording are no longer guaranteed to be accurate! If they no longer work, or seem to be doing something different, it’s because I reused them for another presentation!
Replacement links are available with a “yyyymm-“ datestamp after the “sfpy” but before the rest of the URL.
Some are “201810” because I was able to reuse them from an earlier session; others are “201901” for today’s new links.
(Click here for session video)
- A real-life example of “vertical concatenation” (using a new command, “
.stack(),” that’s very similar to “
pandas.concat()“) for Salesforce
- Official documentation of Pandas commands
- Quick Examples of the sort that we went over in class, with a “homework” exercise for each problem