1. data1 = pd.read_excel("offset.xlsx")
    2. print(data1)
    3. li =[]
    4. for row in data1.iterrows():
    5.     li.append(str((row[1].values)[0]).split(','))
    7. df1 = pd.DataFrame(li,columns=["offset","bandwidth"])
    8. offset = list(df1.loc[:,'offset'])
    9. bandwidtd =list(df1.loc[:,'bandwidth'].apply(lambda x: float(x)))
    10. print(bandwidtd)

    给数据转换类型