I have two dataframes df1 and df2 with different shapes (number of rows and columns differ).
df1
ticketid descp alertname
1 3000 nsp 2 1000 rsp 3 5000 gsp
df2
ticketid vol prd technology
1 30 scom soft
3 45 dess hard
6 34 scom soft
7 35 scom hard
I need to combine these two dataframes based on ticketid column. the new dataframe must have all values from df1 and whatever matches in df2(based on ticketid) those rows also need to be added.
I want the new dataframe to be like this
ticketid descp alertname vol prd technology
1 3000 nsp 30 scom soft 3 5000 gsp 45 dess hard
How to do this in pandas`