Posts by Tag

Python

Blood_Pressure_Recorder_Mobile_App

6 minute read

Summary: Developed a mobile APP to recognize picture of blood pressure monitor and store the data to sqlite3 database. The use can view, add, edit the record...

Deploy PostgreSQL on Heroku

less than 1 minute read

Summary: deploy PostgreSQL on Heroku and ingest Data using Pandas and SQLAlchemy.

Data Modeling with Apache Cassandra

4 minute read

Summary: Data modeling with Apache Cassandra. Modeling event data to create a non-relational database and ETL pipeline for a music streaming app.

Data Modeling with PostgreSQL

9 minute read

Summary: Modeling user activity data to create a relational database and ETL pipeline in PostgreSQL for a music streaming app.

10 Days of Statistics

10 minute read

Summary: solving some problems about statistics in 10 days. The problems are on HackerRank.

Back to Top ↑

Web

Back to Top ↑

SQL

Data Modeling with PostgreSQL

9 minute read

Summary: Modeling user activity data to create a relational database and ETL pipeline in PostgreSQL for a music streaming app.

SQL on LeetCode

4 minute read

Summary: solving the SQL problems on LeetCode.

SQL on HackerRank

6 minute read

Summary: solving the SQL problems on HackerRank.

Back to Top ↑

Jekyll

Back to Top ↑

PostgreSQL

Deploy PostgreSQL on Heroku

less than 1 minute read

Summary: deploy PostgreSQL on Heroku and ingest Data using Pandas and SQLAlchemy.

Data Modeling with PostgreSQL

9 minute read

Summary: Modeling user activity data to create a relational database and ETL pipeline in PostgreSQL for a music streaming app.

Back to Top ↑

Bokeh

Back to Top ↑

Heroku

Deploy PostgreSQL on Heroku

less than 1 minute read

Summary: deploy PostgreSQL on Heroku and ingest Data using Pandas and SQLAlchemy.

Back to Top ↑

Kivy

Blood_Pressure_Recorder_Mobile_App

6 minute read

Summary: Developed a mobile APP to recognize picture of blood pressure monitor and store the data to sqlite3 database. The use can view, add, edit the record...

Back to Top ↑

Github Pages

Back to Top ↑

Fortran

Install_and_Use_Intel_oneAPI_Toolkit

less than 1 minute read

Summary: Installing Intel oneAPI, run fortran code with calling Math Kernel Library on Visual Studio 2019.

Back to Top ↑

Linux

Shell Notes

5 minute read

Summary: Shell Notes.

Back to Top ↑

HackerRank

10 Days of Statistics

10 minute read

Summary: solving some problems about statistics in 10 days. The problems are on HackerRank.

SQL on HackerRank

6 minute read

Summary: solving the SQL problems on HackerRank.

Back to Top ↑

MySQL

SQL on LeetCode

4 minute read

Summary: solving the SQL problems on LeetCode.

SQL on HackerRank

6 minute read

Summary: solving the SQL problems on HackerRank.

Back to Top ↑

AWS

Data Lakes with Spark

4 minute read

Summary: Data Warehouse with AWS. Building an ETL pipeline that extracts data from S3, stage them in Redshift, and transform data into a set of dimensional t...

Data Warehouse with AWS

7 minute read

Summary: Data Warehouse with AWS. Building an ETL pipeline that extracts data from S3, stage them in Redshift, and transform data into a set of dimensional t...

Back to Top ↑

Mobile APP

Back to Top ↑

MongoDB

Back to Top ↑

JavaScript

Back to Top ↑

GPU

Back to Top ↑

Notebook

Back to Top ↑

update

Back to Top ↑

markdown

Back to Top ↑

academicpages

Back to Top ↑

Intel

Back to Top ↑

LeetCode

SQL on LeetCode

4 minute read

Summary: solving the SQL problems on LeetCode.

Back to Top ↑

matlab

Set matlab scheme

less than 1 minute read

Summary: A useful package which can set matlab scheme easily.

Back to Top ↑

scheme

Set matlab scheme

less than 1 minute read

Summary: A useful package which can set matlab scheme easily.

Back to Top ↑

Statistics

10 Days of Statistics

10 minute read

Summary: solving some problems about statistics in 10 days. The problems are on HackerRank.

Back to Top ↑

Tableau

Story of Texas Outage in Feb 2021

4 minute read

Summary: Tableau is a popular visualization software. I collected Texas outage data and visualize it in Tableau.

