I had to retrieve data from multiple .xlsx files with multiple sheets. This can be done manually, but it will be rather time-consuming tasks, plus Office quotes text fields, which is not very convenient for downstream analysis…
I have found handy script, xlsx2tsv.py, that does the job, but it reports only one sheet at the time. Thus, I have rewritten xlsx2tsv.py a little to save all sheets from given .xlsx file into separate folder. In addition, multiple .xlsx files can be process at once. My version can be found on github.
While updating matplotlib I got an error: * The following required packages can not be built: * freetype.
To solve the issue, you should install two packages:
# install missing packages
sudo apt-get install libfreetype6-dev pkg-config
# update matplotlib
sudo pip install matplotlib –upgrade
Solution found on github.
Today I’ve faced problem with syncing two github repositories. Yes, I know, I shouldn’t keep two, but sometimes it’s difficult to avoid. Anyway, the problem is super easy to solve. It’s enough to edit `.git/config` by adding new remote:
url = firstname.lastname@example.org:user1/repo1.git
url = email@example.com:user2/repo2.git
Of course, more than two repos can be added. Then, after next push all repositories will be synced.
git push Origin master
Counting objects: 61, done.
Delta compression using up to 4 threads.
Compressing objects: 100% (61/61), done.
Writing objects: 100% (61/61), 5.73 KiB | 0 bytes/s, done.
Total 61 (delta 41), reused 0 (delta 0)
8b97528..8aed8c2 master -> master
Inspired by ruiabreu.
Creating reference list is always a nightmare. Mendeley and its handy LibreOffice / OpenOffice plugin may be of great help to many. It was for me. Below, I’ll describe how to make it working.
# get & install mendeley from https://www.mendeley.com/download-mendeley-desktop/
# check version of your mendeley
# Help > About Mendeley Desktop
# clone repo and build plugin
git clone firstname.lastname@example.org:Mendeley/openoffice-plugin.git
python build.py 1.15.2 false
# add to LibreOffice
# Tools > Extension Manager > Add…
# and look for `Mendeley-1.15.2.oxt`
After OpenOffice / LibreOffice restart, you should see new bar. Note, in order for the plugin to work, Mendeley has to be running.
What’s great about this plugin, you can adjust citation style by just a few clicks by clicking on `Choose Citation Style`. There is quite extensive database of predefined citation styles, so adjusting the reference style to your favourite journal will take just a few seconds 🙂
More info about the plugin on github.
More weekend oriented tip today;)
I have found downloading videos from youtube super easy with youtube-dl.
# install it
sudo apt-get install youtube-dl
# you can fetch many videos at once
youtube-dl LINK1 [LINK2 LINK3]
This tool provide many useful options, like changing the audio/video compression format and quality. You can read more here.
Gene Cluster is a program for clustering. I wanted to use it to analyse gene expression data. However, I had problems during installation under Ubuntu 14.04. This is how I solved it:
# install dependencies: Motif libraries
sudo apt-get install libxext-dev libmotif-dev
Get GeneCluster3.0 source code and unpack it.
# configure to install in local dir
./configure –prefix=`pwd` –program-prefix=gene_ && make && make install
# add install dir to ~/.bashrc
Some time ago I was recommending to use Python virtual environment to install local version of Python packages. However this will not solve the issue of outdated version Python in the server your are working in. Here, pythonbrew may be help for you.
# install pythonbrew to ~/.pythonbrew
curl -kL http://xrl.us/pythonbrewinstall | bash
# add to ~/.bashrc to automatically activate pythonbrew
[[ -s "$HOME/.pythonbrew/etc/bashrc" ]] && source "$HOME/.pythonbrew/etc/bashrc"
# open new terminal tab (Ctrl+Shift+T) or window (Ctrl+Shift+N)
# install python 2.7.10
pythonbrew install 2.7.10
# and enable the new version
pythonbrew switch 2.7.10
# from now on, you can enjoy the version of your choice and install dependencies