Making charts in excel makes it easy for us to do analysis for deriving further insights from data.

Consider the following data is available with us for creating a chart in excel.

Data for Analysis

Steps to insert Chart in Excel:

Select column for drawing chart -> click Insert -> Select the line…


Pandas is a newer package built on top of Numpy and provides efficient implementation of a Dataframe. Dataframes are essentially multidimensional arrays with attached row and column labels, and often with heterogenous types and/or missing data.

Installing pandas on windows system:

pip install pandas

We will start the coding session…


Up until now, we have been discussing some of the basic nuts and bolts of Numpy ; in this section we will dive deep into the reasons that Numpy is so important in the Python Data Science world.

The key to make the computation on Numpy arrays fast is to…


Fundamentals of Python:

  1. Loading a simple delimited data file
  2. Counting how many rows and columns were loaded
  3. Determining which type of data was loaded
  4. Looking at different parts of the data by subsetting rows and columns.

In order to access the dataset used in this tutorial, kindly follow the below…


Analytics: It is defined as, “The scientific process of transforming data into insights for making better decisions.”

Data Analysis: It is the process of examining, transforming and arranging raw data in a specific way to generate useful information from it.

Analysis ≠ Analytics

Analysis: What has happened in the past?


Data manipulation in Python is nearly synonymous with Numpy array manipulation, even newer tools like Pandas are built around the Numpy array. This section will present several examples using Numpy and manipulation to access data and subarrays, and to split, reshape and join arrays.

Let’s start by defining three random…


Datasets can come from wide range of sources and wide range of formats, including collections of documents, collection of images, collection of sound clips or nearly anything else.

For example, Images can be thought of as simply 2 — dimensional arrays of numbers. Sound clips can be thought of as…


Five Traits of good Data:

Accuracy, completeness, Reliability, Relevance and Timeliness. A Data Analyst must clean the dataset by removing duplicates, correcting formatting errors and removing blank rows.

Removing duplicated or inaccurate data and empty rows:

Its very common when collecting or importing data, whether through normal or automated processes…


Various functions and formulas can be used in order to make our work easier.

Split: The split button splits the screen into multiple sections, you can scroll each section separately.

Freeze panes: If you have headings in your columns like a header row, then you might want those to remain…


Microsoft Excel is one of the most widely used tools in any industry. While some enjoy playing with pivotal tables and histograms, others limit themselves to simple pie-charts and conditional formatting.

Once we write correct formula, we can expect automatic calculations. Excel helps to organize and easily access data. It…

Pallavi Srivastava

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