The basic need I have is to convert the codes in a MEDDRA dataset to CUIs (UMLS concept unique identifiers). If there were only 10 or so, I’d look them up on the Metathesaurus manually…but I have a dataset of 155 related to COVID-19. Once I have the CUIs, I can limit the output from…
Disable New Microsoft Office “Save As” Menu
Perhaps I’m old-fashioned, or perhaps I haven’t invested enough learning how great Microsoft Office’s new(-ish) save dialog is. Typically, when I want to save something, I want to type/paste in the path I want to save my file, or click through the folders as I’m accustomed to in Windows Explorer. I can’t really figure out…
Default Values for max and min
I rely pretty heavily on Python’s min and max function when trying to take the highest or lowest values from a particular algorithm. For example, a regular expression extracts scores (these could be grades, number of pages in a book, distance run, etc.) from an input document. The document may contain multiple scores (e.g., describing…
Simplify Project Setup with Cookiecutter
Nearly every time I kick-off a new Python project, I follow the same set of steps: And then I feel about ready to grab some lunch or call it a hard-worked day at the office. Each time I follow these steps, I have realized that this should be automated. In fact, the only non-automatable part…
Outlook: Improve Delay Delivery (Part 2)
A couple months ago, I wrote up an initial implementation of adding a button to Outlook that would allow me to ‘delay delivery’. I took the basics of the code from a SuperUser post and turned it into a macro. Basically, the VB code checked to see if I was sending the email at weird…
Install Package from within Jupyter Notebook
I often use Jupyter Notebooks, usually from within the (default) web browser interface, though I’ve been increasingly liking the direction that PyCharm’s interface has been going (e.g., see the feature page: https://www.jetbrains.com/pycharm/features/scientific_tools.html). One of the problems I regularly encounter, however, is that some package (e.g., pandas) is not installed on whichever virtual environment I’m using….
Non-technical Guide to Running a Docker Project
This guide will lead you through the steps to install and run an existing Docker project using docker-compose.yaml, but provides no help in starting a Docker project from scratch. Also, it assumes you are using Windows. Step 1: Enable Virtualization The Windows features ‘Containers’ and ‘Hyper-V’ must both be enabled. To check if this is…
ERROR: Not a supported wheel on this platform
Installing spacy on a new Windows 7 virtual machine, and running into trouble (per usual). The appropriate way to do this is to usually to install Build Tools, but it always seems quicker to grab the necessary wheels from Christoph Gohlke’s website: https://www.lfd.uci.edu/~gohlke/pythonlibs/. Selecting the appropriate set under spacy along with cytoolz and sometimes ujson….
Configuring TensorFlow to use GPU on Windows
A couple years ago, I had attempted to get involved in Tensorflow/Keras but go waylaid with a few projects. Anyway, I have a new use case to be able to touch my toe in that water (more to come). The configuration is not difficult, but can be time consuming, so I thought it worth recording…
Outlook: Improve Delay Delivery
I use Outlook’s ‘delay delivery’ feature frequently when working at odd hours (or when I’d prefer to not get an immediate response). I don’t really want to set an expectation that I’ll answer/respond to email over the weekend or at 11pm. (It can also be useful to ensure that the email is at the top…