How to concatenate multiple dataframes

[rajeshE]

Hi,
I have three data frames, I want to connate them horizontally. However. third df is Date column. when I concatenate, its values showing nana.

df1:
[python]s1	s2	s3
1	2	3
na	0	na

df2

s1	s2	s3
8	9	3
2	5	6

df3:

   date
0  2020-02-12
1  2020-02-12
2  2020-01-23
3  2020-02-06

I use below code:

result = pd.concat([df1, df2,df_date], axis=1, join_axes=[df1.index])

But I am getting the resuls is as below:
result:

s1	s2	s3 s1 s2 s3 date
1	2	3   8  9  3  na
na	0	na  2  5  6  na

[scidam]

join_axes is deprecated. Unfortunately, I can't reproduce the problem. See working example below:

import pandas as pd
df1 = pd.DataFrame({'x': [1,2,3], 'y': [4, None, 8]})
df2 = pd.DataFrame({'x': [4, 2, 2], 'y': [None, None, 1]})
df3 = pd.DataFrame({'z': pd.date_range("2020-01-01", "2020-02-01", freq="4D")})
pd.concat([df1, df2, df3], axis=1)

Output:
0	1.0	4.0	4.0	NaN	2020-01-01
1	2.0	NaN	2.0	NaN	2020-01-05
2	3.0	8.0	2.0	1.0	2020-01-09
3	NaN	NaN	NaN	NaN	2020-01-13
4	NaN	NaN	NaN	NaN	2020-01-17
5	NaN	NaN	NaN	NaN	2020-01-21
6	NaN	NaN	NaN	NaN	2020-01-25
7	NaN	NaN	NaN	NaN	2020-01-29