python convert string to float_python - 将Column(str)转换为(Float),ValueError: could not convert string ...

x = pd.DataFrame({"Cost" : ["83.53462540716612" ,"0.0" ,"66.6315396408911" ,"340.9281334351922" ,"181.8128056341571" ,"0.00" ]

尝试:###Attempt 0

# x["Cost"] = x["Cost"].str.replace(' ', '')

# x["Cost"] = x["Cost"].str.replace(',', '').astype(float)

###Attempt 1

#x = x.where((pd.notnull(x)), None)

#x["Cost"] = float(len(x["Cost"]))

###Attempt 2

#x["Cost"].isdecimal()

#x = [float(x) for x in range(len(x["Cost"])) ]

###Attempt 3

#[float(x) for x in x["Cost"].strip().split()]

###Attempt 4

#x["Cost2"] = x["Cost"].append([float(str(x)) for x in x["Cost"].split(' ') if len(x)>1])

###Attempt 5

#x["Cost"] = pd.get_dummies(x["Cost"]).values

无效,得到错误:ValueError: could not convert string to float: 'Null'

# else, only a single dtype is given

# _astype_nansafe works fine with 1-d only

# TODO(extension)

# Explicit copy, or required since NumPy can't view from / to object.

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值