Menu Problem.

[carpe]

Could you please give me a rough outline of option 1? To show me what I need to progress to. It would be much appreciated as I have small experience in python.

Assuming the original text file looks something similar to...

Member ID Surname Year Joined Membership Status Nights Booked Points Balance
Gri33415 Griffiths 2015 Gold 35 40000
Smi22316 Smith 2016 Silver 3 7500
Mia56213 Miah 2013 Platinum 140 165000
...

tThen something like...

import pandas as pd

def read_text():

    data_frame = pd.read_csv("/path/to/relevant/file/textfile.txt", sep=" ", skiprows=[0], header=None)
    data_frame.columns = ["Member ID", "Surname", "Year Joined", "Membership Status", "Nights Booked", "Points Balance"]

    return data_frame

... should get the data loaded in and ready to use.