Noise is a strange thing. I've worked in open plan offices my entire career.. specifically on trading floors. These places are renowned for people shouting and screaming... I've found that my level of focus on something really matters what the task at hand is..

If it's coding, I need a good steady drone of noise.

If it's reading I need silence.

The choice of background noise really matters as well:

CNBC is a terrible choice for noise because the variability in cadence and the sound effects are very distracting. It's all designed to attract your attention.

NPR on the other hand is just perfect for having in the background as there aren't many "highs" or "lows".

Having said that, I recommend investing in a bose quietcomfort noise cancelling earbuds. These give you some bit of control on your environment. I haven't tried the latest airpods, but I hear (pun) good things..