search

graphicsdesk / 2020-campaign-contributions

Columbia affiliates donated far more to Biden, but Trump fares better than in 2016
https://www.columbiaspectator.com/news/2020/11/06/columbia-affiliates-donated-far-more-to-biden-but-trump-fares-better-than-in-2016
0 stars 0 forks source link

Data from Columbia Southern University left in analysis #1

Closed exprez135 closed 3 years ago

exprez135 commented 3 years ago

It appears that data from employees of Columbia Southern University was accidentally in this analysis.

df.loc[df.contributor_employer == "COLUMBIA SOUTHERN UNIVERSITY"] yields 259 contributions totaling $23,950.30.

There is also someone who misspelled their employer as "UNIVERSITY OF BRIRISH COLUMBIA" so that the filter for British didn't catch it.

Other than that, I found no anomalous data. Could probably be rooted out by adding "SOUTHERN" and "BRIRISH" to the faux list?

southern.csv.txt

exprez135 commented 3 years ago

Note: this is from looking at 2019-2020 data from 2020_final.ipynb. Didn't check 2016 data at all.

raeedahw commented 3 years ago

@exprez135 Thanks for catching this! Working on updating