下午好,
我正在做freeCodeCamp.org的课程:使用Python的算法交易-完整课程
我对以下代码有问题:
import numpy as np
import pandas as pd
import requests
import xlsxwriter
import math
stocks = pd.read_csv(r'XXXXXXXXXXXXXXXXXXXXXXX.csv')
from secret import IEX_CLOUD_API_TOKEN
my_columns=['Ticker','Stock Price','Market Capitalisation','Number of Shares to Buy']
final_dataframe = pd.DataFrame(columns = my_columns)
for stock in stocks['Ticker'][:5]:
api_url =f'https://sandbox.iexapis.com/stable/stock/{stock}/quote?token={IEX_CLOUD_API_TOKEN}'
data = requests.get(api_url).json()
final_dataframe = final_dataframe.append(
pd.Series([stock,data['latestPrice'],data['marketCap'],'N/A'],
index= my_columns),ignore_index=True)
print(final_dataframe)
它给我打印了以下内容:
结果需要
我只想在练习中有以下内容:
结果需要
有人知道哪里出了问题吗?
非常感谢!
当pd.Series
是appended
时,您刚刚为每次迭代打印了final_dataframe
。您可以将print(final_dataframe)
放在for循环&它应该可以像您想要的输出一样正常工作。
for stock in stocks['Ticker'][:5]:
api_url =f'https://sandbox.iexapis.com/stable/stock/{stock}/quote?token={IEX_CLOUD_API_TOKEN}'
data = requests.get(api_url).json()
final_dataframe = final_dataframe.append(
pd.Series([stock,data['latestPrice'],data['marketCap'],'N/A'],index= my_columns),ignore_index=True)
print(final_dataframe)