quick R script
$10-30 AUD
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
Project ID: #15884868
About the project
2 freelancers are bidding on average $75 for this job
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