是的,你不会相信,但我已经浏览了两个小时,只为一行简单的代码。如何将充满字符串的DataFrame转换为浮点DataFrame。更重要的是,如何将充满字符串的DataFrame转换为np.array?似乎有两种解决方案被反复提出——转换对象和astype。它们都不起作用。。。。。
database = pd.read_csv('test1.csv',header=None)
database
Out[165]:
0
0 0,0,1,0,0
1 1,0,1,0,0
2 0,4,0,1,0
3 1,4,0,1,0
4 1,1,0,0,1
5 2,1,0,0,1
database = database.astype(str).convert_objects(convert_numeric=True)
x = np.array(database)
In [170]:
x
Out[170]:
array([['0,0,1,0,0'],
['1,0,1,0,0'],
['0,4,0,1,0'],
['1,4,0,1,0'],
['1,1,0,0,1'],
['2,1,0,0,1']], dtype=object)
或
DATA = database.astype(float)
ValueError: could not convert string to float: '2,1,0,0,1'
根据我在您的评论中看到的,这可能会有所帮助:
import pandas
pandas.read_csv('test1.csv', header=None, lineterminator=' ')