bike_summary_stats: Extract summary statistics of database

Description Usage Arguments Value Examples

Description

Extract summary statistics of database

Usage

1

Arguments

bikedb

A string containing the path to the SQLite3 database. If no directory specified, it is presumed to be in tempdir().

Value

A data.frame containing numbers of trips and stations along with times and dates of first and last trips for each city in database and a final column indicating whether the files match the latest published versions.

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
data_dir <- tempdir ()
bike_write_test_data (data_dir = data_dir)
# dl_bikedata (city = 'la', data_dir = '.') # or download some real data!
bikedb <- file.path (data_dir, 'testdb')
store_bikedata (data_dir = data_dir, bikedb = bikedb)
bike_summary_stats ('testdb')

bike_rm_test_data (data_dir = data_dir)
bike_rm_db (bikedb)
# don't forget to remove real data!
# file.remove (list.files ('.', pattern = '.zip'))

mpadge/sqlite3-test documentation built on May 23, 2019, 6:24 a.m.