568 search results for "sql"

Coming R meetings in Paris

February 4, 2012
By
Coming R meetings in Paris

If you live in Paris and are interested in R, there will be two meetings for you this week. First a Semin-R session, organized at the Muséum National d’Histoire Naturelle on Tuesday 7 Feb (too bad, the Museum is closed on Tuesdays). Presentations will be about colors, phylogenies and maps, while I will speak about

Read more »

R meets HANA

February 2, 2012
By
R meets HANA

If you read my last blog called HANA meets R you will remember that we read data from HANA into R directly, without having to download an .csv file, but using ODBC. This time, we're going to read data from HANA as well, but after do some nice tricks on R, we're going to post back the...

Read more »

HANA meets R

February 2, 2012
By
HANA meets R

In my previous HANA and R blogs, I have been forced to create .csv files from HANA and read them on R...an easy but also boring procedure...specially if your R report is supposed to be run on a regular basis...having to create an .csv file every time you need to run your report it's not a nice thing...After...

Read more »

Two courses in R programming by Ken Rice and Thomas Lumley

February 2, 2012
By

Ken Rice and Thomas Lumley will give a course on advanced R programming in two locations this summer. 1. In Edinburgh, June 13-15 (the week before the International Conference in Quantitative Genetics). See http://www.eisg2012.org.uk/ 2. In Seattle, July 23-25, as part of the Summer Institute in Statistical Genetics. See http://www.biostat.washington.edu/suminst/sisg/general The course is about 60% lecture and 40% lab session (BYO R),...

Read more »

Say it in R with "by", "apply" and friends

January 28, 2012
By
Say it in R with "by", "apply" and friends

Iris versicolor (Source: Wikipedia)R is a language, as Luis Apiolaza pointed out in his recent post. This is absolutely true, and learning a programming language is not much different from learning a foreign language. It takes time and a lot of pr...

Read more »

Quick Introduction to ggplot2

January 17, 2012
By
Quick Introduction to ggplot2

For a much better looking version of this post (where code is actually readable!), see this Github repository, which also contains some of the example datasets I use and a literate programming version of this tutorial. Introduction This is a bare-bones introduction to ggplot2, a visualization package in R. It assumes no knowledge of R

Read more »

Annotating limma Results with Gene Names for Affy Microarrays

January 17, 2012
By
Annotating limma Results with Gene Names for Affy Microarrays

Lately I've been using the limma package often for analyzing microarray data. When I read in Affy CEL files using ReadAffy(), the resulting ExpressionSet won't contain any featureData annotation. Consequentially, when I run topTable to get a list of di...

Read more »

Prediction model with HANA and R

January 14, 2012
By
Prediction model with HANA and R

These days, I have been reading and playing a lot with R, and I really come to love it...of course, I don't have a clue on those weird statistics formulas, but it doesn't mean I can't use R and try do some awesome stuff with it.So, yesterday I was thin...

Read more »

Homicides in Mexico 2010

December 28, 2011
By
Homicides in Mexico 2010

Recently the Mexican government released to the public the final homicide data for 2010, and as you can see from the chart Mexico has suffered from a steep rise in homicides since 2008, and in 2010 reached the highest homicide rate in recent history. The Mexican government had actually released preliminary homicide data...

Read more »

SVN Version Control, R, and some rambling thought on AWS,Rscripts

December 16, 2011
By

I do a alot of my modelling on Rstudio hosted on EC2 instances. If you don’t use, I would highly recommend. A brilliant tool. Kudos to the Rstudio team. I have made a personal and professional pledge to obsessively use version control. I hope to show...

Read more »