Solution to concatenate columns in Dataframe

Asked

Viewed 14 times

0

I need help concatenating a column of a Dataframe into another Dataframe, but when inserting the new columns, the index date and time (2010-01-01 - 15:43: example) will not match because they do not have the same date and time value. As I did, the columns are inserted, in the Dataframe and the values values that do not match the time of one column and another are like Nan.

Does anyone have any simple way to assign Nan with the values of the previous date?

For those who are familiar, are Yahooquery Ticker data, and need to align the Tickers with exactly the same number of rows and columns. But when choosing Tickers with different Timezone, the data will never match on the same line (considering the date and time). ex:

import yahooquery

from yahooquery import Ticker
apple = Ticker('AAPL')

print(apple.history(period="60d", interval="30m"))

AAPL has New York Timezone and compare with something in ASIA

Thank you,

Marcio S F.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.