Feb-12-2021, 02:42 AM
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