asks_price asks_qty exchange_name_ask bids_price bids_qty exchange_name_bid
0 20156.51 0.000745 Coinbase 20153.28 0.000200 Coinbase
1 20157.52 0.050000 Coinbase 20152.27 0.051000 Coinbase
2 20158.52 0.000745 Coinbase 20151.28 0.000200 Kraken
3 20158.52 0.050000 FTX 20151.28 0.051000 Coinbase
I would like to group the same price, add quantity together and combine the name of the exchange like :
asks_price asks_qty exchange_name_ask bids_price bids_qty exchange_name_bid
0 20156.51 0.000745 Coinbase 20153.28 0.000200 Coinbase
1 20157.52 0.050000 Coinbase 20152.27 0.051000 Coinbase
2 20158.52 0.050745 CoinbaseFTX 20151.28 0.051200 KrakenCoinbase
Thanks you for help
>Solution :
df.groupby(['asks_price', 'bids_price'], as_index=False).sum(False)
asks_price bids_price asks_qty exchange_name_ask bids_qty exchange_name_bid
0 20156.51 20153.28 0.000745 Coinbase 0.0002 Coinbase
1 20157.52 20152.27 0.050000 Coinbase 0.0510 Coinbase
2 20158.52 20151.28 0.050745 CoinbaseFTX 0.0512 KrakenCoinbase