Add series to only the first row in a DataFrame in Python

Question

i have a series of tickers of the S&P500 constituents (ticker). I want to add all the tickers to my DataFrame (SP) within the column Ticker and within the row of the 2021-01-22.

So just copy all the tickers into one cell, like this:

SP = pd.DataFrame(data={'Date': "2021-01-22", 'Ticker': ['MMM,ABT,ABBV,...','NaN','NaN']})
SP

    Date    Ticker
0   2021-01-22  MMM,ABT,ABBV,...
1   2021-01-22  NaN
2   2021-01-22  NaN

I have tried SP.at[0, 'Ticker'] = ticker , but it did not work.

question from:https://stackoverflow.com/questions/65845478/add-series-to-only-the-first-row-in-a-dataframe-in-python

Answer 1

Ok, you can do this way

ticker_list = list(ticker.values)
SP.iloc[5494,1] = ', '.join(ticker_list)
SP

Here I have just made a list of ticker values and appended it to the row you want. By seeing your image, your row for date '2021-01-22' seems to be 5494.