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 the distance between their lat/long. There are so many apps out there which uses this information to show what are the…
Python 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 it needs to solve complex computational problems and emphasizes productivity and readability. However many complains that it’s slow and doesn’t perform very…
Learn 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 store data. It is the language for data querying. You might do some manipulation or more complicated work in a…
How 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 3 hours but you cannot be a data scientist with your this knowledge on…
Thank You Google!! For Sharing my 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 single day goes by without accessing any of these Google apps. Our life is partially dependent on Google. My Mom always…
Pandas Exploratory Data Analysis: Data Profiling with one single command
We cannot see all the details through a large dataset and its important to go for a Exploratory data analysis. As a Data Scientist you would be always curious to know for a new data set what are the missing values in a column? How are the features co-related? What is the max, min or…
How to merge multiple csv files and upload to MySQL or PostgresSQL using Python
Often we encounter this challenge to deal with multiple csv files and we start looking out for options to import these files to MySQL or PostgresSQL Databases. For many of us this possess a challenge because we don’t know a good tool or a way to merge these csv files into one and import it…
How to Optimize your Pandas Code
Working with large dataset has always been a challenging and daunting task. The data is growing everyday but the resources and computational power required to process this big data is limited. In last few year we have seen Pandas growing popularity within the data science fraternity and it is one of the widely used python…
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 OMG! How would I clean or explore this data? Can I ever do a EDA(Exploratory Data Analysis) on…
Color 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 highlight all the nan’s in my data. and Pandas has a feature which is still development in progress as per the…