Styjun

How would you control supersoldiers in a late iron-age society?

I was promised a work PC but still awaiting approval 3 months later so using my own laptop - Is it fair to ask employer for laptop insurance?

What is and what isn't ullage in rocket science?

A medieval fantasy adventurer lights a torch in a 100% pure oxygen room. What happens?

What is the mathematical notation for rounding a given number to the nearest integer?

Bash, import output from command as command

Thematic, genred concepts in Ancient Greek?

Newly created XFS filesystem shows 78 GB used

Some Prime Peerage

Should you only use colons and periods in dialogues?

Why did it become so much more expensive to start a university?

Might have gotten a coworker sick, should I address this?

How are aircraft depainted?

What was redacted in the Yellowhammer report? (Point 15)

What does a Light weapon mean mechanically?

How do certain apps show new notifications when internet access is restricted to them?

Is there a real-world mythological counterpart to WoW's "kill your gods for power" theme?

Why did they ever make smaller than full-frame sensors?

POSIX compatible way to get user name associated with a user ID

2000s space film where an alien species has almost wiped out the human race in a war

why car dealer is insisting on loan v/s cash

Why do sellers care about down payments?

Can I conceal an antihero's insanity - and should I?

Stucturing information on this trade show banner

How to calculate mean value for each column ignoring NA [duplicate]

calculate the mean for each column of a matrix in RHow to sort a dataframe by multiple column(s)R: removing rows and replacing values using conditions from multiple columnsAssign values based on NA in other two variables of a data frameR- Consecutive K-means clustering operations in Rcount the number of non-NA numeric values of each row in dplyrComplicated filter statements in dbplyr using lists of listsdata frame set value based on matching specific row name to column nameloop a function in r and output the result to .csv fileconditional lag calculations using RGet minimum value for each group by multiple subgroups

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

This question already has an answer here:

• 
  calculate the mean for each column of a matrix in R
  
  6 answers
  
  

table, data.frame.

Which has 12 columns with variable names and 24 rows df

Like:

Var1 Var2 Var3 Var4 Var12
1 NA 2 3 4
5 6 2 3 3
NA 7 8 NA 4

And I want to calculate the mean for each column while ignoring the Na's
For example:

colMeans(df)

And get the result like:

Var1 Var2 Var3 Var4 Var12
 3 6,5 4 3 3,66

I don't want the NA's to be considered in the calculation of Mean.

I tried some methods like na.omit, !is.na, but I don't get the desired result like what I described above.

r data.table mean

share|improve this question

edited Mar 28 at 10:59

Ronak Shah

82k1313 gold badges5050 silver badges8787 bronze badges

asked Mar 28 at 10:28

Alex RikaAlex Rika

5888 bronze badges

marked as duplicate by Ronak Shah r
Users with the  r badge can single-handedly close r questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
Mar 28 at 10:57

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  colMeans(df, na.rm = TRUE)
  
  – Ronak Shah
  Mar 28 at 10:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yeah that worked ! Thanx was so easy.. :P
  
  – Alex Rika
  Mar 28 at 10:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You might wanna post it as answer?
  
  – Alex Rika
  Mar 28 at 10:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The calculation of Means is correct but how can I get it like horizontal while getting the col names above each mean number?
  
  – Alex Rika
  Mar 28 at 10:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Not sure what you mean by that. Can you update the post with the expected output?
  
  – Ronak Shah
  Mar 28 at 10:39
  
  

  
  
  
  

 | 
show 3 more comments

0

This question already has an answer here:

• 
  calculate the mean for each column of a matrix in R
  
  6 answers
  
  

table, data.frame.

Which has 12 columns with variable names and 24 rows df

Like:

Var1 Var2 Var3 Var4 Var12
1 NA 2 3 4
5 6 2 3 3
NA 7 8 NA 4

And I want to calculate the mean for each column while ignoring the Na's
For example:

colMeans(df)

And get the result like:

Var1 Var2 Var3 Var4 Var12
 3 6,5 4 3 3,66

I don't want the NA's to be considered in the calculation of Mean.

I tried some methods like na.omit, !is.na, but I don't get the desired result like what I described above.

r data.table mean

share|improve this question

