The Examples Book

Appendices

Corporate Partners Personal Projects Seminar TA TDM Internal Documentation The Examples Book Tools

Tools

- Anvil
- GitHub
- Matlab
  - Training
- Perl
  - Perl Books
- PowerBI
  - PowerBI in Teams
- Python
- R
  - Variables
  - Logical Operators
  - Lists and Vectors
  - data.frames
  - Reading and Writing Data
  - Control Flow
  - Writing Functions
  - R Base Functions
    - ncol
    - nrow
    - dim
    - str
    - head
    - tail
    - unique
    - mean
    - median
    - var
    - sd
    - abs
    - sum
    - min
    - max
    - length
    - table & prop.table
    - rep
    - seq
    - which
    - grep
    - sort
    - order
    - paste & paste0
    - cut
    - split
    - subset
    - merge
  - Apply Functions
  - Plotting
    - R graphics plotting
      - barplot
    - ggplot2
      - geom_point
  - Tidyverse
    - Piping
    - select
    - transmute
    - mutate
    - case_when
    - between
    - glimpse
    - filter
    - arrange
    - group_by
    - summarize
    - str_extract and str_extract_all
    - lubridate
    - strrep
    - nchar
  - data.table
  - SQL in R
  - Scraping
  - Shiny
  - R Bloggers - Resource for Variety of R Topics
- SQL
- Unix
  - Standard Utilities
    - man
    - pwd
    - ls
    - cd
    - cat
    - head
    - tail
    - touch
    - cp
    - rm
    - rmdir
    - which
    - type
    - wc
    - cut
    - uniq
    - find
    - tr
    - grep
    - ssh
  - Text Editors
    - vim
    - emacs
    - nano
  - Other Topics
    - Permissions
    - ~ & . & ..
    - Piping
    - Scripts

Corporate Partners
- stable
Personal
- stable
Projects
- stable
Seminar TA
- stable
TDM Internal Documentation
- stable
The Examples Book
- stable
Tools
- stable

Tools stable

Tools
SQL
Queries
SQL Baseball examples

Baseball Examples

SQL Baseball examples with no joins
SQL Baseball examples with one join
SQL Baseball examples with two joins
SQL Baseball examples with a subquery

Queries SQL Chinook examples

Purdue University, The Data Mine, Hillenbrand Hall, 1301 Third Street, West Lafayette, IN 47906-4206, (765) 494-0325

© 2024 Purdue University | An equal access/equal opportunity university | Integrity Statement | Copyright Complaints | Maintained by The Data Mine

Contact The Data Mine at [email protected] for accessibility issues with this page | Accessibility Resources