get_whole_nation_pop_df is used to build the whole nation population estimates. It reads many excel files and returns the results in dfs which get concat'd at the end.
The reading of these Excel files in a for-loop is painfully slow. It could be massively sped up with asynchronous programming.
get_whole_nation_pop_dfis used to build the whole nation population estimates. It reads many excel files and returns the results in dfs which get concat'd at the end.The reading of these Excel files in a for-loop is painfully slow. It could be massively sped up with asynchronous programming.