python - Excel 显示重复的合并列

Question

标签： pythonexcel

Answer 1

this should do it.

import pandas as pd
// data
data = {'letters':['a', 'e', 'c', 'g', 'h', 'b']}
data1 = {'letters':['a', 'd', 'b', 'e', 'f',]}
// data to df
df0 = pd.DataFrame(data)
df1 = pd.DataFrame(data1)
// merge
df2 = df0.merge(df1, how='outer')

now they are merged without duplicates, but out of order. Use sort_values to correct this

df2 = df2.sort_values(['letters'])
print(df2)