edited Mar 28 at 10:59

Ronak Shah

82k1313 gold badges5050 silver badges8787 bronze badges

asked Mar 28 at 10:28

Alex RikaAlex Rika

5888 bronze badges

marked as duplicate by Ronak Shah r
Users with the  r badge can single-handedly close r questions as duplicates and reopen them as needed.

StackExchange.ready(function()
if (StackExchange.options.isMobile) return;

$('.dupe-hammer-message-hover:not(.hover-bound)').each(function()
var $hover = $(this).addClass('hover-bound'),
$msg = $hover.siblings('.dupe-hammer-message');

$hover.hover(
function()
$hover.showInfoMessage('',
messageElement: $msg.clone().show(),
transient: false,
position: my: 'bottom left', at: 'top center', offsetTop: -7 ,
dismissable: false,
relativeToBody: true
);
,
function()
StackExchange.helpers.removeMessages();

);
);
);
Mar 28 at 10:57

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  colMeans(df, na.rm = TRUE)
  
  – Ronak Shah
  Mar 28 at 10:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yeah that worked ! Thanx was so easy.. :P
  
  – Alex Rika
  Mar 28 at 10:32
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You might wanna post it as answer?
  
  – Alex Rika
  Mar 28 at 10:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The calculation of Means is correct but how can I get it like horizontal while getting the col names above each mean number?
  
  – Alex Rika
  Mar 28 at 10:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Not sure what you mean by that. Can you update the post with the expected output?
  
  – Ronak Shah
  Mar 28 at 10:39
  
  

  
  
  
  

 | 
show 3 more comments

This question already has an answer here:

• 
  calculate the mean for each column of a matrix in R
  
  6 answers
  
  

table, data.frame.

Which has 12 columns with variable names and 24 rows df

Like:

Var1 Var2 Var3 Var4 Var12
1 NA 2 3 4
5 6 2 3 3
NA 7 8 NA 4

And I want to calculate the mean for each column while ignoring the Na's
For example:

colMeans(df)

And get the result like:

Var1 Var2 Var3 Var4 Var12
 3 6,5 4 3 3,66

I don't want the NA's to be considered in the calculation of Mean.

I tried some methods like na.omit, !is.na, but I don't get the desired result like what I described above.

r data.table mean

share|improve this question

edited Mar 28 at 10:59

Ronak Shah

82k1313 gold badges5050 silver badges8787 bronze badges

asked Mar 28 at 10:28

Alex RikaAlex Rika

5888 bronze badges

Var1 Var2 Var3 Var4 Var12
1 NA 2 3 4
5 6 2 3 3
NA 7 8 NA 4

Var1 Var2 Var3 Var4 Var12
 3 6,5 4 3 3,66

share|improve this question

edited Mar 28 at 10:59

Ronak Shah

82k1313 gold badges5050 silver badges8787 bronze badges

asked Mar 28 at 10:28

Alex RikaAlex Rika

5888 bronze badges

share|improve this question

edited Mar 28 at 10:59

Ronak Shah

82k1313 gold badges5050 silver badges8787 bronze badges

asked Mar 28 at 10:28

Alex RikaAlex Rika

5888 bronze badges

edited Mar 28 at 10:59

Ronak Shah

82k1313 gold badges5050 silver badges8787 bronze badges

edited Mar 28 at 10:59

Ronak Shah

82k1313 gold badges5050 silver badges8787 bronze badges

asked Mar 28 at 10:28

Alex RikaAlex Rika

5888 bronze badges

asked Mar 28 at 10:28

Alex RikaAlex Rika

5888 bronze badges

1 Answer
1

active

oldest

votes

1

For a data.table dt, that looks like this:

dt
 Var1 Var2 Var3 Var4 Var12
1: 1 NA 2 3 4
2: 5 6 2 3 3
3: NA 7 8 NA 4

You can simply use lapply():

dt[, lapply(.SD, mean, na.rm = TRUE)]

The result is:

 Var1 Var2 Var3 Var4 Var12
1: 3 6.5 4 3 3.666667

share|improve this answer

answered Mar 28 at 10:53

clemensclemens

