Data Visualization in R

  1. Foundations of R for Data Visualization
    1. R Data Structures
      1. Vectors
        1. Numeric Vectors
          1. Character Vectors
            1. Logical Vectors
              1. Indexing and Subsetting
                1. Vector Operations
                2. Factors
                  1. Creating Factors
                    1. Factor Levels
                      1. Ordered Factors
                        1. Factor Manipulation
                        2. Lists
                          1. Creating Lists
                            1. Accessing List Elements
                              1. Nested Lists
                                1. List Operations
                                2. Data Frames
                                  1. Creating Data Frames
                                    1. Accessing Rows and Columns
                                      1. Data Frame Operations
                                        1. Combining Data Frames
                                        2. Tibbles
                                          1. Differences from Data Frames
                                            1. Creating Tibbles
                                              1. Printing Behavior
                                                1. Subsetting Behavior
                                              2. Data Manipulation with dplyr
                                                1. The Pipe Operator
                                                  1. Magrittr Pipe (%>%)
                                                    1. Native Pipe (|>)
                                                      1. Chaining Operations
                                                        1. Pipe Best Practices
                                                        2. Core dplyr Verbs
                                                          1. select() for Column Selection
                                                            1. Selecting by Name
                                                              1. Selecting by Position
                                                                1. Helper Functions
                                                                  1. Renaming Columns
                                                                  2. filter() for Row Filtering
                                                                    1. Logical Conditions
                                                                      1. Combining Conditions
                                                                        1. Missing Value Handling
                                                                        2. mutate() for Variable Creation
                                                                          1. Creating New Variables
                                                                            1. Modifying Existing Variables
                                                                              1. Conditional Variables
                                                                                1. Window Functions
                                                                                2. summarise() for Data Summarization
                                                                                  1. Aggregation Functions
                                                                                    1. Multiple Summaries
                                                                                      1. Handling Missing Values
                                                                                      2. arrange() for Sorting
                                                                                        1. Single Column Sorting
                                                                                          1. Multiple Column Sorting
                                                                                            1. Ascending and Descending Order
                                                                                          2. Grouping Operations
                                                                                            1. group_by() Function
                                                                                              1. Grouped Operations
                                                                                                1. Multiple Grouping Variables
                                                                                                  1. Ungrouping Data
                                                                                                  2. Joining Data
                                                                                                    1. Inner Joins
                                                                                                      1. Left Joins
                                                                                                        1. Right Joins
                                                                                                          1. Full Joins
                                                                                                            1. Semi Joins
                                                                                                              1. Anti Joins
                                                                                                            2. Data Tidying with tidyr
                                                                                                              1. Tidy Data Principles
                                                                                                                1. Variables in Columns
                                                                                                                  1. Observations in Rows
                                                                                                                    1. Values in Cells
                                                                                                                      1. Benefits for Visualization
                                                                                                                      2. Reshaping Data
                                                                                                                        1. pivot_longer() for Wide to Long
                                                                                                                          1. Basic Syntax
                                                                                                                            1. Multiple Variables
                                                                                                                              1. Handling Names and Values
                                                                                                                              2. pivot_wider() for Long to Wide
                                                                                                                                1. Basic Syntax
                                                                                                                                  1. Handling Missing Values
                                                                                                                                    1. Multiple Value Columns
                                                                                                                                  2. Handling Missing Values
                                                                                                                                    1. drop_na() Function
                                                                                                                                      1. fill() Function
                                                                                                                                        1. replace_na() Function
                                                                                                                                        2. Separating and Uniting Columns
                                                                                                                                          1. separate() Function
                                                                                                                                            1. unite() Function
                                                                                                                                          2. Data Import and Export
                                                                                                                                            1. Reading Delimited Files
                                                                                                                                              1. read.csv() from Base R
                                                                                                                                                1. read_csv() from readr
                                                                                                                                                  1. Handling Different Delimiters
                                                                                                                                                    1. Character Encoding
                                                                                                                                                      1. Missing Value Specifications
                                                                                                                                                      2. Reading Excel Files
                                                                                                                                                        1. readxl Package
                                                                                                                                                          1. Reading Specific Sheets
                                                                                                                                                            1. Reading Cell Ranges
                                                                                                                                                              1. Handling Multiple Sheets
                                                                                                                                                              2. Reading from Statistical Software
                                                                                                                                                                1. SPSS Files with haven
                                                                                                                                                                  1. Stata Files with haven
                                                                                                                                                                    1. SAS Files with haven
                                                                                                                                                                    2. Reading from Databases
                                                                                                                                                                      1. DBI Package
                                                                                                                                                                        1. Database Connections
                                                                                                                                                                          1. SQL Queries in R