1108 search results for "SQL"

Web data acquisition: parsing json objects with tidyjson (Part 3)

March 24, 2017
By
Web data acquisition: parsing json objects with tidyjson (Part 3)

The collection of example flight data in json format available in part 2, described the libraries and the structure of the POST request necessary to collect data in a json object. Despite the process generated and transferred locally a proper response, the data collected were neither in a suitable structure for data analysis nor immediately … Continue...

Read more »

R – Change columns names in a spatial dataframe

March 24, 2017
By
R – Change columns names in a spatial dataframe

Ordnance Survey have a great OpenRoads dataset, but unfortunately it contains a column called ‘primary’, which is a keyword in SQL. This makes it challenging/impossible to import the OpenRoads dataset into a SQL… Continue reading →

Read more »

Announcing R Tools 1.0 for Visual Studio 2015

March 23, 2017
By
Announcing R Tools 1.0 for Visual Studio 2015

by Shahrokh Mortazavi, Partner PM, Visual Studio Cloud Platform Tools at Microsoft I’m delighted to announce the general availability of R Tools 1.0 for Visual Studio 2015 (RTVS). This release will be shortly followed by R Tools 1.0 for Visual Studio 2017 in early May. RTVS is a free and open source plug-in that turns Visual Studio into a...

Read more »

Running your R code on Azure with mrsdeploy

March 22, 2017
By
Running your R code on Azure with mrsdeploy

by John-Mark Agosta, data scientist manager at Microsoft Let’s say you’ve built a model in R that is larger than you can conveniently run locally, and you want to take advantage of Azure’s resources simply to run it on a larger machine. This blog explains how to provision and run an Azure virtual machine (VM) for this, using the...

Read more »

Is it possible to use RevoScaleR package in Power BI?

March 20, 2017
By
Is it possible to use RevoScaleR package in Power BI?

I was invited to deliver a session for Belgium User Group on SQL Server and R integration. After the session – which we did online using web based Citrix  – I got an interesting question: “Is it possible to use RevoScaleR performance computational functions within Power BI?“. My first answer was,  a sceptical yes. But … Continue...

Read more »

Alteryx integrates with Microsoft R

March 20, 2017
By
Alteryx integrates with Microsoft R

You can now use Alteryx Designer, the data science workflow tool from Alteryx, as a drag-and-drop interface for many of the big-data statistical modeling tools included with Microsoft R. Alteryx v11.0 includes expanded support for Microsoft SQL Server 2016, Microsoft R Server, Azure SQL Data Warehouse, and Microsoft Analytics Platform System (APS), with new workflow tools to access functionality...

Read more »

Python & R vs. SPSS & SAS

March 18, 2017
By
Python & R vs. SPSS & SAS

When we’re working for clients we mostly come across the statistical programming languages SAS, SPSS, R and Python. Of these SAS and SPSS are probably the most used. However, the interest for the open source languages R and Python is increasing. In recent years, some of our clients migrated from using SAS or SPSS to

Read more »

Another R [Non-]Standard Evaluation Idea

March 17, 2017
By
Another R [Non-]Standard Evaluation Idea

Jonathan Carroll had a an interesting R language idea: to use @-notation to request value substitution in a non-standard evaluation environment (inspired by msyql User-Defined Variables). He even picked the right image: The idea is kind of reverse from some Lisp ideas ("evaled unless ticked"), but an interesting possibility. We can play along with it … Continue...

Read more »

RevoScaleR package dependencies with graph visualization

March 15, 2017
By
RevoScaleR package dependencies  with graph visualization

MRAN currently holds 7520 R Packages. We can see this with usage of following command (stipulating that you are using MRAN R version. ): library(tools) df_ap <- data.frame(available.packages()) head(df_ap) With importing package tools, we get many useful functions to find additional information on packages. Function package.dependencies() parses and check dependencies of a package in current … Continue...

Read more »

Three advanced online R courses in Statistics.com that are starting soon (and a discount code for them)

March 15, 2017
By
Three advanced online R courses in Statistics.com that are starting soon (and a discount code for them)

Three courses in R are starting tomorrow and two next week on Statistics.com. You may use the code “1qR-blogger-17″ when registering (offering a reduced rate of $399 instead of,  around, $589 a course).  List of R courses: Mar 17:  SQL and R – Introduction to Database Queries, taught by Ben Baumer, (Director of the Statistical & Data Sciences Program...

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)