The only code you have thus far is reading the contents of this text file. You still need to process the information that you have read. I would suggest reading up on the concepts of iterables, for loops, and conditional statements.
This function doesn’t work quite like you think it does because “-1” references the newline character “\n”. Even if you try and usurp the newline character, by instead using “-2”, it still would not apply to the last line since its second to last character isn’t a capital letter.
One way to solve the problem is to have a plan in spoken language and then just translate it to Python. In broad terms:
get the rows we want from the file
process these rows
In order to make more specific plan we must inspect inventory we have - in this case the file content. Based on our objective of getting rows we want:
skip rows which end with letters (header row, and rows 2 3, 6)
skip rows which start with letter (last row)
So it appears that we can use str.isalpha() for checking whether first (at index 0) and last (at index -1) are letters. However, we should keep in mind that rows in files have newlines at the end. These could be stripped using str.rstrip() before checking.
To process rows and split them we can use str.rsplit() with maxsplit argument. We can then simply append values to two lists.
Put it all above together:
with open("content.txt", "r") as f:
start = []
end = []
for row in f:
text = row.rstrip()
if text[-1].isalpha() or text[0].isalpha():
continue
else:
first, last = text.rsplit(maxsplit=1)
start.append(first)
end.append(last)
print(start)
print(end)
# will produce:
['27/11 15:46:50 1', '27/11 15:03:39 1']
['350.00', '269.00']
