![]() |
|
[Tut] How to Convert Avro to CSV in Python? - Printable Version +- Sick Gaming (https://sickgaming.net) +-- Forum: Programming (https://sickgaming.net/forum-76.html) +--- Forum: Python (https://sickgaming.net/forum-83.html) +--- Thread: [Tut] How to Convert Avro to CSV in Python? (/thread-99770.html) |
[Tut] How to Convert Avro to CSV in Python? - xSicKxBot - 08-04-2022 How to Convert Avro to CSV in Python? 4/5 – (1 vote) Question: How to convert an .avro file to a .csv file in Python?Solution: To convert an Avro file Code: my_file.avroCode: my_file.csvCode: csvCode: fastavro.reader()Code: writerow()Here’s an example: Code: from fastavro import reader
import csv with open('my_file.avro', 'rb') as file_object: csv_file = csv.writer(open("my_file.csv", "w+")) head = True for x in reader(file_object): if head: # write header header = emp.keys() csv_file.writerow(header) head = False # write normal row csv_file.writerow(emp.values())Related: This code is a modified and improved version of this source. Avro is a data serialization framework for RPCs (remote procedure calls) that uses JSON and binary format to serialize data. CSV stands for comma-separated values, so you have a row-based file format where values are separated by commas, and the file is named using the suffix Code: .csv |