I have a pannel dataset that is organized by country, code, year, and Disaster type.
the disaster variable has 5 kinds of observations "Bio, Hydro, Climat, geo, & Meteo." For example:

Country Code Year Disaster type
Algeria DZA 1980 Geophysical
Algeria DZA 1981 Hydrological
Algeria DZA 1981 Hydrological
Algeria DZA 1981 Biological

I want to create 2 variables one that sums up the biological events for each year and another that sums up the 4 remaining categories, without having to duplicate the year. For example:

Country Code Year occurrence_h occurance_w
Algeria DZA 1980 0 1
Algeria DZA 1981 1 2

I tried creating dummy variables for each disaster type however I couldn't do anything after that. I would be grateful for any ideas on how I can sort out this problem.

Thanks in advance