pandas combine multiple dataframes or use as updates

Question

Is there a way to concat, join or merge dataframes based on both the index and columns? For example, suppose I have a list of dataframes and I want something like

df = pandas.fullConcat(dfList)

where df.index should be the union of the indices in dfList ('outer' join) and df.columns should also be the union of the columns in dfList. I think all of the concat, join and merge methods just do a join on either the index or the column. I suppose a workaround is stack/unstack or reset_index? Do i miss something ?

Maybe it makes sense that the joins can only occur on one multi-index at a time. When you have both MultiIndexes and multi-dimensional indexed arrays, the options are many. As a 'work flow' t seems that working with a single MultiIndex during aggregation of data makes the most sense. — safetyduck
– safetyduck, Commented Feb 22, 2013 at 23:06

Zelazny7 · Accepted Answer · 2013-02-23 01:08:27Z

2

I think you're going to have to reset the index:

df = df1.reset_index().merge(df2.reset_index(), on=['index','cols']).set_index('index')

answered Feb 23, 2013 at 1:08

Zelazny7

40.7k18 gold badges72 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

pandas combine multiple dataframes or use as updates

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related