Faster way of iterating through lists in Python

Question

I have list vector_list of length 800,000, where the elements are lists of size 768. I'm trying to add 768 columns to a pandas dataframe where each column is 800,000 long and represents an element from each list. Here's my code:

active = pd.DataFrame()    
for i in range(len(vector_list[0])):
    element_list = []
    for j in range(len(vector_list)):
        element_list.append(vector_list[j][i])
    active['Element {}'.format(i)] = element_list

Just to reiterate,

len(vector_list) = 800,000
len(vector_list[0]) = 768

Is there a more clever, faster way to do this?

Pass your vector list to the pd.DataFrame constructor and use the names parameter and insert it the names of the columns ? — IMCoins
– IMCoins, Commented Dec 8, 2019 at 16:18

Ajay Dabas · Accepted Answer · 2019-12-08 16:19:32Z

3

Directly pass the list to DataFrame constructor.

import pandas as pd
_list = [[1, 2], [3, 4], [5, 6], [7, 8]] 
df = pd.DataFrame(_list) 
print(df.head())

Output

answered Dec 8, 2019 at 16:19

Ajay Dabas

1,4441 gold badge7 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Faster way of iterating through lists in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related