sum of a subset of rows in a data table [duplicate]












0
















This question already has an answer here:




  • Consecutive/Rolling sums in a vector in R

    4 answers



  • Running Sum in R data.table [duplicate]

    1 answer




I have a little problem...let's say I have a data.table with one numerical column like:



  NR

  1

  2

  3

  5

  7 

  10

  1


I want to create a new column which is computed in this way:
in row j I want the sum of NR in the rows j, j+1, j+2. So I want this result:



  NR    NEW_NR

  1     6

  2     10

  3     15

  5     22

  7     18

  10    11

  1     1


Could anyone help me pls?






r data.table







share|improve this question













marked as duplicate by Jimbou, Martin Schmelzer, Community♦ Nov 14 '18 at 14:45


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.














  • 1





    have a look at shift or rolling sum functions from other packages.

    – mt1022
    Nov 14 '18 at 14:36











  • @mt1022 thank you, maybe this is what I need!

    – Francesco Tamberi
    Nov 14 '18 at 14:38











  • dt[, S := Reduce(`+`, shift(NR, 0:2, type = "lead"))]

    – Martin Schmelzer
    Nov 14 '18 at 14:39













  • @Jimbou you are right, I'll delete asap the question!

    – Francesco Tamberi
    Nov 14 '18 at 14:44
















0
















This question already has an answer here:




  • Consecutive/Rolling sums in a vector in R

    4 answers



  • Running Sum in R data.table [duplicate]

    1 answer




I have a little problem...let's say I have a data.table with one numerical column like:



  NR

  1

  2

  3

  5

  7 

  10

  1


I want to create a new column which is computed in this way:
in row j I want the sum of NR in the rows j, j+1, j+2. So I want this result:



  NR    NEW_NR

  1     6

  2     10

  3     15

  5     22

  7     18

  10    11

  1     1


Could anyone help me pls?






r data.table







share|improve this question













marked as duplicate by Jimbou, Martin Schmelzer, Community♦ Nov 14 '18 at 14:45


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.














  • 1





    have a look at shift or rolling sum functions from other packages.

    – mt1022
    Nov 14 '18 at 14:36











  • @mt1022 thank you, maybe this is what I need!

    – Francesco Tamberi
    Nov 14 '18 at 14:38











  • dt[, S := Reduce(`+`, shift(NR, 0:2, type = "lead"))]

    – Martin Schmelzer
    Nov 14 '18 at 14:39













  • @Jimbou you are right, I'll delete asap the question!

    – Francesco Tamberi
    Nov 14 '18 at 14:44














0












0








0









This question already has an answer here:




  • Consecutive/Rolling sums in a vector in R

    4 answers



  • Running Sum in R data.table [duplicate]

    1 answer




I have a little problem...let's say I have a data.table with one numerical column like:



  NR

  1

  2

  3

  5

  7 

  10

  1


I want to create a new column which is computed in this way:
in row j I want the sum of NR in the rows j, j+1, j+2. So I want this result:



  NR    NEW_NR

  1     6

  2     10

  3     15

  5     22

  7     18

  10    11

  1     1


Could anyone help me pls?






r data.table







share|improve this question















This question already has an answer here:




  • Consecutive/Rolling sums in a vector in R

    4 answers



  • Running Sum in R data.table [duplicate]

    1 answer




I have a little problem...let's say I have a data.table with one numerical column like:



  NR

  1

  2

  3

  5

  7 

  10

  1


I want to create a new column which is computed in this way:
in row j I want the sum of NR in the rows j, j+1, j+2. So I want this result:



  NR    NEW_NR

  1     6

  2     10

  3     15

  5     22

  7     18

  10    11

  1     1


Could anyone help me pls?





This question already has an answer here:




  • Consecutive/Rolling sums in a vector in R

    4 answers



  • Running Sum in R data.table [duplicate]

    1 answer







r data.table




r data.table






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 14 '18 at 14:33









Francesco TamberiFrancesco Tamberi

6418




6418




marked as duplicate by Jimbou, Martin Schmelzer, Community♦ Nov 14 '18 at 14:45


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.









