Jingwen Zheng - page 2

Review of 2020.

This blog talks about how to draw public transport lines with "folium" module in Python.

In this blog, I presented 3 excel functions, `vlookup`, `index`, and `match`, on their usages, syntaxes, applied them in different use cases, and their pro & cons.

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()".