Re: [R] - Trying to replicate VLOOKUP in R - help needed

2020-11-18 Thread Gregg via R-help
t; > On November 18, 2020 7:11:49 AM PST, Gregg via R-help r-help@r-project.org > wrote: > > > Thanks Andrew and Mitch for your help. > > With your assistance, I was able to sort this out. > > Since I have to do this type of thing of often, and since there is no > >

Re: [R] - Trying to replicate VLOOKUP in R - help needed

2020-11-18 Thread Gregg via R-help
package, a simple little VLOOKUP(like) function contained in a package would be of great use. r/ Gregg ‐‐‐ Original Message ‐‐‐ On Monday, November 16, 2020 1:56 PM, Gregg via R-help wrote: > PROBLEM: I am trying to replicate something like a VLOOKUP in R but am having &

[R] - Trying to replicate VLOOKUP in R - help needed

2020-11-16 Thread Gregg via R-help
PROBLEM: I am trying to replicate something like a VLOOKUP in R but am having no success - need a bit of help. GIVEN DATA SET (data.table): (looks something like this, but much bigger) NAME TOTALAUTH ASSIGNED_COMPANY ABERDEEN PROVING GROUND 1 NA ADEL

[R] Would Like Some Advise

2020-08-28 Thread Gregg via R-help
Phillip, The primary differences between Windows and Linux: Windows attempts to monetize most of what you do on your computer in the same way that Facebook, Google, and other Social Media sites go, but Microsoft goes one step further, and they use the OS to monetize Windows Users. Linux on the

[R] How to convert column from millisecond epoch time to yyyy-mm-dd GMT

2020-06-23 Thread Gregg via R-help
Hello to all the smart people out there I have a data.frame labeled itsm_service_type_field. I need to convert the Timestamp field which is epoch time in milliseconds to a -mm-dd GMT Date.  Data.frame format is below. I've attempted to use the lapply and as.POSIXct functions to convert

[R] How to combine two rows in a data table into a third new row, such that the values in the row are added together in the new row?

2020-05-06 Thread Gregg via R-help
If I have a data table that is essentially output titled: "dt_count" - it contains: "","STATUS","N" "1","Resolved",650 "2","Assigned",135 "3","Closed",530 "4","In Progress",56 "5","Pending",75 "6","Cancelled",20 Need to change the "dt_count" data table to a new data table that looks like this:

[R] How to combine two rows in a data table into a third new row, such that the values in the row are added together in the new row?

2020-05-06 Thread Gregg via R-help
I have a data table titled: "dt_count" - it contains: > "","STATUS","N" > "1","Resolved",650 > "2","Assigned",135 > "3","Closed",530 > "4","In Progress",56 > "5","Pending",75 > "6","Cancelled",20 > > I need to change the "dt_count" data table to a new data table that looks > like this: > >