StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO"Conditional formatting" in python for each dataset in a list appending the hex colors
primarykey
Id
20557560
data
AcceptedAnswerId
20564433
AnswerCount
2
ClosedDate
CommentCount
5
CommunityOwnedDate
CreationDate
2013-12-13T01:28:34.953
FavoriteCount
0
LastActivityDate
2015-10-19T07:49:43.830
LastEditDate
2015-10-19T07:49:43.830
LastEditorUserId
1505120
OwnerUserId
2487602
ParentId
0
PostTypeId
1
Score
0
ViewCount
525
LastEditorDisplayName
text
Body
<p>I'm looking for a way to do conditional formating based on numbers/percentages in a list, the output conditional formatting needs to be a hex color.</p> <p>For example in the data below, there are 3 fully unique <em>"datasets"</em> which are generated by <code>row[0] + row[1]</code> each dataset would be analysed on it's own.</p> <h3>Data in List form (current layout)</h3> <pre><code>[['UniqueData1', 'UniqueTest1', '13', '13.39%', '42.7%', 'Data'], ['UniqueData1', 'UniqueTest1', '14', '82%', '41.9%', 'Data'], ['UniqueData1', 'UniqueTest1', '18', '29.39%', '41%', 'Data'], ['UniqueData2', 'UniqueTest2', '22.3', '44.4%', '42.3%', 'Data'], ['UniqueData2', 'UniqueTest2', '4', '44.2%', '43.4%', 'Data'], ['UniqueData2', 'UniqueTest2', '4.1', '49%', '42.7%', 'Data'], ['UniqueData3', 'UniqueTest1', '4.45', '49.5%', '42.42%', 'Data'], ['UniqueData3', 'UniqueTest1', '4.29', '20%', '42.3%', 'Data'], ['UniqueData3', 'UniqueTest1', '4.22', '25%', '41.2%', 'Data']] </code></pre> <p>The wanted output would be for the above to appear with appended columns in each row of data for example:</p> <pre><code>['UniqueData3', 'UniqueTest1', '4.22', '25%', '41.2%', 'Data'] </code></pre> <p>Might turn into:</p> <pre><code>['UniqueData3', 'UniqueTest1', '4.22', '25%', '41.2%', 'Data', '#d23f3f', '#db8a2e', '#4ea157'] </code></pre> <p>Where <code>#d23f3f</code> relates to <code>4.22</code> and <code>#db8a2e</code> relates to <code>25%</code> and <code>#4ea157</code> relates to <code>41.2%</code> <strong>Please note the hex colors are just examples</strong></p> <p>Any ideas?</p> <h3>EDIT: Data in CSV form so that it's easily readable :)</h3> <pre><code>UniqueData1,UniqueTest1,13,13.39%,42.7%,Data UniqueData1,UniqueTest1,14,82%,41.9%,Data UniqueData1,UniqueTest1,18,29.39%,41%,Data UniqueData2,UniqueTest2,22.3,44.4%,42.3%,Data UniqueData2,UniqueTest2,4,44.2%,43.4%,Data UniqueData2,UniqueTest2,4.1,49%,42.7%,Data UniqueData3,UniqueTest1,4.45,49.5%,42.42%,Data UniqueData3,UniqueTest1,4.29,20%,42.3%,Data UniqueData3,UniqueTest1,4.22,25%,41.2%,Data </code></pre> <p><strong>For example in excel it would appear like:</strong> </p> <p><img src="https://i.stack.imgur.com/xQii1.png" alt="enter image description here"></p> <p><strong>Which ultimately looks like:</strong> </p> <p><img src="https://i.imgur.com/nY1EFti.png" alt="enter image description here"></p> <h3>Expected output would be:</h3> <pre><code>[['UniqueData1', 'UniqueTest1', '13', '13.39%', '42.70%', 'Data', '#F8696B', '#F8696B', '#63BE7B'], ['UniqueData1', 'UniqueTest1', '14', '82%', '41.90%', 'Data', '#FFEB84', '#63BE7B', '#FFEB84'], ['UniqueData1', 'UniqueTest1', '18', '29.39%', '41%', 'Data', '#63BE7B', '#FFEB84', '#F8696B'], ['UniqueData2', 'UniqueTest2', '22.3', '44.40%', '42.30%', 'Data', '#63BE7B', '#FFEB84', '#F8696B'], ['UniqueData2', 'UniqueTest2', '4', '44.20%', '43.40%', 'Data', '#F8696B', '#F8696B', '#63BE7B'], ['UniqueData2', 'UniqueTest2', '4.1', '49%', '42.70%', 'Data', '#FFEB84', '#63BE7B', '#FFEB84'], ['UniqueData3', 'UniqueTest1', '4.45', '49.50%', '42.42%', 'Data', '#63BE7B', '#63BE7B', '#63BE7B'], ['UniqueData3', 'UniqueTest1', '4.29', '20%', '42.30%', 'Data', '#FFEB84', '#F8696B', '#FFEB84'], ['UniqueData3', 'UniqueTest1', '4.22', '25%', '41.20%', 'Data', '#F8696B', '#FFEB84', '#F8696B']] </code></pre> <h3>In visual terms (strictly for show only)</h3> <pre><code>UniqueData1,UniqueTest1,13,13.39%,42.70%,Data,#F8696B,#F8696B,#63BE7B UniqueData1,UniqueTest1,14,82%,41.90%,Data,#FFEB84,#63BE7B,#FFEB84 UniqueData1,UniqueTest1,18,29.39%,41%,Data,#63BE7B,#FFEB84,#F8696B UniqueData2,UniqueTest2,22.3,44.40%,42.30%,Data,#63BE7B,#FFEB84,#F8696B UniqueData2,UniqueTest2,4,44.20%,43.40%,Data,#F8696B,#F8696B,#63BE7B UniqueData2,UniqueTest2,4.1,49%,42.70%,Data,#FFEB84,#63BE7B,#FFEB84 UniqueData3,UniqueTest1,4.45,49.50%,42.42%,Data,#63BE7B,#63BE7B,#63BE7B UniqueData3,UniqueTest1,4.29,20%,42.30%,Data,#FFEB84,#F8696B,#FFEB84 UniqueData3,UniqueTest1,4.22,25%,41.20%,Data,#F8696B,#FFEB84,#F8696B </code></pre> <p>M4tini's answer below is very close to what I need, just looking for a way to ignore and or force a different color for certain values.</p>
Tags
<python><python-2.7><formatting><conditional>
Title
"Conditional formatting" in python for each dataset in a list appending the hex colors
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USpnuts
UserOwnerUserId
1. USRyflex
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO"Conditional formatting" in python for each dataset in a list appending the hex colors
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTDownMod
2. VO
  singulars
  PostPostId
  PO"Conditional formatting" in python for each dataset in a list appending the hex colors
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  PO"Conditional formatting" in python for each dataset in a list appending the hex colors
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTDownMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.