webinar-exam-review-2023-04-29

# Exam Review 2023 Apr 29

# Do those LABS
# Ch 2-14... all Labs!
# Ch 21-32 just ADDITIONAL LABS, but important practice!
# Prac Tests, Ch 33 and 34
# Use Submit Mode and get them to 100%!!!

# Comp 1: Basic syntax and knowledge: operators, data types, etc
# Comp 2: Control Flow
# Comp 3: Modules and Files

# Watch your string input and output
# input...
# myInput = input().strip()
# output/print()
# print() is the same print(end="\n")
# print("Something I'm printing", end=" ")
# print()
# print("Clean new line!")

# Comp 1: Basic syntax and knowledge: operators, data types, etc
# int
# float
# bool # True, False
# str # ""
# list # [ ]
# dict # {key:value}
# tuple # () immutable, Python sees a,b,c as (a,b,c)... return x,y -> return (x,y)
# set # all unique/no duplicates, no order... no index, no slicing, no sorting
# range # range() --> range object # range(5), range(0, 5) --> [0, 1, 2, 3, 4]

# operators
# = # assigns
# == # equality... asking a question, part of a condition
# +
# -
# *
# /
# % # modulo... gives the int remainder, "how many whole things didn't fit?"... since the last even division
# // # floor division ... the last even division
# <
# >
# <=
# >=
# += # x += 1 is x = x + 1
# -=
# ** # raising to a power... pow() and math.pow()
# != # not equal
# # keywords used like operators
# in # if x in myList:
# not # if not x in myList:
# and
# or # any one True means whole condition is True... limit OR to 2 condition

# Comp 2
# the HOW stuff... control flow structures
# IF statements... if, if/else, if/elif, if/elif/etc...
# LOOPS
# WHILE - an IF that repeats
# FOR -  looping over a container, or a known number of times # hence... range()
# for ___ in _container_:
# for item in myList:
# for char in myStr:
# for key in myDict: # the value for that key is myDict[key]
# for n in range(0, 12):
# for i in range(0, len(myList)): # for i, item in enumerate(myList):

# FUNCTIONS
# defining/writing vs calling
# parameters are special variables... they don't work like "regular" variables
# parameters vs arguments
# a function has ONE, PARTICULAR job
# return vs print()/output... vs other... do whatever the question says

# def someFunction(x, y):
#     return x // y
#
# if __name__ == "__main__":
#     myInput = int(input())
#     myOther = int(input())
#     myNum = someFunction(myInput, myOther)
#     print(myNum)
# print(__name__) # "__main__" because this is the script that's running

# See "tasks" in the last section of Ch 10, 11, 13, 14 for function writing practice
# # CodingBat also has good function-based Python questions:
# # https://codingbat.com/python

# BUILT-IN FUNCTIONS
# input()
# print()
# range()
# len()
# min()
# max()
# sum()
# int()
# float()
# list()
# str()
# dict()
# tuple()
# set()
# enumerate()
# round() # cousins math.ceil() and math.floor() are in math module
# open() # open to a file, create a file object
# type() # print(type(x)) # <class 'int'>, print(type(x).__name__) # int
# help() # # help(str)
# dir() # print(dir(list))

# STRINGS
# be able to slice strings like it's second nature
# [start:stop:step]
# myStr = "abcdef"
# revStr = myStr[::-1]
# print(revStr) # fedcba

# KNOW YOUR WHITESPACE
# # " "
# # many Unicode spaces
# "\n" # NEW line return
# "\t" # tab
# "\r" # carriage return

# STRING METHODS
# myStr.format()  # "stuff I want to put together {}".format(var)... compare to similar to f strings
# myStr.strip() # lstrip(), rstrip()
# myStr.split() # returns a list of smaller strings
# myStr.join() # " ".join(listOfStrings)
# myStr.replace(subStr, newStr) # "remove"... myStr = myStr.replace(subStr, "")
# myStr.find(subStr) # return int index of where found, or -1 if not there
# myStr.count(subStr) # return int count of occurrences
# case: myStr.lower(), myStr.upper()...myStr.title(), myStr.capitalize()
# is/Boolean: myStr.isupper(), myStr.islower(), myStr.isspace(), myStr.isalpha(), myStr.isdigit(), myStr.isnumeric(), myStr.isalnum()

# LISTS
# be able to use indices
# be able to slice

# LIST METHODS
# # +
# myList.append(item)
# myList.insert(i, item)
# myList.extend(anotherList)
# # -
# myList.pop(i) # pop by index...
# myList.remove(item) # remove by value
# myList.clear()
# # other
# myList.count(item)
# myList.sort()
# myList.reverse()
# myList.copy()
# myList.index(item)

# DICT
# use the key like an index
# myDict[key] # retrieve value for that key
# myDict[key] = value # assign value to key
# myDict.keys()
# myDict.values()
# dataList = [ " Agent Scully", "Queequeg", "Fred", " Dino", "Thor ", "Frog Thor"]
# pets = {}
# for i in range(0, len(dataList), 2):
#     # pets[key] = value
#     pets[dataList[i].strip()] = dataList[i+1].strip()
# print(pets)

# MODULES
# math and csv

# MATH MODULE
# import math # FULL IMPORT
# math.factorial(x)
# math.ceil(x.yz)
# math.floor(x.yz)
# math.pow(x, y) # not to be confused with math.exp()
# math.sqrt(x)
# math.fabs(x) # abs(x)
# math.pi
# math.e
#
# # PARTIAL IMPORT
# from math import factorial
# from math import ceil, sqrt
# from math import *
# factorial(x) # not math.factorial()
# floor(x.yz) # not math.floor()
#
# # ALIAS IMPORT
# import math as m
# m.floor(x.yz) # not math.floor()

# FILES
# READ MODE
# with open("test.txt", "r") as f: # f is file object
#     contents = f.readlines() # list of strings line by line
# print(contents) # ['Hello.\n', 'This\n', 'is\n', 'just\n', 'a\n', 'string.\n', 'But...\n', 'with\n', 'many\n', 'line\n', 'breaks!']
#
# for line in contents:
#     line = line.strip()
#     print(line)

import csv # csv.reader()
with open("mock_data.csv", "r") as f1:
    contents = list(csv.reader(f1)) # if a tsv file... csv.reader(f1, delimiter="\t")
# print(contents[0:25]) # slice!

# WRITE MODE
with open("output_data17.csv", "w") as f2:
    for row in contents:
        # write out data for rows where the email address is at photobucket.com
        if "@photobucket.com" in row[3]:
            f2.write(",".join(row)+"\n") # takes a single string arg


# APPEND MODE
with open("output_data17.csv", "a") as f3:
    # [1001, Gomer, Pyle, golly@usmc.gov, Male, 157.108.244.163]
    f3.write("1001,Gomer,Pyle,golly@usmc.gov,Male,157.108.244.163\n")