Updated script to check inconsistent pandas namespace
- [ ] closes #37838 
- [ ] tests added / passed
- [ ] passes `black pandas`
- [ ] passes `git diff upstream/master -u -- "*.py" | flake8 --diff`
- [ ] whatsnew entry

Updates the script for inconsistent namespace usage. To be merged after all the errors are fixed with the updated script. The script is described here : https://github.com/MarcoGorelli/PyDataGlobal2020-sprint/issues/1 by @MarcoGorelli 
Hello @mohdkashif93! Thanks for updating this PR. We checked the lines you've touched for [PEP 8](https://www.python.org/dev/peps/pep-0008) issues, and found:

















There are currently no PEP 8 issues detected in this Pull Request. Cheers! :beers: 

##### Comment last updated at 2020-11-18 17:28:47 UTC we will likely need to merge master to make sure after some other merges (but wait till this is green) can you merge master and see if you can fixup and remaining issues ( pre-commits are failing). ping on green. this is pending on #37852 , once that's in I'd expect this to pass Hi @mohdkashif93 - can you try fetching and merging upstream/master now please and see if this passes? If not, do you want to fix up the remaining files as well? yep this needs a rebase and merge on green. Yes @MarcoGorelli , I will rebase and check if there are any pending errors with the script 😄  can you merge master @jreback I merged master and fixed up the few remaining files - good to go? great thanks @mohdkashif93 