Python Pandas DF append to same row

Question

Trying to print some stockprices to Pandas Df, and having a hard time to make the stock name get in the same line as the price.

This is my complete code, what am i missing?

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)

Result:

     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

Expected:

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

BENY · Accepted Answer · 2020-06-02 01:19:03Z

1

Let us try , this will make the ticker become the index

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)

edited Jun 2, 2020 at 1:19

answered Jun 2, 2020 at 1:16

BENY

324k22 gold badges176 silver badges250 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

guialmachado Over a year ago

TypeError: Index(...) must be called with a collection of some kind, 'ALZR11.SA' was passed

BENY Over a year ago

@guialmachado add []~

Collectives™ on Stack Overflow

Python Pandas DF append to same row

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related