We wouldn’t like to see garbage in, garbage out…

Image for post
Image for post
Photo by Kaleidico on Unsplash
  • Dropping unused column
  • Removing duplicate
  • Mapping of data
  • Dealing with null data

Getting Started

conda install pandas


How to master the basic key features of Matplotlib in 5 mins

Image for post
Image for post
Photo by Isaac Smith on Unsplash
  • Basic Charting
  • Generate Mathematical Expression in title and label
  • Annotate your chart with text and arrows
  • Highlight your chart

Getting Started

pip install matplotlib

Basic Charting


Reproducing the same SQL queries result in Python

Image for post
Image for post
Photo by Hitesh Choudhary on Unsplash

Getting Started

conda install pandas


How does other social media apps impact your usage on Facebook Messenger? Who do you talk with the most?

Image for post
Image for post
Photo by Tim Bennett on Unsplash

Download your Facebook Data

  • Open your Facebook and go into Settings & Privacy > Settings
  • Go to Your Facebook Information > Download Your Information
  • Select the data range…


A simple guide to create your own Python script with command line arguments

Image for post
Image for post
Photo by Émile Perron on Unsplash
$ python main.py
$ python main.py arg1 arg2


Toggle between your Python 2 and Python 3 environments with ease

Image for post
Image for post
Photo by Denis Pavlovic on Unsplash

Using Conda Environment


You will definitely enjoy Visual Studio Code if you are a fan of Spyder or R Studio.

Image for post
Image for post
Photo by Safar Safarov on Unsplash


Few simple steps to automate your report by using Python email library.

Image for post
Image for post
Photo by Web Hosting on Unsplash


Image for post
Image for post


Image for post
Image for post
Photo on unsplash

Using Google Drive API

June Tao Ching

Data Analyst, Game Designer and future Pirate King

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store