rtracklayer package allows you to access most of the UCSC wiggle tracks from R. However, there is another way which might more practical in situations where you need to summarize the wig track scores over a given set of genomic coordinates. Although yo...
372 search results for "SQL"
Extracting all Crime Data for England and Wales using R and MYSQL
Last week I started creating some data extraction code for the new England and Wales crime maps website using the R software / language. Although there is an API, a more efficient way of accessing all of the data (and without causing stress to their API server) is to download the CSV files located here
Stata or R
Recently I came across a complex model written in Access with complex SQL queries all over the place. The engineer who was maintaining it and I did some analysis and agreed that the model was using SQL in an unnatural way (things SQL isn't good at) - c...
Stata or R
Recently I came across a complex model written in Access with complex SQL queries all over the place. The engineer who was maintaining it and I did some analysis and agreed that the model was using SQL in an unnatural way (things SQL isn't good at) - c...
sqldf and grouping rows in R
In R, you can treat tables (or data.frames as they are called in R) as SQL tables. That means you can query them as you would query a database with SQL commands. This is particularly useful 1) if you know SQL, hahah:) 2) if you have large tabl...
sqldf and grouping rows in R
In R, you can treat tables (or data.frames as they are called in R) as SQL tables. That means you can query them as you would query a database with SQL commands. This is particularly useful 1) if you know SQL, hahah:) 2) if you have large tabl...
Merging Multiple Data Frames in R
Earlier I had a problem that required merging 3 years of trade data, with about 12 csv files per year. Merging all of these data sets with pairwise left joins using the R merge statement worked (especially after correcting some errors pointed out by Ha...
Posted Question for R Users
I recently undertook a project where a colleague had about 12 .csv files that they wanted to merge. Each file had a common (key) variable 'Partner' (which is trading partner) with differing columns (variables) except for the common key variable. Actual...
R GUIs, IDEs, and text editors
When deciding what program to write your R code in it is important to consider a number of factors so you can keep organized and work efficiently. I found this article useful for getting started. Text editors include syntax highlightin...
Winners of Mozilla Open Data Competition announced
The winners of the Mozilla Open Data Visualization competition "How Do People Use Firefox" have been announced. The competition attracted 32 entries, each visualizing an aspect of data collected in the Mozilla Test Pilot program to reveal insights about how people use the popular open-source browser Firefox. I was honoured to be asked to participate in the judging of...
Zero Inflated Models and Generalized Linear Mixed Models with R.
Zuur, Saveliev, Ieno (2012).
