R Programming

  1. Data Import and Export
    1. File System Navigation
      1. Working Directory Concepts
        1. File Path Specifications
          1. Directory Listing (`list.files()`)
            1. File Information (`file.info()`)
            2. Reading Text-based Data Files
              1. CSV Files
                1. `read.csv()` Function
                  1. `read.csv2()` for European Format
                    1. Handling Headers
                      1. Specifying Data Types
                        1. Dealing with Missing Values
                        2. Tab-delimited Files
                          1. `read.delim()` Function
                            1. `read.delim2()` Function
                            2. General Delimited Files
                              1. `read.table()` Function
                                1. Custom Separators
                                  1. Quote Handling
                                    1. Comment Characters
                                    2. Fixed-width Files
                                      1. `read.fwf()` Function
                                        1. Specifying Column Widths
                                          1. Column Positioning
                                        2. Reading Structured Data Files
                                          1. Excel Files
                                            1. `readxl` Package
                                              1. `read_excel()` Function
                                                1. Sheet Selection
                                                  1. Range Specification
                                                  2. `openxlsx` Package
                                                    1. Advanced Excel Features
                                                      1. Multiple Sheets
                                                    2. JSON Files
                                                      1. `jsonlite` Package
                                                        1. `fromJSON()` Function
                                                          1. Nested JSON Structures
                                                          2. XML Files
                                                            1. `xml2` Package
                                                              1. XML Parsing
                                                                1. XPath Queries
                                                              2. Reading from Statistical Software
                                                                1. SAS Files
                                                                  1. `haven` Package
                                                                    1. `read_sas()` Function
                                                                    2. SPSS Files
                                                                      1. `read_spss()` Function
                                                                        1. Variable Labels
                                                                          1. Value Labels
                                                                          2. Stata Files
                                                                            1. `read_stata()` Function
                                                                              1. Stata-specific Features
                                                                              2. Other Formats
                                                                                1. `foreign` Package
                                                                                  1. Legacy Format Support
                                                                                2. Web Data Sources
                                                                                  1. Reading from URLs
                                                                                    1. Direct URL Reading
                                                                                      1. HTTP Headers
                                                                                        1. Authentication
                                                                                        2. Web Scraping
                                                                                          1. `rvest` Package
                                                                                            1. HTML Parsing
                                                                                              1. CSS Selectors
                                                                                              2. APIs and Web Services
                                                                                                1. REST API Consumption
                                                                                                  1. JSON API Responses
                                                                                                    1. Authentication Methods
                                                                                                  2. Writing Data Files
                                                                                                    1. CSV Export
                                                                                                      1. `write.csv()` Function
                                                                                                        1. Custom Separators
                                                                                                          1. Row Names Handling
                                                                                                          2. General Text Export
                                                                                                            1. `write.table()` Function
                                                                                                              1. Formatting Options
                                                                                                              2. Excel Export
                                                                                                                1. `writexl` Package
                                                                                                                  1. `openxlsx` Package
                                                                                                                    1. Multiple Sheets
                                                                                                                      1. Formatting Options
                                                                                                                    2. R Object Persistence
                                                                                                                      1. Saving R Objects
                                                                                                                        1. `save()` Function
                                                                                                                          1. `saveRDS()` Function
                                                                                                                            1. Workspace Saving (`save.image()`)
                                                                                                                            2. Loading R Objects
                                                                                                                              1. `load()` Function
                                                                                                                                1. `readRDS()` Function
                                                                                                                                  1. Object Name Preservation
                                                                                                                                2. Database Connectivity
                                                                                                                                  1. Database Connection Concepts
                                                                                                                                    1. DBI Package Framework
                                                                                                                                      1. Connection Management
                                                                                                                                        1. Query Execution
                                                                                                                                          1. Result Handling
                                                                                                                                          2. Specific Database Drivers
                                                                                                                                            1. SQLite (`RSQLite`)
                                                                                                                                              1. PostgreSQL (`RPostgreSQL`)
                                                                                                                                                1. MySQL/MariaDB (`RMariaDB`)
                                                                                                                                                  1. SQL Server (`odbc`)
                                                                                                                                                  2. Database Operations
                                                                                                                                                    1. Reading Tables
                                                                                                                                                      1. Writing Tables
                                                                                                                                                        1. SQL Query Execution
                                                                                                                                                          1. Transaction Management

                                                                                                                                                      Previous

                                                                                                                                                      5. R Data Structures

                                                                                                                                                      Go to top

                                                                                                                                                      Next

                                                                                                                                                      7. Data Manipulation with Base R