How to generate a result list from pandas DataFrame

Question

I need to generate a list from pandas DataFrame . I am able to print the result,but i don't know how to convert it to the list format.The code i used to print the result(without converting to list) is

df=pandas.DataFrame(processed_data_format, columns=["file_name", "innings", "over","ball", "individual ball", "runs","batsman", "wicket_status","bowler_name","fielder_name"])**  
  #processed_data_format is the list passing to the DataFrame   
t = df.groupby(['batsman','over'])['runs','ball'].sum()
print t

i am getting the result like

Sangakara 1   10   5

          2    0   2

          3    3   1


    sewag 1    2   1

          2    1   1

I would like to convert this data into list format like

[ [sangakara,1,10,5],[sangakara,2,0,2],[sangakara,3,3,1],[sewag,1,2,1][sewag,2,1,1] ]

score 1 · Accepted Answer · answered Jan 26 '16 at 18:13

1

You can use to_records:

import pandas as pd

df = pd.DataFrame({'a': [1, 2, 3, 4], 'b': [2, 3, 4, 5]})

>>> list(df.to_records())

 [(0, 1, 2), (1, 2, 3), (2, 3, 4), (3, 4, 5)]

This will make a list of tuples. Converting this to a list of lists (if you really need this at all), is easy.

answered Jan 26 '16 at 18:13

Ami Tavory

74,578
11
141
185

Thank you .It works, How to convert it to List of lists?? – Edwin Baby Jan 27 '16 at 05:11
@EdwinBaby See [here](http://stackoverflow.com/questions/14831830/convert-a-list-of-tuples-to-a-list-of-lists). – Ami Tavory Jan 27 '16 at 05:17
The answer is really helpful for me, Since i am new to StackOverflow i did'nt know about the things .So, thanks for point out the things – Edwin Baby Jan 27 '16 at 05:23

How to generate a result list from pandas DataFrame

1 Answers1