How to store a df.column in a list without index in a loop?

Question

df.shape (15,4)

I want to store 4th column of df within the loop in a list. What I'm trying is:

l=[]
n=1000 #No. of iterations
for i in range(0,n):
    #df expressions and results calcualtion equations
    l.append(df.iloc[:,2]) # This is storing values with index. I want to store then without indices while keeping inplace=True.

df_new = pd.DataFrame(np.array(l), columns = df.index)

I want l list to append only values from df column 3. Not series object of pandas.core.series module in each cell.

you want that 3rd column of a df stored as a list in another list over 1000 times? — sharathnatraj, Commented Nov 9, 2020 at 11:58
Yes precisely, but without indices. This loop is taking a lot of time to run if iteration is increased further — Zee, Commented Nov 9, 2020 at 14:20
Oh sorry, forgot the paranthesis.. I mean try df.iloc[:,2].tolist() — sharathnatraj, Commented Nov 10, 2020 at 6:13

sharathnatraj · Accepted Answer · 2020-11-10 06:20:03Z

1

Use df.iloc[:,2]).tolist() inside append to get the desired result.

answered Nov 10, 2020 at 6:20

sharathnatraj

1,6146 silver badges14 bronze badges

And how to make 3d list into pandas df on same index? I'm able to merge them, but not on index stackoverflow.com/questions/64782474/…
– Zee
Commented Nov 11, 2020 at 8:59

Add a comment |

Collectives™ on Stack Overflow

How to store a df.column in a list without index in a loop?

1 Answer 1

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Linked

Related