• In the normal file slot: your .py file that generates your site
• In comments-to-teacher: The URL of your site (on homer.stuy.edu/...)
• In comments-to-teacher: any bonuses you've added to your site

• Make a small list of numbers / small string of chars to test your functions on first
• While testing, print() out your dictionary each loop to make sure you can see what's going on
• When you're done counting occurrences, you'll need sort by most/least frequent, but dictionaries don't have a notion of order. To be able to sort something, write some code to construct a list like so: [ [val1, key1] , [val2, key2], ...] You will need to loop over all the keys in the dictionary to construct this list.

        f = open(filename,'r')
        lines = f.read().strip().split("\n")
        for line in lines:
            if line.isdigit():  # make sure it's an integer string (e.g. "123")
                #do some stuff
        

    ADD THE FOLLOWING TO YOUR SITE:

    - Download this zip file, which contains 10 images of numbers.
    - Unzip that, put the 'numbers' folder inside your hw18 folder
    - Modify your script to include an image of the appropriate number on each page
    - Modify your script to also generate an index.html file
        - index.html should have a link to each of the pages
        - each page should have a link back to index


    Bonus:
    - here's a way to add simple navbars to your site: Navbars
    - Add a navbar to the top of each page, containing a link to the index, and a dropdown
      of links to each individual page
        

1. First: if you were having trouble with HW16, take a look at my posted solution, and make sure you can get your version working.
2. Download this csv: 2012_SAT_Results50.csv. This is a subset of this dataset from NYC OpenData, limited to the 50 schools with the most SAT test takers.
3. Write a function to read in this csv file, split it, and convert the number columns to integers, and return a list of lists.
4. Write a function that takes this data (as a list of lists), and returns the row (i.e., a list of len 6) with the most SAT Test Takers
5. Write a function that takes this data (as a list of lists), and returns the row with the highest combined SAT Score.
6. Write a function that takes this data (as a list of lists), and returns a list of [ average reading score, average math score, average writing score ]
7. Putting it all together: Your program, when run, should read in the csv file, process it, and write out an html file with the following:
   • Full html structure (html, head, title, body)
   • An html heading at the top of the page (e.g. h1)
   • Some text describing, what this dataset is, and where it came from.
   • An unordered list of the school with the most test takers, school with the highest score, and a listing of the averages for the scores.
   • A full table of all the SAT results, with the column names

• Bold and underline the column names
• Sort the table by either name, total test takers, or score
• Add an extra column to the table for "Combined SAT Score"
• If you finish all the bonuses, see if any of your classmates are stuck or want help

• format can be used instead of ..." + str(x) + "..., like so:
  result = "{} fish {} fish\n {} fish {} fish".format(1,2,"red","blue").


• Here are some notes on using split and join.
• Here are some notes on reading/writing files

1. Who earned the most total pay during their time on this job?
2. Which 3 people worked the fewest days? How many days did they work?
3. What was the average amount each person earned? (i.e. average of the total-pay)

1. In python, write code to read in the file and print out its lines in reverse order (i.e. last line goes first)


2. Then write code to output the lines (in reverse order) to a new file. You should be able to open the output file in a text editor and verify that it has the correct contents.

Answers:

1. 100 Names
2. Longest first name: 10 characters, "ALEXANDRIA"
3. Longest last name: 13 characters, "KROP-SIEGMUND"
4. Mean score: 10.88
5. Top 3: SAYAN GRAEBER 20; AFIA HUMAIDEE 19; XINQING LEUNG 18

• If you were not able to get steps 1-3 working last night, take a look at the partial solution posted now. Make sure you understand it, and use it to go fix your code. DO NOT just copy-paste it, copy pasting will not reduce your confusion, but rewriting it will! After you get steps 1-3 working, then work on calculating the median.
• If you were able to get steps 1-3 working last night, but not the median, then for homework, get the median working, and resubmit
• If you got all parts of the homework working last night, then congratulations, and enjoy your well-earned rest.

print('"apple".replace("p","ba") should be "ababale", is: ',  "apple".replace("p","ba"))

• Then, skim (i.e., no more than 5 minutes total) through all of the string methods in Text Sequence Type - str. Not all of them are useful to you, and some use techniques we haven't discussed yet, but many will be useful and interesting.
• Pick two string methods that seem interesting or useful. Read through their descriptions, try to predict what they do.
• Write at least two test cases for each of the string methods you chose.

• You should review for i in range(...):
• You should be able to run through the execution of a while loop and write out the loop table (i.e., values of variables at start of each iteration, whether the loop test passes or fails, what changes in the body).
• You should be familiar with the math operations (+ - * / %), and the comparisons (==, <, >, <=, >=, !=), and the logical operations (and, or not).
• You should be able to determine which path the code will take through a series of if ... : and else: statements

    def foo(n):
        print("x")
        return(n * 10)
        print("y")
    print("a")
    i = 50
    while i < 1000:
        i = foo(i)
    print("b")
    print(i)
    
    

• In the "comments-to-teacher box", please write how much time you spent working at home on this homework, in decimal hours. (i.e. if you spent half an hour on it, put 0.5).
• If you worked with someone on this homework, write it in the comments-to-teacher box.

• In the "comments-to-teacher box", please write how much time you spent working at home on this homework, in decimal hours. (i.e. if you spent half an hour on it, put 0.5).
• If you worked with someone on this homework, got help from someone, or helped someone on their own homework, you must mention that in the comments-to-teacher box. I strongly encourage collaborating with your peers, as working together and dicussing code can be very helpful, but make sure that you attribute your collaborators.

• isBig
• sleep_in
• monkey_trouble

# Assuming we have a numeric variable x
if x > 10:  
    return 1 # If test is True (above 10)
else:
    return 2 # If test is False (not above 10)


#Comparison operators:
# Less/greater than: >, <
# Less/greater than or equal to: >=, <=
# Equal/not equal: ==, !=
# NOTE: a single equal '=' DOES NOT CHECK EQUALITY.
#       a single equal '=' assigns values to variables


# Note: if we have variables a and b that hold
# either True or False, we can test them directly without a comparison
if a:
    if b:
        print("Both a and b are True")
    else:
        print("a is True, and not b")
    print("a is True")
print("prints always")


# True and False are values in python like 0 and 1
# Don't quote them: "True" is a string, (not what you want here)
if a: 
    return False
        

1. Create an account using your email address and make up some pasword that you'll remember
2. After logging in, click on the "prefs" link (on the upper-right of the window)
3. In the "Teacher Share" field, enter jvorob@stuy.edu and press the Share button
4. In the "Memo" field, enter 2022,your period,lastname,firstname with no spaces.
   For instance: 2022,9,Shelley,Mary 
   and then press the Update Memo button.

• square
• evalQuadratic