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.

Deze oefening maakt deel uit van de cursus

Importing and Managing Financial Data in R

Cursus bekijken

Oefeninstructies

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.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

# 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

Code bewerken en uitvoeren