Converting a numpy float64 data type into 2 lists

Question

I'm trying to convert the following code's output into 2 lists, dates and prices, which contain the dates and prices that are outputted as a dtype:float64

from pandas_datareader import data
def get_stock_data(ticker, start, end):
    stock_data = data.DataReader(ticker, start=start, end=end, data_source='yahoo')['Close']
    return stock_data

print(get_stock_data('TSLA', '2021-01-01', '2021-01-31'))

stock_data.tolist() gives me the prices but how do I get the dates?

This could be any arbitrary set of start and end dates so I don't want to manually create a list for one test case.

Kyle Parsons · Accepted Answer · 2021-08-20 18:07:33Z

0

Assuming the return is a Pandas series and the dates are the index stock_data.index.tolist().

answered Aug 20, 2021 at 18:07

Kyle Parsons

1,5358 silver badges14 bronze badges

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

1 Comment

rexess Over a year ago

This might help you convert to regular datetime object: stackoverflow.com/questions/34386751/…

hbstha123 · Accepted Answer · 2021-08-20 18:34:38Z

0

Your code needs to be modified a bit to get two different lists of dates and prices. I have converted the stock_data into a pandas dataframe and extracted the lists of dates and prices from the dataframe as follows:

from pandas_datareader import data
def get_stock_data(ticker, start, end):
    stock_data = data.DataReader(ticker, start=start, end=end, data_source='yahoo')['Close']
    df = pd.DataFrame(stock_data)
    df.reset_index(inplace=True)
    dates = df["Date"].astype(str).tolist()
    prices = df["Close"].tolist()
    
    return dates, prices

get_stock_data('TSLA', '2021-01-01', '2021-01-31')

answered Aug 20, 2021 at 18:34

hbstha123

1,8101 gold badge22 silver badges43 bronze badges

Collectives™ on Stack Overflow

Converting a numpy float64 data type into 2 lists

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related