python - How to resample starting from the first element in pandas? -

-

i resampling following table/data:

timestamp  l_x   l_y    l_a     r_x     r_y     r_a 2403950   621.3 461.3   313     623.3   461.8   260 2403954   622.5 461.3   312     623.3   462.6   260 2403958   623.1 461.5   311     623.4   464     261 2403962   623.6 461.7   310     623.7   465.4   261 2403966   623.8 461.5   309     623.9   466.1   261 2403970   620.9 461.4   309     623.8   465.9   259 2403974   621.7 461.1   308     623     464.8   258 2403978   622.1 461.1   308     621.9   463.9   256 2403982   622.5 461.5   308     621     463.4   255 2403986   622.4 462.1   307     620.7   463.3   254

the table goes on , on that. timestamps in milliseconds. did following resample 100milliseconds bin time:

  1. i changed timestamp index datetime format

    df.index = pd.to_datetime((df.index.values*1e6).astype(int))

  2. i resampled in 100milliseconds:

    df = df.resample('100l')

the resulting resampled data following:

timestamp  l_x   l_y    l_a     r_x     r_y     r_a 2403900   621.3 461.3   313     623.3   461.8   260 2404000   622.5 461.3   312     623.3   462.6   260 2404100   623.1 461.5   311     623.4   464     261 2404200   623.6 461.7   310     623.7   465.4   261 2404300   623.8 461.5   309     623.9   466.1   261

as can see first bin time 2403900, 50milliseconds behind first timestamp index of original table. wanted bin time start first timestamp index original table, 2403950. following:

timestamp  l_x   l_y    l_a     r_x     r_y     r_a 2403950   621.3 461.3   313     623.3   461.8   260 2404050   622.5 461.3   312     623.3   462.6   260 2404150   623.1 461.5   311     623.4   464     261 2404250   623.6 461.7   310     623.7   465.4   261 2404350   623.8 461.5   309     623.9   466.1   261

you can specify offset:

df.resample('100l', loffset='50l')

update

of course can calculate offset:

offset = df.index[0] % 100 df.index = pd.to_datetime((df.index.values*1e6).astype(int)) df.resample('100l', loffset='{}l'.format(offset))

Comments

Post a Comment

Popular posts from this blog

java - Static nested class instance -

-
this question has answer here: java inner class , static nested class 23 answers i came across in java, know static nested class why create instance of 'static'. isn't whole idea of 'static' use without instance? understand concept of inner classes, why (and frankly how possible to) create 'instance' of 'static' member @ ? why this: 1- outerclass.staticnestedclass nestedobject = new outerclass.staticnestedclass(); 2- nestedobject.anestedclassmethod(); and not this: 1- outerclass outerinstance=new outerclass(); 2- outerinstance.staticnestedclass.anestedclassmethod(); use on inner classes, keyword static indicates can access inner class without instance of outer class. for example: public class outer { public static class inner { /* code here. */ } } with construction, can create instance of inn
Read more

c# - Bluetooth LE CanUpdate Characteristic property -

-
i building xamarin.forms cross platform mobile app, uses monkey.robotics bluetoth low energy functionality. connecting mbed based implimentation of custom gatt service . in xamarin c#, triggers characteristic. canupdate property in monkey.robotics? this standard example c# based on: if (characteristic.canupdate) { characteristic.valueupdated += (s, e) => { debug.writeline("characteristic.valueupdated"); device.begininvokeonmainthread( () => { updatedisplay(characteristic); }); isbusy = false; // spin until first result received }; isbusy = true; characteristic.startupdates(); } this has been working, since changed own custom gatt service connecting to, canupdate property false. property , how triggered? me debugging gatt service code. thanks monkey.robotics open sour
Read more

JavaScript - Replace variable from string in all occurrences -

-
ok, know if have character '-' , want remove in places in string javascript, ... someword = someword.replace(/-/g, ''); but, when applying array of characters, s not working ... const badchars = ('\/:*?"<>|').split(''); let filename = title.replace(/ /g, '-').tolocalelowercase(); (let item = 0; item < badchars.length; item++) { // below not work global '/ /g' filename = filename.replace(/badchars[item]/g, ''); } any ideas? /badchars[item]/g looks badchars , literally, followed i , t , e , or m . if you're trying use character badchars[item] , you'll need use regexp constructor, , you'll need escape regex-specific characters. escaping regular expression has been well-covered . using that: filename = filename.replace(new regexp(regexp.quote(badchars[item]), 'g'), ''); but , don't want that. want character class: let filename = title.replac
Read more