Combine multiple rows of lists into one big list using pandas

user_18313588 0
Viewed 252

I have a pandas data frame with multiple lists. Is there any way to combine all of the lists from all rows ( there could be 100 rows ) into one big list?

     fruits
0    [apple, banana, orange]
1    [berry, lemon]
2    [apple, tomato]
3    [lime, orange, banana]

Expected Output

[ 'apple', 'banana', 'orange', 'berry', 'lemon', 'apple', 'tomato', 'lime', 'orange', 'banana' ]
pandas dataframe python-3.x python
3 Answers

use df.explode()

lst = df['fruits'].explode().to_list()
user_90505140

Try:

df["fruits"].sum()
user_117478610

Try extend :

result = []
for row in fruits :
    result.extend(row)
user_66239070
Related