基于python的美国总统大选数据分析源码(课程作业).zip

CAND_ID|CAND_NAME|CAND_ICI|PTY_CD|CAND_PTY_AFFILIATION|TTL_RECEIPTS|TRANS_FROM_AUTH|TTL_DISB|TRANS_TO_AUTH|COH_BOP|COH_COP|CAND_CONTRIB|CAND_LOANS|OTHER_LOANS|CAND_LOAN_REPAY|OTHER_LOAN_REPAY|DEBTS_OWED_BY|TTL_INDIV_CONTRIB|CAND_OFFICE_ST|CAND_OFFICE_DISTRICT|SPEC_ELECTION|PRIM_ELECTION|RUN_ELECTION|GEN_ELECTION|GEN_ELECTION_PRECENT|OTHER_POL_CMTE_CONTRIB|POL_PTY_CONTRIB|CVG_END_DT|INDIV_REFUNDS|CMTE_REFUNDS H8AK00132|SHEIN, DIMITRI|C|1|DEM|0|0|367.52|0|367.52|0|0|0|0|367.52|0|0|0|AK|00||||||0|0|09/30/2019|0|0 H6AK00045|YOUNG, DONALD E|I|2|REP|1950289.86|138304.94|1817836.79|0|116720.12|249173.19|0|0|0|0|0|0|963416.04|AK|00||||||839094.63|500|12/31/2020|19609.67|5500 H8AK01031|NELSON, THOMAS JOHN|C|2|REP|0|0|466.51|0|466.51|0|0|0|0|0|0|0|0|AK|00||||||0|0|03/31/2019|0|0 H8AK00140|GALVIN, ALYSE|C|3|IND|5253251.54|60024.76|5162902.93|0|6245.09|96593.7|4371.82|0|0|0|0|0|4796137.47|AK|00||||||340486.99|10025|12/31/2020|32594.02|0 H0AL01097|AVERHART, JAMES|O|1|DEM|80094.95|0|78973.24|0|0|1121.71|0|29245|0|0|0|29245|50849.95|AL|01||||||0|0|12/31/2020|0|0 H0AL01105|GARDNER, KIANI A|O|1|DEM|118661.85|0|118661.85|0|0|0|764.97|6000|0|138.91|0|5861.09|92896.88|AL|01||||||19000|0|07/31/2020|0|0 H0AL01139|COLLINS, FREDERICK G. RICK'|O|1|DEM|62935.42|0|60825.97|0|0|2109.45|56500|0|0|0|0|0|5917.12|AL|01||||||0|0|07/14/2020|0|0 H0AL01055|CARL, JERRY LEE, JR|O|2|REP|2344516.53|102070.05|2232543.94|0|0|111972.59|1655.5|758900|0|325900|0|469225.79|1044195.95|AL|01||||||387000|5000|12/31/2020|1600|0 H0AL01063|LAMBERT, DOUGLAS WESTLEY III|O|2|REP|182564.96|0|182564.96|0|0|0|47804.96|110000|0|38388.87|0|71611.13|20760|AL|01||||||4000|0|12/31/2020|0|0 H0AL01071|PRINGLE, CHRISTOPHER PAUL|O|2|REP|491715.7|0|491715.7|0|0|0|0|0|0|0|0|0|464115.7|AL|01||||||27600|0|06/17/2020|1300|5000 H0AL01089|HIGHTOWER, BILL|O|2|REP|1323944.09|0|1323944.09|0|0|0|0|0|0|0|0|0|1268756.68|AL|01||||||53200|0|09/30/2020|43860|0 H0AL01121|CASTORANI, JOHN|O|2|REP|26809.68|0|26809.68|0|0|0|0|15159.68|0|8600|0|6559.68|11650|AL|01||||||0|0|12/03/2020|0|0 H4AL01123|BYRNE, BRADLEY ROBERTS|I|2|REP|544643.34|19259.14|1619368.36|1504815.73|1074725.02|0|0|0|0|0|0|0|60571|AL|01||||||464813.2|0|03/31/2019|0|2500 H0AL02202|HARVEY-HALL, PHYLLIS|O|1|DEM|57722.77|11.32|57661.16|0|0|0|0|12248.5|0|1673.09|0|5666.91|42411.95|AL|02||||||2032|1019|12/31/2020|0|0 H6AL02167|MATHIS, NATHAN|O|1|DEM|12230|0|12230|0|0|0|12230|0|0|0|0|0|12230|AL|02||||||0|0|03/03/2020|0|0 H0AL02087|ROBY, MARTHA|I|2|REP|216297.5|0|512768.27|0|341683.01|45212.24|0|0|0|0|0|0|53800|AL|02||||||161500|0|12/31/2020|54914.76|12615.38 H0AL02137|DISMUKES, WILL|O|2|REP|15043|0|14291.33|0|0|751.67|0|0|0|0|0|0|15043|AL|02||||||0|0|12/31/2019|1900|0 H0AL02145|COLEMAN, JEFF|O|2|REP|2615977.24|0|2615977.24|0|0|0|4129.49|1125000|0|0|0|0|1241814.56|AL|02||||||231000|0|12/31/2020|9214|12000 H0AL02152|KING, TROY|O|2|REP|286727.66|0|283699.45|0|0|3028.21|3614.26|0|0|0|0|43313.84|272113.4|AL|02||||||11000|0|12/31/2020|22750|0 H0AL02160|BROWN, THOMAS WILLIAM JR.|O|2|REP|22950|0|22417.46|0|0|532.54|0|17950|0|0|0|17950|5000|AL|02||||||0|0|03/31/2020|0|0 H0AL02178|TAYLOR, JESSICA|O|2|REP|476139.02|3351.7|476139.02|0|0|0|0|0|0|0|0|0|439304.12|AL|02||||||29505|0|09/09/2020|28760|0 H0AL02194|HASDORFF, TERRI|O|2|REP|82156|0|82156|0|0|0|0|0|0|0|0|0|82156|AL|02||||||0|0|03/31/2020|16800|0 H6AL02159|ROGERS, ROBERT L|O|2|REP|23574.69|0|17129.67|0|0|830.28|23320.24|0|0|0|0|4041|254.32|AL|02||||||0|0|03/31/2020|0|0 H8AL02080|LOVE, JAY K|O|2|REP|0|0|0|0|372.13|372.13|0|0|0|0|0|194214.55|0|AL|02||||||0|0|12/31/2019|0|0 H8AL02171|MOORE, FELIX BARRY|O|2|REP|837715.85|0|836276.8|0|4927.67|6366.72|0|190900|0|179400|0|121742.79|408536.2|AL|02||||||230281.65|7998|12/31/2020|7509.1|0 H8AL02189|AMASON, THOMAS MARRION III|C|2|REP|0|0|0|0|-654.2|-654.2|0|0|0|0|0|0|0|AL|02||||||0|0|03/31/2019|0|0 H8AL03039|TURNHAM, JOSEPH R|C|1|DEM|0|0|0|0|0|0|0|0|0|0|0|0|0|AL|03||||||0|0|03/31/2019|0|0 H8AL03054|HAGAN, MALLORY|C|1|DEM|4891.75|0|7809.28|0|2917.53|0|0|0|0|0|0|-6|1320|AL|03||||||0|0|03/31/2019|240|0 H8AL03062|WINFREY, ADIA|C|1|DEM|50523.2|0|41221.09|0|0|43.31|700|250|300|250|0|0|46912.89|AL|03||||||107.97|2252.34|12/31/2020|0|0 H2AL03032|ROGERS, MICHAEL|I|2|REP|1202888.07|0|1228340.4|365530|527686.03|502233.7|0|0|0|0|0|0|443369|AL|03||||||744733.7|8000|12/31/2020|5100|0 H8AL04086|NEIGHBORS, RICKY|C|1|DEM|48942.68|0|47908.58|0|0|1034.1|1980.86|1800|0|0|0|1800|33021.97|AL|04||||||9504.55|60.51|12/31/2020|300|0 H6AL04098|ADERHOLT, ROBERT B. REP.|I|2|REP|1283402.11|0|1352138.08|0|715740.36|647004.39|0|0|0|0|0|0|541121.78|AL|04||||||739300|0|12/31/2020|27576|0 H8AL05190|JOFFRION, PETER S.|O|1|DEM|171.51|0|3106.96|0|2935.45|0|171.51|0|0|0|0|0|0|AL|05||||||0|0|04/22/2019|0|0 H0AL05163|BROOKS, MO|I|2|REP|669026.33|0|223706.66|2000|692181.51|1137501.18|0|0|0|0|0|4746.67|417354.83|AL|05||||||250020|0|12/31/2020|10500|2500 H0AL05205|LEWIS, CHRIS|C|2|REP|167746.86|0|166737.31|0|0|1009.55|3.25|29500|0|3000|0|61744.83|122467.86|AL|05||||||15000|0|12/31/2020|1250|0 H8AL05208|HINCHMAN, ROBERT CLAYTON MR|O|3|GOP|1033.08|0|0|0|-1033.08|0|1033.08|0|0|0|0|92624.68|0|AL|05||||||0|0|06/30/2019|0|0 H4AL06098|PALMER, GARY|I|2|REP|919678.33|50948.78|921541.75|2000|372551.28|370687.86|0|0|0|0|0|0|469170|AL|06||||||397600|0|12/31/2020|13200|-2700 H0AL07086|SEWELL, TERRI A.|I|1|DEM|2171039.72|0|1498831.85|0|1571272.38|2243480.25|0|0|0|0|0|0|407562.27|AL|07||||||1760802.74|0|12/31/2020|200|0 H6AL07166|WALTERS, EDDISON T|O|1|DEM|0|0|1291.5|0|1291.5|0|0|0|0|1177.8|0|10164.85|0|AL|07||||||0|0|12/31/2020|0|0 H0AR01109|CAUSEY, CHAD|O|1|DEM|0|0|600|0|331.59|181.59|0|0|0|0|0|112037.3|0|AR|01||||||0|0|12/31/2020|0|0 H0AR01083|CRAWFORD, ERIC ALAN RICK|I|2|REP|966801.25|5072.23|1095517.53|46000|311424.52|182708.24|0|0|0|0|0|0|405293.4|AR|01||||||556335.62|100|12/31/2020|0|0 H0AR01125|SMITH, PRINCELLA D|O|2|REP|0|0|0|0|4|4|0|0|0|0|0|0|0|AR|01||||||0|0|12/31/2020|0|0 H0AR02206|ELLIOTT, JOYCE ANN SENATOR|C|1|DEM|3543886.52|0|3540156.67|0|0|3729.85|100|10000|0|10000|0|0|3146457.55|AR|02||||||373403.13|11610|12/31/2020|49613.49|1200 H8AR02142|COMBS, GWENDOLYNN MILLEN MRS.|C|1|DEM|0|0|2456.03|0|2456.03|0|0|0|0|0|0|0|0|AR|02||||||0|0|12/31/2020|0|0 H8AR02159|TUCKER, EVERETT CLARKE IV|C|1|DEM|99.99|0|4219.51|0|7756.41|3636.89|0|0|0|0|0|4500|0|AR|02||||||0|0|12/31/2020|0|0 H4AR02141|HILL, JAMES FRENCH|I|2|REP|3423234.37|144152.08|3059235.64|0|46780.63|410779.36|0|0|0|0|0|0|1700705.98|AR|02||||||1531281.6|8400|12/31/2020|50|0 H0AR03030|WHITAKER, DAVID JEFFREY|O|1|DEM|0|0|0|0|3367.43|3367.43|0|0|0|0|0|18457.09|0|AR|03||||||0|0|12/31/2020|0|0 H0AR03105|WILLIAMS, CELESTE SARENE|C|1|DEM|356059.69|0|356059.69|0|0|0|0|0|0|0|0|0|339611.09|AR|03||||||4500|11183.33|11/30/2020|0|0 H8AR03074|MAHONY, JOSH|C|1|DEM|2660|0|2846.36|0|186.36|0|2660|0|0|0|0|0|0|AR|03||||||0|0|04/30/2019|0|0 H0AR03055|WOMACK, STEVE|I|2|REP|1128158.85|0|924120.94|0|1159218.79|1363256.7|0|0|0|0|0|0|548980|AR|03||||||568221.3|0|12/31/2020|0|0 H2AR03143|HENDREN, JAMES PAUL|C|2|REP|.55|0|0|0|93.06|93.61|0|.28|.27|0|0|450142.7|0|AR|03||||||0|0|12/31/2020|0|0 H0AR02198|REDMOND, RAYMOND DALLAS JR.|C|1|DEM|20|0|20|0|0|0|20|0|0|0|0|0|0|AR|04||||||0|0|06/30/2019|0|0 H0AR04087|HANSON, WILLIAM MR.|C|1|DEM|109767.15|0|111682.66|0|0|-1915.51|0|0|70100|0|0|70100|39667.15|AR|04||||||0|0|12/31/2020|0|0 H2AR04133|HURST, Q. BYRUM JR|O|1|DEM|0|0|0|0|20.61|20.61|0|0|0|0|0|8982.22|0|AR|04||||||0|0|12/31/2020|0|0 H8AR04130|SHAMEL, HAYDEN CATHERINE|C|1|DEM|1506.23|0|3311.33|0|2197.18|112.18|1371.85|0|0|0|0|0|0|AR|04||||||0|0|09/30/2020|0|0 H2AR04083|COTTON, THOMAS|C|2|REP|9139904.91|1461076.82|4842303.46|0|2099351.54|6396952.99|0|0|0|0|0|73959|6395452.56|AR|04||||||1171770|200|12/31/2020|84420.56|5000 H4AR04048|WESTERMAN, BRUCE|I|2|REP|1428508.39|4167|1123311.93|2000|671609.55|976806.01|0|0|0|0|0|0|667948.54|AR|04||||||748630.35|0|12/31/2020|13700|1000 H8AR04148|CALDWELL, RANDY|C|2|REP|0|0|644.64|0|307|108|0|0|0|0|0|0|0|AR|04||||||0|0|06/14/2019|0|0 H0AS01016|CRICHTON, ORETA TUFAGA-MAPU|C|1|DEM|36273|