1233 search results for "excel"

Update to resolv (0.1.2) + valgrind and R + Parallel DNS Requests with Revolution R’s ‘foreach’ and `doParallel`

August 15, 2014
By

Thanks to a blog comment by @arj, I finally ran at least one of the new Rcpp-based through valgrind (resolv) and, sure enough there were a few memory leaks which are now fixed. However, I first ran valgind with a simple test R script that just did library(stats) to get a baseline (and dust off some...

Read more »

Results of the Readers’ Survey

August 5, 2014
By
Results of the Readers’ Survey

 First of all, let me say “Thank You” to all of the 357 people who completed the survey. I was hoping for 100, so needless to say the response blew away my expectations. This endeavor seems like a worthwhile effort to do once a year. Next year I will refine the...

Read more »

When life gives you coloured cells, make categories

August 5, 2014
By
When life gives you coloured cells, make categories

Let’s start by making one thing clear. Using coloured cells in Excel to encode different categories of data is wrong. Next time colleagues explain excitedly how “green equals normal and red = tumour”, you must explain that (1) they have sinned and (2) what they meant to do was add a column containing the words

Read more »

Parameterized SQL queries

August 5, 2014
By

Mateusz Żółtak asked me to spread the word about his new R package for parameterized SQL queries. Below you can find the copy of package vignette. If you work with SQL in R you may find it useful. Mateusz Żółtak The package RODBCext is an extension of the RODBC database connectivity package. It provides support

Read more »

Review of “Building interactive graphs with ggplot2 and shiny”

August 4, 2014
By

Recently, Packt published a video course with the above title, and I've just spent a pleasant morning reviewing it on Packt's request. Pleasant, because I think the course gives an excellent introduction to both ggplot2 and shiny. The course is … Continue reading →

Read more »

Guns are Cool – Differences between states

August 3, 2014
By
Guns are Cool – Differences between states

Last week my blog showed that there are differences between states in the shootingtracker database. This week it is attempted to understand why states are different. A number of variables were extracted from a few sources, among which gun laws, % ...

Read more »

Come see RStudio at JSM in Boston

August 1, 2014
By
Come see RStudio at JSM in Boston

The Joint Statistical Meetings (JSM) start this weekend! We wanted to let you know we’ll be there. Be sure to check out these sessions from RStudio and friends: Sunday, August 3 4:00 PM: A Web Application for Efficient Analysis of Peptide Libraries: Eric Hare*+ and Timo Sieber and Heike Hofmann 4:00 PM: Gravicom: A Web-Based

Read more »

Adjusted Momentum

July 31, 2014
By
Adjusted Momentum

David Varadi has published two excellent posts / ideas about cooking with momentum: VIX-Adjusted Momentum Error-Adjusted Momentum I just could not resist the urge to share these ideas with you. Following is implementation using the Systematic Investor Toolbox. Please enjoy and share your ideas with David and myself. To view the complete source code for

Read more »

Eighth Torino R net meeting and free R for data analysis course

July 31, 2014
By
Eighth Torino R net meeting and free R for data analysis course

On 17 September 2014 – 14:00 there will be a free R for data analysis course and starting at 16:30 there will be the Eighth Torino R net meeting. Events will take place at Campus Luigi Einaudi, Università degli Studi di Torino. Torino R net will be … Continue reading →

Read more »

Fast-track publishing using the new R markdown – a tutorial and a quick look behind the scenes

July 29, 2014
By
Fast-track publishing using the new R markdown – a tutorial and a quick look behind the scenes

The new R Markdown (rmarkdown-package) introduced in Rstudio 0.98.978 provides some neat features by combining the awesome knitr-package and the pandoc-system. The system allows for some neat simplifications of the fast-track-publishing (ftp) idea using so called formats. I've created a new package, the Grmd-package, with an extension to the html_document format, called the docx_document. The formatter allows an almost...

Read more »