title: How do I convert binary data to hexadecimal through Python?
body: <p>So I'm trying to get the binary data field in a database as a hexadecimal string. I don't know if that is exactly what I'm looking for but that is my hunch. There is a column called <code>status</code> in my dataframe that says <code>[binary data]</code> in PostgreSQL but when I execute the following command it looks like this:</p>
  <pre><code>df = pd.read_sql_query(&quot;&quot;&quot;SELECT * FROM public.&quot;Vehtek_SLG&quot; LIMIT 1000&quot;&quot;&quot;,con=engine.connect())
  </code></pre>
  <p><a href="https://i.stack.imgur.com/HX4kb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HX4kb.png" alt="Status column" /></a></p>
  <p>How do I get the actual data in that column?</p>