擅长:python、mysql、java
<p>我建议使用pandas库来实现这一点,然后您可以轻松地进行任何类型的转换。在</p>
<pre><code>import pandas as pd
exceldata = pd.read_excel('tmp.xlsx', index_col=0)
print(exceldata)
</code></pre>
<p>您可以轻松删除<code>null/na value</code>,也可以替换它并将其导出为excel格式。在</p>
<p>帮助参考:</p>
<p><a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html" rel="nofollow noreferrer">Reading Excel</a></p>
<p><a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.dropna.html" rel="nofollow noreferrer">Drop Na Value</a></p>
<p><a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.fillna.html" rel="nofollow noreferrer">Replace NA Value</a></p>