4,50722 gold badges55 silver badges1919 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How would you syntax the exact thing but for row means?
  
  – Alex Rika
  Mar 28 at 10:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You could use dt[, apply(.SD, 1, mean, na.rm = TRUE)]
  
  – clemens
  Mar 28 at 11:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  for some reason now the dt[, lapply(.SD, mean, na.rm = TRUE)] gives me an error:Error in .subset(x, j) : invalid subscript type 'list' But before I didnnt get an error?
  
  – Alex Rika
  Mar 28 at 11:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  oh ok I fixed it should have converted back to data table
  
  – Alex Rika
  Mar 28 at 11:12
  

  
  
  
  

add a comment
 | 

1

For a data.table dt, that looks like this:

dt
 Var1 Var2 Var3 Var4 Var12
1: 1 NA 2 3 4
2: 5 6 2 3 3
3: NA 7 8 NA 4

You can simply use lapply():

dt[, lapply(.SD, mean, na.rm = TRUE)]

The result is:

 Var1 Var2 Var3 Var4 Var12
1: 3 6.5 4 3 3.666667

share|improve this answer

answered Mar 28 at 10:53

clemensclemens

4,50722 gold badges55 silver badges1919 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How would you syntax the exact thing but for row means?
  
  – Alex Rika
  Mar 28 at 10:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You could use dt[, apply(.SD, 1, mean, na.rm = TRUE)]
  
  – clemens
  Mar 28 at 11:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  for some reason now the dt[, lapply(.SD, mean, na.rm = TRUE)] gives me an error:Error in .subset(x, j) : invalid subscript type 'list' But before I didnnt get an error?
  
  – Alex Rika
  Mar 28 at 11:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  oh ok I fixed it should have converted back to data table
  
  – Alex Rika
  Mar 28 at 11:12
  

  
  
  
  

add a comment
 | 

1

For a data.table dt, that looks like this:

dt
 Var1 Var2 Var3 Var4 Var12
1: 1 NA 2 3 4
2: 5 6 2 3 3
3: NA 7 8 NA 4

You can simply use lapply():

dt[, lapply(.SD, mean, na.rm = TRUE)]

The result is:

 Var1 Var2 Var3 Var4 Var12
1: 3 6.5 4 3 3.666667

share|improve this answer

answered Mar 28 at 10:53

clemensclemens

4,50722 gold badges55 silver badges1919 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How would you syntax the exact thing but for row means?
  
  – Alex Rika
  Mar 28 at 10:57
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You could use dt[, apply(.SD, 1, mean, na.rm = TRUE)]
  
  – clemens
  Mar 28 at 11:02
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  for some reason now the dt[, lapply(.SD, mean, na.rm = TRUE)] gives me an error:Error in .subset(x, j) : invalid subscript type 'list' But before I didnnt get an error?
  
  – Alex Rika
  Mar 28 at 11:05
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  oh ok I fixed it should have converted back to data table
  
  – Alex Rika
  Mar 28 at 11:12
  

  
  
  
  

add a comment
 | 

For a data.table dt, that looks like this:

dt
 Var1 Var2 Var3 Var4 Var12
1: 1 NA 2 3 4
2: 5 6 2 3 3
3: NA 7 8 NA 4

You can simply use lapply():

dt[, lapply(.SD, mean, na.rm = TRUE)]

The result is:

 Var1 Var2 Var3 Var4 Var12
1: 3 6.5 4 3 3.666667

share|improve this answer

answered Mar 28 at 10:53

clemensclemens

4,50722 gold badges55 silver badges1919 bronze badges

dt
 Var1 Var2 Var3 Var4 Var12
1: 1 NA 2 3 4
2: 5 6 2 3 3
3: NA 7 8 NA 4

dt[, lapply(.SD, mean, na.rm = TRUE)]

 Var1 Var2 Var3 Var4 Var12
1: 3 6.5 4 3 3.666667

share|improve this answer

answered Mar 28 at 10:53

clemensclemens

4,50722 gold badges55 silver badges1919 bronze badges

answered Mar 28 at 10:53

clemensclemens

4,50722 gold badges55 silver badges1919 bronze badges

answered Mar 28 at 10:53

clemensclemens

4,50722 gold badges55 silver badges1919 bronze badges