Comments posted to this topic are about the item Basic Data Manipulation for Relational Data in R
Thanks for the good article.
Really impressive, actually took us to very basic rules of using R, and a way to describe is impressive
The article is very enlightening for me. Thanks for that.
I have a question regarding the last code in the article. The query written only lists as output fields "Name" and "Size"
subset(advdata, advdata$Size<45, select=Name:Size)
However, the results show another column, named "ListPrice".
Is there a typo in the query or R uses a different algorithm to determine the columns to be selected?
Thanks in advance and I apologize for my bad english.
Regards from Argentina.
Hi Ariel, the colon : between fields indicates from-to, from this column to that column, and you will get all the fields in between. So when you say Name:Size, since ListPrice is the column between the two, it is also listed. If you want just Name and Size, you have to instead use subset(advdata, advdata$Size<45, select=c(Name,Size)) - that will give you just the two columns or more that you need. I hope this answers your question. No need to apologize on the english etc. - you communicated what you wanted to know just fine. Thank you.
Great. Thank you so much for having the time to let me know.
Excellent article. Your writing is very clear and concise. I look forward to many more post by you. Thank you for your contributions.
Jeff "Woody" Torres
Viewing 7 posts - 1 through 6 (of 6 total)