Pandas NameError is frustrating. This error happens because your python script cannot find the name ‘pandas’ in your namespace. This means you have either imported pandas under a different name or not at all. How…
Browsing Category Pandas
Category for all things to learn Pandas
Pandas Query Data With Categorical Variables
Pandas Query is a great way to filter your data. But what if you have categorical variables. In this case, you’re gonna want to treat them a bit differently. The important part to remember is…
User Retention – How To Manually Calculate
Calculating user retention is done via many tools today. This feature is usually out of the box with any analytics or Business intelligence tool. However! if you want to truly understand retention, what better way…
KeyError Pandas – How To Fix
Pandas KeyError is frustrating. This error happens because Pandas cannot find what you’re looking for. To fix this either: Preferred Option: Make sure that your column label (or row label) is in your dataframe! Error…
Multiply Columns To Make New Column Pandas
Community request time! Thanks to Leonah for the tutorial request about how to multiply columns in pandas Multiplying columns together is a foundational skill in Pandas and a great one to master. Good thing it…
Pandas Rank – Rank Your Data – pd.df.rank()
Pandas Rank will compute the rank of your data point within a larger dataset. It is extremely useful for filtering the ‘first’ or 2nd of of a sub dataset. We will look at two methods…
Pandas Diff – Difference Your Data – pd.df.diff()
Pandas Diff will difference your data. This means calculating the change in your row(s)/column(s) over a set number of periods. Or simply, pandas diff will subtract 1 cell value from another cell value within the…
Pandas Merge – Join Data – pd.DataFrame.merge()
Pandas Merge is another Top 10 Pandas function you must know. Simply, if you have two datasets that are related together, how do you bring them together? Pandas Merge will join two DataFrames together resulting…
Selecting Data – Pandas loc & iloc[] – The Guide
When it comes to selecting data on your DataFrame, Pandas loc and iloc are two top favorites. They are quick, fast, and easy to read when reviewing code later. Pandas loc will select data based…
Pandas Group By Guide – 3 Methods
Pandas Group By, the foundation of any data analysis. This is a MUST know function when working with the pandas library. 95% of analysis will require some form of grouping and aggregating data. This post…