How to find the sum of squared values of an R data frame column?


To find the sum of squared values of an R data frame column, we can simply square the column with ^ sign and take the sum using sum function. For example, if we have a data frame called df that contains a column say V then the sum of squared values of V can be found by using the command sum(df$V^2).

Example

Consider the below data frame −

 Live Demo

ID<-1:20
x<-rpois(20,5)
df1<-data.frame(ID,x)
df1

Output

  ID  x
1  1  3
2  2  9
3  3  7
4  4  4
5  5  6
6  6  4
7  7  7
8  8  4
9  9  8
10 10 5
11 11 6
12 12 7
13 13 7
14 14 7
15 15 5
16 16 4
17 17 4
18 18 5
19 19 4
20 20 5

Finding the sum of squared values in column x of df1 −

Example

sum(df1$x^2)

Output

[1] 667

Example

 Live Demo

S.No<-LETTERS[1:20]
y<-rnorm(20,5,1)
df2<-data.frame(S.No,y)
df2

Output

   S.No y
1  A    4.398238
2  B    5.543076
3  C    3.089420
4  D    7.313162
5  E    6.389394
6  F    5.718104
7  G    4.999203
8  H    5.835729
9  I    5.078716
10 J    3.507107
11 K    5.712762
12 L    2.778876
13 M    4.379454
14 N    5.487530
15 O    6.192156
16 P    5.065865
17 Q    4.984204
18 R    4.925256
19 S    4.522911
20 T    4.957369

Finding the sum of squared values in column y of df2 −

Example

sum(df2$y^2)

Output

[1] 531.5479

Updated on: 16-Mar-2021

6K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements