table 转view dual python 代码

import pandas
import io



s =  io.BytesIO(b""""CATEGORY_ID","CATEGORY_NAME","DESCRIPTION","PICTURE"
1,"Beverages","Soft drinks, coffees, teas, beers, and ales","beverages.gif"
2,"Condiments","Sweet and savory sauces, relishes, spreads, and seasonings","condiments.gif"
3,"Confections","Desserts, candies, and sweet breads","confections.gif"
4,"Dairy Products","Cheeses","diary.gif"
5,"Grains/Cereals","Breads, crackers, pasta, and cereal","cereals.gif"
6,"Meat/Poultry","","meat.gif"
7,"Produce","Dried fruit and bean curd","produce.gif"
8,"Seafood","Seaweed and fish","seafood.gif"
9,"9","9","9"
10,"8","","8"
""")
df = pandas.read_csv(s)

col = df.columns
result = []
df = df.fillna('')
for key, item in df.iterrows():
    x = item.tolist()
    s_sql =' select '+ ','.join (list(map(lambda y,z : f" '{y}' {z} " , x, col))) + ' from dual '
    result.append(s_sql)
print(' union all \n'.join(result))