619 search results for "sql"

Forecasting with Neural Network (using SAP HANA and R)

Forecasting with Neural Network (using SAP HANA and R)

Usually...when I use R...I try to use it with SAP HANA as well...and the most simple way to make them work is for sure an ODBC connection....fast and simple...First, I went to my SAP HANA Studio to get the query...which is basically...get all the seats...

Read more »

Downloading and Analyzing CD1025′s Playlist

August 20, 2013
By
Downloading and Analyzing CD1025′s Playlist

CD1025 is an “alternative” radio station here in Columbus. They are one of the few remaining radio stations that are independently owned and they take great pride in it. For data nerds like me, they also put a real time list of recently played songs on their website. The page has the most recent 50 songs played,...

Read more »

Downloading and Analyzing CD1025′s Playlist

August 19, 2013
By
Downloading and Analyzing CD1025′s Playlist

CD1025 is an “alternative” radio station here in Columbus. They are one of the few remaining radio stations that are independently owned and they take great pride in it. For data nerds like me, they also put a real time list of recently played songs on their website. The page has the most recent 50 songs played,...

Read more »

Software carpentry

August 11, 2013
By
Software carpentry

I would never call myself a programmer, but as an ecologists I manage moderately big and complicated datasets, and that require to interact with my computer to get the most of them. I self-taught most of the things I need … Continue reading →

Read more »

Trends in the Analytics Job Market

August 7, 2013
By
Trends in the Analytics Job Market

Tracking the job market for statistics, analytics, data mining and the like used to be a major undertaking. However, on November 10, 2011 the world’s largest web site for job postings, Indeed.com, released a tool that allows you to examine trends … Continue reading →

Read more »

Tabular Data I/O in Julia

August 6, 2013
By

Importing tabular data into Julia can be done in (at least) three ways: reading a delimited file into an array, reading a delimited file into a DataFrame and accessing databases using ODBC. Reading a file into an array using readdlm The most basic way to read data into Julia is through the use of the Tabular Data I/O...

Read more »

Dashboards in R with Shiny and GoogleVis

August 2, 2013
By
Dashboards in R with Shiny and GoogleVis

Previously on this post, I introduced limitedly some features of the Shiny package. However, I felt the need of doing a new post related to Dashboards due to many reasons: a) Shiny has changed most of its functions and the … Continue reading →

Read more »

Estimating Ages from First Names Part 2 – Using Some Morbid Test Data

July 31, 2013
By
Estimating Ages from First Names Part 2 – Using Some Morbid Test Data

In my last post, I wrote about how I compiled a US Social Security Agency data set into something usable in R, and mentioned some issues scaling it up to be usable for bigger datasets.  I also mentioned the need … Continue reading →

Read more »

R in Insurance: Presentations are online

July 31, 2013
By
R in Insurance: Presentations are online

The programme and the presentation files of the first R in Insurance conference have been published on GitHub. Front slides of the conference presentations Additionally to the slides many presenters have made their R code available as well: Alexander McNeil shared the examples of the CreditRisk+ model he presented. Lola Miranda made a...

Read more »

Easier Database Querying with R

July 29, 2013
By
Easier Database Querying with R

I have a strong distaste for database connection management.  All I want to do when I want to query one of our many databases at work is to simply supply the query, and package the result into an R data.frame or data.table. R has many great database connection tools, including but not limited to RPostgreSQL,

Read more »