I was working with dataframes and I came across a problem I was not able to solve.
Suppose I have a dataframe A and dataframe B
A -
0 NAME1 20
1 NAME2 30
2 NAME3 40
B -
0 NAME1 10
1 NAME2 100
2 NAME4 50
I want the output as-
Output -
0 NAME1 20
1 NAME2 30
2 NAME3 40
3 NAME4 50/0
For the last one anything would work either 50 or 0. This is a combination of both concat and merge. I have to concat but with left join logic. How can I do this using pandas functions?
