我已經走到這一步了。當我運行它時，它會將字符串數字變成浮點數，甚至為我擺脫時間戳。那么我如何獲取這些數字并將它們放入新的組中？我的目標是，我希望每一行都是它自己的列表，但只有時間戳和每行最后一個 0 之間的數字。import pandas as pd import numpy as npver = ''' 2018.12.0400:00,0.73572,0.73614,0.73544,0.73550,520,02018.12.0401:00,0.73550,0.73594,0.73545,0.73553,1181,02018.12.0402:00,0.73553,0.73606,0.73510,0.73539,1960,02018.12.0403:00,0.73539,0.73621,0.73481,0.73608,2898,0'''number = ver.split(',')for num in number: try: new = float(num) print(new) except: print('this one messed up')
1 回答
慕俠2389804
TA貢獻1719條經驗 獲得超6個贊
您可以先按行拆分數據，然后再按“，”拆分。
ver = '''2018.12.0400:00,0.73572,0.73614,0.73544,0.73550,520,0
2018.12.0401:00,0.73550,0.73594,0.73545,0.73553,1181,0
2018.12.0402:00,0.73553,0.73606,0.73510,0.73539,1960,0
2018.12.0403:00,0.73539,0.73621,0.73481,0.73608,2898,0'''
ver = [i.split(',') for i in ver.split('\n')]
df = pd.DataFrame(ver)
df
輸出：
0 1 2 3 4 5 6
0 2018.12.0400:00 0.73572 0.73614 0.73544 0.73550 520 0
1 2018.12.0401:00 0.73550 0.73594 0.73545 0.73553 1181 0
2 2018.12.0402:00 0.73553 0.73606 0.73510 0.73539 1960 0
3 2018.12.0403:00 0.73539 0.73621 0.73481 0.73608 2898 0
添加回答
舉報
0/150
提交
取消