python - Pandas: Can you access rolling window items -


can access pandas rolling window object. 

rs = pd.series(range(10)) rs.rolling(window = 3)  #print's  rolling [window=3,center=false,axis=0]

can groups?: 

[0,1,2] [1,2,3] [2,3,4]

i start off saying reaching in internal impl. if really wanted compute indexers same way pandas.

you need v0.19.0rc1 (just released), can conda install -c pandas pandas=0.19.0rc1

in [41]: rs = pd.series(range(10))  in [42]: rs out[42]:  0    0 1    1 2    2 3    3 4    4 5    5 6    6 7    7 8    8 9    9 dtype: int64  # reaches internal implementation # first 3 window, second minimum periods # need     in [43]: start, end, _, _, _, _ = pandas._window.get_window_indexer(rs.values,3,3,none,use_mock=false)  # starting index in [44]: start out[44]: array([0, 0, 0, 1, 2, 3, 4, 5, 6, 7])  # ending index in [45]: end out[45]: array([ 1,  2,  3,  4,  5,  6,  7,  8,  9, 10])  # windo size in [3]: end-start out[3]: array([1, 2, 3, 3, 3, 3, 3, 3, 3, 3])  # indexers in [47]: [np.arange(s, e) s, e in zip(start, end)] out[47]:  [array([0]),  array([0, 1]),  array([0, 1, 2]),  array([1, 2, 3]),  array([2, 3, 4]),  array([3, 4, 5]),  array([4, 5, 6]),  array([5, 6, 7]),  array([6, 7, 8]),  array([7, 8, 9])]

so sort of trivial in fixed window case, becomes extremely useful in variable window scenario, e.g. in 0.19.0 can specify things 2s example aggregate by-time.

all of said, getting these indexers not particularly useful. want do results. point of aggregation functions, or .apply if want generically aggregate.


-

Comments

Post a Comment

Popular posts from this blog

serialization - Convert Any type in scala to Array[Byte] and back -

i have following question: i have variable value in program declared value. i want convert value byte array.. how can serialize byte array , back? found examples related other types such double or int, not any. this should need. it's pretty similar how 1 in java. import java.io.{bytearrayinputstream, bytearrayoutputstream, objectinputstream, objectoutputstream} object serialization extends app { def serialise(value: any): array[byte] = { val stream: bytearrayoutputstream = new bytearrayoutputstream() val oos = new objectoutputstream(stream) oos.writeobject(value) oos.close stream.tobytearray } def deserialise(bytes: array[byte]): = { val ois = new objectinputstream(new bytearrayinputstream(bytes)) val value = ois.readobject ois.close value } println(deserialise(serialise("my test"))) println(deserialise(serialise(list(1)))) println(deserialise(serialise(map(1 -> 2)))) println(deserialise(seri
Read more

matplotlib support failed in PyCharm on OSX -

any idea how fix ? how can debug might problem ? not seem : https://youtrack.jetbrains.com/issue/py-15520 i in console: python 2.6.9 (unknown, jul 14 2015, 19:46:31) [gcc 4.2.1 compatible apple llvm 6.0 (clang-600.0.39)] on darwin >>> import matplotlib.pyplot plt matplotlib support failed the backend : >>> import matplotlib >>> print(matplotlib.rcparams['backend']) macosx
Read more

python - Matplotlib: TypeError: 'AxesSubplot' object is not callable -

i new programming please pardon me if rookie mistake. i writing python script have defined functions create subplots of distributions. i have slider widget end user change value of variables(mu , sigma) , see effect on distribution. here's code import numpy np print np.__version__ import scipy print scipy.__version__ scipy.stats import norm, lognorm, uniform import matplotlib print matplotlib.__version__ import matplotlib.pyplot plt matplotlib.widgets import slider, button, radiobuttons, checkbuttons #####calculating mean , standard deviation##### global mu_a1 mu_a1 = 1 global mu_b1 mu_b1 = 10 global mu_c1 mu_c1 = -13 global sigma_a1 sigma_a1 = 0.14 global sigma_b1 sigma_b1 = 1.16 global sigma_c1 sigma_c1 = 2.87 mu_x01 = -11 sigma_x01 = 1.9 #####_____##### #####generating random data##### a1 = 0.75*mu_a1 + (1.25 - 0.75)*sigma_a1*np.random.sample(10000) b1 = 8*mu_b1 + (12 - 8)*sigma_b1*np.random.sample(10000) c1 = -12*mu_c1 + 2*sigma_c1*np.random.sample(10000)
Read more