704 search results for "SQL"

Visualising Pandas DataFrames With IPythonBlocks – Proof of Concept

March 26, 2014
By
Visualising Pandas DataFrames With IPythonBlocks – Proof of Concept

A few weeks ago I came across IPythonBlocks, a Python library developed to support the teaching of Python programming. The library provides an HTML grid that can be manipulated using simple programming constructs, presenting the outcome of the operations in a visually meaningful way. As part of a new third level OU course we’re putting

Read more »

R 101: Summarizing Data

March 25, 2014
By
R 101: Summarizing Data

When working with large amounts of data that is structured in a tabular format, a common operation is to summarize that data in different ways using specific variables. In Microsoft Excel, pivot tables are a nice feature that is used for this purpose. While not as “efficient” in relation to Excel pivot tables, R also

Read more »

Interactive Discovery of Research Affiliates JoPM Paper

March 25, 2014
By

In my previous post More on Rebalancing | With Data from Research Affiliates , I did some really basic visualizations, but I thought this data would be great for some more powerful interactive discovery using an interesting javascript SQL-like query l...

Read more »

Learn to Manage Data at useR! 2014 or Online April 25

March 18, 2014
By
Learn to Manage Data at useR! 2014 or Online April 25

Before you can analyze data, it must be in the right form. Join me on April 25th for a 4-hour webinar that shows how to perform the most commonly used data management tasks in R. We will work through hands-on examples of … Continue reading →

Read more »

analyze the national household travel survey (nhts) with r and monetdb

March 18, 2014
By

if you've ever gotten stuck in traffic and started wondering what data might be available to better design the network of roads and rail, rev your engines for the national household travel survey (nhts).  dating back to the same decade as eisenhow...

Read more »

Software Carpentry at UVA, Redux

March 12, 2014
By
Software Carpentry at UVA, Redux

Software Carpentry is an international collaboration backed by Mozilla and the Sloan Foundation comprising a team of volunteers that teach computational competence and basic programming skills to scientists. In addition to a suite of online lessons, ...

Read more »

Confounding & collinearity

March 11, 2014
By
Confounding & collinearity

(This article was first published on MATHEMATICS IN MEDICINE, and kindly contributed to R-bloggers) Confounding and collinearity Introduction In this blog article, I will discuss about the bias introduced in estimation of coefficient of a given explanatory variable due to the presence of confounding factors. After that, I will try to demonstrate about the effect of variable collinearity on...

Read more »

Upcoming NYC R Programming Classes

March 10, 2014
By
Upcoming NYC R Programming Classes

It is our pleasure to once again offer the intensive R beginner level course for the third time! Beginning this Sunday, the 35 hour course will walk you through the basic operations and characteristics of R, all the way to having a firm understanding of data manipulation and visualization. Also launching this weekend are two... Read more »

Using Google BigQuery with R

March 10, 2014
By
Using Google BigQuery with R

Hey everybody, this tutorial is about combining two great and powerful tools: R and Google BigQuery. Big Query: So but what is BigQuery? I think Google describes it very well on the developers page: “Querying massive datasets can be time consuming and expensive without the right hardware and infrastructure. Google BigQuery solves this problem by …

Read more »

What are the most common RNG seeds used in R scripts on Github?

March 6, 2014
By
What are the most common RNG seeds used in R scripts on Github?

In the R programming language, the random number generator (RNG) is seeded each session using the current time and process ID. Via the magic of the popular Mersenne Twister PRNG, the values stored in .Random.seed are used sequentially each time … Continue reading →

Read more »