Skip to main content
 首页 » 编程设计

python之如何编写一个累加器来围绕中点压缩数组

2025年01月19日10Leo_wl

假设我有一个数组,如下所示:

array([[ 7108.4,  -600. ], 
       [ 7101.3,  -500. ], 
       [ 7094.3,  -400. ], 
       [ 7087.2,  -300. ], 
       [ 7080.1,  -200. ], 
       [ 7073.1,  -100. ], 
       [ 7058.3,   100. ], 
       [ 7051.3,   200. ], 
       [ 7044.2,   300. ], 
       [ 7037.1,   400. ], 
       [ 7030.1,   500. ], 
       [ 7023. ,   600. ]]) 

这是一个价格和数量列表,正数表示买入,负数表示卖出。

如果当前市场价格是 7050,我想“压缩”我的价格,如下所示:

array([[ 7108.4,  -600. ], 
       [ 7101.3,  -500. ], 
       [ 7094.3,  -400. ], 
       [ 7087.2,  -300. ], 
       [ 7080.1,  -200. ], 
       [ 7073.1,  -100. ], 
       [ 7050. ,   300. ], # Price & quantity changed here 
       [ 7044.2,   300. ], 
       [ 7037.1,   400. ], 
       [ 7030.1,   500. ], 
       [ 7023. ,   600. ]]) 

并且在另一个方向做同样的事情,所以如果市场价格是 7085:

array([[ 7108.4,  -600. ], 
       [ 7101.3,  -500. ], 
       [ 7094.3,  -400. ], 
       [ 7087.2,  -300. ], 
       [ 7085. ,  -300. ], # Price & quantity change here 
       [ 7058.3,   100. ], 
       [ 7051.3,   200. ], 
       [ 7044.2,   300. ], 
       [ 7037.1,   400. ], 
       [ 7030.1,   500. ], 
       [ 7023. ,   600. ]]) 

写这样的东西最干净的方法是什么?理想情况下,我想将压缩和数量分组写成两个单独的步骤。

请您参考如下方法:

pandas 使这种操作变得更容易.

>>> import numpy as np 
>>> import pandas as pd 
>>>  
>>> t = np.array([[ 7108.4,  -600. ], 
...        [ 7101.3,  -500. ], 
...        [ 7094.3,  -400. ], 
...        [ 7087.2,  -300. ], 
...        [ 7080.1,  -200. ], 
...        [ 7073.1,  -100. ], 
...        [ 7058.3,   100. ], 
...        [ 7051.3,   200. ], 
...        [ 7044.2,   300. ], 
...        [ 7037.1,   400. ], 
...        [ 7030.1,   500. ], 
...        [ 7023. ,   600. ]]) 
>>>  
>>> df = pd.DataFrame(t, columns=['price', 'quantity']) 
>>> (df.price > 7050) & (df.quantity > 0) 
0     False 
1     False 
2     False 
3     False 
4     False 
5     False 
6      True 
7      True 
8     False 
9     False 
10    False 
11    False 
dtype: bool 
>>> df[(df.price > 7050) & (df.quantity > 0)] 
    price  quantity 
6  7058.3     100.0 
7  7051.3     200.0 
>>> df[(df.price > 7050) & (df.quantity > 0)].quantity.sum() 
300.0 
>>> df[(df.price < 7085) & (df.quantity < 0)] 
    price  quantity 
4  7080.1    -200.0 
5  7073.1    -100.0 
>>> df[(df.price < 7085) & (df.quantity < 0)].quantity.sum() 
-300.0 

如果你愿意,你仍然可以坚持使用 numpy:

>>> import numpy as np 
>>> import pandas as pd 
>>>  
>>> t = np.array([[ 7108.4,  -600. ], 
...        [ 7101.3,  -500. ], 
...        [ 7094.3,  -400. ], 
...        [ 7087.2,  -300. ], 
...        [ 7080.1,  -200. ], 
...        [ 7073.1,  -100. ], 
...        [ 7058.3,   100. ], 
...        [ 7051.3,   200. ], 
...        [ 7044.2,   300. ], 
...        [ 7037.1,   400. ], 
...        [ 7030.1,   500. ], 
...        [ 7023. ,   600. ]]) 
>>>  
>>>  
>>> t[:,0] 
array([ 7108.4,  7101.3,  7094.3,  7087.2,  7080.1,  7073.1,  7058.3, 
        7051.3,  7044.2,  7037.1,  7030.1,  7023. ]) 
>>> t[:,0] > 7050 
array([ True,  True,  True,  True,  True,  True,  True,  True, False, 
       False, False, False], dtype=bool) 
>>> (t[:,0] > 7050) & (t[:,1] > 0) 
array([False, False, False, False, False, False,  True,  True, False, 
       False, False, False], dtype=bool) 
>>> t[(t[:,0] > 7050) & (t[:,1] > 0)] 
array([[ 7058.3,   100. ], 
       [ 7051.3,   200. ]]) 
>>> t[(t[:,0] < 7085) & (t[:,1] < 0)] 
array([[ 7080.1,  -200. ], 
       [ 7073.1,  -100. ]]) 
>>> t[(t[:,0] < 7085) & (t[:,1] < 0)][:,1] 
array([-200., -100.]) 
>>> t[(t[:,0] < 7085) & (t[:,1] < 0)][:,1].sum() 
-300.0