dainiuxt

A Developer's Notebook - Repurposing an old Android phone as a Ruby web server

2022-06-25T00:00:00+00:00

Do you have an old Android phone? Sure you do! There’s a mind-blowing amount of electronic waste of all kinds, and with the average person in developed countries discarding their phones every couple of years, discarded smartphones are probably one of the most common forms of e-waste.

Original link

Tags: ruby android phone server

Install/Update Portable R and RStudio on Windows

2016-02-02T00:00:00+00:00

If you should work on windows machine where you don’t have administrative privilegies, you can very easily make portable R/Rstudio installation.

Download recent version of R from CRAN site and recent version of RStudio. After download extract RStudio installation exec with 7Zip and copy files from $_OUTDIR to desired location (in case you making an update, simply overwrite all files, that already exist). Your RStudio executable will be in

your-chosen-directory/bin/rstudio.exe

Then run CRAN-R installation, ignore warning that you don’t have administrative privilegies and go forward untill installation will complete. Run RStudio, from menu

Tools->Global Options

locate where your R installation is located.

If you performing update (more recent version of R), copy all files from library subfolder of old R installation into new, but this time DON’T OVERWRITE! This operation vill preserve the packages you have installed in previous version of R. After copying update all your packages from RStudio window (Packages->Update). When packages update process will end check which packages failed to update (You will see warning messages near them in RStudio console). Remove these packages (write down names of failed packages and delete corresponding folders from library subfolder). For this you will ned to exit from RStudio. After deletion lauch RStudio again and execute packages install command in RStudio console:

install.packages(c("package1", "package2", "package3"))

Congratulations, You are ready to go!

Shortcut for setting ODBC data sources is pointing to the 32bit data sources instead of 64bit

2015-10-20T00:00:00+00:00

Go to control panel -> administrative tools –> select data sources(ODBC) –> then right click on that file –> go to properties –> in the shortcut tab -> change the path from

%windir%\System32\odbcad32.exe

%windir%\SysWOW64\odbcad32.exe

Install R packages on demand (if require)

2015-10-20T00:00:00+00:00

if (!require("data.table")) {
install.packages("data.table")
}
if (!require("reshape2")) {
install.packages("reshape2")
}
require("data.table")
require("reshape2")

Locale setting in R/RStudio

2015-10-19T00:00:00+00:00

If you have different locale from English (usually living outside US or UK), then pretty common problem can be simple task - get weekdays in English from dates.

Sys.setlocale("LC_TIME", "C")

do the trick and bypass

OS reports request to set locale to "EN" cannot be honored

error which is pretty common if you use command

Sys.setlocale("LC_TIME", "English")

Connect MS Access database (.accdb) to R under Win7(x64)

2015-10-19T00:00:00+00:00

The very first tip for this case is you should use 32 bit version of R. To change your active R version you can go in menu Tools->Global Options while using Rstudio IDE and select prefered version of R.

library("RODBC") #load package

db<-file.path("C:/path/to/your/database.accdb") #connect database.

#Note the UNIX style slash (/). "\" is "escape character" so all "\"  you should replace either with "/" or "\\"

channel<-odbcConnectAccess2007(db) #internal RODBC function

dataSetName<-sqlFetch(channel,"TableName") #read particular table from Access database file.

close(channel) #do not forget this, otherwise you lock access database from editing.

So far this works only in Windows but not in linux.

Beginner's resources for R

2015-10-19T00:00:00+00:00

Core R site

The Comprehensive R Archive Network

R-esources for R

The R Journal

R-bloggers

R Wiki

Rdocumentation (info of all packages)

Tips and learning

Rtips. Revival 2014!

Learn and use R

R Tutorial

Advanced R Programming