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:
Is it possible to achieve this using the pandas library in Python? if not, is there any library to get the colors?
Greetings
4
-
are you asking if in pandas we can convert #FFFF00 into the name of the color ?moys– moys2019-08-14 13:09:16 +00:00Commented Aug 14, 2019 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 itAceconhielo– Aceconhielo2019-08-14 13:10:59 +00:00Commented Aug 14, 2019 at 13:10
-
Possible duplicate of Identifying Excel Sheet cell color code using XLRD packageLaurens Koppenol– Laurens Koppenol2019-08-14 13:13:49 +00:00Commented Aug 14, 2019 at 13:13
-
Possible duplicate of Get Excel cell background color in pandas read_excel?Zach Oakes– Zach Oakes2019-08-14 13:15:53 +00:00Commented Aug 14, 2019 at 13:15
Add a comment
|