title: Is there ways to add 0s in a specific columns of dataframe to match specific number of digits?
body: <p>I have two tables with a column that contains specific IDs.</p>
  <p>For example,</p>
  <p>TABLE A</p>
  <pre><code>cust_id 
  1234
  32145
  1235692
  9293159
  </code></pre>
  <p>TABLE B</p>
  <pre><code>cust_id 
  0001234
  0032145
  1235692
  9293159 
  </code></pre>
  <p>I'm trying to apply inner join using sql, but since they do not exactly match, the first two ids 1234 (0001234), 32145 (0032145) are missing from the results using inner join clause.</p>
  <p>So here is my question.</p>
  <ol>
  <li>Is there any way to add additional 0s in front of cust_id of TABLE A to match that of TABLE B's cust_id?</li>
  </ol>
  <p>For example, 1234 is only 4 digits, but after transformation, it would be in 7 digits with additional three 0s in front of it --&gt; 0001234.</p>
  <ol start="2">
  <li>Are these kinds of tasks easier to handle with Python? or SQL?
  My past experiences with data cleansing tells me it's Python, but are there any other suggestions?</li>
  </ol>
  <p>If possible, for this specific case, I am hoping I can get help using Python or SQL.</p>
  <p>Thanks in advance.</p>