[crazygringo]

First of all, what a fantastic and inspiring read.

But, I'm left greatly confused -- the article never states whether this changed the result.

It says that halfway through counting Obi was in the lead, but nothing about when finished counting.

And when I look at the spreadsheet, the last row (#3380) appears to be the totals, which lists:

  APC     LP     PDP     NNPP
  149014  85748  329030  8305

Which shows LP (Obi) in third place, just like the official results.

So what point is the article trying to make at the end of the day? Or have I misunderstood the numbers?

[sd9]

Those are the results for just one state, Adamawa.

However, like you I don't know what the overall results are; I agree that the article could make this clearer.

[crazygringo]

Oh thanks for clarifying. Turns out the link to the folder for all the states is here:

https://drive.google.com/drive/folders/173oHgms6wYy5WKz_i3Lh...

But there doesn't appear to be any file that calculates the nationwide totals.

It just seems like such a strange omission but I'm on mobile and can't add up the numbers from across a ton of different files myself.

[didgetmaster]

I downloaded all the .CSV files from that site and quickly loaded them into a table. It just took a couple minutes, but I didn't stop to verify that there were not duplicate rows across the various files.

When I added up the totals, I got: APC - 7,225,399 LP - 5,286,181 PDP - 5,285,900 NNPP - 1,529,575

Note: I was using a beta version of a new database tool I created to do this.

[jxramos]

should be something quick to whip up in a few minutes in pandas I'd think assuming the column headers are identical and in the same order. It would translate into a bunch of pandas concat call and with the merged table a value_counts for the column where the vote is retained.

[didgetmaster]

I have no doubt that a pandas expert (or a postgres expert, or a mysql expert, or..) can whip up something fairly quickly to load in the data and find the totals.

My tool is designed for people who are not experts but just have a basic understanding of relational tables (e.g. someone comfortable with a spreadsheet) to be able to load a data set like this and analyze it with just a few clicks of a mouse. Using it, I was able to do the whole thing in about 2 minutes.

BTW: When my numbers did not match up with another HN commenter on this thread, I investigated and found a bug in my code. Once fixed the numbers were correct. (I guess that's why it is still in beta!)

[karagenit]

I totaled up the results from only the "crosschecked" CSV files, here's what I saw:

  APC:  5928825
  LP:   4731127
  PDP:  4555334
  NNPP: 1019045

I tried to manually verify about a dozen rows myself, half were so blurry/low res they were illegible but the ones that were legible were all correct.

And for the "unsure" CSVs:

  APC:  1308067
  LP:    578482
  PDP:   736183
  NNPP:  513245

Also checked about a dozen, and all but one of them were wildly inaccurate so I wouldn't trust these much.

[error503]

I collected all the _crosschecked CSVs and got:

  LP       PDP      APC      NNPP
  4731127  4555334  5928825  1019045

Obi seems to make second place here, but far from first.

https://i.imgur.com/UaZbXz6.png

[pxc]

There are some conditions under which a presidential election in Nigeria can trigger a runoff election, so that may still matter, right?

[error503]

It doesn't look like (from TFA or the collected spreadsheets) there's enough information collected (2nd choices) at the polls to support an instant runoff. So they'd need to go back to the polls for a traditional runoff if that were the case.

[jxramos]

probably because it was submitted as evidence and not yet accepted by the courts or wherever things wound up next.