merging dataframes only by certain columns
<p>I try to merge dataframes by index and only take certain columns to the result.</p>

<pre><code>result = pd.concat([self.retailer_categories_probes_df['euclidean_distance'], self.retailers_categories_df['euclidean_distance']])
</code></pre>

<p>But with the result I get the 'euclidean_distance' from first table ?
Any idea what is wrong ?</p>

<p>Also how I can give names to the destination columns ?</p>