Post reply

Long Formats

  • August 15, 2018 at 12:05 am

    #77516

    Comments posted to this topic are about the item Long Formats

  • August 15, 2018 at 4:06 am

    #2001802

    Need to dust off my R
    very true that if you don't use it for a while, you lose it...

    Thanks for the question, Steve

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • August 15, 2018 at 8:35 am

    #2001894

    For sure. I had to mess with this a bit to get an understanding, and then search a few older commands to set up a demo. This is after I haven't done any R in a month.

  • August 17, 2018 at 6:14 am

    #2002212

    Not done much with R yet, definitely need to upskill!
    Thanks for the question Steve

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

  • August 17, 2018 at 7:36 am

    #2002231

    My answer would be ... don't do this in R. 😀  It's simple to do in T-SQL.  And it's funny a bit... you've nicely covered up the word "EAV" with the term, "Long Format". 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 17, 2018 at 8:10 am

    #2002247

    Jeff Moden - Friday, August 17, 2018 7:36 AM

    My answer would be ... don't do this in R. 😀  It's simple to do in T-SQL.  And it's funny a bit... you've nicely covered up the word "EAV" with the term, "Long Format". 😉

    Long format is the R term. You do this for analysis in plotting to get multiple values. This isn't for modeling or storage.

  • August 17, 2018 at 8:38 am

    #2002262

    Steve Jones - SSC Editor - Friday, August 17, 2018 8:10 AM

    Jeff Moden - Friday, August 17, 2018 7:36 AM

    My answer would be ... don't do this in R. 😀  It's simple to do in T-SQL.  And it's funny a bit... you've nicely covered up the word "EAV" with the term, "Long Format". 😉

    Long format is the R term. You do this for analysis in plotting to get multiple values. This isn't for modeling or storage.

    So R can't handle a 2 column row of data? 😀  (Just kidding).

    I may have to break down and learn more about R because I do like the syntactical brevity a whole lot.  I wish MS understood that when the wrote PIVOT.  For that matter, they'd have done well if the incorporated the features of PIVOT found in MS Access instead of the god-awful one they settled on for SQL Server.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 17, 2018 at 10:20 am

    #2002292

    Jeff Moden - Friday, August 17, 2018 8:38 AM

    So R can't handle a 2 column row of data? 😀  (Just kidding).

    I may have to break down and learn more about R because I do like the syntactical brevity a whole lot.  I wish MS understood that when the wrote PIVOT.  For that matter, they'd have done well if the incorporated the features of PIVOT found in MS Access instead of the god-awful one they settled on for SQL Server.

    It can, but for plotting multiple items, think multiple line charts together, you want the long format.

    Don't learn R. It's  got no great advantage I can see of Python and Python can do all of what R does and more. Most of the data analysis stuff has been ported to Python.

  • August 17, 2018 at 4:27 pm

    #2002327

    Steve Jones - SSC Editor - Friday, August 17, 2018 10:20 AM

    Jeff Moden - Friday, August 17, 2018 8:38 AM

    So R can't handle a 2 column row of data? 😀  (Just kidding).

    I may have to break down and learn more about R because I do like the syntactical brevity a whole lot.  I wish MS understood that when the wrote PIVOT.  For that matter, they'd have done well if the incorporated the features of PIVOT found in MS Access instead of the god-awful one they settled on for SQL Server.

    It can, but for plotting multiple items, think multiple line charts together, you want the long format.

    Don't learn R. It's  got no great advantage I can see of Python and Python can do all of what R does and more. Most of the data analysis stuff has been ported to Python.

    Good tip.  Thanks, Steve.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • August 18, 2018 at 11:33 am

    #2002366

    You're welcome. Once I started with R, I realized it's a PIA and nowhere near as clear. I had some Python experience and started to see all the plotting, all the ML, all the analysis libraries in R that existed in Python. If you want to have some fun and get started, this is a good book you can read online: http://www.diveintopython3.net/

    You can download Python 3 and put it on a laptop. I started with the free PyCharm IDE, but now I tend to use some VSCode. Both work well.

  • August 18, 2018 at 6:57 pm

    #2002373

    Steve Jones - SSC Editor - Saturday, August 18, 2018 11:33 AM

    You're welcome. Once I started with R, I realized it's a PIA and nowhere near as clear. I had some Python experience and started to see all the plotting, all the ML, all the analysis libraries in R that existed in Python. If you want to have some fun and get started, this is a good book you can read online: http://www.diveintopython3.net/

    You can download Python 3 and put it on a laptop. I started with the free PyCharm IDE, but now I tend to use some VSCode. Both work well.

    Awesome.  Thanks again, Steve.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 11 posts - 1 through 10 (of 10 total)

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