回答此问题可获得 20 贡献值,回答如果被采纳可获得 50 分。
<p>我有一个excel文件,我从它的列中创建了列表。问题是列的行不相等。因此,在列表的末尾有多个“nan”值。我试图用dropna()方法删除它们,但仍然存在“nan”值。这是我的密码:</p>
<pre><code>import pandas as pd
excel_name = r'file_name.xlsx'
df = pd.read_excel(excel_name, engine='openpyxl')
df.dropna()
clomun_1 = list(df['clomun1'])
clomun_2 = list(df['clomun2'])
clomun_3 = list(df['clomun3'])
print(clomun_1)
print(clomun_2)
print(clomun_3)
</code></pre>
<p>输出:</p>
<pre><code>clomun_1 = ['value1', 'value2', 'value3', 'value4', 'nan', 'nan', 'nan', 'nan']
clomun_2 = ['value1', 'value2', 'value3', 'value4', 'value5', 'value6', 'nan', 'nan']
clomun_3 = ['value1', 'value2', 'nan', 'nan', 'nan', 'nan', 'nan', 'nan']
</code></pre>
<p>我只想保留价值观。我必须删除“nan”元素</p>