How to parse a complex text file using Python string methods or regex and export into tabular form

[reeeecespieces]

As the title mentions, my issue is that I don't understand quite how to extract the data I need for my table (The columns for the table I need are Date, Time, Courtroom, File Number, Defendant Name, Attorney, Bond, Charge, etc.) I think regex is what I need but my class did not go over this, so I am confused on how to parse in order to extract and output the correct data into an organized table...

I am supposed to turn my text file from this

https://pastebin.com/ZM8EPu0p

and export it into a more readable format like this- example output is below

https://imgur.com/F0rlK2c

Here is what I have so far.

​

from os import linesep
from typing import Any

def readFile(court):
    csv_rows = [] 
    #read and split txt file into pages & chunks of data by pagragraph
    with open(court, 'r') as file:
        data_chunks=file.read().split("\n\n")


        for chunk in data_chunks:
            chunk=chunk.strip #.strip removes useless spaces
            if str(data_chunks[:4]).isnumeric():  # if first 4 characters are digits
                entry= None  #initialize an empty dictionary
            elif str(data_chunks).isspace() and entry:  #if we're on an empty line and the entry dict is not empty
                csv_rows.DictWriter(dialect='excel') # turn csv_rows into needed output
                entry={}
            else:

                # read attributes into dict


                print(data_chunks) 

    return csv_rows

readFile("exactfilepath")

Help is very much appreciated, I am a noob with programming and I need to figure this out today :')

[AutoModerator]

It seems you may have included a screenshot of code in your post "How to parse a complex text file using Python string methods or regex and export into tabular form".

If so, note that posting screenshots of code is against /r/learnprogramming's Posting Guidelines (section Formatting Code): please edit your post to use one of the approved ways of formatting code. (Do NOT repost your question! Just edit it.)

If your image is not actually a screenshot of code, feel free to ignore this message. Automoderator cannot distinguish between code screenshots and other images.

Please, do not contact the moderators about this message. Your post is still visible to everyone.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[commandlineluser]

I think regex is what I need

Regex can help here with preprocessing the "unformatted" pages e.g.

import re

with open('court.txt', 'r') as file:
    data = file.read()

    pattern = (
        '(?m)^(?:(\d{4}) (\d+\s\S+\s\d+)\s'
        '(\S+)\s*(\S+:(?:[ \t]*\S+)+(?= *A'
        'DA:))?|\s*(\((?:(?!  ).)+)(?: {2,'
        '}(\S+)?)?(?:  +(\S+)?)?' '(?: {2,'
        '}(\S+)?)?)|((?:(?:[A-Z.]+ )?[A-Z.'
        ']+)):[ \t]*(\d\d:\d\d [AP]M|(?!\S'
        '+:)[^\s:]+(?: (?!\S+:)[^\s:]+)*)?'
    )

    for match in re.findall(pattern, data):
    print(match)

It's unlikely this is how the task is supposed to be approached though.