coding a Python 'has letters' function | fixing errors with data types

Having scraped some data using Python and Selenium the next part of the project was to match some collected data with a source csv to create an output csv based on collected data and the source csv.


A truncated test data csv was missing an 'old style' value which used an alpha character. When I tested my code it worked, when testing on the customer's computer we had an error.


Why?


Pandas (NumPy) chooses the data type to suit the data in the column.
If the file has more than just numbers in the 'id' column then we needed to take care of this...watch along to see the outcome.


Links:
https://numpy.org/doc/stable/user/basics.types.html
https://pbpython.com/pandas_dtypes.html



Visit redandgreen blog for more Tutorials
=========================================
? http://redandgreen.co.uk/about/blog/

Subscribe to the YouTube Channel
=================================
? https://www.youtube.com/c/DrPiCode

Follow on Twitter - to get notified of new videos
=================================================
? https://twitter.com/RngWeb

Buy Dr Pi a coffee (or Tea)
☕ https://www.buymeacoffee.com/DrPi

Proxies
=================================================
If you need a good, easy to use proxy, I was recommended this one, and having used ScraperAPI for a while I can vouch for them. If you were going to sign up anyway, then maybe you would be kind enough to use the link and the coupon code below?

You can also do a full working trial first as well, (unlike some other companies). The trial doesn't ask for any payment details either so all good! ?

? 10% off ScraperAPI : https://www.scraperapi.com?fpr=ken49
◼️ Coupon Code: DRPI10
(You can also get started with 1000 free API calls. No credit card required.)

Thumbs up yeah? (cos Algos..)

#python #webscraping #csv