569 search results for "sql"

Frustration

March 6, 2012
By

Google has failed me.  Cannot get RMySQL to install on my laptop.  Looks like I am going to need a different method to get data from MySQL into R.If anyone has pointers, I'm all ears.Windows 7 x64, R 2.13.1

Read more »

Parsing R code: Freedom of expression is not always a good idea

February 28, 2012
By
Parsing R code: Freedom of expression is not always a good idea

With my growing interest in R it was inevitable that I would end up writing a parser for it. The fact that the language is relatively small (the add-on packages do the serious work) hastened the event because it did not look like much work; famous last words. I knew about R’s design and implementation

Read more »

R integrated throughout the enterprise analytics stack

February 27, 2012
By

The past couple of years have seen a dramatic growth in the use of the R language in the enterprise. R has always been pervasive in academia for research and teaching in statistics and data science, and as new graduates trained in R have migrated to the workplace the demand for R in corporations has become more and more...

Read more »

R and Salesforce

February 25, 2012
By
R and Salesforce

Introduction R is widely used among scientists and statisticians to perform statistical analysis while Salesforce.com is one of the leading CRM software packages used for Marketing and Salesforce automation. Salesforce.com contains vital information regarding Leads, Customers, Contacts, Opportunities and Cases. Currently this data is mainly used for operational purposes by Sales and Marketing professionals. How

Read more »

Why I don’t like Dynamic Typing

February 25, 2012
By

A lot of people consider the static typing found in languages such as C, C++, ML, Java and Scala as needless hairshirtism. They consider the dynamic typing of languages like Lisp, Scheme, Perl, Ruby and Python as a critical advantage (ignoring other features of these languages and other efforts at generic programming such as the Related posts:

Read more »

What to do about publishing data?

February 22, 2012
By
What to do about publishing data?

There seems to be a scale that’s tipping at the moment: Data or code that should be published* is often not.  This should seem like an odd statement for anyone in science, but it should be easy to show that most publications … Continue reading →

Read more »

Log File Analysis with R

February 21, 2012
By
Log File Analysis with R

 R often comes up in discussions of heavy duty scientific and statistical analysis (and so it should).  However, it is also incredibly handy for a variety of more routine developer activities.   And so I give you… log file analysis with R!  I was just involved in the launch of gradesquare.com (go ahead – click...

Read more »

Reading huge files into R

February 19, 2012
By

SAS is much touted for its ability to read in huge datasets, and rightly so. However, that ability comes at a cost: for smaller datasets, since files remain on the disk rather than in memory (as is the case with Stata and R), it is potentially less fa...

Read more »

Elegant & fast data manipulation with data.table

February 12, 2012
By
Elegant & fast data manipulation with data.table

Just learned about the R data.table package (ht @recology_) makes R data frames into ultra-fast, SQL-like objects. One thing we get is some very nice and powerful syntax. Consider some simple data of replicate time series: To apply a function to each set of replicates, instead of We can use: Note that we could have

Read more »

R for Quants, Part I.A

February 12, 2012
By
R for Quants, Part I.A

I’m teaching an R workshop for the Baruch MFE program. This is the first installment of the workshop and focuses on …Continue reading »

Read more »