/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

1 vote212 views1 answer
How to check whole number in python
Python
0 vote216 views1 answer
Read a csv and plot in python
Python
0 vote198 views1 answer
Install google cloud python
Python
0 vote207 views1 answer
Input and ouput array in python
Python
0 vote143 views1 answer
Print Odd Even Negative Integer Count
Python
8 votes225 views5 answers
Pytorch
Python
0 vote184 views1 answer
Command run test keep db python
Python
0 vote197 views1 answer
Python loop chrome
Python
2 votes256 views3 answers
Convert csv to dictionary in Python
Python
0 vote197 views1 answer
Gets an existing SparkSession or, if there is no existing one, creates a new one based on the options set in this builder
Python