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
This article will give you an overview of the blockchain basics, transactions, and blocks. In the previous article of this series, we looked at how to create your own token using Solidity and, specifically, events for transactions. Blockchain Basics Blockchain technology enables us to write programs without having to think about the details of the … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to update and replace text in a file using Python. To make it more fun, we have the following running scenario: Tristen, a columnist with the Toronto Star, is writing a column about Niagara Falls. He has noticed a few issue(s) with his writing. … Read more
To convert a Microsoft Acces table (.accdb) to a CSV file in Python, use the following four steps: Establish database connection, Run the SQL query to select data, Store the data in the CSV using basic Python file I/O and the csv module, and Close the database connection. Here’s a specific example with additional annotations … Read more
You can merge multiple text files to a single CSV file in Python by using the glob.glob(‘./*.txt’) expression to filter out all path names of text files in a given folder. Then iterate over all those path names and use the open() function to read the file contents and write append them to the CSV. … Read more
You can convert a text file to a CSV file in Python in four simple steps: (1) Install the Pandas library, (2) import the Pandas library, (3) read the CSV file as DataFrame, and (4) write the DataFrame to the file: (Optional in shell) pip install pandas import pandas as pd df = pd.read_csv(‘my_file.txt’) df.to_csv(‘my_file.csv’, … Read more
💬 Question: How to convert an .avro file to a .csv file in Python? Solution: To convert an Avro file my_file.avro to a CSV file my_file.csv, create a CSV writer using the csv module and iterate over all rows using the iterator returned by fastavro.reader(). Then write each row to a file using the writerow() … Read more
for i j in python The Python expression for i, j in XXX allows you to iterate over an iterable XXX of pairs of values. For example, to iterate over a list of tuples, this expression captures both tuple values in the loop variables i and j at once in each iteration. Here’s an example: … Read more
As you know, Web3 is a new online era that differs from Web2 in its foundational technology, the blockchain. Blockchain is a disruptive technology characterized by being a decentralized solution for communication and transactions. Decentralization means that there are no controlled databases by third-party service providers. These providers can own and hold your accounts or … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to extract specific columns or a sub-set thereof from a NumPy array in Python. Often, a sub-set of data needs to be extracted from a larger dataset. This sub-set could be a pre-determined number of column(s) or row(s). These examples show you how to … Read more