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

matlab - error with cyclic autocorrelation function -

-
Image
i'm trying code cyclic autocorrelation function in matlab follows: t=0:(n-1); t=t*te; i_alpha=0; tau=-n2*te:te:n2*te; alpha=-1/2:1/n:1/2; ryy_cl=zeros(length(alpha),length(tau)); alpha=alpha/te ind_tau=0; i_alpha=i_alpha+1; k=tau ind_tau=ind_tau+1; if k>0 % ryy_cl(i_alpha,ind_tau)=1/length(sig_bin_syl_mod(1:end- k))*sum((sig_bin_syl_mod(1:end-k)).*sig_bin_syl_mod(k+1:end)).*exp(1i*2*pi*alpha*t(1+k:length(sig_bin_syl_mod(1:end)))); ryy_cl(i_alpha,ind_tau)=(1/n)*sum((sig_bin_syl_mod(1:end-k)).*sig_bin_syl_mod(k+1:end)).*exp(-1i*2*pi*alpha*t(1:end-k)); else ryy_cl(i_alpha,ind_tau)=(1/n)*sum((sig_bin_syl_mod(1-k:end)).*sig_bin_syl_mod(1:end+k)).*exp(-1i*2*pi*alpha*t(1-k:end)); end end end i'm getting errors, , doesn't show expecting. according below formulae, how can fix it? the code provided incomplete, difficult confidently reproduce error. in particular, haven't de...
Read more

django - (fields.E300) Field defines a relation with model 'AbstractEmailUser' which is either not installed, or is abstract -

-
i trying create customuser django project email username , add radio button truck , company. in registration process email-id registered per truck or company. mentioned radio button 'tag' , add manytomany field tag in emailuser model. when makemigrations, raising error : (fields.e300) field defines relation model 'abstractemailuser' either not installed, or abstract. i quite new django , not sure whether have created correct code wants. please me solving this. here code, models.py: import django django.contrib.auth.models import ( abstractbaseuser, baseusermanager, permissionsmixin) django.core.mail import send_mail django.db import models django.utils import timezone django.utils.translation import ugettext_lazy _ class emailusermanager(baseusermanager): """custom manager emailuser.""" def _create_user(self, email, password, is_staff, is_superuser, **extra_fields): """create , save emailus...
Read more

c# - What is a good .Net RefEdit control to use with ExcelDna? -

-
i using exceldna , c# build suite of tools. part of forms i'd want user select cells/ranges workbook. i've got application.inputbox route working...but doesn't cool... i haven't read many things excel's refedit control, , see many have in past written workarounds, in (shudder) vba or vb.net. however, none of these seem recent... best approach/control refedit functionality on form run via exceldna (if applicable)? the refedit sample project of github explores different ways of dealing threading when showing form excel add-in, main issue making refedit control .net add-in. check page links various other implementations: https://github.com/excel-dna/exceldna/wiki/links-about-refedit
Read more