English 中文(简体)
我如何比照处理更高效地处理安达数据框架?
原标题:How do I process a pandas dataframe more efficiently than by looping?

我正在处理PYTHON的安达数据。 我怎么能够作出计算,以便在不使用假套的情况下解决这一问题,因为数据集太长,时间太长。 这是计算存货栏所需的公式。

stock = supply - demand + previous day stock (Assume 0 stock on day 1)

然而,如果前一天的存量为negative,我们将以公式中的零存量计算。

stock = supply - demand + 0
day demand supply stock
1 11 21 10
2 11 0 -1
3 11 0 -11
4 11 23 12
5 11 0 1
6 11 0 -10
7 11 0 -11

举例如下:

pd.DataFrame({ day : [1,2,3,4,5,6,7], demand :
[11,11,11,11,11,11,11], supply :[21,0,0,23,0,0,0]})
问题回答

我不想 lo。 每一储量都取决于它收到的每行,因此,你可以把这一计算作为矢量(这需要独立的业务)。





相关问题
Can Django models use MySQL functions?

Is there a way to force Django models to pass a field to a MySQL function every time the model data is read or loaded? To clarify what I mean in SQL, I want the Django model to produce something like ...

An enterprise scheduler for python (like quartz)

I am looking for an enterprise tasks scheduler for python, like quartz is for Java. Requirements: Persistent: if the process restarts or the machine restarts, then all the jobs must stay there and ...

How to remove unique, then duplicate dictionaries in a list?

Given the following list that contains some duplicate and some unique dictionaries, what is the best method to remove unique dictionaries first, then reduce the duplicate dictionaries to single ...

What is suggested seed value to use with random.seed()?

Simple enough question: I m using python random module to generate random integers. I want to know what is the suggested value to use with the random.seed() function? Currently I am letting this ...

How can I make the PyDev editor selectively ignore errors?

I m using PyDev under Eclipse to write some Jython code. I ve got numerous instances where I need to do something like this: import com.work.project.component.client.Interface.ISubInterface as ...

How do I profile `paster serve` s startup time?

Python s paster serve app.ini is taking longer than I would like to be ready for the first request. I know how to profile requests with middleware, but how do I profile the initialization time? I ...

Pragmatically adding give-aways/freebies to an online store

Our business currently has an online store and recently we ve been offering free specials to our customers. Right now, we simply display the special and give the buyer a notice stating we will add the ...

Converting Dictionary to List? [duplicate]

I m trying to convert a Python dictionary into a Python list, in order to perform some calculations. #My dictionary dict = {} dict[ Capital ]="London" dict[ Food ]="Fish&Chips" dict[ 2012 ]="...

热门标签