How to create a list of list from a dataframe

Question

I have a dataframe df and I want to convert the dataframe to a list of list

    left_side                                  right_side                             similarity
0114600043776001 loan payment receipt         0421209017073500 loan payment receipt     0.689008
0114600043776001 loan payment receipt         0421209017073500 loan payment receipt     0.689008
vat onverve*issuance fee*506108               vat onverve*issuance fee*5061087       0.743522
vat onverve*issuance fee*506108               verve*issuance fee*506108*********1112    0.684342
verve*issuance fee*506108                     verve*issuance fee*506108*********8296    0.717817
verve*issuance fee*506108                     vat onverve*issuance fee*506108**         0.684342

maint fee recovery jun 2018                   vat maint fee recovery jun 2018          0.896607
maint fee recovery jun 2018                  vat maint fee recovery jun 2018         0.896607
maint fee recovery jun 2018                  vat maint fee recovery jun 2018         0.896607

Expected output should look like this:

[[0114600043776001 loan payment receipt, 0421209017073500 loan payment receipt,
  0421209017073500 loan payment receipt],
[vat onverve*issuance fee*506108, vat onverve*issuance fee*5061087, 
  verve*issuance fee*506108*********1112], 
[verve*issuance fee*506108*********8296, verve*issuance fee*506108                    
 vat onverve*issuance fee*506108** ],...]

I have tried grouping the above df by left_side column and converting the resulting df to a list, but the output is not what I expected. please I need your assistance on this

grouup_df = df.groupby(['left_side']).right_side.sum().to_frame()

grouup_df.values.tolist()

and the output looks like this:

['0421209017073500 loan payment receipt0421209017073500 loan payment receipt0421209017073500 loan payment receipt0421209017073500 loan payment receipt0421209017073500 loan payment receipt0421209017073500 loan payment receipt']
['vat maint fee recovery jun 2018vat maint fee recovery jun 2018vat maint fee recovery jun 2018maint fee recovery jul 2018maint fee recovery oct 2018maint fee recovery jul 2018maint fee recovery jul 2018']

See if this helps out, stackoverflow.com/a/12866648/4985099

sushanth
– sushanth

2021-04-14 10:13:42 +00:00
Commented Apr 14, 2021 at 10:13 — sushanth
– sushanth, Commented Apr 14, 2021 at 10:13

Sayandip Dutta · Accepted Answer · 2021-04-14 12:43:01Z

1

You can use df.groupby:

>>> [[k, *g] for k, g in df.groupby('left_side', sort=False)['right_side']]

[['0114600043776001 loan payment receipt',
  '0421209017073500 loan payment receipt',
  '0421209017073500 loan payment receipt'],
 ['vat onverve*issuance fee*506108',
  'vat onverve*issuance fee*5061087',
  'verve*issuance fee*506108*********1112'],
 ['verve*issuance fee*506108',
  'verve*issuance fee*506108*********8296',
  'vat onverve*issuance fee*506108**'],
 ['maint fee recovery jun 2018',
  'vat maint fee recovery jun 2018',
  'vat maint fee recovery jun 2018',
  'vat maint fee recovery jun 2018']]

edited Apr 14, 2021 at 12:43

answered Apr 14, 2021 at 10:28

Sayandip Dutta

15.9k4 gold badges27 silver badges57 bronze badges

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

Comments

M_x · Accepted Answer · 2021-04-14 10:19:04Z

1

import pandas as pd

dfold = {'left_side': ['string','string','string','string'],
            'right_side': ['string','string','string','string']
            }

df = pd.DataFrame(dfold, columns= ['left_side', 'right_side'])
print(df)
df_list = df.values.tolist()
print(df_list)

answered Apr 14, 2021 at 10:19

M_x

8982 gold badges9 silver badges28 bronze badges

Comments

Lucas Ford · Accepted Answer · 2021-04-14 10:18:38Z

0

I believe your looking for the to_records() method on a Datagrams. Try df.to_records(), you can find its documentation here

answered Apr 14, 2021 at 10:18

Lucas Ford

1813 bronze badges

1 Comment

chuky pedro Over a year ago

I think the method to_records() creates a list of tuples from the dataframe which difference from the expected output.

Collectives™ on Stack Overflow

How to create a list of list from a dataframe

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related