Correct me if I'm wrong, but I don't believe he knew the difference between the success and failures; it was all just piled up and someone had to come along, sort through it, and tell him it was important. He sought patterns.

Didn’t he publish his work about gravity and light but not about alchemy ? It seems to me he had a pretty good handle on results that were worth publishing vs the ones that weren’t.