Concatenating Two Pandas Dataframes While Maintaining Index Order

Basic question - I am trying to concatenate two DataFrames, with the resulting DataFrame preserving the index in order of the original two. For example: df = pd.DataFrame({'Houses

Solution 1:

Use concat with parameter sort for avoid warning and then DataFrame.sort_index:

df = pd.concat([df, df2], sort=False).sort_index()

print(df)
   Cities  Houses
0       1      15
1       3      10
2       4      20
3       8      25
4       7      30
5      11      35
6       6      40
7      14      45
8       1      50
9       4      55

Solution 2:

Try using:

print(df.T.join(df2.T).T.sort_index())

Output:

   Cities  Houses
0       1      15
1       3      10
2       4      20
3       8      25
4       7      30
5      11      35
6       6      40
7      14      45
8       1      50
9       4      55