YahooFinancials:将多维字典写入csv

import csv
from yahoo_fin import stock_info as si
from yahoo_fin import YahooFinancials

# 创建一个多维字典
data = {
    'AAPL': {
        'price': si.get_live_price('AAPL'),
        'volume': si.get_quote_table('AAPL')['Volume'],
        'market_cap': YahooFinancials('AAPL').get_market_cap()
    },
    'GOOGL': {
        'price': si.get_live_price('GOOGL'),
        'volume': si.get_quote_table('GOOGL')['Volume'],
        'market_cap': YahooFinancials('GOOGL').get_market_cap()
    }
}

# 将多维字典写入CSV文件
with open('financial_data.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    
    # 写入表头
    writer.writerow(['Symbol', 'Price', 'Volume', 'Market Cap'])
    
    # 写入数据行
    for symbol, info in data.items():
        writer.writerow([symbol, info['price'], info['volume'], info['market_cap']])