79277021

Date: 2024-12-13 01:23:42
Score: 1.5
Natty:
Report link

Ok found out how. Indexing on MultiIndex

multiple_df.index.name = None
data = {idx: gp.T for idx, gp in multiple_df.T.groupby(level=0)}

separated_df = {}
for ticker in data:
    new_df = data[ticker][ticker]['Close High Low Open Volume'.split()]
    new_df.columns.name = None
    adj_close = data[ticker][ticker]['Adj Close']
    new_df.insert(0, 'Adj Close', adj_close)
    
    separated_df[ticker] = new_df

print(separated_df)
Reasons:
  • Probably link only (1):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Ryanc88