R Graphical Manual

Browse All

Last data update: 2014.03.03

R: Export TweeterJSON files to sqlite database and import to R...

t2sqlite

R Documentation

Export TweeterJSON files to sqlite database and import to R as a Data Frame

Description

Export Json files retrieved with tweet2r to a Sqlite database and import tweets as a Data Frame.

Usage

t2sqlite(fileprefix, import)

Arguments

fileprefix

Setup file prefix for JSON files. If tweets have been retrieved with the tweet2r function, it should be the same name. The file prefix is used to create the table name and the geotagged table which will have geo as a prefix (example "geofileprefix")n. By default the database file will be save in the working directory with no file extension name. Sqlite is embedded in R within the package RSQLite. More information about Sqlite it its web page.

import

TRUE to import the tweets stored in the Sqlite database to R. It can be imported as a data frame with all the tweets retrieved with the function tweet2r. FALSE to not import as Data Frame

Author(s)

Pau Arag<c3><83><c2><b3> Galindo parago@uji.es

Examples


## Not run: 

#File prefix name for json files and also the name of the database
fileprefix=tweets

t2sqlite(fileprefix, import, export)

## End(Not run)