How to fill missing value in the Panel data

Hello, I have panel data, You 20 countries every country 20 years. I have some missing values in some columns. I want to fill this missing data for example by average, but only the average for the country not the average for all the column.
I couldn’t know how to filter it and make the missing values node only work on the missing values country by country
Thanks

Hey there and welcome to the forum :).

Use a group loop start node. Select country column as only group column. Connect the group loop start node to the missing value filter. Then connect that to a loop end node.

That should give you the desired result

4 Likes

thanks a lot, it worked

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.