marked as duplicate by Jimbou, Martin Schmelzer, Community♦ Nov 14 '18 at 14:45


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.










  • 1





    have a look at shift or rolling sum functions from other packages.

    – mt1022
    Nov 14 '18 at 14:36











  • @mt1022 thank you, maybe this is what I need!

    – Francesco Tamberi
    Nov 14 '18 at 14:38











  • dt[, S := Reduce(`+`, shift(NR, 0:2, type = "lead"))]

    – Martin Schmelzer
    Nov 14 '18 at 14:39













  • @Jimbou you are right, I'll delete asap the question!

    – Francesco Tamberi
    Nov 14 '18 at 14:44














  • 1





    have a look at shift or rolling sum functions from other packages.

    – mt1022
    Nov 14 '18 at 14:36











  • @mt1022 thank you, maybe this is what I need!

    – Francesco Tamberi
    Nov 14 '18 at 14:38











  • dt[, S := Reduce(`+`, shift(NR, 0:2, type = "lead"))]

    – Martin Schmelzer
    Nov 14 '18 at 14:39













  • @Jimbou you are right, I'll delete asap the question!

    – Francesco Tamberi
    Nov 14 '18 at 14:44








1




1





have a look at shift or rolling sum functions from other packages.

– mt1022
Nov 14 '18 at 14:36





have a look at shift or rolling sum functions from other packages.

– mt1022
Nov 14 '18 at 14:36













@mt1022 thank you, maybe this is what I need!

– Francesco Tamberi
Nov 14 '18 at 14:38





@mt1022 thank you, maybe this is what I need!

– Francesco Tamberi
Nov 14 '18 at 14:38













dt[, S := Reduce(`+`, shift(NR, 0:2, type = "lead"))]

– Martin Schmelzer
Nov 14 '18 at 14:39







dt[, S := Reduce(`+`, shift(NR, 0:2, type = "lead"))]

– Martin Schmelzer
Nov 14 '18 at 14:39















@Jimbou you are right, I'll delete asap the question!

– Francesco Tamberi
Nov 14 '18 at 14:44





@Jimbou you are right, I'll delete asap the question!

– Francesco Tamberi
Nov 14 '18 at 14:44












0






active

oldest

votes

















0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes

-

Popular posts from this blog

List item for chat from Array inside array React Native

Image
0 This is my code for Chat Box, the window where I have "In" and "Out" messages are appearing. import React, { Component } from "react"; import { StyleSheet, Text, View, TouchableOpacity, TextInput, FlatList, Platform, AsyncStorage } from "react-native"; import Tutor from "../image/krutika.jpg"; import { Container, Header, Left, Input, Body, Right, Thumbnail, Button } from "native-base"; import FontAwesome from "react-native-vector-icons/FontAwesome"; import Ionicons from "react-native-vector-icons/Ionicons"; import Icon1 from "react-native-vector-icons/FontAwesome"; import axios from "axios"; export default class ChatBox extends Component { st...
Read more

App crashed after uploaded to heroku server

Image
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } 0 I am uploading my code to heroku with the command: git push heroku master But whenever i push the code, whole code pushed on the server, but there is nothing there but application error. 2018-11-17T07:14:17.465955+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/" host=ecodrivebot.herokuapp.com request_id=47dc6aff-19dc-45e3-8a86-2d41eeef86b0 fwd="122.180.29.179" dyno= connect= service= status=503 bytes= protocol=https 2018-11-17T07:14:18.030853+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/favicon.ico" host=ecodrive...
Read more

Xamarin.iOS Cant Deploy on Iphone

Image
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box; } -1 I have a windows laptop and a mac mini my problem is that It wont deploy on iphone if I use Visual Studio Xamarin on windows to install my app, but it works fine with Visual Studio For Mac. Here's what I get after build succeded on Visual Studio Xamarin on windows : 1>------ Build started: Project: FinalCustomerApp.iOS, Configuration: Debug iPhone ------ 1> Connecting to Mac server 192.168.8.100... 1> FinalCustomerApp.iOS -> C:UsersJeremy PaulDesktopFinalCustomerAppFinalCustomerAppFinalCustomerApp.iOSbiniPhoneDebugFinalCustomerApp.iOS.exe 1> Detected signing identity: 1> Code Signing Key: ...
Read more