'While and Append in pandas python

I am trying to Call Api in a while loop and append the dataframe. But it is not appending .

#Max timestamp
MaxTs = 1635876000

api_key = "api_key"


cnt = 0
while cnt < 4:

url = f"https://min-api.cryptocompare.com/data/v2/histohour?fsym=BTC&tsym=USD&limit=2000&toTs={MaxTs}&api_key={api_key}"
r = requests.get(url)
data = r.json()
price_df = pd.DataFrame(data['Data']['Data'])



i = 0
reccnt = 2000
while i < reccnt:
    currTs = price_df.iloc[i]['time']
  
    
    if currTs < MaxTs:
        MaxTs = currTs
    i = i + 1
    
if cnt == 0:
    #Copying the Orginal df to new df.
    newdf = price_df.copy()
  
else:
    #when counter increases append the df.
    newdf.append(price_df)
    
  
print(MaxTs)
cnt = cnt + 1

python pandas

Solution 1:^[1]

You should increase cnt inside the while loop, not outside. But after you perform a correction you will get several copies of the same price_df. Is that what you are trying to get?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	StuffHappens

'While and Append in pandas python

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]