Replacing append with concat?

Question

Whenever I run this code I get:

The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead. What should I do to make the code run with concat?

final_dataframe = pd.DataFrame(columns = my_columns)
for symbol in stocks['Ticker']:
    api_url = f'https://sandbox.iexapis.com/stable/stock/{symbol}/quote?token={IEX_CLOUD_API_TOKEN}'
    data = requests.get(api_url).json()
    final_dataframe = final_dataframe.append(
                                        pd.Series([symbol, 
                                                   data['latestPrice'], 
                                                   data['marketCap'], 
                                                   'N/A'], 
                                                  index = my_columns), 
                                        ignore_index = True)

score 0 · Answer 1 · answered Apr 19 '22 at 18:27

See this release note

or from another post:

"Append is the specific case(axis=0, join='outer') of concat" link

The changes in your code should be: (changed the pd.Series to variable just for presentation)

s = pd.Series([symbol, data['latestPrice'], data['marketCap'], 'N/A'], index = my_columns)
final_dataframe = pd.concat([final_dataframe, s], ignore_index = True)

Replacing append with concat?

1 Answers1