I'm doing my very first data science project ever and am likely to seem a bit naive, and I've got three .DAT files each of which I want to convert into a list of lists, and the code I've been using so far is
import csv dat1Content = [i.strip().split() for i in open("./001_SALES_DATA_NNME_28012019.DAT")
but this isn't what I want because that uses newline to break the data up into the elements of the "outermost" list, each element of which is also a list, and then it uses space to break the data up within each sub-list, but I don't want to use space for that, I want to use semi-colon. If my way of putting it makes sense. Can anyone help me figure out a fragment of code that would do that for me? Sorry if my question is a bit of a basic one, I'm still in the process of learning the ropes for how to clean up data in Python.
EDIT: More specifically is there a way to do it in just one line; if it's just a case of I have to write a script for it then I'm sure I can do that.