假设有以下信号:
# -*- coding: utf-8 -*-
"""
Created on Sat Jan 1 22:49:04 2022
@author: LENOVO
"""
import pandas as pd
import itertools
def PT():
print ("----------------***********-------------------------------")
io = r'F:\pythonplay\signal.xlsx'
df = pd.read_excel(io, sheet_name = 'Sheet1')
print("gear clomn is :" ,df['gear'])
PT()
print (df.columns) #列名
PT()
print(df.describe)
PT()
print("ADAS列输出值\n",df['ADAS'].values)#指定列的值
PT()
ADAS = df['ADAS'].values.tolist()
GEAR = df['gear'].values.tolist()
SPEED = df['Speed'].values.tolist()
#cleanedADAS = [x for x in ADAS if str(x) != 'nan']
def Del_Nan(lst):
result = [x for x in lst if str(x) != 'nan']
return (result )
cleanedADAS = Del_Nan(ADAS)
print ("看看有没有NAN",cleanedADAS)
df_combinatn = []
for i in itertools.product(GEAR,cleanedADAS):
print(i)
#for i, j in itertools.product(GEAR, cleanedADAS):
#df_combinatn.append(i)
list1 = ['a','b','c']
list2 = [1,2]
#df2 = pd.DataFrame(itertools.product(list1, list2), columns=['col1', 'col2'])
df2 = pd.DataFrame(itertools.product(GEAR, cleanedADAS,SPEED))
#df = df.append(df2)
print (df2)
#writer = df2.ExcelWriter(io)
#df2.to_excel(writer, sheet_name="Sheet1")
with pd.ExcelWriter(io, mode='a', engine='openpyxl') as writer:
df2.to_excel(writer, sheet_name="Sheet1")