如何从系列列中移除尾随.0
如何从系列列中移除尾随.0
提问于 2022-08-24 17:41:36
我试图使用以下代码从CAS/ID NO列的行中删除尾随的CAS/ID NO：
import requests
import pandas as pd
url = ' https://www.accessdata.fda.gov/scripts/sda/sdNavigation.cfm?sd=edisrev&displayAll=true'
html = requests.get(url).content
df_list2 = pd.read_html(html)
df2 = df_list2[0]
df3=df2.dropna(subset = ['CAS/ID NO'])
df3['CAS'] = df3['CAS/ID NO'].to_string()
df3['CAS'] = df3['CAS/ID NO'].astype(str).replace('\.0', '', regex=False)
df3它坚决抵制我所有的努力。
回答 1
Stack Overflow用户
发布于 2022-08-24 18:07:02
您可以尝试将其转换为.astype('int64')类型
df2['CAS'] = df2['CAS/ID NO'].astype('int64')示例
import requests
import pandas as pd
url = ' https://www.accessdata.fda.gov/scripts/sda/sdNavigation.cfm?sd=edisrev&displayAll=true'
html = requests.get(url).content
df_list2 = pd.read_html(html)
df2 = df_list2[0]
df2 = df2.dropna(subset = ['CAS/ID NO']).copy()
df2['CAS'] = df2['CAS/ID NO'].astype('int64')
df2页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/73477515
复制相关文章
相似问题
腾讯云开发者
