Python将数据追加到同一行

Question

试图将一些股票价格打印到熊猫Df上，很难让股票名称与价格一致

这是我的完整代码，我遗漏了什么

import yfinance as yf
from pandas_datareader import data
import matplotlib.pyplot as plt
import pandas as pd

df = pd.DataFrame()
tickers = ['ALZR11']
df['Ticker'] = ['']
for ticker in tickers:
    print(ticker)
    df = df.append(pd.DataFrame({'Ticker': ticker}, index=[0]), ignore_index=True)
    ticker = ticker+".SA"
    data = yf.download(tickers=ticker, period="1d", interval="1d")
    df = df.append(data, ignore_index=True)
    #df.loc[ticker, 'New Column Title'] = ticker
    print(df)

结果:

     Ticker  Open  High  Low        Close    Adj Close  Volume
0             NaN   NaN  NaN          NaN          NaN     NaN
1    ALZR11   NaN   NaN  NaN          NaN          NaN     NaN
2       NaN   0.0   0.0  0.0   116.500000   116.500000     0.0

预期：

     Ticker  Open  High  Low        Close    Adj Close  Volume
0    ALZR11   0.0   0.0  0.0   116.500000   116.500000     0.0

Answer 1

让我们试试，这将使股票代码成为索引

for ticker in tickers:
    print(ticker)
    ticker = ticker+".SA"
    data = yf.download(tickers=ticker, period="1d", interval="1d")
    data.index=[ticker]
    df = df.append(data)
    #df.loc[ticker, 'New Column Title'] = ticker
    print(df)