CODEWITHSUNDEEP
rdataframestatistics
Noob3000
Noob3000

Reputation: 53

How do I Divide Values in a Column by the Value in the Last Cell?

So I am working in R, and I am trying to write a function. But I reached a roadblock.

I have the following df:

Number Freq CumFreq
00.1 2 2
00.5 1 3

...so on and so forth.

I'd like to have it so the numbers in df$CumFreq are divided by the last cell in the df$CumFreq, and create a new column. For instance:

Number Freq CumFreq CF/n
00.1 2 2 0.667
00.5 1 3 1

Any advice on how to write this out?

Upvotes: 1

Views: 663

Answers (2)

benson23
benson23

Reputation: 19097

Here's a dplyr approach using mutate:

df %>% mutate("CF/n" = CumFreq/sum(Freq))

  Number Freq CumFreq      CF/n
1   00.1    2       2 0.6666667
2   00.5    1       3 1.0000000

Upvotes: 2

ThomasIsCoding
ThomasIsCoding

Reputation: 101335

You can try

df$CFn <- with(df,CumFreq/sum(Freq))

or

df$CFn <- with(df,CumFreq/tail(CumFreq,1))

Upvotes: 2

Related Questions