What is Machine Learning?

Machine Learning is the science (and art) of programming computers so they can learn from data.

General Definition:

Machine Learning is the field of study that gives computers the ability to learn without being explicitly programmed. [Arthur Samuel, 1959 ]

Applied Machine Learning: Here applied means how to interpret the machine learning algorithms at a high level.

Why Machine Learning?

Consider how you would write a spam filter using traditional programming techniques.

Photo by Amanda Dalbjörn on Unsplash
  • What is Deep Face?

Deepface is a lightweight face recognition and facial attribute analysis (age, gender, emotion and race) framework for python.

It is a hybrid face recognition framework wrapping state-of-the-art models: VGG-Face, Google FaceNet, OpenFace, Facebook DeepFace, DeepID, ArcFace and Dlib. The library is mainly based on Keras and TensorFlow.

  • Module Used:
  1. DeepFace
  2. OpenCV -(To read the input images)
  3. Matplotlib -(For visualisations)

Let’s See the Implementation:

  • First of all you need to install prerequisite libraries into your python environment
pip install deepface
pip install opencv-python
pip install matplotlib
  • After installation let’s import the installed libraries
from deepface import DeepFace

Photo by Fatos Bytyqi on Unsplash
  • SELECT: SELECT is the most common statement used ,It allow us to retrieve information from a table.

Syntax for SELECT:

SELECT column_name FROM table_name

If you want all the columns from table:

SELECT * FROM table_name
  • SELECT DISTINCT : Sometimes a table contains a column that has duplicate values . The DISTINCT keyword can be used to return only the distinct values in a column.


SELECT DISTINCT column FROM table_name
  • COUNT: It returns the number of rows in a table.


SELECT COUNT(name) FROM table_name;


  • SELECT WHERE: The WHERE statement allow us to…

Photo by Boitumelo Phetla on Unsplash
  • Go to the terminal and update system software packages
sudo apt update
  • Install the package of PostgreSQL and it’s contrib files
sudo apt install postgresql postgresql-contrib
  • Once the installation done check the status of postgresql
sudo systemctl is-active postgresql


sudo systemctl status postgresql
  • If status is active then go to next step and create database using below command
sudo pg_isready
  • To connect the database
sudo su - postgres
  • Now create user
$ psql
psql (12.6 (Ubuntu 12.6-0ubuntu0.20.04.1))
Type "help" for help.
postgres-# CREATE USER dev_test WITH SUPERUSER PASSWORD 'root';
  • Create database
postgres’# create database testing;
  • Grant role to the…

Photo by Christopher Gower on Unsplash

What is Django?

  • Django is a high-level Python Web framework that enables rapid development of secure and maintainable websites.
  • It follows Model View Controller (MVC) Design Pattern.
  • Django was invented to meet fast moving new room deadlines.
  • Started in 2003 as a internal project.
  • In 2005 released as a open source project.

What is a Web Framework?

  • A web frame work is server side application framework that design to support development of dynamic websites. Django is one of available frameworks for python.

Why Django?

  • Fast
  • Secure
  • Scalable

Django’s Design Philosophy

  • Less Code
  • Fast Development
  • Don’t Repeat Yourself (DRY)
  • Functionally Independent

A Blog By Amit

Hello World!

In this blog i will explain how to import data from Excel file into MySQL. Let’s see the implementation in Python.

Python Module Used:

  • pymysql : pyMySQL is a python library for connecting to a MySQL database server from Python.This module has lots of features like it mad CRUD operations simple.

To use this library you need to install. For installation use below command

pip install PyMySQL

If you want to know more pymysql then refer pyMySQL documentations using below link

  • xlrd : xlrd is a python library for reading data and formatting information from Excel file.

To install this library…

Photo by Jesus Kiteque on Unsplash

What is Recursion?

Recursion is a technique where functions or methods makes a call to itself.

Let’s have a look of template of recursive function

Photo by Hitesh Choudhary on Unsplash

Python 3.9 is out. Here are the few new features you should know about.

  • Merging dictionaries

There is a new operator “|” that can be used to merge two dictionaries.

Photo by Adeolu Eletu on Unsplash


  • Python
  • Interest in Data​

Why is the data required?​

Below are some of the examples where data plays very important role:

  • Social Network Analysis​
  • Sentiment Analysis​
  • Weather Prediction​
  • Financial forecasts​
  • Recommendation Systems​

Where is the data?​

Everywhere you look!​ In Structured/Unstructured form.

  • Dblp — co-authorship network​
  • Textual data​
  • Twitter​
  • Facebook​
  • Zomato​
  • Stack overflow​
  • Blogs​
  • Sloan Digital Sky Survey(SDSS)

How to get it?​

Some organisations/websites which are helpful in getting the Data.​

  • API access (twitter)​
  • XML format (dblp)​
  • Zip files (snap, kaggle)​
  • Json format​
  • FITS (Image Astronomical Data)​

What can be done with the available data?

  • When you need large scale of data to conduct your own research.
  • When you want to do research in totally diversified area.

How To?

Using Below Techniques:


Module: Module generally is collection of functions.

Advantages of using modules:

  • Modules allows large programs to be broken down into small chunks of code.
  • Modules are developed separately but integrated into complex complete system which makes software development process effective.
  • Modules also help in program modifications and updations.

Lets have an example.

Note: By conventions modules are named in lower case.

As you can see in below snapshots that I have created two python files containing some functions.

Amit Kumar Manjhi

Software Developer | Technical Writer

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