Yahoo_fin, Pandas: how to convert data table structure in csv file

[detlefschmitt]

The below Yahoo_fin script exports 59 stock stats for each ticker to csv. The program is working fine.

import pandas as pd
from yahoo_fin import stock_info as si
import glob
  
stock_list = "MSFT", "AAPL"
 
stats = {}
  
for ticker in stock_list:
  data2 = si.get_stats(ticker)
  data2 = data2.iloc[:,:2]
  data2.columns = ["Attribute", "Recent"]
  stats[ticker] = data2
  
combined2 = pd.concat(stats)
combined2 = combined2.reset_index()
del combined2["level_1"]
combined2.columns = ["Ticker", "Attribute", "Recent"]
  
df = pd.DataFrame(combined2)
df2 = df.drop_duplicates(subset=None, keep="first", inplace=False)
df2.to_csv(r'stats.csv')

The csv output file looks as follows:

Output:
	Ticker	Attribute	               Recent
0	MSFT	Market Cap	               1.84T
1	MSFT	Enterprise Value	       1.78T
.
.
58	MSFT	Free Cash Flow	               34.79B
59	AAPL	Market Cap	               2.27T
60	AAPL	Enterprise Value	       2.31T
.
.
117	AAPL	Free Cash Flow	               66.89B

Is there are a way to modified the yahoo_fin script so that the output looks like below instead?

Output:
Ticker     Market Cap     Enterprise Value   ..   Free Cash Flow
MSFT       1.84T          1.78T                   34.79B
AAPL       2.27T          2.31T                   66.89B