SQL Join is changing values of my existing column

I’m attempting to use SQL to pull data from a database into a Jupyter (python)