/Python/Merge two list of dictionaries python with string

Merge two list of dictionaries python with string

import pandas as pd

l1 = [{'id': 9, 'av': 4}, {'id': 10, 'av': 0}, {'id': 8, 'av': 0}]
l2 = [{'id': 9, 'nv': 45}, {'id': 10, 'nv': 0}, {'id': 8, 'nv': 30}]

df1 = pd.DataFrame(l1).set_index('id')
df2 = pd.DataFrame(l2).set_index('id')
df = df1.merge(df2, left_index=True, right_index=True)
df.T.to_dict()
# {9: {'av': 4, 'nv': 45}, 10: {'av': 0, 'nv': 0}, 8: {'av': 0, 'nv': 30}}

Source: codereview.stackexchange.com

Similar codes

0 vote126 views1 answer
Calculate time python
Python
1 vote136 views1 answer
Barabasi albert graph networkx
Python
36 votes136 views6 answers
Get list file in folder python
Python
0 vote148 views1 answer
Kivy button on press call function with arguments
Python
2 votes141 views1 answer
How to append element python
Python
2 votes143 views3 answers
0 1 1 2 3 5 in python
Python
1 vote198 views1 answer
Get csrf_token value in django template
Python Django
0 vote161 views1 answer
Django time cualtulate
Python Django
0 vote143 views1 answer
Share x axis matplotlib
Python
0 vote151 views2 answers
Chrome driver selenium python online compiler
Python