From dataframe sructured like this
JavaScript
x
4
1
A B
2
0 1 2
3
1 3 4
4
I need to get list like this:
JavaScript
1
2
1
[{"A": 1, "B": 2}, {"A": 3, "B": 4}]
2
Advertisement
Answer
It looks like you want:
JavaScript
1
2
1
df.values.tolist()
2
example:
JavaScript
1
5
1
df = pd.DataFrame([['A', 'B', 'C'],
2
['D', 'E', 'F']])
3
4
df.values.tolist()
5
output:
JavaScript
1
3
1
[['A', 'B', 'C'],
2
['D', 'E', 'F']]
3
other options
JavaScript
1
8
1
df.T.to_dict('list')
2
{0: ['A', 'B', 'C'],
3
1: ['D', 'E', 'F']}
4
5
df.to_dict('records')
6
[{0: 'A', 1: 'B', 2: 'C'},
7
{0: 'D', 1: 'E', 2: 'F'}]
8