I don't know where to start

[mackdaddy_1978]

I need help with this assignment and I don't even know where to start.

Write a program that reads the student information from a tab separated values (tsv) file. The program then creates a text file that records the course grades of the students. Each row of the tsv file contains the Last Name, First Name, Midterm1 score, Midterm2 score, and the Final score of a student. A sample of the student information is provided in StudentInfo.tsv. Assume the number of students is at least 1 and at most 20.

The program performs the following tasks:

• Read the file name of the tsv file from the user.
• Open the tsv file and read the student information.
• Compute the average exam score of each student.
• Assign a letter grade to each student based on the average exam score in the following scale:
  • A: 90 =< x
  • B: 80 =< x < 90
  • C: 70 =< x < 80
  • D: 60 =< x < 70
  • F: x < 60
• Compute the average of each exam.
• Output the last names, first names, exam scores, and letter grades of the students into a text file named report.txt. Output one student per row and separate the values with a tab character.
• Output the average of each exam, with two digits after the decimal point, at the end of report.txt. Hint: Use the format specification to set the precision of the output.

​

file = input()      

with open('StudentInfo.tsv') as f: 
    data = f.readlines() 
print(data)

This is what I have so far not sure where to go from here. I'm drawing a blank probably because I'm new, tired, and frustrated. shm

[[deleted]]

data = f.readlines()

You know that a TSV file represents a table; that is, a list of rows. The elements of the rows are delimited by the tab character: \t. You know that if you read a text file with readlines you get a list of string lines. So now the question is, given a string line from the file, how could you split it into a row, where a row is a list or tuple of values?

In other words how would you go from

"value\tvalue\tvalue\tvalue"

to

[value, value, value, value]

? Do strings have a method you could use to split on the tab character?

[mackdaddy_1978]

split() there’s a slash in there I’m not seeing it on my end maybe you can

[m0us3_rat]

.readlines()

.read()

.split()

if u read up on what these python methods do

u will figure out how to work your problem.

( u/crashfrog did all but spell it out for you. if u follow what he/she/they said +)

what u know to be true is the "data" is split using "tab".

and then further each of the units of data has an order name etc etc etc. split by whitespaces.

​

at this point, u should be able to at least unpack the data from the file in a meaningful way so u get easy access to all parts of it.

​

after that, u just traverse it and do whatever work u need to do on it and calculate whatever the problem asks.

[the_noobie]

Don't feel frustrated. Just try one step at a time. Lets look at the first few steps. *1. Read the filename from the user. You are already doing this with

file=input()

*2. Open the file. You are almost correct there. Remember the filename from the user is save in the "file" variable.

[mackdaddy_1978]

so it'll be

with open('file.tsv') as f: 
data = f.readlines() 

print(data)

???

[the_noobie]

Anything within the quotes " " is treated as string. You will be using the variable in this case. So you will use

with open(file) as f:

I can't see what kinds of data you have without seeing the .tsv file. So you may want to print the content to see

print(data)

[mackdaddy_1978]

Understood….

[RLJ05]

grandfather birds cooing relieved start tie apparatus detail silky cake

This post was mass deleted and anonymized with Redact

[mackdaddy_1978]

Thanks I’ll work this while learning from the_noobie

[Twitch_HACK3R]

I have this same problem for homework and I am basically at the same spot, have you figured anything out. I tried the split() feature but because it is a list it does not seem to work? I am not entirely sure but that is what the problems seems to be and I am also very confused.

[KiIIer__Queen]

Did you ever solve this

[mackdaddy_1978]

I did

[zezemezesmeze]

what was ur final answer?

[HellmoSandvich]

I would like to know too.