Create Pandas Dataframe with loop

Question

I am trying to create 10 new dataframes from one larger dataframe based on some criteria. See code below.

for i in range(1,11):
    'x_'+str(i) = CRSP_mom[(CRSP_mom['mom_rank'] > (float(i)-1.0)/10)]

I get the error.

  File "<ipython-input-167-902910fdab60>", line 2
    'x_'+str(i) = CRSP_mom[(CRSP_mom['mom_rank'] > (float(i)-1.0)/10) & (CRSP_mom['mom_rank'] <= (float(i))/10)]
SyntaxError: can't assign to operator

Any thoughts on how I could get it to create a dataframe with the looped name?

Thanks much all.

Alex · Accepted Answer · 2015-02-19 17:59:18Z

3

In general, dynamic variable creation is not a good idea.

How about a dictionary?

d = {'x' + str(i) : CRSP_mom[(CRSP_mom['mom_rank'] > (float(i)-1.0)/10) & (CRSP_mom['mom_rank'] <= (float(i))/10)] for i in range(1, 11)}

answered Feb 19, 2015 at 17:59

Alex

19.2k9 gold badges65 silver badges82 bronze badges

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

1 Comment

Wade Bratz Over a year ago

Useful. Worked perfectly. Thanks.

Collectives™ on Stack Overflow

Create Pandas Dataframe with loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related