Back to Top ↑

Texas

Story of Texas Outage in Feb 2021

4 minute read

Summary: Tableau is a popular visualization software. I collected Texas outage data and visualize it in Tableau.

Back to Top ↑

Outage

Story of Texas Outage in Feb 2021

4 minute read

Summary: Tableau is a popular visualization software. I collected Texas outage data and visualize it in Tableau.

Back to Top ↑

Visualization

Story of Texas Outage in Feb 2021

4 minute read

Summary: Tableau is a popular visualization software. I collected Texas outage data and visualize it in Tableau.

Back to Top ↑

NoSQL

Data Modeling with Apache Cassandra

4 minute read

Summary: Data modeling with Apache Cassandra. Modeling event data to create a non-relational database and ETL pipeline for a music streaming app.

Back to Top ↑

Cassandra

Data Modeling with Apache Cassandra

4 minute read

Summary: Data modeling with Apache Cassandra. Modeling event data to create a non-relational database and ETL pipeline for a music streaming app.

Back to Top ↑

Data Warehouse

Data Warehouse with AWS

7 minute read

Summary: Data Warehouse with AWS. Building an ETL pipeline that extracts data from S3, stage them in Redshift, and transform data into a set of dimensional t...

Back to Top ↑

Redshift

Data Warehouse with AWS

7 minute read

Summary: Data Warehouse with AWS. Building an ETL pipeline that extracts data from S3, stage them in Redshift, and transform data into a set of dimensional t...

Back to Top ↑

Data Lakes

Data Lakes with Spark

4 minute read

Summary: Data Warehouse with AWS. Building an ETL pipeline that extracts data from S3, stage them in Redshift, and transform data into a set of dimensional t...

Back to Top ↑

Spark

Data Lakes with Spark

4 minute read

Summary: Data Warehouse with AWS. Building an ETL pipeline that extracts data from S3, stage them in Redshift, and transform data into a set of dimensional t...

Back to Top ↑

Web Map

Back to Top ↑

Folium

Back to Top ↑

PyMol

Create xyz-axis for PyMol

1 minute read

Summary: When show protein unit cell in PyMol, I want to show xyz axis, but PyMol doesn’t have this option. Here is a solution. Contents: Step 1: Create ...

Back to Top ↑

PDB

Create xyz-axis for PyMol

1 minute read

Summary: When show protein unit cell in PyMol, I want to show xyz axis, but PyMol doesn’t have this option. Here is a solution. Contents: Step 1: Create ...

Back to Top ↑

GUI

Back to Top ↑

Buildozer

Back to Top ↑

Node

Back to Top ↑

Mongoose

Back to Top ↑

Flask

Back to Top ↑

Database

Back to Top ↑

Django

Back to Top ↑

Bootstrap

Back to Top ↑

Dashboard

Back to Top ↑

Minimal Mistake

Back to Top ↑

Intel oneAPI

Install_and_Use_Intel_oneAPI_Toolkit

less than 1 minute read

Summary: Installing Intel oneAPI, run fortran code with calling Math Kernel Library on Visual Studio 2019.

Back to Top ↑

Visual Studio 2019

Install_and_Use_Intel_oneAPI_Toolkit

less than 1 minute read

Summary: Installing Intel oneAPI, run fortran code with calling Math Kernel Library on Visual Studio 2019.

Back to Top ↑

Math Kernel Library

Install_and_Use_Intel_oneAPI_Toolkit

less than 1 minute read

Summary: Installing Intel oneAPI, run fortran code with calling Math Kernel Library on Visual Studio 2019.

Back to Top ↑

OpenCV

Blood_Pressure_Recorder_Mobile_App

6 minute read

Summary: Developed a mobile APP to recognize picture of blood pressure monitor and store the data to sqlite3 database. The use can view, add, edit the record...

Back to Top ↑

APK

Blood_Pressure_Recorder_Mobile_App

6 minute read

Summary: Developed a mobile APP to recognize picture of blood pressure monitor and store the data to sqlite3 database. The use can view, add, edit the record...

Back to Top ↑

Ubuntu

Back to Top ↑

Cuda

Back to Top ↑

Shell

Shell Notes

5 minute read

Summary: Shell Notes.

Back to Top ↑

CSS

SCSS Notes

less than 1 minute read

Summary: SCSS Notes.

Back to Top ↑

SCSS

SCSS Notes

less than 1 minute read

Summary: SCSS Notes.

Back to Top ↑