file_1<-"D:/Myblog/posts/ggplot2-tidytuesday-2024week22/tech/41588_2021_831_MOESM4_ESM.xlsx"fig1a_dat<-read_excel(file_1, sheet ="Fig1a")test<-fig1a_dat%>%rename(region ="Country", radius ="Total number")%>%mutate(radius_1 =radius/10)%>%left_join(world_map_test, by ="region")%>%select(long, lat, everything())%>%janitor::clean_names()ggplot()+geom_scatterpie(aes(x =long, y =lat, group =region, r =radius_1), data =test, cols =c("l_sativa", "l_serriola", "l_saligna", "l_virosa"))+coord_equal()+theme_bw()