584 search results for "sql"

RSQLite 1.0.0

October 25, 2014
By
RSQLite 1.0.0

I’m very pleased to announce a new version of RSQLite 1.0.0. RSQLite is the easiest way to use SQL database from R: library(DBI) # Create an ephemeral in-memory RSQLite database con <- dbConnect(RSQLite::SQLite(), ":memory:") # Copy in the buit-in mtcars data frame dbWriteTable(con, "mtcars", mtcars, row.names = FALSE) #> TRUE # Fetch all results

Read more »

PageRank For SQL Lovers

September 24, 2014
By
PageRank For SQL Lovers

If you’re changing the world, you’re working on important things. You’re excited to get up in the morning (Larry Page, CEO and Co-Founder of Google) This is my particular tribute to one of the most important, influential and life-changer R packages I have discovered in the last times: sqldf package. Because of my job, transforming

Read more »

Build Predictive Model on Big data: Using R and MySQL Part-3

September 21, 2014
By
Build Predictive Model on Big data: Using R and MySQL Part-3

Welcome to last part of the series post again! In previous part I discussed about the solutions to the questions mentioned in first part. In this part, we will implement whole scenario using R and MySQL together and see how we can process bigdata(computationally ) Let us recall those questions and summarize their answers to The post Build...

Read more »

Build Predictive Model on Big data: Using R and MySQL Part-2

September 21, 2014
By
Build Predictive Model on Big data: Using R and MySQL Part-2

Welcome to the second part of the series blog posts. In first part we tried to understand the challenges of fitting predictive model to the large dataset. In this post I will discuss about the solution approach to that challenges. Let’s start rolling. As machine learning technique requires accessing whole dataset for fitting model on The post Build...

Read more »

Build Predictive Model on Big data: Using R and MySQL Part-1

September 21, 2014
By
Build Predictive Model on Big data: Using R and MySQL Part-1

Wellcome to the series blog posts. Since long time, I am writing post on Machine learning with R. Today I am gonna discuss on big data problem while fitting machine learning on it and its solution using MySQL and R. Before we jump directly to solution, let us discuss about big data little bit. (You The post Build...

Read more »

Using SQLite in R

September 16, 2014
By
Using SQLite in R

Working on big data requires a clean and robust approach on storing and accessing the data. SQLite is an all inclusive server-less database system in a single file. This is very convenient for data exchange between colleagues. Here is a workflow of SQLite data accessing and data storing in R. Connect to an SQLite database Related posts:

Read more »

Parameterized SQL queries

August 5, 2014
By

Mateusz Żółtak asked me to spread the word about his new R package for parameterized SQL queries. Below you can find the copy of package vignette. If you work with SQL in R you may find it useful. Mateusz Żółtak The package RODBCext is an extension of the RODBC database connectivity package. It provides support

Read more »

How to update and backup a MySQL database under version control and all within Rstudio

July 21, 2014
By
How to update and backup a MySQL database under version control and all within Rstudio

I am trying to have better workflows to ensure data quality and two important things for me are first, scripting as much as posible the data manipulation process, and second, backing up the database we use under version control (e.g. … Continue reading →

Read more »

Julia and SQLite

February 8, 2014
By
Julia and SQLite

Similar to R and Pandas in Python, Julia provides a simple yet efficient interface with SQLite database. In addition, it is extremely handy to use sqldf() function, which is almost identical to the sqldf package in R, in SQLite package for data munging.

Read more »

Connecting TOAD For MySQL, MySQL Workbench, and R to Amazon AWS EC2 Using SSH Tunneling

January 7, 2014
By
Connecting TOAD For MySQL, MySQL Workbench, and R to Amazon AWS EC2 Using SSH Tunneling

I often use Amazon EC2 to store and retrieve data when I need either additional storage or higher computing capacity.  In this tutorial I’ll share how to connect to a MySQL database so that one can retrieve the data and do the analysis.  I tend to use either TOAD for MySQL or MySQL Workbench to run

Read more »