Twitter Data API access in RSTUDIO

Get access to the Twitter API:

Create an APP, as documented here:

Annotation 2019-11-05 073528

Click on “Details”, then “Keys and tokens”

Annotation 2019-11-05 073800

(The credentials listed above will not work)

Use the generated credentials as below:

So where did the URL in GET come from?

The API Reference contains these instructions:

Annotation 2019-11-05 080500.png


Coming Soon:

Please follow the blog to get updates!

Projects from COURSERA Data Science Specialization ETA: 10 November 2019

“Simplest Way Possible” series: p-value and R-squared, what they are and how to use them in Data Analysis ETA: 20 November 2019

Oracle OLAP functions overview ETA: 30 November 2019





Data Science Specialization



MySQL Custom Install on Windows Startup Issue

OS: MS Windows 10

MySQL: Developer Computer configuration 8.0

Other: Custom path install, configured to NOT work as a service

Considerations: The software was recently installed, and ran properly when it was started through the installer. Nothing was changed on the installation of the software, but the host has been restarted

Issue: MySQL server will not start through the Workbench, and running


will generate issue with missing data directory. If this data directory is not the correct %Program Data% specified, this means that the mysqld.exe does not have access to configuration file


Solution: Place a copy of file my.ini in the root directory of Windows

(ie "C:\Windows").

Execute mysqld.exe once again and minimize its terminal




xmlTreeParse Fails with error “XML content does not seem to be XML”

Code below is run in RSTUDIO.

  • fileURL is the variable that holds the internet location of the XML file in question
  • doc is the variable to store the output of xmlTreeParse

> fileUrl doc <- xmlTreeParse(fileUrl,useInternal=TRUE)
Error: XML content does not seem to be XML: ‘;

SOLUTION: Install package RCurl and use function getURL on the link to the XML file  first

WARNING: Rtools is required to build R packages but is not currently installed. Please download and install the appropriate version of Rtools before proceeding:
also installing the dependency ‘bitops’

trying URL ‘;
Content type ‘application/zip’ length 38894 bytes (37 KB)
downloaded 37 KB

trying URL ‘;
Content type ‘application/zip’ length 2968691 bytes (2.8 MB)
downloaded 2.8 MB
> library(RCurl)
Loading required package: bitops
> xData <- getURL (fileUrl)
> doc <- xmlTreeParse(xData)
> doc