How do I make a new df with the mean of a certain columns in r?

Asked Jun 21 '20 at 12:52

Active Jun 21 '20 at 13:14

Viewed 27 times

I have a df with sessions of clients with for every session the duration. I want to have a new df where I have per client the avergage session duration. The sessionid's and client id's are rendom generated numbers in my data, but I simplified it here to be more clear.

My data looks like:

Sessionid    Clientid    Session_duration
    1           1               40
    2           1               10
    3           1               100
    4           2               32
    5           2               12 
    6           3               3

I want to have output like:

Clientid    avg_session_duration
   1                 50
   2                 22
   3                 3

I tried this the following code, but then I get only the average of the whole column.

mydata %>% 
  group_by(Clientid) %>% 
  summarise(avg_session = mean(Session_duration, na.rm = T))

EDIT: the problem was what Henrik highlighted. After detaching the plyer and dyplr packages and loading the dplyr again it worked.

edited Jun 21 '20 at 13:14

asked Jun 21 '20 at 12:52

Joost

Except that your variable is called `Session_duration` in the df instead of `sessionDuration` in the code your code works fine and gives the desired output. – stefan Jun 21 '20 at 12:57
1

Try using `dplyr::summarise` instead of only `summarise`. – Ronak Shah Jun 21 '20 at 13:05
Your code worked fine on my machine, and provided means for three groups. – Zhiqiang Wang Jun 21 '20 at 13:09

How do I make a new df with the mean of a certain columns in r?

0 Answers0