Questions tagged [microsoft-r]

Microsoft R is an distribution of R from Microsoft Corporation. It is an open source platform for statistical analysis and data science.

Microsoft R Open is the enhanced distribution of R from Microsoft Corporation. It is a complete open source platform for statistical analysis and data science.

176 questions
1
vote
0 answers

Configuring Microsoft R server on computer with Swedish Windows

After installing Microsoft R Server 9.1.0 on my computer I follow the guide published on Microsofts docs to configure it with the One Box…
Nfourx
  • 81
  • 9
1
vote
1 answer

Microsoft R Server Parsing errors

It is really lame that you can't just copy/paste code from RStudio to a SQL Server stored procedure seamlessly, but alas, it wouldn't be Microsoft otherwise, right? Basically, I get really strange errors in parsing: Error in…
Pablo Boswell
  • 805
  • 3
  • 13
  • 30
1
vote
0 answers

Using R, Unable to Read Image files on Azure DataLakeStore

Using R, I am trying to read image files using WebHDFS API on Azure DataLakeStore. It is not working. However, I can read the text files using WebHDFS API sitting next to image file, using same code, with no issues. Also, I can read image files…
Ravi Rai
  • 68
  • 1
  • 8
1
vote
1 answer

SQL works in R studio but not in R-Serivces

This code works perfectly in R-Studio but there is no way to make it work in MS Management studio. It keeps on saying that: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'myserver\LOCAL01'. That is not my user give it is a…
Leonardo Lanchas
  • 1,616
  • 1
  • 15
  • 37
1
vote
1 answer

mro 3.4.0 bug with install.packages

There was a bug with the general release of R 3.4.0 that has since been patched for 3.4.0 and also included in 3.4.1, but apparently has not been fixed for mro 3.4.0.  When is the fix/patch going to be available for mro?  What is the work-around…
user1118189
1
vote
1 answer

Microsoft R Server SQL NULL/Missing values

I am having a bit of on issue using RxSqlServerData() in Microsoft R to import a table from a SQL Server database. My database in SQL server contains rows that have both blanks and NULL values. When I run RxSqlServerData, these both get imported as…
Thomas Moore
  • 941
  • 2
  • 11
  • 17
1
vote
1 answer

rxImport potential issue in RevoScaleR

I have a SQL connection to a table on my SQLServer, which I have imported with the following line: master_table <- RxSqlServerData(etc...) Then, my goal is to save/import this table using rxImport and save it to a .xdf file, which I have called…
1
vote
0 answers

(Microsoft R Server) Clustered/Robust Standard Errors for rxGLM / rxLogit models

I am currently using rxLogit models in MRS as an alternative to standard GLM models in MRO (~300,000 rows, but 3 factors with 200, 400, and 5000 levels). This cuts my computing time from 26 to 7 hours on a 2x6 core Xeon with 128 GB RAM. After the…
JNWHH
  • 721
  • 5
  • 11
1
vote
0 answers

Installing / Using Microsoft R Client on Mac OS

I have just started a job where I need to get upto speed on the Microsoft R. I want to understand some of the parallel functions such as rxSummary / rxGetInfo / rx* .... other functions. I want to use these functions at home. But I only have Mac…
markthekoala
  • 1,065
  • 1
  • 11
  • 24
1
vote
2 answers

making a single xdf files from 2 other xdf files

I am using the RevoScaleR package in MS Visual Studio, and I'm stuck on a step. I have one XDF file with a column called "Total_Admits_Pred". I have another XDF file with a column called "Total_Admits". Both XDF files have the same number of rows.…
Thomas Moore
  • 941
  • 2
  • 11
  • 17
1
vote
1 answer

rxImport fails on large dataset

I've been trying unsuccessfully the past two days to convert a large CSV (9 gigs) into XDF format using the RxImport function. The process seems to start off well with R server reading in the data chunk by chunk but after a few minutes it slows to…
1
vote
1 answer

RTools Big Data and Visual Studio

So, I'm working on a big data project which requires importing data into Visual Studio and using Microsoft's R packages, in particular, the RevoScaleR packages. So, this is all well and good. I've written my scripts. What I would like to do is set…
1
vote
1 answer

Can't find MRO (Microsoft R Open) installation on MacOS, after installation

Thought I'd give MRO a spin, to see if it speeds up my usage in general. I can't find the installed R though. Not as a separate, not as an overwrite. /usr/local/bin/R contains R version 3.4.0 (2017-04-21) -- "You Stupid Darkness", which is also the…
komodovaran_
  • 1,940
  • 16
  • 44
1
vote
1 answer

different result by transforms and transformFunc in rxDatastep

I would like to add a new column in an xdf file. I tested both transforms and transformFunc in rxDatastep. This line of code works fine for me: rxDataStep(nyc_jan_xdf,transforms = list(newCol5=ifelse(payment_type==1,10,20))) but If I use…
Kaja
  • 2,962
  • 18
  • 63
  • 99
1
vote
1 answer

Adding a new column to an xdf file

I would like to add a new column to an xdf file using rxDataStep. To achieve this aim, I have written this code: rxDataStep(nyc_jan_xdf,transformFunc = CashVsCard ) CashVsCard<-function(dataList) { if(dataList$payment_type==1) { …
Kaja
  • 2,962
  • 18
  • 63
  • 99