The rationale behind Skynet, is to provide researchers with a unifying tool overcoming some of the challenges faced when dealing with the Bureau of Transport Statistics, DB1B and T100 data. The DB1B data consists of 2 sets of files, Coupon and Ticket. They can be both downloaded at https://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=289 and https://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=272 respectively while the T100 data can be found here https://www.transtats.bts.gov/Tables.asp?DB_ID=111.
To comply with R syntax guidelines, we changed to a clearer function naming from version 1.2.0. Deprecated functions are still present, but will be removed for the next versions.
We are constantly working on new functions that allow importing data from different data sources. However, as we can’t cover them all at least for now, in case you would like to work with a database which is not covered by skynet, simply create a data.frame with the following variables:
itin_id, mkt_id, seq_num, origin_mkt_id, origin, year, quarter, dest_mkt_id, dest, trip_break, op_carrier, distance, gateway, roundtrip, itin_yield, passengers, itin_fare, bulk_fare, distance_full
For more information on the variables, please visit https://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=289 and https://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=272.
Skynet allows that some of this variables have a 0 or NA value, however, if you’re working with a specific dataset which doesn’t allow an easy conversion to our format, please feel free to create an issue so we can look into it. Please make sure to include at least one small example of a csv file with the data you’re trying to import.
You can install skynet from github with:
# install.packages("devtools") devtools::install_github("FilipeamTeixeira/skynet")
To import data, simply type
import_t100() including the path to your desired file.
Note: The Coupon file should take the first argument while the Ticket file should take the second argument.
library(skynet) import_db1b("folder/Coupon 2016Q1.csv", "folder/Ticket 2016Q1.csv") import_t100("folder/T100_2016.csv")
The BTS DB1B data consists of 2 sets of files,
Ticket. They can be both downloaded at https://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=289 and https://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=272 respectively.
Despite being possible to download the complete zipped file, which includes all variables, due to its size, we recommend selecting the following set.
|Itinerary ID||Itinerary ID|
|Sequence Number||Itinerary Yield|
|Origin City Market ID||Passengers|
|Destination City Market ID|
Since version 1.0.2 that the import method changed being the
netimport() function no longer available. When importing from the prezipped DB1B file, just add the argument
zip = TRUE to the
import_db1b() function. This does not apply to the T100 file which can be simply imported by typing
import_t100(). In order to save space, it is possible as well to import the prezipped file, and convert it to a smaller file with only the necessary variables, with the function
To generate a directed network, please type: