884 search results for "SQL"

Connecting R to MySQL/MariaDB

September 2, 2015
By
Connecting R to MySQL/MariaDB

Overview Relational databases, such as MySQL, organize data into tables consisting of rows and columns similarly to an R data.frame. While many beginners will be satisfied with R’s native RData storage format, storing data in a flat-file has its disadvantages. First, they are difficult to share among collaborators. .RData files can contain many matrices and

Read more »

Using Azure as an R datasource, Part 4 – Pulling data from SQL Server to Linux

August 18, 2015
By
Using Azure as an R datasource, Part 4 – Pulling data from SQL Server to Linux

by Gregory Vandenbrouck Software Engineer, Microsoft This post is the fourth in a series that covers pulling data from Microsoft SQL Server or MySQL/MariaDB on Azure to an R client on Windows or Linux. In the previous posts, we covered pulling data from SQL Server to Windows and from MySQL/MariaDB to both Windows and Linux. This time we’ll be...

Read more »

Using Azure as an R datasource Part 3: Pulling data from MySQL/MariaDB to Linux

July 21, 2015
By
Using Azure as an R datasource Part 3: Pulling data from MySQL/MariaDB to Linux

by Gregory Vandenbrouck Software Engineer, Microsoft This post is the third in a series that covers pulling data from Microsoft SQL Server or MySQL/MariaDB on Azure to an R client on Windows or Linux. In the previous two, we covered pulling data from SQL Server and MySQL/MariaDB to an R client on Windows. This time we’ll be pulling data...

Read more »

Working with MS SQL server on non-windows systems

July 15, 2015
By

As I know, there are few choices to connect from R to MS SQL Server: RODBC RJDBC rsqlserver But only second option can be used on mac and linux machines. Here is nice stackoverflow thread. Most of the people suggest to use microsoft sql java driver. But there is a case when this will not...

Read more »

Using Azure as an R datasource: Part 2 – Pulling data from MySQL/MariaDB

June 2, 2015
By
Using Azure as an R datasource: Part 2 – Pulling data from MySQL/MariaDB

by Gregory Vandenbrouck Software Engineer, Mirosoft This post is the second in a series that covers pulling data from various Windows Azure hosted storage solutions (such as MySQL, or Microsoft SQL Server) to an R client on Windows or Linux. Last time we covered pulling data from SQL Azure to an R client on Windows. This time we’ll be...

Read more »

Getting started with PostgreSQL in R

May 18, 2015
By
Getting started with PostgreSQL in R

When dealing with large datasets that potentially exceed the memory of your machine it is nice to have another possibility such as your own server with an SQL/PostgreSQL database on it, where you can query the data in smaller digestible chunks. For example, recently I was facing a financial dataset of 5 GB. Although 5

Read more »

In-database R coming to SQL Server 2016

May 15, 2015
By

R is coming to SQL Server. SQL Server 2016 (which will be in public preview this summer) will include new real-time analytics, automatic data encryption, and the ability to run R within the database itself: For deeper insights into data, SQL Server 2016 expands its scope beyond transaction processing, data warehousing and business intelligence to deliver advanced analytics as...

Read more »

Turning Data Into Awesome With sqldf and pandasql

April 29, 2015
By
Turning Data Into Awesome With sqldf and pandasql

Both R and Python possess libraries for using SQL statements to interact with data frames. While both languages have native facilities for manipulating data, the sqldf and pandasql provide a simple and elegant interface for conducting tasks using an intuitive framework that’s widely used by analysts.         R and sqldf sqldf("SELECT COUNT(*) FROM df2 WHERE

Read more »

Text bashing in R for SQL

March 6, 2015
By

Fairly often, a coworker who is strong in Excel, but weak in writing code will come to me for help in special details about customers in their datasets. Sometimes the reason is to call, email, or snail mail a survey, … Continue reading →

Read more »

Tools in Tandem – SQL and ggplot. But is it Really R?

February 28, 2015
By
Tools in Tandem – SQL and ggplot. But is it Really R?

Increasingly I find that I have fallen into using not-really-R whilst playing around with Formula One stats data. Instead, I seem to be using a hybrid of SQL to get data out of a small SQLite3 datbase and into an R dataframe, and then ggplot2 to render visualise it. So for example, I’ve recently been

Read more »

Sponsors

Mango solutions



plotly webpage

dominolab webpage



Zero Inflated Models and Generalized Linear Mixed Models with R

Quantide: statistical consulting and training

datasociety

http://www.eoda.de





ODSC

ODSC

CRC R books series





Six Sigma Online Training









Contact us if you wish to help support R-bloggers, and place your banner here.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)