r/pythonhelp • • 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

16 comments sorted by

View all comments

3

u/[deleted] Dec 08 '21

Not signing into a Dropbox account account to open some random file from a stranger on the Internet.

Include a sample of the data showing the format in your post and also what you've done so far.

The standard way to read a text file would be,

with open('MOCK_DATA-3.txt') as data_source:
    for line in data_source:
        # do something with the string referenced by line

It is possible to read all of the lines in a file in one go, but it is assumed you will want to process each line to extract the data into a required format.

If the file is formatted in a standard way such as CSV, comma separated values (other separators than comma can be used) then the CSV module will help.

import csv

with open('MOCK_DATA-3.txt') as data_source:
    reader = csv.reader(data_source)
    for row in reader:
        # do something with the **list** that is referenced by row

This looks similar but the csv module reads data into a list rather than one string, saving you some work.

Good guide: https://realpython.com/python-csv/

1

u/KeganBergi Dec 08 '21

Also another thing, I've actually never posted anything to reddit, this was truly my last resort, tutoring didn't even help, it's honestly sickening me knowing that I can't do a simple index() and sort() with two nested for loops

1

u/[deleted] Dec 08 '21 edited Dec 08 '21

There's a lot of people starting out on this subreddit and getting great help. Some people take to programming very quickly but others find it very difficult at first and it takes a lot of effort to get it.

I help a lot of kids learn to programme through the Code Club organisation, working in local schools, and also sometimes teach adults at local community college.

For most of those who find it difficult, I find the problem is usually that they assume the computer is far more intelligent than it actually is. They find it difficult to dumb things down sufficiently for a very stupid (compared to a human) machine. This is partly because it is hard as humans to see all the leaps we make when carrying out tasks.

I give some people an exercise to sort a small set of cards, say 10 number cards, that have been shuffled, into the correct order. Most people can do this very quickly and easily. However, when I say to write down the instructions for someone with significant learning difficulties, assuming they have a very short memory, can only hold one card in their hand at a time, people find it a lot more challenging than they expected. I get them to put a load of bits of paper down on the table, with labels on them A .. J. And an extra bit of paper off to the side as a holding area. It takes a while and is very irritating for some when I play the computer and do dumb stuff because I've not got an instruction to do anything else.

It is definitely worth looking at the learning guidance and materials in the wiki for this subreddit. There's some great content.

The only way to learn though is practice! Practice! Practice! With lots of failure and experimentation. I recommend people make use of the Python Interactive Shell, the one with the >>> prompt in IDLE, as you get instant feedback when trying things out, and don't need to use long variable names, real data - just quickly check how to do something simple.

Did the example code I shared make any sense?

EDIT: The wiki is for the /r/learnpython subreddit - forgot where I was.

1

u/KeganBergi Dec 08 '21

The example is perfect, I know how to read in the file of mock data with... file open("MOCK-DATA3.txt") along with sorting the data, but obviously, it does work but it sorts literally everything in alphabetical order, I just need to index the first row being the header, with the... data[0:] command which then pinpoints where each of the first words for the header, the assignment states I need a "was is" list. In that sense I get that I need to keep the old data and copy it to a new list to work from.

1

u/[deleted] Dec 08 '21

Firstly, the wiki I mentioned, and my comments in general, were related to the r/learnpython subreddit - forgot where I was.

You can read the first row, as a header, using next (whether simple text file or csv file).

import csv

with open('MOCK_DATA-3.txt') as data_source:
    reader = csv.reader(data_source)
    header = next(reader)  # this will be a list of header names
    rows = []
    for row in reader:
        # could make changes to row before appending below
        rows.append(row)  # builds up internal copy of data

Now your rows list contains nested lists. You can sort on any entry using the key option in sorted. Keep in mind how different cases impact sorting.

You could have using slicing instead to sort just rows[1:], ignoring the header row. Look up list slicing.

1

u/KeganBergi Dec 08 '21

You describe how to do this perfectly, I'm going to try and implement this the best I can.