602 search results for "sql"

Throw some, throw some STATS on that map…(Part 1)

July 12, 2013
By
Throw some, throw some STATS on that map…(Part 1)

R is a very powerful and free (and fun) software package that allows you to do, pretty much anything you could ever want. Someone told me that there’s even code that allows you to order pizza (spoiler alert: you actually cannot order pizza using R :( ). But if you’re not hungry, the statistical capabilities

Read more »

A Rough Guide to Data Science

July 9, 2013
By
A Rough Guide to Data Science

If Big Data was last year's buzzword, Data Science may reach the same level of hype this year. There's no shortage of discussion about the high demand for data scientists, the term's usefulness as a designation, and even declarations of its "sexiness" as a career. And as with many terms that reach a critical mass on social media, data...

Read more »

analyze the united states decennial census public use microdata sample (pums) with r and monetdb

July 1, 2013
By

during his tenure as secretary of state, thomas jefferson oversaw the first american census way back in 1790.  some of my countrymen express pride that we're the oldest democracy, but my heart swells with the knowledge that we've got the world's o...

Read more »

?help! Instant R search on Rdocumentation.org

June 26, 2013
By
?help! Instant R search on Rdocumentation.org

Last week, I was working on an educational R project when I needed to consult the help files of different R packages and functions online. After doing some Google searches, it appeared to me that finding an easy-to-use tool was not as simple as I had expected. The closest that I got, were the websites

Read more »

Merging Data — SAS, R, and Python

June 24, 2013
By
Merging Data — SAS, R, and Python

On analyticbridge, the question was posed about moving an inner join from Excel (which was taking many minutes via VLOOKUP()) to some other package.  The question asked what types of performance can be expected in other systems.  Of the list ...

Read more »

A beer recommendation system made with R

June 24, 2013
By
A beer recommendation system made with R

If you know a beer you like and want some recommendations for a style of beer to try, check out the yhat Beer Recommender: This neat little app is the product of a recommendation system built using the R language by the folks behind the yhat blog. It's based on about 1.5 million beer reviews from the Beer Advocate....

Read more »

Creating a BI Dashboard: Part 1

June 23, 2013
By
Creating a BI Dashboard: Part 1

Introduction A few first posts of this blog will demonstrate how to build each report hosted by the business intelligence (BI) application dashboard shown below (see Fig. 1). This application uses the following tools and technologies R – a free software environment for statistical computing and graphics, ASP.NET MVC4 – a free framework for building

Read more »

Prototyping A General Regression Neural Network with SAS

June 22, 2013
By
Prototyping A General Regression Neural Network with SAS

Last time when I read the paper “A General Regression Neural Network” by Donald Specht, it was exactly 10 years ago when I was in the graduate school. After reading again this week, I decided to code it out with SAS macros and make this excellent idea available for the SAS community. The prototype of

Read more »

Datagrabbing Commonly Formatted Sheets from a Google Spreadsheet – Guardian 2014 University Guide Data

June 20, 2013
By
Datagrabbing Commonly Formatted Sheets from a Google Spreadsheet – Guardian 2014 University Guide Data

So it seems like it’s that time of year when the Guardian publish their university rankings data (Datablog: University guide 2014), which means another opportunity to have a tinker and see what I’ve learned since last year… (Last year’s hack was a Filtering Guardian University Data Every Which Way You Can…, where I had a

Read more »

literacy rates using semantics and R

June 19, 2013
By
literacy rates using semantics and R

(This article was first published on - R, and kindly contributed to R-bloggers) Somehow I stumbled into the world of linked open data trying to pull information easily off of a wikipedia page without having to write a customer scrapper. Enter in dbpedia, semantic technologies and some wonderful R packages take care of the back-end coding. The Research Group...

Read more »