Category Archives: Data Management

How to Assign Variable Labels in R

Intro Defining variable labels is a useful way to describe and document datasets. Unlike SPSS, which makes it very easy to define variable labels using the data editor, base R doesn't provide any function to define variable labels (as far … Continue reading

Posted in Data Management, Fav R Packages, Tips & Tricks | Tagged | Leave a comment

How to parse Citavi files using R

Intro In academic writing, the use of reference management software has become essential. A couple of years ago, I started using the free open-source software Zotero. However, most of my workmates at Leipzig University work with Citavi, a commercial software … Continue reading

Posted in Data Management | Tagged , | Leave a comment

How to import a bunch of Excel files with multiple sheets

The Problem I have been recently conducting an evaluation study in the field of social work with elderly people. With the purpose to provide advice to elderly peoply regarding age-related questions about housing, home care etc, 10 offices for senior … Continue reading

Posted in Data Management | Tagged , | Leave a comment

How to number and reference tables and figures in R Markdown files

Introduction R Markdown is a great tool to make research results reproducible. However, in scientific research papers or reports, tables and figures usually need to be numbered and referenced. Unfortunately, R Markdown has no “native” method to number and reference … Continue reading

Posted in Data Management | Tagged , , | Leave a comment

How to parse Evernote export files (.enex) using R

Evernote is a “cross-platform […] app designed for note taking, organizing, and archiving” (Wikipedia). All notes can be tagged and exported. I'm using Evernote, above all, to save and tag interesting blog posts related to R. In this blog post, … Continue reading

Posted in Data Management | Tagged , | Leave a comment

RMarkdown: How to format tables and figures in .docx files

In research, we usually publish the most important findings in tables and figures. When writing research papers using Rmarkdown (*.Rmd), we have several options to format the output of the final MS Word document (.docx). Tables can be formated using … Continue reading

Posted in Data Management | Tagged , , | Leave a comment

How to install the ‘RWordPress’ package in R

The RWordPress package is a very convenient tool for publishing blog posts from R to WordPress. In his blog post Publish blog posts from R + knitr to WordPress, Yihui Xie explains how to install and use the package. Furthermore, … Continue reading

Posted in Data Management, Fav R Packages, Tips & Tricks | 12 Comments