python - How to color-code 2D scatter plot based on a 3rd column -

i have scatter plot x , y axes showing distance , temperature, respectively. data collected on multiple days, , want color-code plot see data collected on date (e.g., 20160703). how can add color based on "date" column?

i assume using xlsx newest excel file format.

for xlsx going want use openpyxl.

documentation: https://openpyxl.readthedocs.io/en/default/

here specific documentation color: http://openpyxl.readthedocs.io/en/default/_modules/openpyxl/styles/colors.html

if understand correctly here want:

import openpyxl x = 0  wb = openpyxl.workbook()  ws = wb.active  columnname = ['date']  cell in columnname:     cell.style = color_index[x]     x += 1    wb.save(filename.xlsx)