quick R script

Cancelled Posted 6 years ago Paid on delivery
Cancelled Paid on delivery

Quick R script. Take parent CSV file with a list of datetimes and an ID variable and a third variable x. Then take key csv file with list of datetimes and an id variable.

Return parent CSV, but with three new colums: Near, NearClose and Numbernear

Near = 1 for all values where the key matches and the time in parent is 45 seconds or less after a time in datetimes.

Numbernear = the sum of near=1 for each match from the key csv file

Nearclose = 1 for the smallest value of X from every matches from a datetime in the key csv file.

example: (using seconds rather than datetime for clarity)

parent CSV

User time X

2 45 s 100

2 48 s 85

2 49 s 43

3 50 s 10

3 150 100

4 360 150

4 10 70

4 200 69

4 150 30

key csv

User time

2 30

3 80

4 180

Produces result:

parent CSV Near, NearClose, Numbernear

User time X

2 45 s 100 1 3 0

2 48 s 85 1 3 0

2 49 s 43 1 3 1

3 50 s 10 0

3 150 100 1 1 1

4 360 150 0

4 10 70 0

4 200 69 1 1 1

R Programming Language

Project ID: #15884868

About the project

2 proposals Remote project Active 6 years ago

2 freelancers are bidding on average $75 for this job

schoudhary1553

Greeting, I have understood your R script task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in R Programming La More

$50 AUD in 1 day
(13 Reviews)
5.4