Statistics with R

  1. Data Import and Export
    1. File System Navigation
      1. Working Directory
        1. File Paths
          1. Relative vs Absolute Paths
          2. Importing Delimited Files
            1. CSV Files
              1. read.csv() Function
                1. read.table() Function
                  1. readr::read_csv() Function
                  2. Tab-delimited Files
                    1. Custom Delimiters
                      1. Handling Headers
                        1. Specifying Data Types
                          1. Handling Missing Values
                            1. Character Encoding
                            2. Importing Excel Files
                              1. readxl Package
                                1. read_excel() Function
                                  1. Sheet Selection
                                    1. Range Selection
                                    2. openxlsx Package
                                      1. Handling Multiple Sheets
                                      2. Importing from Statistical Software
                                        1. haven Package
                                          1. SPSS Files
                                            1. Stata Files
                                              1. SAS Files
                                              2. foreign Package
                                                1. Preserving Labels and Attributes
                                                2. Database Connections
                                                  1. DBI Package
                                                    1. RSQLite Package
                                                      1. Connecting to Databases
                                                        1. SQL Queries in R
                                                          1. ODBC Connections
                                                          2. Web Data Import
                                                            1. Reading from URLs
                                                              1. Web Scraping Basics
                                                                1. API Data Access
                                                                2. Exporting Data
                                                                  1. Writing CSV Files
                                                                    1. write.csv() Function
                                                                      1. write.table() Function
                                                                        1. readr::write_csv() Function
                                                                        2. Exporting to Excel
                                                                          1. writexl Package
                                                                            1. openxlsx Package
                                                                            2. Saving R Objects
                                                                              1. save() Function
                                                                                1. saveRDS() Function
                                                                                  1. load() Function
                                                                                    1. readRDS() Function

                                                                                Previous

                                                                                4. R Data Structures

                                                                                Go to top

                                                                                Next

                                                                                6. Data Cleaning and Preprocessing