Import text files in other formats

The previous exercise taught you how to import well-formatted CSV data using getSymbols(). Unfortunately, most data are not well-formatted.

The zoo package provides several functions to import text files as zoo objects. The main function is read.zoo(), which wraps read.table(). The xts class extends zoo, so you can easily convert the result of read.zoo() into an xts object by using as.xts().

In this exercise, you will learn how you can use read.zoo() to import the same AMZN.csv data from the previous exercise.

This exercise is part of the course

Importing and Managing Financial Data in R

View Course

Exercise instructions

Use read.zoo() to import AMZN.csv. Assign the output to an object named amzn_zoo.
Convert amzn_zoo to an xts object. Assign the output to an object named amzn_xts.
Look at the first few rows of amzn_xts.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Import the AMZN.csv file using read.zoo
amzn_zoo <- read.zoo("___", sep = "___", header = ___)

# Convert to xts


# Look at the first few rows of amzn_xts

Edit and Run Code