1

I have a xlsx file with color in cells and I would like to detect the color of each cell and add it as a new column. Result:

enter image description here

Is it possible to achieve this using the pandas library in Python? if not, is there any library to get the colors?

Greetings

Aceconhielo
  • 3,316
  • 4
  • 19
  • 26
  • are you asking if in pandas we can convert #FFFF00 into the name of the color ? – moys Aug 14 '19 at 13:09
  • @mohanys nope, I would like detect the color in the first column and then add it as a new column with the name of it – Aceconhielo Aug 14 '19 at 13:10
  • Possible duplicate of [Identifying Excel Sheet cell color code using XLRD package](https://stackoverflow.com/questions/7991209/identifying-excel-sheet-cell-color-code-using-xlrd-package) – Laurens Koppenol Aug 14 '19 at 13:13
  • Possible duplicate of [Get Excel cell background color in pandas read\_excel?](https://stackoverflow.com/questions/47857112/get-excel-cell-background-color-in-pandas-read-excel) – Zach Oakes Aug 14 '19 at 13:15

0 Answers0