how to calculate combined column mean value in R

Question

I want to make representative combined column and calculate mean.

for example, there are BILL_AMT(1,2,3,4,5,6). but i want

BILL_AMT <- which includes mean value of all BILL_AMT values.

how can i do?

Do you mean `colSums()`? – user2974951 Oct 23 '18 at 07:34 — user2974951, Oct 23 '18 at 07:34
Please provide a reproducible example of your data. – s_baldur Oct 23 '18 at 08:46 — s_baldur, Oct 23 '18 at 08:46
i did it. not colsums(). it was rowSums() . thanks!! – 유승우 Oct 26 '18 at 08:21 — 유승우, Oct 26 '18 at 08:21

ceefel · Answer 1 · 2018-10-26T08:22:49.523

0

Please provide a reproducible example of your data.

Just assuming what you're trying to do:

data <- data.frame(x = rep(1:10,1), y = rep(11:20, 1))

data %>% 
  rowwise() %>% 
  mutate(mean = mean(x + y + ...))

Based on your comment: fill in your variables for x + y + ...

edited Oct 26 '18 at 08:22

answered Oct 23 '18 at 07:51

ceefel

i mean make a new value which has mean value of all pay_AMTs.(pay_AMT1,2,3,4,5,6) for example, pay_amt = 1 column, 10000 rows. each row has mean value of pay_amt(1,2,3,4,5,6) – 유승우 Oct 26 '18 at 08:14
Updated the answer – ceefel Oct 26 '18 at 08:23

1 Answers1