I have a panel dataset of 51 countries for 19 years. For each of the panels, it is subdivided into five regions. I wish to calculate the weighted means of the BIT variable by year across the five regions. A snapshot of my dataset is attached that shows the weights, BITS(variable of interest) and region.
country year region weight bits
Algeria 2000 NOA 0.095238 29
Algeria 2001 NOA 0.095238 33
Algeria 2002 NOA 0.095238 35
Algeria 2003 NOA 0.095238 38
Algeria 2004 NOA 0.095238 40
Algeria 2005 NOA 0.095238 41
Benin 2000 WAC 0.091667 3
Benin 2001 WAC 0.091667 11
Benin 2002 WAC 0.091667 11
Benin 2003 WAC 0.091667 11
Benin 2004 WAC 0.091667 14
Benin 2005 WAC 0.091667 14
Botswana 2000 SADC 0.109091 4
Botswana 2001 SADC 0.109091 4
Botswana 2002 SADC 0.109091 7
Botswana 2003 SADC 0.109091 7
Botswana 2004 SADC 0.109091 8
Botswana 2005 SADC 0.109091 9
Burkina Faso 2000 WAC 0.05 12
Burkina Faso 2001 WAC 0.05 12
Burkina Faso 2002 WAC 0.05 13
Burkina Faso 2003 WAC 0.05 14
Burkina Faso 2004 WAC 0.05 14
Burkina Faso 2005 WAC 0.05 14
Burundi 2000 CAC 0.155556 5
Burundi 2001 CAC 0.155556 5
Burundi 2002 CAC 0.155556 5
Burundi 2003 CAC 0.155556 5
Burundi 2004 CAC 0.155556 5
Burundi 2005 CAC 0.155556 5
Chad 2000 CAC 0.022222 5
Chad 2001 CAC 0.022222 9
Chad 2002 CAC 0.022222 9
Chad 2003 CAC 0.022222 9
Chad 2004 CAC 0.022222 11
Chad 2005 CAC 0.022222 11
Comoros 2000 EAC 0.120879 1
Comoros 2001 EAC 0.120879 6
Comoros 2002 EAC 0.120879 6
Comoros 2003 EAC 0.120879 6
Comoros 2004 EAC 0.120879 6
Comoros 2005 EAC 0.120879 6
Egypt 2000 NOA 0.238095 98
Egypt 2001 NOA 0.238095 102
Egypt 2002 NOA 0.238095 104
Egypt 2003 NOA 0.238095 105
Egypt 2004 NOA 0.238095 107
Egypt 2005 NOA 0.238095 109
Eswatini 2000 SADC 0.145455 5
Eswatini 2001 SADC 0.145455 5
Eswatini 2002 SADC 0.145455 5
Eswatini 2003 SADC 0.145455 5
Eswatini 2004 SADC 0.145455 5
Eswatini 2005 SADC 0.145455 5
Ethiopia 2000 EAC 0.043956 10
Ethiopia 2001 EAC 0.043956 11
Ethiopia 2002 EAC 0.043956 12
Ethiopia 2003 EAC 0.043956 17
Ethiopia 2004 EAC 0.043956 22
Ethiopia 2005 EAC 0.043956 22
I sincerely appreciate any advice on how to proceed.

Note:

There is a similar post here is yet to receive any response.