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

In tweet2r: Twitter Collector for R and Export to 'SQLite', 'postGIS' and 'GIS' Format

Description

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

Usage

t2sqlite(fileprefix, import, path = ".", pattern = ".json$")

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
path	A character vector to folder. see ?list.files()
pattern	Limits possible file extensions, optional as regular expression. see ?list.files()

Author(s)

Pau Aragó Galindo [e-mail]

See Also

RSQLite, tweet2r, valjson

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)

tweet2r documentation built on May 2, 2019, 2:34 a.m.