Repositories

Education

• Python-Playgroundopen in new window — Jupyter Notebooks containing beginner and intermediate tutorials for Python.
  • Beginner's Roadmapopen in new window
  • Python's Class Development Toolkitopen in new window
  • ML for Accountantsopen in new window

Web Development

• cv-flaskopen in new window — My Curriculum Vitae websiteopen in new window with a Flask backend, deployed on Google Cloud Run. Flask uses Jinja to render information I stored in Firestore. This is a revamp of an earlier project cv-djangoopen in new window.
• marvintensuan.github.ioopen in new window — a Github Pages site for my main Github account (this website). 😃 At this moment, it is currently a Vuepress website.

Scripting

• My-Data-Migrationsopen in new window — Compilation of Python scripts used to move data from one source to another. It uses tools like praw (Python Reddit API Wrapper) and psycopg2 to move data between sources like a Postgresql instance at Cloud SQL and Firestore.
• cloud-sql-proxy-wrapperopen in new window — A script to set-up Cloud SQL Proxy on my Windows machine. Cloud SQL Proxy provides secure access to Google Cloud SQL instances without the need for Authorized Networks or for configuring SSL.
• PICPA_La_Robotopen in new window — A Reddit script bot which uses praw and pywin32 to scrape from MS Outlook to post the latest PICPA events via /u/PICPA_La_Robot.

Hackathon

• tidecalleropen in new window - Official entry to Project SPARTA 2021 Hackathon. A FastAPI web application which is a complete refactor of the existing sensors API endpoint from a government weather website.

Miscellaneous

• Pandas-Tutorialopen in new window — An introductory tutorial for Python and pandas presented to my colleagues.
• LoLWikiaopen in new window — An Object-Oriented Data Analysis which uses Python's import system to encapsulate behavior required to analyze League of Legends data scraped from the web.
• Who Are VBA Developersopen in new window — Uses dataclass and collections.Counter to generate insights from Stack Overflow Survey 2020 results.
• SAP-with-Pythonopen in new window — Collection of boilerplate codes for Pythonic SAP automation. It features libraries such as multiprocessing and contextmanager.