1
$\begingroup$

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.

$\endgroup$
0
$\begingroup$

I think I may have the answer.

import csv
dat1Content = [i.strip().split(';') for i in open("./001_SALES_DATA_NNME_28012019.DAT")

That will do it I think, although I'll have to check.

Sorry to be asking such a naive question.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.