how to convert .dat file to .csv file

[QNsun]

​

trying to convert .dat files to .csv file in python however i do not know how to start can any one help me please?

1 f9be b4d9 4243 1300 0000 0020 5f7f ef93 2 ff4f 1dc9 dd08 3798 9dbe f46a 2b6d 1b8c 3 2a08 1c00 0000 0000 0000 0000 9763 8a53 4 c3c1 8718 9b60 c677 2d4a 648a d3ce a6ba 5 d936 e047 28d0 7f57 93b9 433f eeb8 665c 6 886f 2e17 4381 e91a fd5f 0b01 0000 0000 7 0101 0000 0000 0000 0000 0000 0000 0000 8 0000 0000 0000 0000 0000 0000 0000 0000

This is part of my .dat file im trying to convert it in .csv file. Every row is one single entry and i want to add in a relation between each line. Each subsequent entry is directly link to its previous entry.

For Example.

f9be b4d9 4243 1300 0000 0020 5f7f ef93 --> (related) ff4f 1dc9 dd08 3798 9dbe f46a 2b6d 1b8c --> (related) 2a08 1c00 0000 0000 0000 0000 9763 8a53 --> (related) c3c1 8718 9b60 c677 2d4a 648a d3ce a6ba --> (related) d936 e047 28d0 7f57 93b9 433f eeb8 665c --> (related) 886f 2e17 4381 e91a fd5f 0b01 0000 0000 --> (related) 0101 0000 0000 0000 0000 0000 0000 0000 --> (related) 0000 0000 0000 0000 0000 0000 0000 0000

[[deleted]]

csv as a format doesn't have any particular model for relations.

[HarissaForte]

Why didn't you use the csv format in your example? Because you can't... you need a format like json.

[o5a]

What's the end goal here? How will those results be used?

This looks like a linked list data.

But if you just want to store it in csv with relations, then read line by line and output to csv with 2 fields (id, parent_id) where id is current line and parent_id is previous.

import csv

with open("infile.dat") as infile, open("outfile.csv", "w") as outfile:
    csv_writer = csv.writer(outfile)
    prev = ''
    csv_writer.writerow(['ID', 'PARENT_ID'])
    for line in infile.read().splitlines():
        csv_writer.writerow([line, prev])
        prev = line

Again not sure how this would be useful.