Reading data from files in R, file formats, and special cases; Learn R Video 12

Do you want to learn to program in R? If you're a beginner, you're in the right place! This is the twelfth video in an introductory series that will teach you to program and analyze data in R. This series of videos is suitable for beginners or experienced programmers or data analysts who want to learn R. In this video we learn about different file formats and how to read them in to a tibble, including special cases such as interpreting missing values, skipping extra rows, and changing column names. Let's have fun learning to program with R!

The auto-graded exercises that go with this video can be downloaded here:
https://github.com/ProfessorBurke/REx...
(Read the readme file and then download or fork the Video12-files folder to use in RStudio.)

Do you want a great book to go along with these videos? You might find it helpful to read chapter 6 (Importing data in case the chapter has moved) in Introduction to Data Science: Data Analysis and Prediction Algorithms with R by Rafael A. Irizarry:
http://rafalab.dfci.harvard.edu/dsboo...

Coming from a programming background, one of the most helpful R books that I've read is The art of R programming: A tour of statistical software design, by Norman Matloff*:
https://amzn.to/3YCsQZD

And of course, the ultimate source on the Tidyverse itself is Hadley Wickham! I urge you to read his book:
https://r4ds.hadley.nz/

And here is the Data import chapter:
https://r4ds.hadley.nz/data-import

The first R video is here:
   • R Basics: Math, Vectors, Variables, a...  

The introduction to R playlist is here:
   • R Basics: Math, Vectors, Variables, a...  

Download and install R:
https://www.r-project.org/

Download and install RStudio:
https://posit.co/downloads/

Hadley Wickham's R style guide:
http://adv-r.had.co.nz/Style.html

Here is all the data from the video.
The apportionment table from census.gov is here:
https://www2.census.gov/programs-surv...

The civil rights data is here:
Mark, Skip and Cingranelli, David and Filippov, Mikhail and Richards, David L., The CIRIGHTS Data Project Scoring Manual V2.11.06.23 (November 6, 2023). Available at SSRN: https://ssrn.com/abstract=4625036 or http://dx.doi.org/10.2139/ssrn.4625036
Retrieved from:
https://cirights.com/

The brittleness data (with missing values) is here:
https://openmv.net/info/brittleness-i...

The github repository with all of the code examples for the introductory programming in R videos is here:
https://github.com/ProfessorBurke/REx...

*As an Amazon Associate I earn from qualifying purchases. Your purchases help me continue to bring you content!

Thumbnail image generated by NightCafe and edited in Photoshop.

00:00 Welcome!
00:26 File formats and special cases
07:51 read_csv with no arguments
09:24 what is NA?
10:10 read_csv with special NA values
13:02 read_xlsx skipping lines, changing column names
16:12 reading characters as factors