{"size": 1453, "ext": "scrbl", "max_stars_repo_path": "scribblings/working-with-data.scrbl", "max_stars_repo_name": "jadudm/data-table", "max_stars_repo_stars_event_min_datetime": "2019-12-13T10:01:51.000Z", "max_stars_repo_stars_event_max_datetime": "2019-12-13T10:01:51.000Z", "max_issues_repo_path": "scribblings/working-with-data.scrbl", "max_issues_repo_name": "jadudm/data-table", "max_issues_repo_issues_event_min_datetime": null, "max_issues_repo_issues_event_max_datetime": null, "max_forks_repo_path": "scribblings/working-with-data.scrbl", "max_forks_repo_name": "jadudm/data-table", "max_forks_repo_forks_event_min_datetime": null, "max_forks_repo_forks_event_max_datetime": null}
{"max_stars_count": 1, "max_issues_count": null, "max_forks_count": null, "avg_line_length": 46.8709677419, "max_line_length": 540, "alphanum_fraction": 0.7274604267}
#lang scribble/manual
@(require racket racket/runtime-path)
@require[@for-label[racket db]]
@(require scribble/eval
          scribble/struct
          racket/sandbox
          data-table)
          
@(define the-eval  (make-base-eval))
@interaction-eval[#:eval the-eval
                   (require data-table)]
                   
@title{Working With Data}

The @racket[data-table] library provides functions and syntactic forms for manipulating data tables in a variety of ways. Throughout this section, we will work with a Google Spreadsheet that contains 128 records, each with 10 fields (or, it has 10 columns and 128 rows). The spreadsheet describes the locations of cities in North America. This data comes from @(hyperlink "https://people.sc.fsu.edu/~jburkardt/data/csv/csv.html" "here"), and was made available under the GPL. The spreadsheet is @(hyperlink cities-gsheet "viewable online").

@(define cities-gsheet "http://bit.ly/cities-gsheet")

Or, if you just want a sense for what it looks like, it looks a bit like this:

@(define-runtime-path cs "cities-sheet.png")
@centered{
  @(image #:scale 0.25 cs)
}

Also, this section borrows the visual language of the @(hyperlink "https://github.com/rstudio/cheatsheets/blob/master/data-transformation.pdf" "dplyr") library for depicting operations on data-tables.

@include-section["operations/select.scrbl"]
@include-section["operations/sieve.scrbl"]
@include-section["operations/pull.scrbl"]
