Jingwen Zheng - page 3

Paris is the capital and most populous city of France. Since the 17th century, Paris has been one of Europe's major centers of finance, diplomacy, commerce, fashion, science, and the arts. All these elements help to bring the increasing price of real estate in Paris. In this blog, I'll talk about the second-hand apartments purchases in Paris bet...

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.