I am running the most simple code I can imagine. All I'm doing is asking R to import a csv file, choose a column, and then show me the value.
DEXUSUK = read.csv('C:/Users/Seth Reuter/Google Drive/GSU/Financial Engineering/Final Project/DEXUSUK.csv')
ExchangeRates = DEXUSUK$DEXUSUK
All I need to do is pull ExchangeRates[1]
, which should return a single value. Instead I'm getting.
> ExchangeRates[1]
[1] 1.4451
2018 Levels: . 1.3658 1.3728 1.3757 1.3780 1.3811 1.3840 1.3960 1.3972 1.3974 1.3989 1.4018 1.4023 1.4034 ... 2.1104
>
What is that 2018 Levels
stuff? And how do I get rid of it?
This is what I've tried.
> ExchangeRates[1]$Value
Error in ExchangeRates[1]$Value : $ operator is invalid for atomic vectors
> ExchangeRates[1]$VALUE
Error in ExchangeRates[1]$VALUE : $ operator is invalid for atomic vectors
> ExchangeRates[1]$value
Error in ExchangeRates[1]$value : $ operator is invalid for atomic vectors
The file I'm using is here. I downloaded it from the federal reserve economic database.