r/pythonhelp • u/KeganBergi • Dec 08 '21
PYTHON ASSIGNMENT PLS SOMEONE LOL
Read in the included data file and write it to a file named sorted_data.txt with the same data, but order the columns in ascending alphabetical order.
https://www.dropbox.com/s/snhowdtcne6zuuf/MOCK_DATA-3.txt?dl=0
That is the link to the data file that is supposed to be initially read in.
1
Upvotes
1
u/KeganBergi Dec 13 '21
This is the code that I have so far, it has quite a few red line errors I'm using due to missing header files of some sorts, the last thing I need is the line for the...
for record in data[1:]:
I'm having a hard time writing the nested loop.
This is the code that I have so far, it has quite a few redline errors I'm using due to missing header files of some sort, the last thing I need is the line for the inputFile:
for line in inputFile.readlines():
returnList.append(line.strip().split('\t'))
return returnList
execpt FileNotFoundError:
print(f"File): {filename} doesn't exist")
exit()
def orderHeader(headerToOrder):
headerToReturn = headerToOrder.copy()
headerToReturn.sort()
return headerToReturn
def buildNewHeader(oldList, newList):
def createData(header, data):
newColumnList = []
oldColumnList = data[0]
for field in header:
newColumnList.append(oldColumnList.index(field))
newData = []
newData.append(buildNewHeader(oldColumnList, newColumnList))
for record in data[1:]:
return newData
def writeFile(listToWrite, filename):
dataList = readFile(assingmentFileName)
newHeader = orderHeader(dataList[0])
sortedDataList = createData(newHeader, dataList)
writeFile(sortedDataList, outputFilename)