python - 有没有办法从字典中提取数据到csv文件

Question

下面的代码会将多个股票数据放入字典中。但我需要将它们放入单个 csv 文件中

代码：

import pandas as pd
from datetime import datetime as dt
from nsepy import get_history

stocks = ['JSWSTEEL','RELIANCE','AXISBANK','HCLTECH','TECHM']
df = {}
for tickers in stocks:
    df[tickers] = get_history(tickers,dt(2020,1,1),dt(2021,1,1))

标签： pythoncsvdictionary

Answer 1

使用 pandas 从 dict 中创建一个 DataFrame，然后使用 pandas.to_csv() 函数，如下所示：

import pandas as pd
from datetime import datetime as dt
from nsepy import get_history

stocks = ['JSWSTEEL','RELIANCE','AXISBANK','HCLTECH','TECHM']
df = {}
for tickers in stocks:
    df[tickers] = get_history(tickers,dt(2020,1,1),dt(2021,1,1))

dataset = pd.DataFrame([df], index=[0])
csv_data = dataset.to_csv("your_file_path.csv")

工作精美！