Jingwen Zheng - page 3

In this blog, I presented how to get coordinates and address by Google Geocoding API, and how to accomplish it by Python.

In this blog, I create a map to display how far is the nearest COVID-19 testing site for each community with python modules "folium" and "shapely".

This blog talks about how COVID-19 impacts people's working in France.

This blog compares "pandas" and "pyspark" on data transformation with the following points: checking dataframe size, checking unique values of a column, creating a new column, filtering, selecting a list of columns, aggregating, renaming columns, joining 2 dataframes, creating a new dataframe, creating a pivot table.

This blog talks about how to apply mock with python unittest module, like use "unittest.mock" to simulate the behavior of complex or real objects, configure your mock instance with "return_value" or / and "side_effect", check how you called a method with assertions and mock an object with "patch()".

This blog talks about how to get YouTube video's/channel's information by YouTube Data API and Python scripts, like getting a video ID & channel ID with a query, getting a video’s statistics data with a video ID, getting a video’s comments, getting a channel’s information with channel ID, and getting a channel’s playlist.

I extract one video's (Mojito Jay Chou) comments on YouTube with YouTube Data API and in this blog I will analyse them in different views.

This blog introduces how to set up a fake SMTP server and send e-mails with python, and how to test sending e-mails with unittest.mock.