How to merge a daily dataset with a quarterly dataset in Pandas where quarterly data will be converted to daily basis?

Asked Mar 02 '22 at 10:12

Active Mar 02 '22 at 10:12

Viewed 5 times

I am working on two datasets, where the first one has multiple firms' daily stock returns and the second one has monthly balance sheet items of those firms. I want to merge the dataset in such a way where the monthly balance-sheet data will join the daily return data on month basis. So in the final daily dataset a particular stock's balance-sheet item will remain fixed over month but it would be completely filled.

df1 will be merged with df2 and the final one would look like df3

asked Mar 02 '22 at 10:12

Asif Zahir

If you have an issue with a merge, please read the duplicate, make sure you tested the proposed solution. If you really don't manage, provide your input data as **text** and explain what you tried and how it failed – mozway Mar 02 '22 at 10:14

How to merge a daily dataset with a quarterly dataset in Pandas where quarterly data will be converted to daily basis?

0 Answers0