This chapter will demonstrate practical, hands-on code examples that show how to handle converting all kinds of data into R for EDA. Here, we will cover how to use advanced options while importing datasets such as delimited data, Excel data, JSON data, and data from web APIs. It will cover the powerful R packages that are needed to work with various data formats.
The following topics will be covered in this chapter:
- Converting all kinds of delimited datasets into R packages using the readr package
- Using advanced options for reading in Excel data
- Learning how to use the jsonlite package to read JSON in R data structures
- Understanding how to use the httr package to read data into R from web APIs
- Getting data into R by scraping the web using the rvest package
- Connecting to relational databases from R using the DBI package
