Hey @Jugal69,
I did go through the docs again and realized that concat has options for inner join and outer join, but it is only with respect to indexes:
Note that the row indexes have been unioned and sorted. Here is the same thing with join='inner':
If you don't understand anything,please ask me. If you don't like the code,just tell me.