Mapping the Coronavirus Cases in 2020 using Python GeoPandas and ArcGIS

In this tutorial, you will learn how to create a map of current cases of Coronavirus cases as of March 2020. We will be using Python Pandas in order to grab the data from an external website, use GeoPandas to manipulate the GIS files, and using ArcGIS to create a standard map.

⭐NOTE:
‘Kite’ is an excellent tool that can help you boost your productivity when it comes to programming with its free Artificial Intelligence (AI) powered coding assistant. Kite is a plugin which provides smart completions and documentation as you’re typing-in your code, and its compatible with most of the well-known IDEs such as PyCharm, Spyder and VS Code. I absolutely love it, and recommend you guys to try it out as well.

[a.k.singhfaculty]

Very detailed explanation of the stepwise process. Excellent!

[tahirtamba]

Very nice tutorial! I'm very impressed in what we can do with python pandas library... Thanks for sharing!

[LucidProgramming]

Nice video. Instead of iterating through the list you obtain on line 4 in the data variable, you can simply do:


That's because the `read_html` function returns a list of dataframes corresponding to all tables on the page. This saves you from having to loop over the `data` variable as you do on lines 6 and 7. This also fixes any warning you may have regarding the copying of a dataframe.


I hope that is helpful to some viewers. Thanks, and keep up the great content!

[cloudtumi]

Straight forward and worth the time thank you

[田逸飞-vv]

Thanks for sharing, look forward geopandas tutorial.

[karakol]

For those who don’t have ArcGIS, you can download QGIS free of costs. There is a lot of documentation that will help you learn the program and concepts easily.

[kipngetichevans]

I'm coming across a problem when I try running the script, especially from line 4. At first the file LXML, used to access web pages, was missing, I installed it to an environment folder. I'm not sure if it was successful because I tried, and it returned a message saying it was already installed but it was in the base/root folder. Then I installed for python 2 instead. When I ran the script again, this time it said HTTPError: Forbidden, and the error comes from urllib folder, request.py file. Is there a way you can help me. I will appreciate.

[shyamsundarshrestha]

Hi !!! When running line 4 in the data variable I came across this error which says HTTP Error: Forbidden. Do you have any idea how this could be solved? I am new to using python so any help would be appreciated. Thanks.

[qrubmeeaz]

16:10 At line 14, you are creating the same list world_data_list at every iteration of the loop. Bad practice.

[triblues]

Hi, what if the other dataset has more rows than the other datasets with the geometry features? What happens to the dataset when you combine both?

[cloudtumi]

First step fetching data from website address I get error HTTP forbidden

[saeidmohammadzadeh]

thank you so much for your video. Could you please teach me how can I read multiple shape files from a folder and named them? imagine read layer_1.shp and named layer_1, layer_2.shp and name layer_2. Thank you

[ranjisangi]

How do we make this automatic by updating on a daily basis...

[irenechang]

Hi, do you know why i can't read the html off of the wordometers website? It raises an HTTP error forbidden

[anshulcaplish]

Could anyone suggest me free software for .shp file, as Arcgis is not free

[nailsplusbeauty]

Sir How i get world maP shape file you have World map shape file but I dont have i only have carona virus cases file please reply

[mimanshrestha]

cant scrap anymore
tried import requests too
it says table not found now

[jordiguerrero]

great video. Can you repeat this video using arcgispro 2.5 notebook?

[OuagaNetNGO]

Great tutorial and detailed explanations. I have a use case also working with Covid-19 data. I am using world = geopandas.read_file(

)
I noticed that some african countries such as Cabo Verde and Mauritius are not on the file. On such cases, how do we find the missing geometry (polygon data) in order to map properly. In my data, I have Lat and Long and can create POINTS, however, I need the polygon data for each of the african country on the list.
Are the datasets the same as the shape file you are working with?
I just elected to delete those countries for the moment.
Thanks

[favourjoseph]

pls sir i am having problem in installing geopandas library via anaconda prompt..pls i need ya help