Publications by markheckmann

Populating data frame cells with more than one value

Data frames are lists Most R users will know that data frames are lists. You can easily verify that a data frame is a list by typing d <- data.frame(id=1:2, name=c("Jon", "Mark")) d id name 1 1 Jon 2 2 Mark is.list(d) [1] TRUE However, data frames are lists with some special properties. For example, all entries in the list must have the same...

3055 sym R (1709 sym/11 pcs) 4 img

Remove password protection from Excel sheets using R

Most data scientists wished that all data lived neatly managed in some DB. However, in reality, Excel files are ubiquitous and often a common way to disseminate results or data within many companies. Every now and then I found myself in the situation where I wanted to protect Excel sheets against users accidentally changing them. A few months lat...

2251 sym 6 img