擅长:python、mysql、java
<p>非常简单,只需在读取excel文件时使用converters参数</p>
<pre><code>pd.read_excel('New.xlsx', converters={'column_name':str})
</code></pre>
<p><strong>编辑1:</strong></p>
<pre><code>pd.read_excel('New.xlsx', converters={'column_name':str}, convert_float=False)
</code></pre>
<p><strong>编辑2:</strong></p>
<pre><code>pd.read_excel('new.xlsx', convert_float=False, dtype='str')
</code></pre>
<p><strong>编辑3:</strong></p>
<pre><code>df = pd.read_excel('new.xlsx', convert_float=False, dtype='str')
for val in df.itertuples():
if '+' in df.at[val[0], 'prod_no'] or 'e' in df.at[val[0], 'prod_no'] or 'E' in df.at[val[0], 'prod_no']:
df.at[val[0], 'prod_no'] = '0'+df.at[val[0], 'prod_no'].replace('e+', 'E')
else:
continue
print(df)
</code></pre>
<p>输出:</p>
<pre><code> prod_no
0 08E55
</code></pre>