Merging Two Datasets, Removing recurring columns, Adding a new column

Question

I have two datasets : Here's the 1st, and Here's the 2nd.

My aim is to merge these datas, removing the 1st or 2nd "JN" column since it's recurring, and find the ratio of "Freq" between these datas.

For each Row, I want to use this calculation :

=(100)-(100*(FreqBL/FreqB))

and place this new calculation to 4th column.

The new data should look like:

JN  FreqBL  FreqB  Success Ratio
 4    10      33      69.6969

But I don't know how to select all rows seperately and the necessary code for the calculation.

Thanks

score 2 · Accepted Answer · answered Dec 12 '12 at 19:06

2

You want to merge the data sets. For the next time, I will recommend you provide a small reproducible example.

> new.dt <- merge(dt1, dt2)
> new.dt$"Success ratio" <- with(new.dt, 100-(100 * (FreqBL/FreqB)))
> head(new.dt)
  JN FreqB FreqBL Success ratio
1  4    33     10      69.69697
2  8    49     10      79.59184
3 10    44     13      70.45455
4 11    38      7      81.57895
5 13    29      3      89.65517
6 17    15     10      33.33333

answered Dec 12 '12 at 19:06

Roman Luštrik

69,533
24
154
197

Thanks Roman, since I'm just a beginner, I'm trying to learn as fast as possible. – forochelian Dec 12 '12 at 19:12
@forochelian here's a page that might help you get started: http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example – Roman Luštrik Dec 13 '12 at 09:40

Merging Two Datasets, Removing recurring columns, Adding a new column

1 Answers1