Analysis
Data analysis with different visualisations on multiple topics, such as real estate, climate, COVID-19. Airbnb Paris Analysis：Paris is the capital and most populous city of France, and it also a...
Excel
My blog introduces how to use openpyxl package to manipulate Microsoft Excel workbook and worksheet, like create a workbook and worksheet, write values in cells, set font(size, type, bold, italic),...
Geovisualisation
Geovisualisation created by folium module of python. In my blogs: I talked about how to draw a variety of maps with folium module in Python, such as displaying all locations with points / cluste...
Machine-Learning
Reviews and projects of Machine Learning models / algorithms, such as: Regression Decision Trees Support Vector Machines Gradient Descent algorithm, etc.
SQL
Various manipulation with SQL query, such as: ISO calendar: When we create yearly, monthly or weekly report, we are sometimes beset by problem about calendar. Like the last day of year 2018 (201...
Visualisation
Visualisation created by multiple modules of python or R. In my blogs: I talked about how to create various plots with matplotlib module of python, such as scatter plot, treemap, venn diagram, a...