Sick Gaming
[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)

[Image: 1f4ac.png] Question: How to convert an .avro file to a .csv file in Python?

Solution:

To convert an Avro file
Code:
my_file.avro
to a CSV file
Code:
my_file.csv
, create a CSV writer using the
Code:
csv
module and iterate over all rows using the iterator returned by
Code:
fastavro.reader()
. Then write each row to a file using the
Code:
writerow()
function.

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.

[Image: 1f4a1.png] Avro is a data serialization framework for RPCs (remote procedure calls) that uses JSON and binary format to serialize data.

[Image: 1f4a1.png] 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
.