Skip to content
Prev 395151 / 398502 Next

replace character by numeric value

On Wed, 27 Sep 2023, arnaud gaboury writes:
I'd use something like this:

    map <- c(BUY = 1, SELL = -1)
    mydf1$side <- map[mydf1$side]
    str(mydf1)
    ## Classes ?data.table? and 'data.frame':	1 obs. of  4 variables:
    ##  $ symbol               : chr "ETHUSDT"
    ##  $ cummulative_quote_qty: num 2000
    ##  $ side                 : num 1
    
    mydf2$side <- map[mydf2$side]
    str(mydf2)
    ## Classes ?data.table? and 'data.frame':	3 obs. of  4 variables:
    ##  $ symbol               : chr  "ETHUSDT" "ETHUSDT" "ETHUSDT"
    ##  $ cummulative_quote_qty: num  1999 0 3000
    ##  $ side                 : num  -1 1 1
    ##  $ time                 : POSIXct, format: "2023-09-26 09:20:48" ...
Message-ID: <87ediin53e.fsf@enricoschumann.net>
In-Reply-To: <CAK1hC9sWDHGLAEOv8zf+kHWtSnkxfgTg0KGEAro3mcQbMamrdA@mail.gmail.com> (arnaud gaboury's message of "Wed, 27 Sep 2023 13:01:08 +0200")