I want to implement operation on excel file in one column that column has string and integer data but that column is object type
我的数据在Excel中看起来像:(字符串和数字的组合)
Time Spent
3600
0
None
1800
0
我试过下面的代码
if (df['Time Spent']=='None').all():
df['Time Spent'] = 0
else:
df['Time Spent'] = df['Time Spent'].astype('int')/3600
Error which I am getting
Index([u'Issue Key', u'Issue Id', u'Summary', u'Assignee', u'Priority',
u'Issue Type', u'Status', u'Tag', u'Original Estimate', u'Time Spent',
u'Resolution Date', u'Created Date'],
dtype='object')
Traceback (most recent call last):
File "dashboard_migration_graph_Resolved.py", line 60, in <module>
df['Time Spent'] = df['Time Spent'].astype('int')/3600
File "/usr/lib64/python2.7/site-packages/pandas/util/_decorators.py", line 118, in wrapper
return func(*args, **kwargs)
File "pandas/_libs/lib.pyx", line 854, in pandas._libs.lib.astype_intsafe
File "pandas/_libs/src/util.pxd", line 91, in util.set_value_at_unsafe
ValueError: invalid literal for long() with base 10: 'None'
我无法评论(因为名声不好),但您是否尝试过:
希望这对你有用。你知道吗
使用^{} 和} :
errors='coerce'
将所有非数字转换为缺少的值,因此在除法之前添加^{如果需要
None
像misssing value一样返回,则只删除fillna
-而不是None
获取缺少的值NaN
,因此可能有多个列:相关问题 更多 >
编程相关推荐