Sign in

EDA = Exploratory Data Analysis

Tools (Shell or Workbench) and Language (SQL) with MySQL RDBMS

Exploratory Data Analysis (aka EDA) is the process of Descriptive Data Analytics that helps to know what has happened based on the given historical data.

This is the initial Descriptive Analysis part of the Data Analysis (aka DA) that involves cleaning and transforming data for the next step of DA that can be of Data Modelling (determining and defining the relationships between the tables).

Why EDA is done?

To get the grasp on organization’s data assets and extract meaningful information from their historical patterns that further helps business team to perform required actions to meet business targets or enhance KPIs…

[ Why | What | When | How & 3 ways to connect]

MongoDB (NoSQL database) + Python (Back-end OOP language)

If you are new to backend development or beginner - articulated it in detail with sample data set & code snippets, by illustrating one of the well-required & real-time scenarios is CRUD operations which is implemented in most of the web or desktop (GUI) applications using the MongoDB with Python.

Three available ways to communicate with MongoDB database to store, retrieve/fetch/read, update and delete data.

Let’s discuss briefly about database and their varieties. It may feel that we already know about databases! but it’s very essential to analyze the task to-do!

So, let’s dive into its WHY, WHAT, WHEN and…

Concepts • Tools • Coding

DA and its Tools

Python3 and Jupyter Notebook: defined in the above image at high-level, if you’re beginner/new to the field and to ensure all in same page prior to its deep dive. DA is performed programmatically or via GUI tools using the historical/existing data. The process of getting to know your data is also known as EDA (Exploratory Data Analysis).

Scenarios of DA - for business, investment & research purposes and for building prediction models (Machine Learning/Deep Learning).

DA categories:

  1. Descriptive Analysis: what has happened based on historical data.
  2. Diagnostic Analysis: to know why something has happened.
  3. Predictive Analysis: analyze…

With its standard/built-in module

Photo by Alex Chumak on Unsplash

If you have ever wondered how to test the Python functions, this is the summarised description with couple of ways to test functions and code examples. One way is to write print statements and view its outputs in the terminal/cmd & another way by using the Python’s built-in module doctest that’s available when Python is installed! It works in both Python2 and Python3.

I found these both ways are useful and simple for testing & debugging functions which also helps other team members to know its outputs: print statement/s and doctest approach.

print statements allows us…

With Python Programming Language

Photo by Brett Jordan on Unsplash

This is an article for how to transform text data into audio (.mp3) file with Python programming language... “From English verbal to English vocal”

I was inquisitive and when did my research on it, came up with one of the solution that I have articulated here with the related code snippets and to further enhance it, it can be automated to translate text to audio aka text-to-speech translation.
One of the use-case for this translation is, for ‘answering machines’ to transform/convert standard text to be played on and which is repetitive task thus information can be transformed to audio file…

3 Ways to interact with MySQL Database

Content: In this article, discussing about scenarios for What, Why, When and How with MySQL Database.

What: MySQL is a RDBMS software that lets us store or retrieve data that are stored in tabular format that uses SQL (Structured Query Language) to interact with database and its tables.

Why: We need RDBMS and SQL for developing and deploying full-stack web applications or softwares and data related projects in all most all sectors/industries today.

When: Briefing about use-cases of MySQL in the below two scenarios are:

i) Full-stack web applications (integration of both front-end and back-end programming technologies) or standalone software…

Ramya N

Data Analysis, Web Development, Tech Writer and ML/DL/NLP Enthusiast

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