读取EXCEL然后导出各列值的笛卡尔积——测试用例辅助

假设有以下信号：

# -*- 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")