Subset an imported xlsx in R without formula. subset gives error because of this

Question

I am trying to subset a column in R from an xlsx file. That particular column in excel is being used to plot a graph. Because of which when I try to subset that column it gives an error.

Error in subset.default(ds[, 2]) : argument "subset" is missing, with no default

This can be done by converting xlsx to csv or removing the graph but I want to solve this problem in R.

require(xlsx)
ds<-read.xlsx("Attachment-.xlsx", sheetName= "exchangeGBP", keepFormulas = FALSE)
ds<-subset(ds[,-1])
apply(ds,2,function)

The data looks like this:

Show your data and the other code you used to read it, please. — Taher A. Ghaleb, Dec 06 '18 at 16:53
ds<-read.xlsx("Attachment.xlsx", sheetName= "exchangeGBP", keepFormulas = FALSE) ds<-subset(ds[,-1]) — Annie Zulfiquar, Dec 06 '18 at 16:54
Take a look [here](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example), how to present your problems in SO. Welcome! Copy-pasting an image is a no-no here. — massisenergy, Dec 06 '18 at 17:10
So, you want `ds` to have only the whole data in the column `GBP/EUR` or part of it? You want to subset based on what? — Taher A. Ghaleb, Dec 06 '18 at 17:20
I want a subset with the GBP/EUR column only and it's giving me that error — Annie Zulfiquar, Dec 06 '18 at 18:26

score 0 · Answer 1 · answered Dec 06 '18 at 18:47

0

Just did it using ds <- ds$GBP.EUR Although still not sure why subset is giving error. Thanks anyway guys

answered Dec 06 '18 at 18:47

Annie Zulfiquar

29
5

Subset an imported xlsx in R without formula. subset gives error because of this

1 Answers1