File Attachments

import local files: CSV, etc.

Import Data

CSV via Arquero

aq.loadcsv()

newdata_unwrangle = aq.loadCSV("data/penguins.csv")

newdata = newdata_unwrangle

newdata_unwrangle.view()

CSV vis OJS standard library

• https://observablehq.com/@observablehq/input-file
• https://observablehq.com/@observablehq/file-attachments

FileAttachment()

mydata = FileAttachment('data/penguins.csv').csv({typed: true})

mydata

mybar = aq.from(mydata)

mybar.view()

via {tidyverse} read_csv()

library(tidyverse)

Warning: package 'tidyverse' was built under R version 4.1.3

-- Attaching packages --------------------------------------- tidyverse 1.3.2 --
v ggplot2 3.4.0      v purrr   0.3.5 
v tibble  3.1.8      v dplyr   1.0.10
v tidyr   1.2.1      v stringr 1.4.1 
v readr   2.1.3      v forcats 0.5.2 

Warning: package 'ggplot2' was built under R version 4.1.3

Warning: package 'tibble' was built under R version 4.1.3

Warning: package 'tidyr' was built under R version 4.1.3

Warning: package 'readr' was built under R version 4.1.3

Warning: package 'purrr' was built under R version 4.1.3

Warning: package 'stringr' was built under R version 4.1.3

Warning: package 'forcats' was built under R version 4.1.3

-- Conflicts ------------------------------------------ tidyverse_conflicts() --
x dplyr::filter() masks stats::filter()
x dplyr::lag()    masks stats::lag()

my_tidy_csv <- read_csv("data/penguins.csv") 

Rows: 344 Columns: 8
-- Column specification --------------------------------------------------------
Delimiter: ","
chr (3): species, island, sex
dbl (5): bill_length_mm, bill_depth_mm, flipper_length_mm, body_mass_g, year

i Use `spec()` to retrieve the full column specification for this data.
i Specify the column types or set `show_col_types = FALSE` to quiet this message.

ojs_define(my_tidy_csv = my_tidy_csv)

via osj transpose for arquero (aq.from)

newdata_foo = aq.from(transpose(my_tidy_csv))

newdata_foo.view()

plot

dotplot = Plot
  .dot(newdata, {
  x: 'flipper_length_mm',
  y: 'body_mass_g',
  fill: 'island'
})
  .plot()

libraries

import { aq, op } from '@uwdata/arquero'
// import {d3-time-format}
// d3 = require("d3@6")