To prepare for future operations using Sqlite3, I recently tried using it to operate on databases at work. I decided to use sqlite3 because it seemed convenient. However, I found that not all SQL statements are supported by sqlite3, and its free-form shell commands cannot be called directly by the Python sqlite module…

Regular expressions are still quite useful in many situations. However, there are some differences in how they are written across different programs, so it’s a good idea to make a cheat sheet for reference!

During my graduate studies, I had the need to display results using maps and used R to create them. I recorded the code from that time below.

Graduate training on R at the Guangdong Provincial CDC was my first serious programming course.