Python, generate xls from csv data with random background color

What I need

In python with xlwt, I need generate xls file from csv, where in the first column will be random background color based on condition (if cell is 1 then orange, if cell is 2 then purple, etc.).

Example

Questions

• First, how can I import data and generate xls from csv in python?
• Second, what is the best way to do that? Some if condition?

Thank you.