Skip to content

Instantly share code, notes, and snippets.

@DeeplyDiligent

DeeplyDiligent/blog.md Secret

Created January 20, 2019 00:22
Show Gist options
  • Save DeeplyDiligent/61c9e4686624abf65e2b58ec11b40986 to your computer and use it in GitHub Desktop.
Save DeeplyDiligent/61c9e4686624abf65e2b58ec11b40986 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
blog.md

Sources

Normally we import csv/text files then convert to XDF

CSV as source

https://gist.github.com/449a33b2b1c88d042b64035959de5471

Data Frame as source

https://gist.github.com/82e677917971e6291eb5d8dc002ae9bf

##ODBC

  • Either as a table or a query
  • Table
    • Import the entire thing and process it into a variable like iris
  • Query
    • Run a query on the database and then use the generated data frame from that

Summaries

Summaries allow you to summarise data.

rxSummary

https://gist.github.com/82b8d960197587d0910ed31d7b72af4f

RxCrossTab and RxCube

Groups by a certain factor and then displays in table/grid form

Defaults for RxCrossTabs and Rx Cube?

  • RxCrossTab will give sum as default
  • RxCube will give mean as default

https://gist.github.com/f105cd193d74ae6398c7f378e9f83e9a

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment