Annulleret

quick R script

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

Evner: Programmeringssproget R

Se mere: script convert text csv file, script able convert csv file hst file, perl script convert xml csv file, r output to text file, save console output to file r, r print text to pdf, r sink function, r write to text file, r output to pdf, capture.output r, r pdf plot, php script parse format csv file, run script computers listed csv file, perl script read columns csv file, bash script parsing comma csv file, script mysql query csv file email, free php script update mysql csv file, script asp importing csv file access, entire php script html upload csv file, script update tables csv file

Om arbejdsgiveren:
( 5 bedømmelser ) collingwood, Australia

Projekt ID: #15884868

2 freelancere byder i gennemsnit $75 på dette job

$100 AUD in 4 dage
(38 bedømmelser)
5.9
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 Flere

$50 AUD på 1 dag
(13 bedømmelser)
5.4