Install dependencies.
library("aws.s3") library("readr")
The S3 bucket is in us-east-2.
Sys.setenv("AWS_DEFAULT_REGION" = "us-east-2")
get_bucket
lists the contents of the bucket. I saved this list as a dataframe for convenience/display.
tables_list <- get_bucket(bucket = 'mortality-tables') tables_df <- data.frame(matrix(unlist(tables_list), nrow=length(tables_list), byrow=TRUE)) colnames(tables_df) <- c("Key", "LastModified", "ETag", "Size", "StorageClass", "Bucket") tables_df
You can read a particular object from the bucket. readr
correctly infers the data types.
cso_2001 <- s3read_using( read_csv, object = "2001CSO/2001CSO_3NT2T_ALB/CSO2001_ALB_3NT2T_Select.csv", bucket = 'mortality-tables' )
Data is normalized/tidy for ease of use.
cso_2001[23:27,]
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.