
Second-hand apartments transactions in Paris (01/2014 - 06/2020)
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...


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

Excel: vlookup vs. index & match
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.

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

How far is the nearest COVID-19 testing site?
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".

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

Data transformation with pandas vs. pyspark
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.
113 post articles, 15 pages.