Grab Twitter search data using R and export to a tab delimited file

Paras Doshi - Blog

In this blog-post, we would see how you can grab Twitter search data using R and then export it to tab delimited file. Here are the steps:

1) First up, if we do not have R – you can install it by following the tutorial: Let’s install R Studio and R on windows machine

2) Instal Package: TwitteR if you haven’t

3) Look at the following code, modify the path in line #4 for write.table:

> require(twitteR)

> tweets <- searchTwitter(“#excel”,n=1500)

> tweetdataframe <- do.call(“rbind”,lapply(tweets,as.data.frame))

> write.table(tweetdataframe,”c:/users/paras/desktop/tweetsaboutexcel.txt”,sep=”t”)

4) so now you have tab delimited file having about 1500 tweets!

1500 tweets R excel tab delimited RStudio code

You can also export the tweets to Excel spreadsheet, SPSS and SAS. Check this out: quick R Exporting Data

Conclusion:

In this blog-post, we saw how you can grab 1500 tweets using R and then export it to a tab delimited file.

View original post

Advertisements

Fuseki Windows Installation

tychen

The Apache Jena site does not give much information for Fuseki installation on Windows. Here’s how I did it with my Windows 8. (Note: No need to set up environmental variables or path)

  1. Take a look at Bob DuCharme’s blog (http://www.snee.com/bobdc.blog/2011/04/getting-started-with-sparql-up.html). BTW, Bob’s book, Learning SPARQL, is a nicely written book. I highly recommend it. ^^
    Or,
  2. Do the following steps:
    1. Download and unzip the Fuseki zip file (http://jena.apache.org/download/index.cgi) to somewhere in your hard drive. (I choose the root so it’s like C:jena-fuseki-1.1.1. I then rename the folder to like C:FUSEKI because all capital looks cool. ^^)
    2. Bob instructed us to create the dataDirfolder under the Fuseki folder. In the current version of Fuseki (1.1.1) there is a Datafolder in place already, so you can just use it.
    3. If you are copying the original command from DuCharme, you need to change the jar file name: fuseki-sys.jar…

View original post 103 more words