One of the easiest ways, to compare this is using the lag function. The lag function will allow you to shift the rows downward so that you can view these rows as one observational row. Here is a simple example of how to use the lag function to shift rows downward. You can Practice FANG […]
I thought this might be helpful. I have been working in data. I get a lot of DMs on LinkedIn on what makes a good data analyst CV. I’ve hired about 30 analyst in my career and interviewed a many. Here are the things I think really work and get the attention of HR, CV […]
As of the time of writing this post, there is no native connector in Power BI for Google Trends API to pull data directly a report. However, we can easily do this with just a few lines of Python code. This will allow you to bring in multiple keywords to compare trends over time. We […]
Excel has a lot of great functions and shortcuts that will make data cleaning and manipulation easier. Not knowing these techniques will add frustration and a lot of time to your current workload and analysis. You can follow the instructions below to figure out how to fill blank cells with previous cell values. Check out […]
Data analysis is among the most in-demand skills in 2021. It is a field with many facets – from working with raw data to uncover actionable insights to knowing how to showcase these in a way that’s easy to consume, data analysis can help any project – big or small.As someone who has worked in […]
Let’s talk about how to do some bi-variate analysis using the Crosstab function from pandas. The Crosstab function is very flexible and allows us to compare two categories. As usual, we’ll work on this practically using a sample dataset. We’re going to analyze a BankChurn dataset to see when our customers left and the different categories […]
Grouping data is one of the most important skills that you would require as a data analyst. Luckily, Pandas has a great function called GroupBy which is extremely flexible and allows you to answer many questions with just one line of code. In this tutorial, we’re going to understand the GroupBy function and subsequently answer […]
One of the key steps in NLP or Natural Language Process is the ability to count the frequency of the terms used in a text document or table. To achieve this we must tokenize the words so that they represent individual objects that can be counted. There are a great set of libraries that you […]
Honestly, knowing Python and knowing how to answer interview questions with Python can be two separate skills. I have bombed interviews due to not explaining my thought process when approaching a problem. Often interviewers are not concerned that you arrive at a perfect answer in the limited time that you are given. They put more […]
One of the best things about Python is the sheer number of libraries that can easily be used. You can create correlation tables and statistic summary tables similar to what you find in the data analysis tool kit or in the Pandas library in Python with the native functions. How to create a correlation table:1. […]