Post reply

Basic Data Manipulation for Relational Data in R

  • October 19, 2016 at 10:24 pm

    #400896

    Comments posted to this topic are about the item Basic Data Manipulation for Relational Data in R

  • October 20, 2016 at 10:48 am

    #1907722

    Thanks for the good article.

  • October 21, 2016 at 9:00 am

    #1907991

    Really impressive, actually took us to very basic rules of using R, and a way to describe is impressive

    Sheraz Mirza::hehe:

  • October 21, 2016 at 10:14 am

    #1908016

    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.

    Ariel.

  • October 21, 2016 at 10:57 am

    #1908028

    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.

  • October 21, 2016 at 11:01 am

    #1908032

    Great. Thank you so much for having the time to let me know.

    Regards.

    Ariel.

  • January 10, 2017 at 1:23 am

    #1921551

    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 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy