python中的str类型的list转化&两层list类型数据的过滤

from collections import OrderedDict
import pandas
import ast
def pandas_excel():
    res = pandas.read_excel(r"C:\Users\USER\Desktop\works\all\\Workbook1.xlsx")
    # print(res[1])
    list_all = []
    # print(len(list(set(res["a0"]))))
    for j in range(len(res["a1"])):

        # for i in range(1,17):
        list1 = [res["a0"][j],res["a1"][j],res["a2"][j],res["a3"][j],res["a4"][j],res["a5"][j],res["a6"][j],res["a7"][j],res["a8"][j],res["a9"][j],res["a10"][j],res["a11"][j],res["a12"][j],res["a13"][j],res["a14"][j],res["a15"][j],res["a16"][j]]
        list1 = [ str(i) for i in list1]
        list_all.append(list1)
    # print(list_all)
    
    list_all = [ str(i) for i in list_all]
    list_all = list(OrderedDict.fromkeys(list_all))#去重
    list_all = [ast.literal_eval(i) for i in list_all]#转列表格式
    return list_all