To aggregate data in an R dataFrame you can use the code below: Aggregating R data by multiple categorical variables Step 1: Install dplyr package If the dplyr package is not yet installed in your environment make sure to install it using the following command: Alternatively consider installing tidyverse, which is a mega library of … Read more
This error occurs when you try to call the string formatter function strftime() on a pandas Series. To fix the error use the Series dt accessor and only then call the strftime method. Here is an example: Reproducing the error Let’s start by defining a very simple pandas DataFrame to show how to reproduce the … Read more
In this tutorial we will learn how to solve attribute errors related to the Pandas DataFrame object. Why do we get DataFrame attributeerror exceptions? Pandas raises the attribute error exception when we try to invoke a method or property that doesn’t exist for a DataFrame. Example # 1: Calling wrong DataFrame methods Here’s a simple … Read more
Create Example Data We will start by creating a very simple DataFrame that you can use in order to followi along this detailed example. This snippet will return the following DataFrame – note that the duration column type is timedelta[ns64]. participant duration 0 Joe 0 days 02:15:15 1 Eric 0 days 02:45:10 2 Aaron 0 … Read more
Solving Keyerror exceptions in pandas Most probably the reason you are getting a KeyError exception when working with a pandas DataFrame is that you have a typo in a column or row label name. When in doubt, make sure to check the correct column name using the following commands below: Define an Example DataFrame Let’s … Read more
TL; DR: Fix the no module named pytorch exception You will get a modulenotfounderror exception when trying to invoke one of the pytorch modules before you have installed the torch package in your Python development environment. You can use the Anaconda prompt to invoke conda; or alternatively invoke the Python Package installer (pip) to install … Read more
In this short tutorial we’ll learn how to troubleshoot issues related one of the most basic tasks when wrangling pandas DataFrames: removing columns off your DataFrame. Can’t drop pandas columns Let’s assume that you are working with the following DataFrame: This will return the following data set: month office salary 0 November Osaka 134.0 1 … Read more
Cannot reindex DataFrame with duplicated axis Let’s start by writing some simple Python coder to define a pandas DataFrame. In reality, most probably you will be acquiring your data from an external file, database or API. We will get the following data set: time team revenue 0 01-02-23 North 109.0 1 [01-02-23, 01-02-24] South 201.0 … Read more
Reproducing the Value Error cannot reshape in Pandas Let’s assume that we have the following Python code that creates a very small DataFrame: Let’s look at our data: month office salary 0 Jan Los Angeles 98 1 Jan Los Angeles 92 2 Feb New York 87 3 Mar New York 92 To reproduce the error … Read more
Plot string data in x axis in Python Assume that we have the following two Python lists: We would like to create a chart based on the string data in the team list. We will use the matplotlib library to render our chart. The team list will be plotted in the x axis and the … Read more