Background 💡 A dBase database file (DBF) is a database file format with the .dbf file extension used by various applications and database systems. 💡 A comma-separated values (CSV) file is a text file that uses a comma to separate fields of a data record (=line). Problem Formulation Given a .dbf file my_db.dbf. How to … Read more
To convert a Pandas DataFrame into a CSV string rather than a CSV file, just use the pd.to_csv() function without any filename or path argument. The function returns a CSV string you can use for further processing in your Python script. Here’s an example: You can modify this output by passing the index=False argument: Now, … Read more
To export/convert a Pandas DataFrame to a CSV file, use the Pandas method to_csv(). Set the index=False argument if you don’t want the first column to be the index number in the CSV, which is usually the case. Let’s dive into a simple two-step example on how to convert a DataFrame to a CSV easily … Read more
To convert a compressed CSV file (.csv.gz) to a CSV file (.csv) and read it in your Python shell, use the gzip.open(filename, ‘rt’, newline=”) function call to open the gzipped file, the file.read() function to read its contents, and the file.write() function to write the CSV in a normal (unzipped) file. The gzip.open() function has … Read more
Problem: How to convert a list of dictionaries to a csv file? Example: Given is a list of dicts—for example salary data of employees in a given company: Your goal is to write the content of the list of dicts into a comma-separated-values (CSV) file format. Your out file should look like this: my_file.csv: Name,Job,Salary … Read more
Step 1: Install csv-ical Module with PIP Run the following command in your command line or PowerShell (Windows) or shell or terminal (macOS, Linux, Ubuntu) to install the csv-ical library: In some instances, you need to modify this command a bit to make it work. If you need more assistance installing the library, check out … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to sort words alphabetically in Python. To make it more fun, we have the following running scenario: Some English sayings, also known as Tongue-Twisters, are fun to try and say quickly. They are also used to improve non-English speaking individuals and small children’s fluency … Read more
This article concerns the conversion and handling of CSV file formats in combination with the UTF-8 encoding standard. 💡 The Unicode Transformation Format 8-Bit (UTF-8) is a variable-width character encoding used for electronic communication. UTF-8 can encode more than 1 million (more or less weird) characters using 1 to 4 byte code units. Example UTF-8 … Read more
If you get a binary input of tabular structured data, you can convert it to CSV easily by using str(byte)[2:-1] slicing to get rid of the b’…’ byte wrapper and apply string.replace(‘\t’, ‘,’) on the result to replace tabular characters with commas. Problem Formulation For example, say you have the following bytes format in your … Read more
To read a binary file, use the open(‘rb’) function within a context manager (with keyword) and read its content into a string variable using f.readlines(). You can then convert the string to a CSV using various approaches such as the csv module. Here’s an example to read the binary file ‘my_file.man’ into your Python script: … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to convert Epoch Time to a Date Time representation using Python. On January 1st, 1970, Epoch Time, aka Time 0 for UNIX systems, started as a date in history to remember. This date is relevant, not only due to this event but because it … Read more
Python __version__ Attribute Python contains many “Magic Methods/Attributes”. One of these is __version__ commonly called “Dunder version” because of the double underscore before and after version. In this article, I will briefly look at what a Dunder Method/Attribute is and talk about __version__. What Does a Dunder Method/Attribute Do? Dunder Methods/Attributes, also called “Magic Methods” … Read more