How to convert searchTwitter results (from library(twitteR)) into a data.frame?

Posted by analyticsPierce on Stack Overflow See other posts from Stack Overflow or by analyticsPierce
Published on 2010-06-16T18:34:35Z Indexed on 2010/06/16 18:42 UTC
Read the original article Hit count: 166

Filed under:

r

|

twitter

|

rodbc

I am working on saving twitter search results into a database (SQL Server) and am getting an error when I pull the search results from twitteR.

If I execute:

library(twitteR)
puppy <- as.data.frame(searchTwitter("puppy", session=getCurlHandle(),num=100))

I get an error of:

Error in as.data.frame.default(x[[i]], optional = TRUE) : 
  cannot coerce class structure("status", package = "twitteR") into a data.frame

This is important because in order to use RODBC to add this to a table using sqlSave it needs to be a data.frame. At least that's the error message I got:

Error in sqlSave(localSQLServer, puppy, tablename = "puppy_staging",  : 
  should be a data frame

So does anyone have any suggestions on how to coerce the list to a data.frame or how I can load the list through RODBC?

Related posts about twitter

Generating a twitter OAuth access key - the semi-manual way

as seen on Hadermann.be - Search for 'Hadermann.be'
[UPDATE] Apparently someone at Twitter was listening, or I’m going senile/blind. Let’s call it a combination of both. Instead of following all the steps below, you could just login with the Twitter account you want to use on http://dev.twitter.com, register your application and then click… >>> More
shell_exec escaping quotes in php for Twitter API --> Getting CURL to work with obscure twitter api

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using shell_exec() to execute a Twitter API Call. shell_exec('curl -u user:password -d "id=3191321" http://api.twitter.com/1/twitterapi/twitterlist/members.xml'); That works fine when I authenticate correctly and put in a number for the id. But when I try to put in a variable ($id), it screws… >>> More
How to get a Twitter user's handle from a phone number using Twitter API

as seen on Stack Overflow - Search for 'Stack Overflow'
If I have a phone number, and the owner of the number Has a Twitter account Associated his account with the phone number Can I use the Twitter API to find the account based on the phone number? UPDATE: What I basically need is a reverse lookup function from a phone number to a Twitter account… >>> More
La rubrique Qt sur Twitter, suivez l'actualité Qt depuis Twitter et partagez-la

as seen on Developper.com - Search for 'Developper.com'
Comme vous l'avez probablement remarqué, les réseaux sociaux explosent de partout, Developpez.com et toutes ses rubriques se doivent donc, comme toujours auparavant, de suivre l'évolution en s'ouvrant à ces réseaux sociaux. Vous pouvez donc désormais suivre l'actualité de la rubrique sur Facebook… >>> More
Twitter User/Search Feature Header Support in LINQ to Twitter

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
LINQ to Twitter’s goal is to support the entire Twitter API. So, if you see a new feature pop-up, it will be in-queue for inclusion. The same holds for the new X-Feature… response headers for User/Search requests. However, you don’t have to wait for a special property on the TwitterContext to access… >>> More

Developer IT

How to convert searchTwitter results (from library(twitteR)) into a data.frame? - Developer IT

How to convert searchTwitter results (from library(twitteR)) into a data.frame?

r

twitter

rodbc

Related posts about r

Related posts about twitter

Generating a twitter OAuth access key - the semi-manual way

shell_exec escaping quotes in php for Twitter API --> Getting CURL to work with obscure twitter api

How to get a Twitter user's handle from a phone number using Twitter API

La rubrique Qt sur Twitter, suivez l'actualité Qt depuis Twitter et partagez-la

Twitter User/Search Feature Header Support in LINQ to Twitter

Categories cloud