pandas 将一个数据框附加到另一个

Appending one data frame into another

提问by arpit joshi

I want to bring three data frames into a single one .All data frames have a single column .

我想将三个数据框合并为一个。所有数据框都有一列。

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'])

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

全部都有 100 条记录，所以我的目标是将它们放入一个包含 300 条记录的数据框中。我下面的代码不起作用

org_city_id.append([pol_city_id,pod_city_id])

the total number of records in org_city_id is still 100 .

org_city_id 中的记录总数仍然是 100 。

Can someone please suggest .

有人可以建议。

采纳答案by Boud

Get a single column name for all your dataframes:

为所有数据框获取一个列名：

org_city_id.columns = pol_city_id.columns = pod_city_id.columns = 'Final Name'

Then concat them:

然后连接它们：

pd.concat([org_city_id,pol_city_id,pod_city_id])

回答by piRSquared

dfs = [org_city_id, pol_city_id, pod_city_id]
pd.concat([df.squeeze() for df in dfs], ignore_index=True)

回答by Harrison

You can use concatfrom Pandas documentation.

您可以使用Pandas 文档中的concat。

Here is what you'll do:

您将执行以下操作：

pd.concat([org_city_id, pol_city_id, pod_city_id])

pd.concat([org_city_id, pol_city_id, pod_city_id])