TDM 10200: Project 6 — 2024

First (without a function!) start with a variable called myyear. It can be an election year, and it helps if you try this with a few of the early 1980’s elections years, so that they data is not-too-big. For instance, try myyear with each of the years 1980, 1984, and 1988 (one at a time, not a list). Once you set the value of myyear, then make a variable for the path to the data from that year, for instance, /anvil/projects/tdm/data/election/itcont1984.txt

Read in the data from the year stored in myyear. Please note that the data does not have column headers built-in, so you need to add the column headers, as in the "tip" below. Please also note that the elements in the data set has | between the data elements, not commas (this is why the file name ends in .txt not .csv in this case). So you need to use the parameter delimiter='|' in your read_csv function.

Look at the head of the data set, after you read it in. Does it look correct? Does everything make sense? Try this for each of the years, 1980, then 1984, then 1988, one at a time, storing each of these values into the variable myyear and then read in the data for that year, and check the head of the data each time. This is good practice for making sure that your work is designed properly.

Now that you are sure that your work is OK, make a function called read_election_year that takes one parameter called myyear as the input, and returns a data frame that contains the data from that election year. Make sure to document your function with a docstring to explain how it works.

mycolumnnames=["CMTE_ID","AMNDT_IND","RPT_TP","TRANSACTION_PGI","IMAGE_NUM","TRANSACTION_TP","ENTITY_TP","NAME","CITY","STATE","ZIP_CODE","EMPLOYER","OCCUPATION","TRANSACTION_DT","TRANSACTION_AMT","OTHER_ID","TRAN_ID","FILE_NUM","MEMO_CD","MEMO_TEXT","SUB_ID"]

mydictionarytypes = {"CMTE_ID": str, "AMNDT_IND": str, "RPT_TP": str, "TRANSACTION_PGI": str, "IMAGE_NUM": str, "TRANSACTION_TP": str, "ENTITY_TP": str, "NAME": str, "CITY": str, "STATE": str, "ZIP_CODE": str, "EMPLOYER": str, "OCCUPATION": str, "TRANSACTION_DT": str, "TRANSACTION_AMT": float, "OTHER_ID": str, "TRAN_ID": str, "FILE_NUM": str, "MEMO_CD": str, "MEMO_TEXT": str, "SUB_ID": int}

myDF = pd.read_csv("/anvil/projects/tdm/data/election/itcont1980.txt", delimiter='|', names=mycolumnnames, dtype=mydictionarytypes)

myDF['TRANSACTION_DT'] = pd.to_datetime(myDF['TRANSACTION_DT'], format="%m%d%Y")

First (without a function!) start with a variable called myyear, such as 1980, and find the number of (unique) committees that appear in the CMTE_ID column in that year. Then do the same for the year 1984, and then do this again for 1988. Print your results for each of these three years in separate cells.

Now that you have part 2a working well, put your work from question 2a into a function. Namely, create a function called committees_function that accepts a year as input, and returns the number of (unique) committees that appear in the CMTE_ID column in that year. Use the function designed in Question 1 to help you accomplish this work.

Test your function for each of the years 1980, 1984, and 1988. How many (unique) committees appear in each of these 3 individual years? The output from this question should show, for each year, how many (unique) committees appear in the data for each of those 3 years. The output for each of these 3 years should agree with your output from question 2a.

First (without a function!) start with a variable called myyear, such as 1980, and find the total (sum) of the values from the TRANSACTION_AMT column for each state in the data set. You only need to print the top 5 results (i.e., the top 5 states and the total of the transaction amounts from those states) for 1980. Then do this again for 1984, and then do this again for 1988.

Now that you have your work from Question 3a working well, build a function called top_five_states. This function should take 1 year as input, and should return the top 5 states and the total (sum) of the values for each of the 5 states, from the TRANSACTION_AMT column (for that state).

First find the top 5 employers in each year 1980, 1984, and 1988, and print the top 5 for each of those years. Do this before you make a function.

Once that is working, then build a function called top_employers that returns the top 5 employers in each year 1980, 1984, and 1988. Your results from question 4b should agree with your results from question 4a.

Experiment with the election data for the same 3 years as above (1980, 1984, 1988). Identify something that you find interesting each of those 3 years before you build a function.

Wrap your interesting working into a function, and make sure that it matches your work from question 5a, for each of the 3 years.