Download Files
Flat Files
Loading flat files:
read.csv
sets sep=","
and header=TRUE
Other paramenters:
quote
-> any quote. “” means no quote.
na.string
-> character that represents missing value
nrows
-> how many rows to read from file
skip
-> number of lines to skip before starting to read
Fixed Width Text
Excel
Spedific rows and columns:
write.xlsx
function will write out an Excel file.
XML
JSON
Mysql
HDF5
Hierachical data format.
Groups contains zero or more data sets and metada
- Have a group header with group name and list of attributes
- Have a group symbol table with a list of objects in group
Datasets multidimensional array of data elmentes with metadata
- Have a header with name, datatype, dataspeace, and storage layout
- Have a data array with the data
Create groups
Write to groups
WEB
APIs
Read from github
Converting the json object
Other sources