How do I create subset dataframe if column names are in the character list?

Question

I have a data frame with a range of dates as the column names and a list of stock tickers down the y axis. I then have a separate character list of dates.

I want to create a subset of the data frame if the dates in the data frame match any of the dates in the character list.

Below please find links to images of the data frame and the list of dates. I would appreciate any advice as I have not been able to find a solution.

enter image description here

Posting pictures of data is not helpful. See [how to create a reproducible example](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example). That will make it easier to help you. — MrFlick, May 30 '17 at 13:01
Adding to the comments of @MrFlick , instead of an image, please use `dput` to create a text version of your data and paste the results into your question. If the data is too long, you can provide a sample with something like `dput(head(myData, 20))` — G5W, May 30 '17 at 13:06

score 2 · Answer 1 · answered May 30 '17 at 13:09

2

If understand you well, you want your data's column which are on the list you put ?

I think this could work :

new_data = data[,which(colnames(data)%in%your_list)]

Tell me if this isn't what you want.

answered May 30 '17 at 13:09

MBnnn

308
2
13

That was amazingly helpful that you so much. Really appreciate your guidance. – asathe1 May 30 '17 at 14:03

How do I create subset dataframe if column names are in the character list?

1 Answers1