Gili Here’s a question from our reader Bobbi: When working for my previous employer, we had an hybrid work setup which meant that some of our group meetings were conducted in the office and some offline. I just switch to a new, remote only employer who uses Outlook Calendar and Microsoft Teams. The thing is that … Read more
The reason for the type error can’t concatenate string to a byte object, when you try to bring together a Python string and a Python byte objects. You can solve this issue by either encoding your string or decoding your bytes objects and only then concatenate them. Understanding the can’t concat str error message Assume … Read more
In a nutshell, Python 3 will throw a TypeError exception when you try to encode a string without specifically specifying the encoding format (Windows -1255, UTF-8, UTF-16 and so forth). Reproducing the typeerror exception You have a Python string which you have read from a file, Pandas series or dataframe, Web API or a database … Read more
Here’s a question from Randy: “I have a pretty long Google Sheets worksheet and need to be able to search for specific words in one of the columns. Seems that Sheets has somewhat different functions than Excel to find text in cells. Can you provide a simple example of how would you go about solving … 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
Sometimes during our data analysis process, we might need to quickly generate or modify data stored as txt files. In this tutorial we will learn how to programmatically create text files in your file system and append text to them using the R language. Create a text file We can use the file.create() method to … 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
In this tutorial we will learn how to subset an R DataFrame (or tibble) by multiple conditions. The simplest way to do this is to use the tidyverse package and its core component dplyr. Create an R Example DataFrame Let’s first import the tidyverse package into RStudio and create a simple R DataFrame that we … 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