Appending one data frame into another
<p>I want to bring three data frames into a single one .All data frames have a single column .</p>

<pre><code>org_city_id=p.DataFrame(training_data['origcity_id'])
pol_city_id=p.DataFrame(training_data['pol_city_id'])
pod_city_id=p.DataFrame(training_data['pod_city_id'])
</code></pre>

<p>All have 100 records in it so my goal is to bring them into a single data frame which will then contain 300 records .My below code is not working </p>

<pre><code>org_city_id.append([pol_city_id,pod_city_id])
</code></pre>

<p>the total number of records in org_city_id is still 100 .</p>

<p>Can someone please suggest .</p>

<p>Get a single column name for all your dataframes:</p>

<pre><code>org_city_id.columns = pol_city_id.columns = pod_city_id.columns = 'Final Name'
</code></pre>

<p>Then concat them:</p>

<pre><code>pd.concat([org_city_id,pol_city_id,pod_city_id])
</code></pre>

python pandas dataframe