如何在熊猫中浮动对象？

xiaoxingxing python 233

原文标题 ：How to float to object in pandas?

我有以下数据框：all_data

delay   settled_users   due_amt prime_tagging   pending_users   cycle_end_date
    0.0   114351    8.095711e+07    Prime_Super 236899           2022-03-15
    1.0   160691    5.590400e+07    Prime_Super 190559           2022-03-15
    2.0   211160    5.818422e+07    Prime_Super 140090           2022-03-15
    3.0   270745    7.271832e+07    Prime_Super 80505             2022-03-15

all_data.info()

<class 'pandas.core.frame.DataFrame'>
Int64Index: 30 entries, 1 to 6
Data columns (total 6 columns):
delay             30 non-null float64
settled_users     30 non-null int64
due_amt           30 non-null float64
prime_tagging     30 non-null object
pending_users     30 non-null int64
cycle_end_date    30 non-null object
dtypes: float64(2), int64(2), object(2)

我想要一个新专栏all_data['delay'] + all_data['cycle_end_date']但这会引发TypeError: unsupported operand type(s) for +: 'int' and 'datetime.date'

我如何实现这一目标？请帮忙

原文链接：https://stackoverflow.com//questions/71555715/how-to-float-to-object-in-pandas

回复

我来回复
  • jezrael的头像
    jezrael 评论

    采用：

    all_data['new'] = pd.to_timedelta(all_data['delay'], unit='d') + pd.to_datetime(all_data['cycle_end_date'])

    要么：

    all_data['new'] = pd.to_timedelta(all_data['delay'], unit='d') + pd.to_datetime(all_data['cycle_end_date'].astype(str))
    2年前 0条评论

相关问题