Pandas loop issue

Question

I am trying to apply the loop to select the specific values to use in the equation. I have the following data set

stock	Demand
1585	-1677
2305	20
34215	-38968
30	70
10967	-4737

I am applying the following code

for i in Demand:
    if i > df['Stock'].all():
        Order = Demand
    elif i < 0 :
        Order = df['Stock'] - Demand

I want the following list

Order
3262
23005
73183
70
15704

But I am getting the following list

Order
3262
23005
73183
-39
15704

I am unable to figure out what is wrong with the loop I am applying here. Thank you.

can you post the actual code? that looks like pseudocode. it certainly doesn't result in a dataframe. — Michael Delgado
– Michael Delgado, Commented Sep 16, 2021 at 22:12
@Corralien : I didn't notice it. It must be a wrong number, I am getting out of the code. Thank you. — irfanraorao
– irfanraorao, Commented Sep 16, 2021 at 22:22

Corralien · Accepted Answer · 2021-09-16 22:16:53Z

1

I tried to understand your logic and fixed errors. Is it what you expect?

df['Order'] = np.where(df['Demand'] < 0,
                       df['stock'] - df['Demand'],
                       df[['stock', 'Demand']].max(1))

Output:

>>> df
   stock  Demand  Order
0   1585   -1677   3262
1   2305      20   2305
2  34215  -38968  73183
3     30      70     70
4  10967   -4737  15704

answered Sep 16, 2021 at 22:16

Corralien

121k8 gold badges44 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Corralien Over a year ago

@irfanraorao. Does it solve your problem?

irfanraorao Over a year ago

It did work. Thank you.

Tomislav Stankovic · Accepted Answer · 2021-09-17 04:56:40Z

1

To debug the code, try to add print() statement after every step to see what the code is doing!

edited Sep 17, 2021 at 4:56

Tomislav Stankovic

3,12417 gold badges38 silver badges43 bronze badges

answered Sep 16, 2021 at 22:08

Daniele

238 bronze badges

1 Comment

Michael Delgado Over a year ago

Hi @Daniele - welcome to StackOverflow! This is a debugging tip, but is not an answer to the question. You don't yet have enough reputation to comment - to get started try to find a question you can answer completely. Check out this guide to answering questions. Good luck :)

Collectives™ on Stack Overflow

Pandas loop issue

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related