Python 如何更改Pandas 数据框中的行和列

我有这样的代码，它从字典创建数据帧，但输出与预期的不同.我给出了下面的代码和步骤

options_pnl={'BTC': {'Pnl(since 6pm)': Decimal('7831.52228528'),
  'Pnl(4 hr)': Decimal('2930.47450133'),
  'Pnl(1 hr)': Decimal('1416.81306308'),
  'Volume(since 6pm)': Decimal('24509290.62181862'),
  'Volume(4 hr)': Decimal('4504202.83422724'),
  'Volume(1 hr)': Decimal('1067850.01837278')},
 'ETH': {'Pnl(since 6pm)': Decimal('387.87564823'),
  'Pnl(4 hr)': Decimal('-349.14871930'),
  'Pnl(1 hr)': Decimal('656.74824550'),
  'Volume(since 6pm)': Decimal('10700784.53262117'),
  'Volume(4 hr)': Decimal('1968872.36761706'),
  'Volume(1 hr)': Decimal('778937.22275036')}}
options_pnl_df = pd.DataFrame.from_dict(options_pnl)
options_pnl_df = options_pnl_df.astype('int64')
options_pnl_df = options_pnl_df.transpose()
display(options_pnl_df)

输出如下:

     Pnl(since 6pm) Pnl(4 hr)   Pnl(1 hr)   Volume(since 6pm)   Volume(4 hr)    Volume(1 hr)
BTC  7831   2930    1416    24509290    4504202 1067850
ETH  387    -349    656 10700784    1968872 778937

我需要改变 struct ，从上面的输出到下面给出的输出

                         PNL    Volume
BTC since 6pm       7831       24509290
BTC since last 4 hr 2930       4504202
BTC last 1 hr       1416       1067850
ETH since 6pm       387        10700784
ETH since last 4 hr -349       1968872  
ETH last 1 hr       656        778937

try 过

data = []

for asset, values in options_pnl.items():
    for interval, metrics in values.items():
        metric_type, metric_interval = interval.split('(')
        metric_interval = metric_interval.rstrip(')')  # remove trailing ')'
        pnl_value = metrics if metric_type == 'Pnl' else 0
        volume_value = metrics if metric_type == 'Volume' else 0
        data.append([asset, metric_interval, pnl_value, volume_value])

columns = ['Asset', 'Type', 'PNL', 'Volume']
options_pnl_df = pd.DataFrame(data, columns=columns)

print(options_pnl_df)

但是没有得到想要的输出，有人能从给定的字典中得到想要的输出吗