Filling NaNs in a financial dataset

Filling NaNs in a financial dataset - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: Data Science (https://python-forum.io/forum-44.html)
+--- Thread: Filling NaNs in a financial dataset (/thread-40096.html)

Pages: 1 2

RE: Filling NaNs in a financial dataset - larzz - Jun-06-2023

(Jun-05-2023, 01:44 PM)snippsat Wrote:
(Jun-05-2023, 12:09 PM)larzz Wrote: I have a bigger file that isn't allowed to be uploaded through this site so I did it like this:
You missed the point,you should post code that you use to create merged_df_nan.
Also working code for function average_col(merged_df_nan) using sample.xlsx that you have posted.

(Jun-05-2023, 12:09 PM)larzz Wrote: https://file.io/cNtj51B5Tswo
Link dos not work.

But it isn't relevant how I created the merged_df_nan right? I mean, it doesn't change anything about the code that needs to be changed. The link for merged_df_nan is https://www.mediafire.com/file/8hqk0h5vy4dgepb/sample.xlsx/file (hopefully it does work now). The code I posted in my first post does work for the sample, but it takes too long and there might be mistakes when I upscale it, but I don't know because it is too slow to find out.

RE: Filling NaNs in a financial dataset - snippsat - Jun-07-2023

(Jun-06-2023, 08:31 PM)larzz Wrote: But it isn't relevant how I created the merged_df_nan right?

Of course it relevant that is the missing piece to get code to work.
Can not suggest anything if not have working code.