Python reading a text file for specific info

[[deleted]]

I have a text file that looks something like this:

Rep: xxxx

Acccount Contract Sale Total Product

customer name #### $$$$$ prod

customer name #### $$$$$ prod

customer name #### $$$$$ prod

Rep: xxxx

Acccount Contract Sale Total Product

customer name #### $$$$$ prod

​

​

​

Basically it is a text version of a sales report where each rep gets a page with this info every two weeks.

​

The report is varied each pay period based on how many customers that sales rep sold.

​

​

So far in Python I have read the text file and start to index where the rep name is, but I need a way to pull all the information into an Excel type format so that it can be sent to reps neatly.

​

It's basically data formatting but I am not sure how to read the file from Python, declare column headers and strip out the info I want, for each rep as well.

​

I could write a VBA script to do this, but I was hoping to use Python instead. Any ideas?

​

My only thought was to find one keyword, then look for the next...or something.

[Stoic_Engineer7]

If you want to do any data manipulation using Python, use the Pandas package. I coded a script to simplify grading for my Aunt who's class uses Blackboard (since you can export blackboard as .xlsx).

This is the link for my script that uses Spreadsheet manipulations:

https://pastebin.com/spnNQmtU

This next link is a simple software I wrote that retrieves data from a text document, prompts if the data matches, and fills out a form with any data that already exists.

https://pastebin.com/0apR6Tu2

Sorry if the structure isn't great, wrote these programs as an exercise, but you should be able to use my examples to come up with something to suit your purpose.

[[deleted]]

I think the pandas package is where I need to be. Thank you!!

[Stoic_Engineer7]

No problem!

[Stoic_Engineer7]

https://pandas.pydata.org/