Categories
Data Science
Dataframe groupby date and time
In this post we will see how to group a timeseries dataframe by Year,Month, Weeks or days. Additionally, we will also see how to groupby time objects like hours
In Data Science, Pandas, Python, May 26, 2020Decision Tree in Sklearn
In this post we are going to see how to build a basic decision tree classifier using scikitlearn package and how to use it for doing multiclass classification on a dataset.
In Python, Data Science, scikitlearn, May 13, 2020Time Series Analysis and Forecasting with ARIMA
In the previous post we have seen how to visualize a time series data. In this post we will discuss how to do a time series modelling using ARMA and ARIMA models. Here AR stands for A...
In Python, Data Science, Time Series Analysis, Apr 30, 2020Time Series Data Visualization
Visualizing Time Series data with Python
In Python, Data Science, Time Series Analysis, Apr 27, 2020Resample and Interpolate time series data
Resampling is a method of frequency conversion of time series data. You can use resample function to convert your data into the desired frequency.
In Data Science, Pandas, Python, Time Series Analysis, Apr 14, 2020Reshaping numpy arrays in python
Reshape is an important feature which lets you to change the shape of your array without changing its data
In Data Science, numpy, Python, Jan 06, 2020How to create interactive data visualization using plotly
Visualization is the graphical representation of your data and it let you paint your data into a canvas in a way you want to see it. There are lot of amazing libraries and tools avail...
In Data Science, Python, Tutorial, Dec 31, 2019How to calculate Distance in Python and Pandas using Scipy spatial and distance functions
Working with Geo data is really fun and exciting especially when you clean up all the data and loaded it to a dataframe or to an array. The real works starts when you have to find dis...
In Data Science, Pandas, Python, Scipy, Dec 27, 2019How to work with JSON in Pandas
JSON is widely used format for storing the data and exchanging. Many of the API’s response are JSON and being light weight it’s used almost everywhere
In Data Science, Pandas, Python, Dec 12, 2019Pandas apply, map and applymap
In this post we will see how to apply a function along the axis of a dataframe using apply and applymap and how to map the values of a Series from one domain to another using map
In Data Science, Pandas, Python, Nov 25, 2019How to create dataframe for testing?
Did you ever wanted to create dataframes for testing and find it hard to fill the dataframe with dummy values then DO NOT Worry there are functions that are not mentioned in the offic...
In Data Science, Pandas, Python, Nov 18, 2019How to use Regex in Pandas
There are several pandas methods which accept the regex in pandas to find the pattern in a String within a Series or Dataframe object. These methods works on the same line as Pythons ...
In Data Science, Python, Tutorial, Nov 12, 2019Python Detect and Translate language
The internet is flooded with articles and posts for translating the language using Machine Learning or Deep Learning LSTM models and building a deep neural network for developing your...
In Data Science, Python, Nov 06, 2019How to remove duplicate data from python dataframe
Not all data are perfect and we really need to get duplicate data removed from our dataset most of the time. it looks easy to clean up the duplicate data but in reality it isn’t. Some...
In Data Science, Pandas, Python, Oct 25, 2019Working with Pandas datetime
In this post we will explore the Pandas datetime methods which can be used instantaneously to work with datetime in Pandas.
In Data Science, Pandas, Python, Tutorial, Oct 09, 2019How to find Percentage Change in pandas
So you are interested to find the percentage change in your data. Well it is a way to express the change in a variable over the period of time and it is heavily used when you are anal...
In Data Science, Pandas, Python, Sep 29, 2019Building a Web app using Python and Mongodb
Introduction
In Data Science, Flask, Mongodb, Python, Tutorial, Sep 25, 2019Dataframe Visualization with Pandas Plot
Visualization has always been challenging task but with the advent of dataframe plot() function it is quite easy to create decent looking plots with your dataframe, The **plot** metho...
In Data Science, Python, Tutorial, Visualization, Sep 16, 2019How to shift a column in Pandas
If you want to shift your columns without rewriting the whole dataframe or you want to subtract the column value with the previous row value or if you want to find the cumulative sum...
In Data Science, Pandas, Python, Sep 09, 2019Pandas Groupby Tutorial
Hope if you are reading this post then you know what is groupby in SQL and how it is being used to aggregate the data of the rows with the same value in one or more column. I was rece...
In Data Science, Pandas, Python, Tutorial, Sep 04, 2019Pandas Dataframe Align function
Pandas Align basically helps to align the two dataframes have the same row and/or column configuration and as per their documentation it Align two objects on their axes with the speci...
In Data Science, Pandas, Python, Aug 27, 2019Pandas Transform and Filter
In this blog we will see how to use Transform and filter on a groupby object. We all know about aggregate and apply and their usage in pandas dataframe but here we are trying to do a ...
In Data Science, Pandas, Python, Aug 22, 2019Pandas Coalesce  How to Replace NaN values in a dataframe
In this post we will discuss on how to use fillna function and how to use SQL coalesce function with Pandas, For those who doesn’t know about coalesce function, it is used to replace ...
In Data Science, Pandas, Python, Aug 17, 2019Add new rows and columns to Pandas dataframe
We often get into a situation where we want to add a new row or column to a dataframe after creating it. A quick and dirty solution which all of us have tried atleast once while worki...
In Data Science, Pandas, Python, Aug 03, 2019How to create Pandas Pivot Table and Crosstab
Pivot table lets you calculate, summarize and aggregate your data. MS Excel has this feature builtin and provides an elegant way to create the pivot table from data. its a powerful t...
In Data Science, Pandas, Python, Jul 24, 2019Pandas How to replace values based on Conditions
Using these methods either you can replace a single cell or all the values of a row and column in a dataframe based on conditions .
In Data Science, Pandas, Python, Jul 17, 2019Pandas Difference Between two Dataframes
There are often cases where we need to find out the common rows between the two dataframes or find the rows which are in one dataframe and missing from second dataframe. In this post ...
In Data Science, Pandas, Python, Jul 04, 2019Pandas how to get a cell value and update it
Accessing a single value or setting up the value of single row is sometime required when we doesn’t want to create a new Dataframe for just updating that single cell value. There are ...
In Data Science, Pandas, Python, Apr 12, 2019Pandas Map Dictionary values with Dataframe Columns
Pandas has a cool feature called Map which let you create a new column by mapping the dataframe column values with the Dictionary Key. Let’s understand this by an example:
In Data Science, Pandas, Python, Apr 06, 2019Pandas Select rows by condition and String Operations
There are instances where we have to select the rows from a Pandas dataframe by multiple conditions. Especially, when we are dealing with the text data then we may have requirements t...
In Data Science, Pandas, Python, Mar 27, 2019Pandas Rename and Reorder Columns
Pandas has two ways to rename their Dataframe columns, first using the df.rename() function and second by using df.columns, which is the list representation of all the columns in data...
In Data Science, Pandas, Python, Mar 23, 2019Text Data Visualization in Python
The best way to understand any data is by visualizing it. if I give you a table load of data and Charts then the latter is more easier way to get insight from the data. Visualization ...
In Data Science, Python, Mar 17, 2019Named Entity Recognition: How to Automate Customer Support
Customer support is one of the complex and most important part of any business. This area of business stands to benefit from the machine learning as it is helping to automate and impr...
In Data Science, Pandas, Python, Feb 21, 2019How to find distance between two Points based on Latitude and Longitude using Python and SQL
if you are working with GIS or POI data then you must be dealing with lat/long values and there would be use cases to calculate the distance between two points or places by evaluating...
In Data Science, Python, Feb 14, 2019Python Itertools: For a faster and memory efficient code
The reason python stands out from many other languages is because of it’s simplicity and easy to work with, and the data science community has put the work in to create the plumbing i...
In Data Science, Feb 08, 2019Learn SQL for Data Science
SQL is important as it is generally one of the first step needed to get your data from a database or data warehouse. SQL is how you query data from databases, which is where companies...
In Data Science, Feb 02, 2019How to Tame a Python
All of those out there who claim that you can learn python in 3,6 or 9 days or 1 month are just fooling around and f** up with your mind. Get it straight you can get a gist of python ...
In Data Science, Python, Jan 30, 2019Google Takeout: How to download your personal google data
I always wondered how our life would have been if Google hadn’t been there. We depend on most of things from our personal to professional life on Google and it’s app. Not even a singl...
In Data Privacy, Data Science, Pandas, Python, Jan 20, 2019How to use AI powered Query in Google Spreadsheet
Dealing with data has always been a daunting task no matter how much data geek you are. Being a Data Scientist the moment I see a new dataset the first thing which comes to my mind is...
In Data Science, Excel, google sheet, Jan 05, 2019Color Columns, Rows & Cells of Pandas Dataframe
I always wanted to highlight the rows,cells and columns which contains some specific kind of data for my Data Analysis. I wanted to Know which cells contains the max value in a row or...
In Data Science, Pandas, Python, Jan 02, 2019Text Matching: Cosine Similarity
Recently I was working on a project where I have to cluster all the words which have a similar name. For a novice it looks a pretty simple job of using some Fuzzy string matching tool...
In Data Science, Python, Dec 27, 2018Read Google Spreadsheet data into Pandas Dataframe
Many a times it happens that we have our data stored on a Google drive and to analyze that data we have to export the data as csv or xlsx and store it on a disk to convert into a data...
In Data Science, google sheet, Pandas, Python, Dec 25, 2018Google Facets  An Open Source Tool to Analyze & Visualize your data
The major challenge which a data scientists face today is to visualize or understand the data and spot the complexity within the given data set and which results in spending lot of ti...
In Data Science, Oct 07, 2017Exploratory Analysis of H1B Visa
The H1B is a nonimmigrant visa in the United States, it is designed to bring foreign professionals with college degrees and specialized skills to fill jobs when qualified Americans ...
In Data Science, Python, May 15, 2017Data Visualization with Excel  Part 1
There are abundant tool available for Data Analysis & Visualization but we all are using excel before we know what is data analytics & visualization.
In Data Science, Excel, Uncategorized, May 15, 2017Learn Python for Data Science from Scratch for Beginners
Why Python?
In Data Science, Python, May 14, 2017Data Analysis of IMDB Data
[youtube https://www.youtube.com/watch?v=mS3dzczv1ZQ?version=3&rel=1&fs=1&autohide=2&showsearch=0&showinfo=1&iv_load_policy=1&start=1&wmode=transparent]
In Data Science, Python, May 14, 2017Python
Show images in grid inside jupyter notebook using matplotlib and numpy
In this post, we will see how to display the images in a grid using matplotlib imshow and Image grid. Alternatively, we will see the visualization of image blocks and show it in a gri...
In Python, Matplotlib, Numpy, May 11, 2021matplotlib fill color between vertical, horizontal lines and polygon
In this post, we will learn how to fill color in the matplotlib charts between two vertical or Horizaontal lines and also inside the Polygons
In Python, Matplotlib, Mar 02, 2021Matplotlib Scatter Plot Color by Category in Python
Scatter plot are useful to analyze the data typically along two axis for a set of data. It shows the relationship between two sets of data
In Python, Matplotlib, Aug 30, 2020Find nearest neighbor using KD Tree
KD Tree is a modified Binary Search Tree(BST) that can perform search in multidimensions and that’s why Kdimensional.
In Python, NearestNeighbor, Algorithm, Aug 05, 2020Vectors, Matrix And Tensors
In this post we will see how large data is stored in multidimensional arrays, which is also called as tensors.
In Python, Tensors, Aug 01, 2020Python API Documentation using Flask and Swagger
What is Swagger?
In Python, Swagger, Flask, Jul 18, 2020Create Interactive Dashboard in Python using Streamlit
Dashboard gives a graphical interface to visualize the key indicators and trends of your data. However, Creating Dashboard is always been a tedious task for developers
In Python, streamlit, Jul 04, 2020Compare two Numpy arrays for equality
In this post we will compare elements of two arrays for equality. This would be really helpful when you wanted to compare if two similar arrays coming out through two different proces...
In numpy, Python, Jun 22, 2020How to split Numpy Arrays
In this post we will see how to split a 2D numpy array using split, array_split , hsplit, vsplit and dsplit.
In numpy, Python, Jun 11, 2020Dataframe groupby date and time
In this post we will see how to group a timeseries dataframe by Year,Month, Weeks or days. Additionally, we will also see how to groupby time objects like hours
In Data Science, Pandas, Python, May 26, 2020Decision Tree in Sklearn
In this post we are going to see how to build a basic decision tree classifier using scikitlearn package and how to use it for doing multiclass classification on a dataset.
In Python, Data Science, scikitlearn, May 13, 2020Time Series Analysis and Forecasting with ARIMA
In the previous post we have seen how to visualize a time series data. In this post we will discuss how to do a time series modelling using ARMA and ARIMA models. Here AR stands for A...
In Python, Data Science, Time Series Analysis, Apr 30, 2020Time Series Data Visualization
Visualizing Time Series data with Python
In Python, Data Science, Time Series Analysis, Apr 27, 2020Resample and Interpolate time series data
Resampling is a method of frequency conversion of time series data. You can use resample function to convert your data into the desired frequency.
In Data Science, Pandas, Python, Time Series Analysis, Apr 14, 2020Convert Pandas dataframe to dictionary
In my this blog we will discover what are the different ways to convert a Dataframe into a Python Dictionary or Key/Value Pair
In Pandas, Python, Mar 24, 2020How to use Pandas Count and Value_Counts
Counting number of Values in a Row or Columns is important to know the Frequency or Occurrence of your data.
In Pandas, Python, Mar 09, 2020Parallelize pandas apply using dask and swifter
Using Pandas apply function to run a method along all the rows of a dataframe is slow and if you have a huge data to apply thru a CPU intensive function then it may take several secon...
In Pandas, Python, Feb 24, 2020Sort Pandas Dataframe and Series
Sorting a dataframe by row and column values or by index is easy a task if you know how to do it using the pandas and numpy builtin functions
In Pandas, Python, Jan 28, 2020Pandas dataframe filter with Multiple conditions
Selecting or filtering rows from a dataframe can be sometime tedious if you don’t know the exact methods and how to filter rows with multiple conditions
In Pandas, Python, Jan 21, 2020Find K smallest and largest values and its indices in a numpy array
To find the maximum and minimum value in an array you can use numpy argmax and argmin function
In numpy, Python, Jan 14, 2020Concatenating arrays in Numpy
We will be discussing about merging numpy arrays and different functions that are available in the toolbox to perform this job
In numpy, Python, Jan 10, 2020Reshaping numpy arrays in python
Reshape is an important feature which lets you to change the shape of your array without changing its data
In Data Science, numpy, Python, Jan 06, 2020How to create interactive data visualization using plotly
Visualization is the graphical representation of your data and it let you paint your data into a canvas in a way you want to see it. There are lot of amazing libraries and tools avail...
In Data Science, Python, Tutorial, Dec 31, 2019How to calculate Distance in Python and Pandas using Scipy spatial and distance functions
Working with Geo data is really fun and exciting especially when you clean up all the data and loaded it to a dataframe or to an array. The real works starts when you have to find dis...
In Data Science, Pandas, Python, Scipy, Dec 27, 2019How to work with JSON in Pandas
JSON is widely used format for storing the data and exchanging. Many of the API’s response are JSON and being light weight it’s used almost everywhere
In Data Science, Pandas, Python, Dec 12, 2019How to iterate through a python dictionary
A python Dictionary is one of the important data structure which is extensively used in data science and elsewhere when you want to store the data as a keyvalue pair. In this post we...
In Python, Dec 04, 2019A primer on Python Regular Expression
Regex is a group of characters which helps to find pattern within a string. Regex is used in lot of applications including the search engines, search and for find and replace in text ...
In Python, Nov 29, 2019Pandas apply, map and applymap
In this post we will see how to apply a function along the axis of a dataframe using apply and applymap and how to map the values of a Series from one domain to another using map
In Data Science, Pandas, Python, Nov 25, 2019How to create dataframe for testing?
Did you ever wanted to create dataframes for testing and find it hard to fill the dataframe with dummy values then DO NOT Worry there are functions that are not mentioned in the offic...
In Data Science, Pandas, Python, Nov 18, 2019How to use Regex in Pandas
There are several pandas methods which accept the regex in pandas to find the pattern in a String within a Series or Dataframe object. These methods works on the same line as Pythons ...
In Data Science, Python, Tutorial, Nov 12, 2019Python Detect and Translate language
The internet is flooded with articles and posts for translating the language using Machine Learning or Deep Learning LSTM models and building a deep neural network for developing your...
In Data Science, Python, Nov 06, 2019How to remove duplicate data from python dataframe
Not all data are perfect and we really need to get duplicate data removed from our dataset most of the time. it looks easy to clean up the duplicate data but in reality it isn’t. Some...
In Data Science, Pandas, Python, Oct 25, 2019Python Logging
Log is an important tool for any developer. it helps in debugging and log important information or exceptions that emits while the code executes
In Python, Oct 16, 2019Working with Pandas datetime
In this post we will explore the Pandas datetime methods which can be used instantaneously to work with datetime in Pandas.
In Data Science, Pandas, Python, Tutorial, Oct 09, 2019How to find Percentage Change in pandas
So you are interested to find the percentage change in your data. Well it is a way to express the change in a variable over the period of time and it is heavily used when you are anal...
In Data Science, Pandas, Python, Sep 29, 2019Building a Web app using Python and Mongodb
Introduction
In Data Science, Flask, Mongodb, Python, Tutorial, Sep 25, 2019Dataframe Visualization with Pandas Plot
Visualization has always been challenging task but with the advent of dataframe plot() function it is quite easy to create decent looking plots with your dataframe, The **plot** metho...
In Data Science, Python, Tutorial, Visualization, Sep 16, 2019How to shift a column in Pandas
If you want to shift your columns without rewriting the whole dataframe or you want to subtract the column value with the previous row value or if you want to find the cumulative sum...
In Data Science, Pandas, Python, Sep 09, 2019Pandas Groupby Tutorial
Hope if you are reading this post then you know what is groupby in SQL and how it is being used to aggregate the data of the rows with the same value in one or more column. I was rece...
In Data Science, Pandas, Python, Tutorial, Sep 04, 2019Pandas Dataframe Align function
Pandas Align basically helps to align the two dataframes have the same row and/or column configuration and as per their documentation it Align two objects on their axes with the speci...
In Data Science, Pandas, Python, Aug 27, 2019Pandas Transform and Filter
In this blog we will see how to use Transform and filter on a groupby object. We all know about aggregate and apply and their usage in pandas dataframe but here we are trying to do a ...
In Data Science, Pandas, Python, Aug 22, 2019Pandas Coalesce  How to Replace NaN values in a dataframe
In this post we will discuss on how to use fillna function and how to use SQL coalesce function with Pandas, For those who doesn’t know about coalesce function, it is used to replace ...
In Data Science, Pandas, Python, Aug 17, 2019Add new rows and columns to Pandas dataframe
We often get into a situation where we want to add a new row or column to a dataframe after creating it. A quick and dirty solution which all of us have tried atleast once while worki...
In Data Science, Pandas, Python, Aug 03, 2019How to create Pandas Pivot Table and Crosstab
Pivot table lets you calculate, summarize and aggregate your data. MS Excel has this feature builtin and provides an elegant way to create the pivot table from data. its a powerful t...
In Data Science, Pandas, Python, Jul 24, 2019Pandas How to replace values based on Conditions
Using these methods either you can replace a single cell or all the values of a row and column in a dataframe based on conditions .
In Data Science, Pandas, Python, Jul 17, 2019Pandas Difference Between two Dataframes
There are often cases where we need to find out the common rows between the two dataframes or find the rows which are in one dataframe and missing from second dataframe. In this post ...
In Data Science, Pandas, Python, Jul 04, 2019Pandas how to get a cell value and update it
Accessing a single value or setting up the value of single row is sometime required when we doesn’t want to create a new Dataframe for just updating that single cell value. There are ...
In Data Science, Pandas, Python, Apr 12, 2019Pandas Map Dictionary values with Dataframe Columns
Pandas has a cool feature called Map which let you create a new column by mapping the dataframe column values with the Dictionary Key. Let’s understand this by an example:
In Data Science, Pandas, Python, Apr 06, 2019Pandas Select rows by condition and String Operations
There are instances where we have to select the rows from a Pandas dataframe by multiple conditions. Especially, when we are dealing with the text data then we may have requirements t...
In Data Science, Pandas, Python, Mar 27, 2019Pandas Rename and Reorder Columns
Pandas has two ways to rename their Dataframe columns, first using the df.rename() function and second by using df.columns, which is the list representation of all the columns in data...
In Data Science, Pandas, Python, Mar 23, 2019Text Data Visualization in Python
The best way to understand any data is by visualizing it. if I give you a table load of data and Charts then the latter is more easier way to get insight from the data. Visualization ...
In Data Science, Python, Mar 17, 2019Compare two excel files for difference using Python
Comparing two excel spreadsheets and writing difference to a new excel was always a tedious task and Long Ago, I was doing the same thing and the objective there was to compare the ro...
In Excel, Pandas, Python, Feb 26, 2019Named Entity Recognition: How to Automate Customer Support
Customer support is one of the complex and most important part of any business. This area of business stands to benefit from the machine learning as it is helping to automate and impr...
In Data Science, Pandas, Python, Feb 21, 2019How to find distance between two Points based on Latitude and Longitude using Python and SQL
if you are working with GIS or POI data then you must be dealing with lat/long values and there would be use cases to calculate the distance between two points or places by evaluating...
In Data Science, Python, Feb 14, 2019How to Tame a Python
All of those out there who claim that you can learn python in 3,6 or 9 days or 1 month are just fooling around and f** up with your mind. Get it straight you can get a gist of python ...
In Data Science, Python, Jan 30, 2019Google Takeout: How to download your personal google data
I always wondered how our life would have been if Google hadn’t been there. We depend on most of things from our personal to professional life on Google and it’s app. Not even a singl...
In Data Privacy, Data Science, Pandas, Python, Jan 20, 2019Color Columns, Rows & Cells of Pandas Dataframe
I always wanted to highlight the rows,cells and columns which contains some specific kind of data for my Data Analysis. I wanted to Know which cells contains the max value in a row or...
In Data Science, Pandas, Python, Jan 02, 2019Text Matching: Cosine Similarity
Recently I was working on a project where I have to cluster all the words which have a similar name. For a novice it looks a pretty simple job of using some Fuzzy string matching tool...
In Data Science, Python, Dec 27, 2018Read Google Spreadsheet data into Pandas Dataframe
Many a times it happens that we have our data stored on a Google drive and to analyze that data we have to export the data as csv or xlsx and store it on a disk to convert into a data...
In Data Science, google sheet, Pandas, Python, Dec 25, 2018Draw Pencil Sketches and Play with Photos
During my childhood, I was always fascinated to have my Pencil sketch and impress my school mates. However at that time it wasn’t an easy job for school goers like me to get this done...
In Python, Aug 15, 2017Get Started with Matplotlib  Data Visualization for Python
Why Visualization?
In Python, Jul 09, 2017Exploratory Analysis of H1B Visa
The H1B is a nonimmigrant visa in the United States, it is designed to bring foreign professionals with college degrees and specialized skills to fill jobs when qualified Americans ...
In Data Science, Python, May 15, 2017Learn Python for Data Science from Scratch for Beginners
Why Python?
In Data Science, Python, May 14, 2017Data Analysis of IMDB Data
[youtube https://www.youtube.com/watch?v=mS3dzczv1ZQ?version=3&rel=1&fs=1&autohide=2&showsearch=0&showinfo=1&iv_load_policy=1&start=1&wmode=transparent]
In Data Science, Python, May 14, 2017Excel
Compare two excel files for difference using Python
Comparing two excel spreadsheets and writing difference to a new excel was always a tedious task and Long Ago, I was doing the same thing and the objective there was to compare the ro...
In Excel, Pandas, Python, Feb 26, 2019How to use AI powered Query in Google Spreadsheet
Dealing with data has always been a daunting task no matter how much data geek you are. Being a Data Scientist the moment I see a new dataset the first thing which comes to my mind is...
In Data Science, Excel, google sheet, Jan 05, 2019Data Visualization with Excel  Part 1
There are abundant tool available for Data Analysis & Visualization but we all are using excel before we know what is data analytics & visualization.
In Data Science, Excel, Uncategorized, May 15, 2017Uncategorized
Hey Google! When did I ask you to access my Purchase details?
Source: Google Image
In Data Privacy, Uncategorized, Jan 01, 2019Data Visualization with Excel  Part 1
There are abundant tool available for Data Analysis & Visualization but we all are using excel before we know what is data analytics & visualization.
In Data Science, Excel, Uncategorized, May 15, 2017google sheet
How to use AI powered Query in Google Spreadsheet
Dealing with data has always been a daunting task no matter how much data geek you are. Being a Data Scientist the moment I see a new dataset the first thing which comes to my mind is...
In Data Science, Excel, google sheet, Jan 05, 2019Read Google Spreadsheet data into Pandas Dataframe
Many a times it happens that we have our data stored on a Google drive and to analyze that data we have to export the data as csv or xlsx and store it on a disk to convert into a data...
In Data Science, google sheet, Pandas, Python, Dec 25, 2018Reading Google Sheets data using Python
Google docs are one of the widely used tools across the industry and the spreadsheets are used to store lot of our data, which we would want to access anytime for data analysis or any...
In google sheet, Jul 04, 2017Pandas
Dataframe groupby date and time
In this post we will see how to group a timeseries dataframe by Year,Month, Weeks or days. Additionally, we will also see how to groupby time objects like hours
In Data Science, Pandas, Python, May 26, 2020Resample and Interpolate time series data
Resampling is a method of frequency conversion of time series data. You can use resample function to convert your data into the desired frequency.
In Data Science, Pandas, Python, Time Series Analysis, Apr 14, 2020Convert Pandas dataframe to dictionary
In my this blog we will discover what are the different ways to convert a Dataframe into a Python Dictionary or Key/Value Pair
In Pandas, Python, Mar 24, 2020How to use Pandas Count and Value_Counts
Counting number of Values in a Row or Columns is important to know the Frequency or Occurrence of your data.
In Pandas, Python, Mar 09, 2020Parallelize pandas apply using dask and swifter
Using Pandas apply function to run a method along all the rows of a dataframe is slow and if you have a huge data to apply thru a CPU intensive function then it may take several secon...
In Pandas, Python, Feb 24, 2020Sort Pandas Dataframe and Series
Sorting a dataframe by row and column values or by index is easy a task if you know how to do it using the pandas and numpy builtin functions
In Pandas, Python, Jan 28, 2020Pandas dataframe filter with Multiple conditions
Selecting or filtering rows from a dataframe can be sometime tedious if you don’t know the exact methods and how to filter rows with multiple conditions
In Pandas, Python, Jan 21, 2020How to calculate Distance in Python and Pandas using Scipy spatial and distance functions
Working with Geo data is really fun and exciting especially when you clean up all the data and loaded it to a dataframe or to an array. The real works starts when you have to find dis...
In Data Science, Pandas, Python, Scipy, Dec 27, 2019How to work with JSON in Pandas
JSON is widely used format for storing the data and exchanging. Many of the API’s response are JSON and being light weight it’s used almost everywhere
In Data Science, Pandas, Python, Dec 12, 2019Pandas apply, map and applymap
In this post we will see how to apply a function along the axis of a dataframe using apply and applymap and how to map the values of a Series from one domain to another using map
In Data Science, Pandas, Python, Nov 25, 2019How to create dataframe for testing?
Did you ever wanted to create dataframes for testing and find it hard to fill the dataframe with dummy values then DO NOT Worry there are functions that are not mentioned in the offic...
In Data Science, Pandas, Python, Nov 18, 2019How to remove duplicate data from python dataframe
Not all data are perfect and we really need to get duplicate data removed from our dataset most of the time. it looks easy to clean up the duplicate data but in reality it isn’t. Some...
In Data Science, Pandas, Python, Oct 25, 2019Working with Pandas datetime
In this post we will explore the Pandas datetime methods which can be used instantaneously to work with datetime in Pandas.
In Data Science, Pandas, Python, Tutorial, Oct 09, 2019How to find Percentage Change in pandas
So you are interested to find the percentage change in your data. Well it is a way to express the change in a variable over the period of time and it is heavily used when you are anal...
In Data Science, Pandas, Python, Sep 29, 2019How to shift a column in Pandas
If you want to shift your columns without rewriting the whole dataframe or you want to subtract the column value with the previous row value or if you want to find the cumulative sum...
In Data Science, Pandas, Python, Sep 09, 2019Pandas Groupby Tutorial
Hope if you are reading this post then you know what is groupby in SQL and how it is being used to aggregate the data of the rows with the same value in one or more column. I was rece...
In Data Science, Pandas, Python, Tutorial, Sep 04, 2019Pandas Dataframe Align function
Pandas Align basically helps to align the two dataframes have the same row and/or column configuration and as per their documentation it Align two objects on their axes with the speci...
In Data Science, Pandas, Python, Aug 27, 2019Pandas Transform and Filter
In this blog we will see how to use Transform and filter on a groupby object. We all know about aggregate and apply and their usage in pandas dataframe but here we are trying to do a ...
In Data Science, Pandas, Python, Aug 22, 2019Pandas Coalesce  How to Replace NaN values in a dataframe
In this post we will discuss on how to use fillna function and how to use SQL coalesce function with Pandas, For those who doesn’t know about coalesce function, it is used to replace ...
In Data Science, Pandas, Python, Aug 17, 2019Add new rows and columns to Pandas dataframe
We often get into a situation where we want to add a new row or column to a dataframe after creating it. A quick and dirty solution which all of us have tried atleast once while worki...
In Data Science, Pandas, Python, Aug 03, 2019How to create Pandas Pivot Table and Crosstab
Pivot table lets you calculate, summarize and aggregate your data. MS Excel has this feature builtin and provides an elegant way to create the pivot table from data. its a powerful t...
In Data Science, Pandas, Python, Jul 24, 2019Pandas How to replace values based on Conditions
Using these methods either you can replace a single cell or all the values of a row and column in a dataframe based on conditions .
In Data Science, Pandas, Python, Jul 17, 2019Pandas Difference Between two Dataframes
There are often cases where we need to find out the common rows between the two dataframes or find the rows which are in one dataframe and missing from second dataframe. In this post ...
In Data Science, Pandas, Python, Jul 04, 2019Pandas how to get a cell value and update it
Accessing a single value or setting up the value of single row is sometime required when we doesn’t want to create a new Dataframe for just updating that single cell value. There are ...
In Data Science, Pandas, Python, Apr 12, 2019Pandas Map Dictionary values with Dataframe Columns
Pandas has a cool feature called Map which let you create a new column by mapping the dataframe column values with the Dictionary Key. Let’s understand this by an example:
In Data Science, Pandas, Python, Apr 06, 2019Pandas Select rows by condition and String Operations
There are instances where we have to select the rows from a Pandas dataframe by multiple conditions. Especially, when we are dealing with the text data then we may have requirements t...
In Data Science, Pandas, Python, Mar 27, 2019Pandas Rename and Reorder Columns
Pandas has two ways to rename their Dataframe columns, first using the df.rename() function and second by using df.columns, which is the list representation of all the columns in data...
In Data Science, Pandas, Python, Mar 23, 2019Compare two excel files for difference using Python
Comparing two excel spreadsheets and writing difference to a new excel was always a tedious task and Long Ago, I was doing the same thing and the objective there was to compare the ro...
In Excel, Pandas, Python, Feb 26, 2019Named Entity Recognition: How to Automate Customer Support
Customer support is one of the complex and most important part of any business. This area of business stands to benefit from the machine learning as it is helping to automate and impr...
In Data Science, Pandas, Python, Feb 21, 2019Google Takeout: How to download your personal google data
I always wondered how our life would have been if Google hadn’t been there. We depend on most of things from our personal to professional life on Google and it’s app. Not even a singl...
In Data Privacy, Data Science, Pandas, Python, Jan 20, 2019Color Columns, Rows & Cells of Pandas Dataframe
I always wanted to highlight the rows,cells and columns which contains some specific kind of data for my Data Analysis. I wanted to Know which cells contains the max value in a row or...
In Data Science, Pandas, Python, Jan 02, 2019Read Google Spreadsheet data into Pandas Dataframe
Many a times it happens that we have our data stored on a Google drive and to analyze that data we have to export the data as csv or xlsx and store it on a disk to convert into a data...
In Data Science, google sheet, Pandas, Python, Dec 25, 2018Data Privacy
Google Takeout: How to download your personal google data
I always wondered how our life would have been if Google hadn’t been there. We depend on most of things from our personal to professional life on Google and it’s app. Not even a singl...
In Data Privacy, Data Science, Pandas, Python, Jan 20, 2019Hey Google! When did I ask you to access my Purchase details?
Source: Google Image
In Data Privacy, Uncategorized, Jan 01, 2019Tutorial
How to create interactive data visualization using plotly
Visualization is the graphical representation of your data and it let you paint your data into a canvas in a way you want to see it. There are lot of amazing libraries and tools avail...
In Data Science, Python, Tutorial, Dec 31, 2019How to use Regex in Pandas
There are several pandas methods which accept the regex in pandas to find the pattern in a String within a Series or Dataframe object. These methods works on the same line as Pythons ...
In Data Science, Python, Tutorial, Nov 12, 2019Working with Pandas datetime
In this post we will explore the Pandas datetime methods which can be used instantaneously to work with datetime in Pandas.
In Data Science, Pandas, Python, Tutorial, Oct 09, 2019Building a Web app using Python and Mongodb
Introduction
In Data Science, Flask, Mongodb, Python, Tutorial, Sep 25, 2019Dataframe Visualization with Pandas Plot
Visualization has always been challenging task but with the advent of dataframe plot() function it is quite easy to create decent looking plots with your dataframe, The **plot** metho...
In Data Science, Python, Tutorial, Visualization, Sep 16, 2019Pandas Groupby Tutorial
Hope if you are reading this post then you know what is groupby in SQL and how it is being used to aggregate the data of the rows with the same value in one or more column. I was rece...
In Data Science, Pandas, Python, Tutorial, Sep 04, 2019Visualization
Dataframe Visualization with Pandas Plot
Visualization has always been challenging task but with the advent of dataframe plot() function it is quite easy to create decent looking plots with your dataframe, The **plot** metho...
In Data Science, Python, Tutorial, Visualization, Sep 16, 2019Flask
Python API Documentation using Flask and Swagger
What is Swagger?
In Python, Swagger, Flask, Jul 18, 2020Building a Web app using Python and Mongodb
Introduction
In Data Science, Flask, Mongodb, Python, Tutorial, Sep 25, 2019Mongodb
Building a Web app using Python and Mongodb
Introduction
In Data Science, Flask, Mongodb, Python, Tutorial, Sep 25, 2019Scipy
How to calculate Distance in Python and Pandas using Scipy spatial and distance functions
Working with Geo data is really fun and exciting especially when you clean up all the data and loaded it to a dataframe or to an array. The real works starts when you have to find dis...
In Data Science, Pandas, Python, Scipy, Dec 27, 2019numpy
Index a Numpy Array by another Array
In this post we will see different ways to Index a Numpy array using another array of index
In numpy, Jul 05, 2020Compare two Numpy arrays for equality
In this post we will compare elements of two arrays for equality. This would be really helpful when you wanted to compare if two similar arrays coming out through two different proces...
In numpy, Python, Jun 22, 2020How to split Numpy Arrays
In this post we will see how to split a 2D numpy array using split, array_split , hsplit, vsplit and dsplit.
In numpy, Python, Jun 11, 2020Find K smallest and largest values and its indices in a numpy array
To find the maximum and minimum value in an array you can use numpy argmax and argmin function
In numpy, Python, Jan 14, 2020Concatenating arrays in Numpy
We will be discussing about merging numpy arrays and different functions that are available in the toolbox to perform this job
In numpy, Python, Jan 10, 2020Reshaping numpy arrays in python
Reshape is an important feature which lets you to change the shape of your array without changing its data
In Data Science, numpy, Python, Jan 06, 2020Time Series Analysis
Time Series Analysis and Forecasting with ARIMA
In the previous post we have seen how to visualize a time series data. In this post we will discuss how to do a time series modelling using ARMA and ARIMA models. Here AR stands for A...
In Python, Data Science, Time Series Analysis, Apr 30, 2020Time Series Data Visualization
Visualizing Time Series data with Python
In Python, Data Science, Time Series Analysis, Apr 27, 2020Resample and Interpolate time series data
Resampling is a method of frequency conversion of time series data. You can use resample function to convert your data into the desired frequency.
In Data Science, Pandas, Python, Time Series Analysis, Apr 14, 2020scikitlearn
Sklearn data PreProcessing using Standard and Minmax scaler
In Machine learning the variables that are measured at different scales can impact the numerical stability and precision of the estimators
In scikitlearn, Jun 01, 2020Decision Tree in Sklearn
In this post we are going to see how to build a basic decision tree classifier using scikitlearn package and how to use it for doing multiclass classification on a dataset.
In Python, Data Science, scikitlearn, May 13, 2020streamlit
Create Interactive Dashboard in Python using Streamlit
Dashboard gives a graphical interface to visualize the key indicators and trends of your data. However, Creating Dashboard is always been a tedious task for developers
In Python, streamlit, Jul 04, 2020Swagger
Python API Documentation using Flask and Swagger
What is Swagger?
In Python, Swagger, Flask, Jul 18, 2020Tensors
Vectors, Matrix And Tensors
In this post we will see how large data is stored in multidimensional arrays, which is also called as tensors.
In Python, Tensors, Aug 01, 2020NearestNeighbor
Find nearest neighbor using KD Tree
KD Tree is a modified Binary Search Tree(BST) that can perform search in multidimensions and that’s why Kdimensional.
In Python, NearestNeighbor, Algorithm, Aug 05, 2020Algorithm
Find nearest neighbor using KD Tree
KD Tree is a modified Binary Search Tree(BST) that can perform search in multidimensions and that’s why Kdimensional.
In Python, NearestNeighbor, Algorithm, Aug 05, 2020Matplotlib
Show images in grid inside jupyter notebook using matplotlib and numpy
In this post, we will see how to display the images in a grid using matplotlib imshow and Image grid. Alternatively, we will see the visualization of image blocks and show it in a gri...
In Python, Matplotlib, Numpy, May 11, 2021matplotlib fill color between vertical, horizontal lines and polygon
In this post, we will learn how to fill color in the matplotlib charts between two vertical or Horizaontal lines and also inside the Polygons
In Python, Matplotlib, Mar 02, 2021Matplotlib Scatter Plot Color by Category in Python
Scatter plot are useful to analyze the data typically along two axis for a set of data. It shows the relationship between two sets of data
In Python, Matplotlib, Aug 30, 2020Numpy
Show images in grid inside jupyter notebook using matplotlib and numpy
In this post, we will see how to display the images in a grid using matplotlib imshow and Image grid. Alternatively, we will see the visualization of image blocks and show it in a gri...
In Python, Matplotlib, Numpy, May 11, 2021Featured

Decision Tree in Sklearn
In DataScience, DecisionTree, Python, scikitlearn, featured, 
Time Series Analysis and Forecasting with ARIMA
In DataScience, Python, Time Series, featured, 
Time Series Data Visualization
In DataScience, Python, Time Series, featured, 
How to Remove Outliers in Python
In Python, Scipy, featured, 
How to calculate Distance in Python and Pandas using Scipy spatial and distance functions
In DataScience, haversine, numpy, Pandas, Python, Scipy, vectorization, featured, 
Dataframe Visualization with Pandas Plot
In Data Visualization, DataScience, Matplotlib, Pandas, Pandas Plot, Python, featured,