In today’s short tutorial we’ll help you troubleshoot a type error that you might receive when trying to multiply a sequence (strings, lists or tuples) by a float number in Python. Can’t multiple sequence by float error Let’s run the following code: After entering the product price, as expected, we’ll get the following error: Fixing … Read more
In this short tutorial we’ll learn how to troubleshoot the the Unexpected EOF while parsing error that we might encounter from time to time in our Python programs. The meaning of this error is that the Python interpreter runs through the end of your Python file but can’t find the end of an open code … Read more
In today’s Python automation tutorial we would like to show how you can easily subtract and calculate time differences using the Python language. We’ll use the datetime module to calculate: Difference between two dates Difference between a date and a timedelta object. Subtracting other timedeltas from date objects : years, months, hours, minutes, seconds. Subtract … Read more
This tutorial explains how to use Python 3 to write data line by line into a comma separated value file. We’ll look into several examples: Using the csv module. Using the Pandas Data Analysis library Write text using the CSV module In the first example we’ll use the Python csv library to define a writer … Read more
In today’s tutorial we’ll learn how to round values in Pandas DataFrame columns. We’ll look into several cases: Round float values to the nearest 2 decimals Round float values to nearest 10 / 100 Rounding a Series Persisting changes after rounding up Example DataFrame Let’s get starting by creating a sample DataFrame that you can … Read more
Our task for today will be to read the content of a text or csv file into a list. Each list item should contain one line of text. Read a text file contents to a list We’ll first define the file system path to the file we would like to read, then open it in … Read more
You have one or multiple files (in either text or comma separated values (csv) format. You would like to use a simple Python snippet in order to programmatically append text into your file/s. Add text to a file in Python example In our first example, we’ll show how you can easily open an existing file … Read more
There are instances in which you might need to divide Python lists into smaller chunks for simpler processing or just to focus your data analysis work on relevant data. A very prevalent case for this is when working with csv (Comma Separated Values) files. In today’s short Python programming tutorial we will learn how to … Read more
In this post we’ll learn to troubleshoot errors you might encounter when starting to use the Amazon Web Services s3transfer library in your Python development environment. You will typically bump into import errors, when trying to use a 3rd party add-ons which is not part of the built-in Python standard library in your program. This … Read more
In today’s data analysis tutorial we’ll learn how to sum across rows in Pandas DataFrame columns and add a total summary row. Create Example Data We will start by creating some sample data based on a fictitious human resources dataset. Adding a Total Row to the DataFrame We can use the sum() DataFrame method to … Read more