How can I combine two Data Frames in Pandas Python?

Question

I have two DataFrames like below:

most_common_OMT = data["Order Method Type"].value_counts().sort_values(ascending=False).to_frame()
most_common_OMT

profitability_OMT = data.groupby("Order Method Type").agg({"Total Revenue":"mean"}).round(2).sort_values(by="Total Revenue",ascending=False)
profitability_OMT

And how can I combine these two tables so as to acheive DataFrame like below. It is not important what will be the index, simply I need to have table something like below.

BENY · Accepted Answer · 2020-09-14 13:12:37Z

1

Let us just do

out = pd.concat([most_common_OMT, profitability_OMT], axis=1)

answered Sep 14, 2020 at 13:12

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

How can I combine two Data Frames in Pandas Python?

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