pythonpandas无列名数据合并,Python Pandas-具有不同列的Concat数据框忽略列名称

I have two pandas.DataFrames which I would like to combine into one. The dataframes have the same number of columns, in the same order, but have column headings in different languages. How can I efficiently combine these dataframes?

df_ger

index Datum Zahl1 Zahl2

0 1-1-17 1 2

1 2-1-17 3 4

df_uk

index Date No1 No2

0 1-1-17 5 6

1 2-1-17 7 8

desired output

index Datum Zahl1 Zahl2

0 1-1-17 1 2

1 2-1-17 3 4

2 1-1-17 5 6

3 2-1-17 7 8

The only approach I came up with so far is to rename the column headings and then use pd.concat([df_ger, df_uk], axis=0, ignore_index=True). However, I hope to find a more general approach.

解决方案

If the columns are always in the same order, you can mechanically rename the columns and the do an append like:

Code:

new_cols = {x: y for x, y in zip(df_uk.columns, df_ger.columns)}

df_out = df_ger.append(df_uk.rename(columns=new_cols))

Test Code:

df_ger = pd.read_fwf(StringIO(

u"""

index Datum Zahl1 Zahl2

0 1-1-17 1 2

1 2-1-17 3 4"""),

header=1).set_index('index')

df_uk = pd.read_fwf(StringIO(

u"""

index Date No1 No2

0 1-1-17 5 6

1 2-1-17 7 8"""),

header=1).set_index('index')

print(df_uk)

print(df_ger)

new_cols = {x: y for x, y in zip(df_uk.columns, df_ger.columns)}

df_out = df_ger.append(df_uk.rename(columns=new_cols))

print(df_out)

Results:

Date No1 No2

index

0 1-1-17 5 6

1 2-1-17 7 8

Datum Zahl1 Zahl2

index

0 1-1-17 1 2

1 2-1-17 3 4

Datum Zahl1 Zahl2

index

0 1-1-17 1 2

1 2-1-17 3 4

0 1-1-17 5 6

1 2-1-17 7 8