1088 search results for "sql"

Performing SQL selects on R data frames

March 13, 2016
By
Performing SQL selects on R data frames

For anyone who has SQL background and who wants to learn R, I guess the sqldf package is very useful because it enables us to use SQL commands in R. One who has basic SQL skills can manipulate data frames in R using their SQL skills. You can read more about sqldf package from cran. Related Post

Read more »

Querying Big Data SQL tables with Oracle R Enterprise

February 15, 2016
By
Querying Big Data SQL tables with Oracle R Enterprise

I was wondering recently if I could use Oracle R Enterprise (ORE) to query Big Data SQL tables (i.e. Oracle Database external tables based on HDFS or Hive data), since I have never seen such a combination mentioned in the relevant Oracle documentation and white papers. I am happy to announce that the answer is an unconditional yes. In...

Read more »

Getting Started with Microsoft SQL Server on Azure

February 11, 2016
By
Getting Started with Microsoft SQL Server on Azure

by Joseph Rickert If you are an R user and work for an enterprise where Microsoft SQL server is important, it is extremely helpful to have easy access to SQL Server databases. Over the past year, we have run several posts on this topic including a comprehensive four part series from Microsoft's Gregory Vandenbrouck on using various flavors of...

Read more »

Tutorial: Credit Card Fraud Detection with SQL Server 2016 R Services

February 8, 2016
By
Tutorial: Credit Card Fraud Detection with SQL Server 2016 R Services

If you have a database of credit-card transactions with a small percentage tagged as fraudulent, how can you create a process that automatically flags likely fraudulent transactions in the future? That's the premise behind the latest Data Science Deep Dive on MSDN. This tutorial provides a step by step to using the R language and the big-data statistical models...

Read more »

Using PostgreSQL in R: A quick how-to

February 1, 2016
By
Using PostgreSQL in R: A quick how-to

The combination of R plus SQL offers an attractive way to work with what we call medium-scale data: data that’s perhaps too large to gracefully work with in its entirety within your favorite desktop analysis tool (whether that be R or Excel), but too small to justify the overhead of big data infrastructure. In some … Continue reading...

Read more »

Data Manipulation in R: Beyond SQL

January 19, 2016
By
Data Manipulation in R: Beyond SQL

As a follow up to an article on using SQL in R, I just had an new article published at Simple Talk that considers ways to manipulate data in R that are cumbersome in SQL as well as ways to replace SQL statements with functional equivalents.

Read more »

A use of gsub, reshape2 and sqldf with healthcare data

December 18, 2015
By
A use of gsub, reshape2 and sqldf with healthcare data

Building off other industry-specific posts, I want to use healthcare data to demonstrate the use of R packages. The data can be downloaded here. To read the .CSV file in R you might read the post how to import data in R. Packages in R are stored in libraries and often are pre-installed, but reaching

Read more »

Tutorial: Data Science with SQL Server R Services

December 17, 2015
By
Tutorial: Data Science with SQL Server R Services

You may have heard that R and the big-data RevoScaleR package have been integrated with with SQL Server 2016 as SQL Server R Services. If you've been wanting to try out R with SQL Server but haven't been sure where to start, a new MSDN tutorial will take you through all the steps of creating a predictive model: from...

Read more »

Bringing the powers of SQL into R

December 11, 2015
By
Bringing the powers of SQL into R

One of the big flaw of R is that data loaded into it are stored in the memory (on the RAM) and not on the disk. As you are working in an analysis with large (big) data the processing time of simple and more complex functions can become very long or even crash your computer.

Read more »

Exploring Recursive CTEs with sqldf

December 1, 2015
By
Exploring Recursive CTEs with sqldf

by Bob Horton Sr. Data Scientist at Microsoft Common table expressions (CTEs, or “WITH clauses”) are a syntactic feature in SQL that makes it easier to write and use subqueries. They act as views or temporary tables that are only available during the lifetime of a single query. A more sophisticated feature is the “recursive CTE”, which is a...

Read more »

Sponsors

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)