r - plot time series with constraint -

-

i have big dataset , i'd plot zizi vs hour each hour while variables looks this:

> datasetjc$hour[1:100]   [1] 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23  [40] 23 23 23 23 23 23 23 23 23 23 23 23 23 23  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  [79]  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0  0   > datasetjc$zizi[1:100]   [1]  2 27  2  3 45  0  6  0 15  8  3  1  4  0  0 15  1 13  0 15 23  8 21  2  0  9 43 26 31 33 11  0  4  7 26  2 25 14  1  [40]  3  1  6  3  4  3  2 27  2  3 45  0  7  0 15  8  3  1  4  0  4 26  0 15  1  4  0 15 14 12 23  8  3 21 13  2  0 32 43  [79] 31 11  4  0  4  7 26 10  2 25 25  1  1  4  4 23  3  2 27  2 45  0 >

i have minutes, dates , days vaiables. each data separated 5 minutes. how can plot?

thx

if take question "how hourly summaries of data taken @ 5 minute intervals", classic split-apply-combine. average data group great summary of different techniques.

for particular example, in vanilla r use aggregate or by function.

> df <- data.frame(hour=c(1,1,2,2,3,3,4,4), zizi=1:8) > aggregate(zizi ~ hour, data=df, mean)   hour zizi 1    1  1.5 2    2  3.5 3    3  5.5 4    4  7.5

if wish summarize date/hour, use +:

> aggregate(zizi ~ hour + day, data=df, mean)

for more advanced versions of this, recommend investing time in learning either dplyr or data.table, both excellent libraries doing more complex versions of extremely common task.

also future reference, see how make great r reproducible example? suggestions on how pose question more clearly.


Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more