StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
6344840
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-06-14T14:08:28.683
FavoriteCount
0
LastActivityDate
2011-06-14T16:18:40.303
LastEditDate
2011-06-14T16:18:40.303
LastEditorUserId
572606
OwnerUserId
572606
ParentId
6343355
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<pre><code>import itertools def search(lines, terms): results = [[t] for t in terms] lines = iter(lines) for l in lines: for i,t in enumerate(terms): if t in l: results[i].append(lines.next().strip()) break return results def format(results): s = [] rows = list(itertools.izip_longest(*results, fillvalue="")) for row in rows: s.append("\t".join(row)) s.append('\n') return ''.join(s)</code></pre> <p>And here's how to call the functions:</p> <pre><code>example = """> <Enzymologic: Ki nM 1> 257000 > <Enzymologic: IC50 nM 1> n/a > <ITC: Delta_G0 kJ/mole 1> n/a > <Enzymologic: Ki nM 1> 5000 > <Enzymologic: EC50/IC50 nM 1> 1000""" def test(): terms = ["> <Enzymologic: IC50 nM 1>", "> <Enzymologic: Ki nM 1>"] lines = example.split('\n') result = search(lines, terms) print format(result)</code></pre> <pre>>>> test() > <Enzymologic: IC50 nM 1> > <Enzymologic: Ki nM 1> n/a 257000</pre> <p>The above example separates each column by a single tab. If you need fancier formatting (as per your example), the format function gets a bit more complicated:</p> <pre><code>import math def format(results): maxcolwidth = [0] * len(results) rows = list(itertools.izip_longest(*results, fillvalue="")) for row in rows: for i,col in enumerate(row): w = int(math.ceil(len(col)/8.0))*8 maxcolwidth[i] = max(maxcolwidth[i], w) s = [] for row in rows: for i,col in enumerate(row): s += col padding = maxcolwidth[i]-len(col) tabs = int(math.ceil(padding/8.0)) s += '\t' * tabs s += '\n' return ''.join(s)</code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POFinding multiple words and print next line using Python
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USshang
UserOwnerUserId
1. USshang
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. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

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.