How do I reverse a CSV- Python

443 views Asked by At

I'm trying to create a stock market predicting algorithm and I'm using alpha vantage as my api for stock prices. However, they store their data from newest to oldest. Is there any way to change this from oldest to newest?

ts = TimeSeries(key=api_key, output_format='pandas')
data, meta_data = ts.get_daily(self.symbol, outputsize='full')
data.to_csv(f'./{self.symbol}_daily.csv')
print(data)

Edit: The CSV is a Data Frame with the following columns: Index (0-2599), Date, Open, High, Low, Close

1

There are 1 answers

0
Lucas H On BEST ANSWER

Yes, you can quickly reformat your data with:

data = data.iloc[::-1]

I would recommend reviewing pandas indexing closely from here.