我需要帮助对数据进行分组

Question

我已经走到这一步了。当我运行它时，它会将字符串数字变成浮点数，甚至为我摆脱时间戳。那么我如何获取这些数字并将它们放入新的组中？我的目标是，我希望每一行都是它自己的列表，但只有时间戳和每行最后一个 0 之间的数字。

import pandas as pd 

import numpy as np

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

'''

number = ver.split(',')

for num in number:

    try:

        new = float(num)

        print(new)

    except:

        print('this one messed up')

Answer 1

您可以先按行拆分数据，然后再按“，”拆分。ver = '''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'''ver = [i.split(',') for i in ver.split('\n')]df = pd.DataFrame(ver)df输出：    0   1   2   3   4   5   60   2018.12.0400:00 0.73572 0.73614 0.73544 0.73550 520 01   2018.12.0401:00 0.73550 0.73594 0.73545 0.73553 1181    02   2018.12.0402:00 0.73553 0.73606 0.73510 0.73539 1960    03   2018.12.0403:00 0.73539 0.73621 0.73481 0.73608 2898    0